Using the GUI, how do you add logins to a SQL Server instance, and how do you add users to a SQL Server database? Edit: I'm using CE version 7.1.2. Forgive me if this has already been asked. I ...

Click "Add," then "OK." Restart SQL Server to run the instance in single-user mode. ... You should restart SQL Server Agent before launching the instance of SQL Server in single-user mode.

Ok, for SQL server 2000, I need to change the account it runs under. I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and at the ...