MSDE

[Jay]

Just installed MSDE from the .NET SDK.
Am used to using SQL2K at work so am hunting around for the SA password
settings. is there such a thing in MSDE?
Can someone give me a very brief (I speak the lingo guide to MSDE please?
Is there an SA password? If so, where do I set/change it?
I'm guessing there is no Query Analyzer or Enterprise manager so how do you
create DBs etc?

Cheers
Jay

 

[Greg Low \(MVP\)]

Hi Jay,

The sa password ONLY works if you have enabled mixed mode authentication.
You can specify you want it in the setup.ini file. You'll also need to
specify an sa password there unless you also override that.

If you already have it installed, you can find the "LoginMode" parameter for
the service in the registry, change it to 2 (zero also works fine) and
restart the service.

For tools, we offer a product called MSDE Manager. Details are at:
www.whitebearconsulting.com. There is a utility, an ocx and a .NET user
control. We are about to ship a native .NET utility also. Google for others.

HTH,

 

[myLittleTools.net]

I'm guessing there is no Query Analyzer or Enterprise manager so how do you

create DBs etc?

you can use web-based application like myLittleAdmin
A free lite version is available on http://www.mylittletools.net/mla_sql

regards

 

[Cowboy \(Gregory A. Beamer\)]

By default, MSDE is set up with Windows authentication. You can specify
mixed mode when you install. As Greg mentions, you can do this in the
setup.ini file. You can also run this as an option from the command line
when you run setup. I do not have the URL, but there is a KB article on
support.microsoft.com that shows how to do this (actually shows how to
create a program to run the MSDE setup).

The program can be found here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814463

While the flags can be found here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;810826

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

 

[Brad Allison]

I just had to do this same thing you are speaking of last night. While reading about security in ASP.NET I found the following:
a.. Open a command window
b.. type the following: osql -S(local)\VSdotNET -E (after this you should see the prompt 1>)
c.. 1> sp_password NULL, ' <new password>', 'sa' (<new password> would be your password)
d.. 2> go
This worked for me just fine for MSDE.

Brad