SQL Server Connection Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello to all

I am trying through VB.Net code to connect to a "System.Data.SqlClient.SqlConnecton" and receive the following error upon Sql1.Open(

"Unable to connect to a trusted sql server connection

Any thoughts? I am using BackOffice SQL Server Test Platform.
 
Hi Trent,

In all probability the SQL Server has been installed with "Windows only"
authentication only which is the default. The security settings need to
be changed to "SQL Server and Windows" authentication.

Hope this helps,
Antoni

_____________________________________________________________
B&D Technologies
http://www.bd-tech.com
Antoni Biliardis - antoni(at)bd-tech.com


O/H Trent Ýãñáøå:
 
Trent,

So you know, you can't just change the setting to use Windows and Sql Server
authentication. You must reinstall Sql Server to enable this option. I
could be wrong, but this is how I remember it being setup.

Raymond Lewallen

Áíôþíçò said:
Hi Trent,

In all probability the SQL Server has been installed with "Windows only"
authentication only which is the default. The security settings need to
be changed to "SQL Server and Windows" authentication.

Hope this helps,
Antoni

_____________________________________________________________
B&D Technologies
http://www.bd-tech.com
Antoni Biliardis - antoni(at)bd-tech.com


O/H Trent Ýãñáøå:
Click to expand...
"System.Data.SqlClient.SqlConnecton" and receive the following error upon
Sql1.Open()
 
Back
Top