SQL sa Login Error | Sql Login Fail | Sql Login Error | SQL Not connect Login Error

1.3K subsciber 1 month ago
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.
1.3K subsciber 1 month ago

#vinskvtech
sql sa login error fixed
sql error login
Sql not connect
#vinulogics #vinodkvtech

[sfkolo-gdwp]

como que no me quedó claro para donde van jajajaj me encanta