Board index » Visual Studio » SQL Server Connection Error

Visual Studio296
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

www.bd-tech.com">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



"Áíôþíçò" <abiliardis@netscape.net>wrote in message

Sql1.Open()



-