Re: SQL2000 accounts to SQL 2005 ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This is a common question, so I keep this link in my favourites.

However you can of course find it easily when you google for it.

--
Ekrem Önsoy



"Hank Arnold (MVP)" <rasilon@xxxxxxx> wrote in message news:ec$ZQ7NDJHA.2476@xxxxxxxxxxxxxxxxxxxxxxx
Ekrem Önsoy wrote:
You mean Logins I believe? Have you seen the following KB? If not, see the Method 2

Method 2
This method applies to the following scenarios:
. You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005.
. You transfer logins and passwords from SQL Server 2000 to SQL Server 2005.
. You assign logins to roles.

http://support.microsoft.com/kb/246133


You're right....

Excellent!!! Thanks for the link....

Sometimes even I forget that "Google is my friend."........ ;-)

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services

.

Relevant Pages

  • RE: Copy SQL Users from a server to another
    ... Transfer Logins and Passwords Between Instances of SQL Server ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • RE: Windows 2003 Migration. Impact on security(windows authenticat
    ... Transfer Logins and Passwords Between Instances of SQL Server ... newsgroup Microsoft.public.sqlserver.security, ...
    (microsoft.public.windows.server.sbs)
  • RE: Linked Server setup problem
    ... Transfer Logins and Passwords Between Instances of SQL Server ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.server)
  • Re: Logins in 6.5 to 2000 upgrade
    ... Check out the PASS Community Summit - Seattle, ... event entirely dedicated to SQL Server, ... > How can I transfer logins and passwords from a 6.5 ...
    (microsoft.public.sqlserver.security)
  • Re: Login migration
    ... Transfer Logins and Passwords Between Instances of SQL Server ... "Chris" wrote in message ...
    (microsoft.public.sqlserver.server)