Reinstalling MIIS to a new Database

Recently I have been setting up a new and imporved web environement at MICA.  This has involved colapsing some of our web servers and databases onto a single machine to free up resources.  Part of this experience involved reloacating an MIIS database to a new machine.

One particularly stupid error I ran into happened while setting up the connection to the new database server, that had a restored copy of the database.  After supplying the login credintials for the SQL Server, I would recieve this message:

The service account cannot access SQL server. Ensure that the server is accessible, the service account is not a local account being used with a remote SQL Server, and that the account doesn’t already have a SQL login

I checked all my credentials over and over, yet I could not get past this error message.  Ultimately what I discovered was that our domain was cAsEsEnSiTiVe, and I was using the wrong case–lower case.

Hope this helps someone else avoid a little pointless frustration.

One Response to “Reinstalling MIIS to a new Database”

  1. Gobsmacked (a lot of knowledge is a dangerous thing…) | Identity Technology - September 2, 2011

    […] couldn’t possibly be the solution based on a blog entry I found on the exceedingly well named “Over 5 minutes – answers for questions that should be simple”, and changed the case of the domain – instant success, go directly to the group specification […]

Leave a Reply