Login failed for user sa The user is not associated with a trusted SQL Server connection Microsoft SQL Server Error 18452 in sql 2008

0 votes
Windows 7 Ultimate is what I use. Although SQL authentication with user sa doesn't work, I can log in using Windows authentication mode. The sa user is active. What then shall I do?
Sep 11 in Database by Kithuzzz
• 20,660 points
146 views

1 answer to this question.

0 votes

Solution

Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.

Right-click the SQL Server instance name > Select Properties from the context menu > Select Security node in left navigation bar.

Under Authentication section, select SQL Server and Windows Authentication.

I hope this helps you.

answered Sep 12 by narikkadan
• 37,660 points

Related Questions In Database

0 votes
0 answers

Where can I find the Northwind database for Microsoft SQL Server 2008

To hone my Linq-fu , I'm looking ...READ MORE

Aug 15 in Database by Kithuzzz
• 20,660 points
96 views
0 votes
1 answer

Rename column SQL Server 2008

Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
93 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

Aug 9 in Database by Kithuzzz
• 20,660 points
360 views
0 votes
0 answers

Simple DateTime sql query

How do I query the DateTime database ...READ MORE

Aug 12 in Database by Kithuzzz
• 20,660 points
57 views
0 votes
0 answers

Calculate time difference in minutes in SQL Server

I require the minutes-based time difference between ...READ MORE

Aug 13 in Database by Kithuzzz
• 20,660 points
308 views
0 votes
1 answer

What is the use of a cursor in SQL Server?

Instead of receiving a result set as ...READ MORE

answered Sep 13 in Database by narikkadan
• 37,660 points
83 views
0 votes
1 answer

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

The BIT datatype can be used to ...READ MORE

answered Sep 15 in Database by narikkadan
• 37,660 points
197 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP