PEO (12th April 2010)
what was the old server Os and what is the new one?
When moving to 2008 you will need to check the firewall as sims does not always use the standard SQl ports .
I always start with connect.ini's when I get reason 0. The connect.ini on the workstation, particularly if it's been a sims workstation since the last migration, can sometimes contain too much bumph. It should ideally just have:
And then the central connect.ini in s:\sims should have the correct servername and database name in it. e.g.
If connect.ini's are correct and they contain the server name rather than IP address, check that you can ping the server by name from a workstation.
Shouldn't really need to reinstall any SIMS client on the workstations or adjust the network config on a new sql install.
The only problem with that is if you have to move SIMS to another server in a hurry with a redirect on the local machine and the full [SIMSConnection] as above on a mapped drive, all you have to do is change the login script to map the drive to a different server, edit the connect.ini on the mapped drive and you're away. After you've set up another server, of course
Or copy the connect.ini from the S:\sims directory.
Redirects have always caused us problems.
BatchFile (12th April 2010)
I'm talking about Primary phase. Secondaries do their own thing.
Last edited by creese; 12th April 2010 at 04:21 PM.
The permissions can sometimes get screwed and then present you with a reason 0 message. Run the following SQL commands to fix... it can take a while! (BTW - the syntax assumes your database is called SIMS)
Code:use sims exec sims.db_p_install exec sims.db_p_grant
Hi gang thank you to everyone for the fast responce, we tried all the suggestions and narrowed it down to the flipping windows firewall. some how Kaspersky had disabled and windows server 2008 firewall had enabled it self.
+1 rep to everyone
Sometimes reason 0/local SIMS logon only is also caused by the SQL server browser agent not running (disabled by default on SQL2008)
There are currently 1 users browsing this thread. (0 members and 1 guests)