Could not log in to SQL Server

Asked By 0 points N/A Posted on -
qa-featured

The Provisioning server used Windows Authentication while the SQL server is on a different machine.

Because of this I keep receiving a database error. I cannot even log in because of this error.

The Provisioning Server is Version 5.0 under Win 2008 and SQL 2008.

How can I fix this?

Provisioning Server Console

A database error occurred.

Critical Error

Login failed. The login is from an untrusted domain and cannot used with Windows authentication.

SHARE
Answered By 0 points N/A #124782

Could not log in to SQL Server

qa-featured

Good day Kirk!This is a very common error faced by so many people and I get lots of questions regarding this error. This error occur due to many reasons and I have already posted a few solutions pertaining this error, You can try these steps below:

(A)SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server.
(B)SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server.
 
Or
 
You can create a new user and connect to SQL SERVER 2008.
 
On common case this error occurs when trying to connect to SQL Server 2008. Try starting the services of  SQL Server from SQL Server services in the Configuration manager and if it will say that the request failed try disabling the VIA protocol and try the same procedure.
 
Here is how to disable the VIA follow the steps:
 
1. Go to SQL Server Configuration Manager.
2. Click on SQL Server Network Configuration node.
3. Click on Protocols for MSSQLSERVER
4. Disable the VIA Protocol.
5. And start the SQL SERVER (MSSQLSERVER) services again.
6. As the services are started 

Login/Register to Answer

Related Questions