November 19, 2002 at 12:00 am
hi out there,
my problem:
after restoring a database on another server no user can logon to the new sqlserver because none is known by the sqlserver.
So I have to announce every single user to the sqlserver and fit the pitnumber in the restored db.
is there a way to do this automatically?(because 180users are too much for me - you`ve to know that I´m a little bit lazy;) )
Mario
November 19, 2002 at 12:20 am
Ok, I find it out by myself.
I`ve to restore the masterdb too.
but the problem is, that the file-structure has to be the same as on the old sqlserver otherwise the sqlserver w´ont start because of the none existence of the masterdb.
Please correct me if I´m wrong....
greetings from the coast
Mario
November 19, 2002 at 5:18 am
Server versions have to be the same to accept a Master restore. Not sure what you me by file structure.
November 19, 2002 at 7:45 am
If you want to transfer SQL Server logins between SQL Server machines, then read this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply