SQL Server Connection Error

[Trent]

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 Ýãñáøå:

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 Ýãñáøå:

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.

[Raymond Lewallen]

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

"Áíôþíçò" <ab********@netscape.net> wrote in message
news:#3**************@TK2MSFTNGP10.phx.gbl...

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 Ýãñáøå:

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.

[Raymond Lewallen]

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

"Áíôþíçò" <ab********@netscape.net> wrote in message
news:#3**************@TK2MSFTNGP10.phx.gbl...

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 Ýãñáøå:

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.