Stand alone install of SIMs
Our SIMs server recently died and whilst waiting for nice new one to be delivered we are trying to install SIMs on a laptop just to run off some reports.
So far we have installed SQL Server 2008 (default instance), attached the sims.mdf database to the SQL server, and installed SIMS.net.
As the laptop has Windows Vista we turned off User Access Control and windows firewall just in case.
When we ran SIMs for the first time it asked for the location of SIMs on the laptop. We chose "I cannot access a SIMS connect.ini file", left the Server Name as (local) and the database name is sims.
When I try and log in it just says invalid username and password.
Looking at the connect.ini file that was created it says:
I tried changing the ServerName to the name of the laptop instead of (local) but this still had no effect. Usually the ServerName would be the name of the Server or PC followed by the name of the SQL server instance but we installed SQL server as the default instance.
Can anyone shed any light on what we might be doing wrong?