RE: Create Database in VS.Net IDE

From: Gary Chang (v-garych_at_online.microsoft.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 08:23:37 GMT

Hi Lori,

> But I get the following message:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
>

This error message could be caused by logging as SA user account with
Windows Authentication, the default authentication mode for MSDE 2000 is
Windows Authentication. MSDE 2000 installs with a built-in system
administrator (SA) user account. However, because SQL Server Authentication
is disabled by default, you cannot access the built-in account after a
typical installation.

Please refer to the following MSDN KB article for detail information:
http://support.microsoft.com/?id=321689

Thanks!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Relevant Pages

  • Confused about Windows Authentication
    ... I read in the help file for MSSQL 2005 that Windows Authentication is ... I don't want the connection strings available ... Create a user account in Master that gives it the rights to do ...
    (microsoft.public.sqlserver.security)
  • SQL Logins using local user accounts on a clustered instance.
    ... I could successfully add a domain user account as SQL Login using windows authentication. ... But when I tried to add the Local windows NT user account as an SQL login, it comes back and says something like "Can not find the user..." ...
    (microsoft.public.sqlserver.clustering)