I use windows 7 ultimate. I can login with windows authentication mode but SQL authentication with user sa
doesn't work. sa
user is enabled. So what do I do?
Go to your server, click on Security and then Logins, right click on sa and then click on Properties. Now go tot Status and then select Enabled under Login. Then, click OK. Now we can restart the SQLExpress, or the SQL you are using.
Check out Windows or Mixed authentication mode is enabled. For that, select the database, right click on it, and choose “Properties”. In the Security tab, check out the server authentication section. If the authentication mode is changed, then do not forget to restart SQL Server to allow changes to take place.
Right click on the database server and go to properties. Choose the security option and check "SQL Server and Windows authentication mode". Enable TCP/IP connection in SQL Configuration Manager. Restart your SQL server.
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
Note: The server must be stopped and re-started before this will take effect
Error 18452 (not associated with a trusted sql server connection)
Click on Start menu > Programs > Microsoft Sql Server > Configuration Tools
Select Sql Server Surface Area Configuration.
Now click on Surface Area configuration for services and connections
On the left pane of pop up window click on Remote Connections and Select Local and Remote connections radio button.
Select Using both TCP/IP and named pipes radio button.
click on apply and ok.
Now when try to connect to sql server using sql username and password u'll get the error mentioned below
Cannot connect to SQLEXPRESS.
ADDITIONAL INFORMATION:
Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) ation To fix this error follow steps mentioned below
connect to sql server using window authentication.
Now right click on your server name at the top in left pane and select properties.
Click on security and select sql server and windows authentication mode radio button.
Click on OK.
restart sql server servive by right clicking on server name and select restart.
Now your problem should be fixed and u'll be able to connect using sql server username and password.
Have fun. Ateev Gupta
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With