Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cann't log on SQL Server 7.0
Message
 
 
To
14/07/2002 14:10:45
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00678505
Message ID:
00678515
Views:
13
>Hello Group,
>
>When I click on my local server in Enterprise Manager It opens with no problem. When I select Query analyzer from the tools, it opens with no problem. If everything is closed and I open query analyzer by it self and try to logon as sa I get the error "Login failed forf user sa not associated with trusted server connection"
>
>How do I fix this.

It looks like Sql Server Security is set to Windows Authentication and 'sa' isn't valid WIndows user. You can switch security to the Mixed Mode authentication. In Mixed Mode users can connect to the SQL Server using SQL Server Authentication or Windows Authentication. You can change authentication mode by tight click on the Sql Server in the EM, select Properties and click Security tab.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform