... the replacement for DTS. Open up SQL Server Business Intelligence Development Studio (... Toolbox, you will find a Transfer Logins Task. Drag and drop ... books online under the topic: Transfer Logins Task [Integration Services] -Sue ... Task --> Source Tab (select sourcce sql server name--> Destination Tab (select ... name) --> Logins (select database name). What about in SQL 2005? I ...

...frienda. Don Em causa you bigga problems with da SQL familia. You musta becoma good frienda with Don Qa,...> In SQL 2000, I used SQL Enterprise Mgr --> Task --> Transfer Logins Task --> Source Tab (select sourcce sql server name--> Destination Tab (select destinate sql server name) --> Logins (select database name). What about in SQL 2005? I am new at SQL 2005 but love ...

... following scenarios: . You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005. . You transfer logins and passwords from ... You assign logins to roles. http://support.microsoft.com/kb/246133 ...>I will be rebuilding our SQL server in the next month ... correct process to migrate the user accounts. I don't have ... well, it's the account passwords that would change and everyone ...

...com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers http://www...>> Issues -Database Is Moved Between SQL Servers -- Arnie Rowland, Ph.D. ...SQL 2000 ENTERPRISE Edition => SQL 2005 STANDARD Edition? According to Microsoft upgrade ...

....com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers http://www.....microsoft.com/kb/274188 Troubleshooting Orphan Logins http://www.support.microsoft.com/?id=240872... SQL 2000 ENTERPRISE Edition => SQL 2005 STANDARD Edition? According to Microsoft upgrade ...

...fat-finger errors like mistyping the password. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada ...a basic question about SQL 2005 security...I often transfer databases between servers...way to restore the login associated with the user account? Or is ...

... fat-finger errors like mistyping the password. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada ... a basic question about SQL 2005 security...I often transfer databases between servers ...way to restore the login associated with the user account? Or is there...

...90).aspx Moving system dbs 2005 http://www.databasejournal.com/features...columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users http://www.support.microsoft.com...246133 How To Transfer Logins and Passwords Between SQL Servers http...and Permissions -- Andrew J. Kelly SQL MVP "Vincent" <vfrissora@proactiontech.com...would involve renaming our new SQL server name to our old...

... know what rights/priviledges/credentials a user has to have to connect through SQL Server Management Studio. You could connect...your GP9.0 and SQL Server with your regular user name instead of...2000 and 2005 by this article: How to transfer logins and passwords between...if you want the new created login is a sysadmin, you can assign... databases. 3. After create the login, you can log on your ...

... from the cluster PRIOR to proceeding with the 2005 install? Thanks again. -- John "Peter Yang [MSFT]" ... by detaching SQL 2000 user databases and attaching them to SQL 2005 server directly. You also need to transfer logins and passwords to the new instance. Please see ... TO: Move Databases Between Computers That Are Running SQL Server http://support.microsoft.com/?id=314546 ...