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, 2022 in Database by Kithuzzz
• 38,000 points
1,100 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, 2022 by narikkadan
• 63,600 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, 2022 in Database by Kithuzzz
• 38,000 points
587 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, 2022 in Database by Vaani
• 7,070 points
690 views
0 votes
0 answers

How to update Identity Column in SQL Server?

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

Aug 9, 2022 in Database by Kithuzzz
• 38,000 points
1,377 views
0 votes
0 answers

Simple DateTime sql query

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

Aug 12, 2022 in Database by Kithuzzz
• 38,000 points
615 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, 2022 in Database by Kithuzzz
• 38,000 points
1,227 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, 2022 in Database by narikkadan
• 63,600 points
795 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, 2022 in Database by narikkadan
• 63,600 points
2,642 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