How is a new login created in SQL Server 2000?
• Open up SQL Server Enterprise Manager. • Navigate to the Security folder. • Expand the Security folder > Logins. • Right click on Logins > New Login. • On the general tab, enter a name for the login. Select SQL Server Authentication. Enter in a password. For the database dropdown, select the database that was created for Spy Sweeper Enterprise. • On the Server Roles tab, verify that nothing is selected. • On the Database Access tab, find the Spy Sweeper database that was created and select it. • For the Permit in Database Role section, select public and db_owner. Please verify that nothing else is selected. Select OK.
