MSDE Authentication

  • Thread starter Thread starter Anthony P. Mancini
  • Start date Start date
A

Anthony P. Mancini

Does anyone know how to make the MSDE do
SQL authentication ? It appears to authenticate
using Windows at all times.

Thanks,

Anthony
 
Ken,

Thanks for the reply. Is this post in the wrong newsgroup ? I figured
since I was working with .NET logging into the backend that this was the
place to post the question. The MSDE is already installed which is why
I'm having the authentication issue in the first place. The 'SecurityMode'
parameter looks like a command line setting to be used before the setup
is started. Can I use this as a startup parameter for the service ?

Also, with respect to your suggestion of third party MSDE managers;
hopefully you're not implying it isn't possible to change the authentication
mode of a Microsoft desktop software package using Windows. (?)

Anthony
 
Hi Anthony,

Yes, you'd probably get better answers in a SQL Server group.

That said, you need to do some tweaks to change modes and establish a
password. See the section titled Enable Mixed Mode Authentication After
Installation in this article:

HOW TO: Connect to Microsoft Desktop Engine

http://support.microsoft.com/?kbid=319930

Out of the box, most MSDE configuration has to be done with the command line
osql tool:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp

There's also tutorial here on changing the MSDE login mode:

http://gnonug.xocomp.net/Support/FAQ/595.aspx

FIX: If You Change Windows Security to Windows/SQL Security the SA Password
is Blank

http://support.microsoft.com/default.aspx?scid=kb;EN-US;274773
 
Ken,

Thanks for the response. The KB article you referenced had a registry
setting that could be modified to change MSDE's authentication mode.
Anyway, I'm using Enterprise Manager as the MSDE client tool which
was my reasoning for thinking this was a no brainer. It looks like some
of the admin level functions in EM don't necessarily function the same
way in MSDE, the database object stuff seems to work fine.

Thanks

Anthony
 
Back
Top