Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Copying Database disables pwd and must enter new

Author  Topic 

bogey
Posting Yak Master

166 Posts

Posted - 2008-01-24 : 11:16:20
I'm copying some of my development databases over to a new server and have noticed that even when I enable the acct the original password will no longer work. I have to then reenter each pwd for every acct that is in the database. I'm on sql server 2005 and I'm using the Task >> Copy Database.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-24 : 22:48:23
That's the way it works in sql2k5.
Go to Top of Page

bogey
Posting Yak Master

166 Posts

Posted - 2008-01-25 : 09:13:38
rmiao - can you elaborate? Does anyone know where I can find this in the documentation?

Thanks rmiao for your reply.

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-26 : 00:26:13
They doesn't put that in document, just a fact.
Go to Top of Page
   

- Advertisement -