Login administration

[John Anderson]

I have Visual Studio .NET and something called "SQL Server Service Manager"
running in my systray. I have a simple question:

How do I add or change username and password information for the pubs
database?

I cannot find an "SQL Manager", which so many of the help files refer to.

I am not new to SQL Server. I have run SQL Server version 7.0 in the past
but no longer use that. I am running .NET with whatever SQL server comes
with it. I just cannot find any information about how to administer
usernames and logins to the database. There are no shortcuts in my start
menu or nothing obvious to access username information from the .NET IDE.

Please help!!!!!!

John Anderson
johnea...@earthlink.net

[Mary Chipman]

There's basically two ways to work with SQLS from the VS.NET IDE:

1. Open the Server Explorer window. This lets you set up a connection
to an existing database.

2. Add a Database project to your solution. If you want to administer
the server, you can add a database project and connect to master. This
way you can write scripts to manage the server (you can't execute a
script from the Server Explorer--only stored procedures).

You can download a new version of SQL BOL if you need more
SQLS-specific help than is available in .NET, although I've found the
dynamic help to be pretty good:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

-- Mary
MCW Technologies
http://www.mcwtech.com