Install Great Plains 7.0

[newForumUser]

our SBS 2000 server crashed and we are in the process of reinstalling everything.we did manage to get a backup of the hard drive just after the crash.

Now i have installed SQL Server 2000, attached the other databases which were .mdfs.

I cannot login as 'sa' onto LocalServer in eEnterprise Utilities. tells me that "There isn't a valid login record on the server for the userID and password you entered. Contact your system administrator or attempt to login again using a different ID."

Now we cannot use the sp_help_revlogin thing since the old server is not there anymore.

How do we get around this?any help would be great.

strange thing was i couldn't even login as 'sa'.

 

[LyleU]

New,

You will be able to log in using the sa password that you specified when you did your new SQL 2000 installation. You may have to recreate all of your users as they would not have been transferred over to the new SQL instance - they may exist in your GP databases but they do not exist in SQL server with roles and security settings.

Lyle

 

[jymm]

Better yet - try this

http://www.sqlservercentral.com/articles/Log+Shipping/63028/

essentially this proc creates all of the sids for each of the DBs from the old server... saved my butt