View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 06:24 PM
Dan Guzman
 
Posts: n/a
Default Re: MSDE login problem

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" <lorenzo@mysurname.net> wrote in message
news:jNaYa.42647$cl3.1359277@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
>
>



Reply With Quote