MSDE login problem

[Lorenzo Bolognini]

Hi all,

I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use
with it.

I did install it with it's default options and now i'd like to administer it
with Web Data Administrator but it keeps telling me that i should enable SQL
Server Authentication.

So i tried debugging the question creating an .udl file and trying to test
various authentication methods:
- Integrated Windows authentication works fine
- SQL Server authentication (when i try logging in using user 'sa' with the
password i've set keeps telling me that user 'sa' is not associated with a
trusted SQL Server connection.

How do i solve this puzzle? Tried googling (and reading some faqs) but
didn't come up with anything useful.

Unfortunately the Web Data Administrator doesn't allow using integrated NT
authentication. :-(

Thank You,
Lorenzo

[Dan Guzman]

Check out MSKB 321698:

https://mvp.support.microsoft.com/de...b;en-us;321698

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Lorenzo Bolognini" <lo*****@mysurname.net> wrote in message
news:jN*********************@news2.tin.it...

Hi all,

I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use with it.

I did install it with it's default options and now i'd like to administer it with Web Data Administrator but it keeps telling me that i should enable SQL Server Authentication.

So i tried debugging the question creating an .udl file and trying to test various authentication methods:
- Integrated Windows authentication works fine
- SQL Server authentication (when i try logging in using user 'sa' with the password i've set keeps telling me that user 'sa' is not associated with a trusted SQL Server connection.

How do i solve this puzzle? Tried googling (and reading some faqs) but
didn't come up with anything useful.

Unfortunately the Web Data Administrator doesn't allow using integrated NT authentication. :-(

Thank You,
Lorenzo

[Lorenzo Bolognini]

"Dan Guzman" <da*******@nospam-earthlink.net> ha scritto nel messaggio
news:p_**************@newsread2.news.atl.earthlink .net...

Check out MSKB 321698:

Thank you very much Dan.

Lorenzo