how do you create logins for an MSDE sql database *without* Enterprise Manager?

[Andy Smith]

Hi - (first posting) ...

I have vs.net and msde installed, which appears to include (or "be"?)
a *partial* version of SQL Server 2000.... I can create a database in
Server Explorer... but how do I create logins so my application can
access the database??

There is no Enterprise Manager on my machine, no "Microsoft SQL
Server" on my 'start -> programs' menu..., but there is a "Microsoft
SQL Server" folder in my "program files" directory.

help?! thanks!




(btw-I'm learning vs.net by trial and error (I'm sure there's a better
way, but I havent found it yet))

 

[Stephen Muecke]

Andy,

You need to create a connection (SQLConnection Class) and use either a
dataAdaptor (SQLDataAdaptor Class) or dataReader (SQLDataReader) to access
the data (Enterprise manager has got nothing to do with creating a login
from vb)
You can create these manually or by dragging them from ServerExplorer
Before you go any further, spend some time reading the help files and doing
the walkthroughs
Start with (Contents)
Visual Studio.NET
Visual Basic and Visual C#
Accessing Data

Stephen

 

[Andy Smith]

Stephen & Ogi-

I've been playing around with the OLEDBConnection and dataadapter and
get connections to an Access database okay (filling a dataset,
binding to a datagrid etc)... but when I try to do the same thing with
my SQL database, using a SQLConnection and SQLDataAdapter, I can't get
the the "uid" and password properties of the connection string to do
very much because I havent figured out how to create a userID and
password. It's this kind of "login" that I'd like to create.

Ogi, I've heard of doing what you've suggested, but where do I run
these stored procedures from? There dont appear to be any tables,
views, SPs, etc when I look at the "master" database under Server
Explorer in VS.NET.

Thank you both for your responses-- I think with one more push in the
right direction I can get it....

Andy