SQL Server Connection Error - Visual Basic .NET

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.

Nov 20 '05 #1

Subscribe Post Reply

1520

Áíôþíçò

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.

Nov 20 '05 #2

Áíôþíçò

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.

Nov 20 '05 #3

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.

Nov 20 '05 #4

Raymond Lewallen

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.

Nov 20 '05 #5

Similar topics

Connecting to Server Problem

by: Suresh | last post by:

Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...

DB2 Database

HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?

by: Marcus | last post by:

I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...

Visual Basic .NET

Server Error in '/mates' Application.

by: James | last post by:

Hello, I have written a simple logon page that redirects to another page when successful. All works fine on my computer but when I upload it I get the error message below. I have written it...

ASP.NET

C# Web Site. Connecting to SQL Server. Test Connection Fine...BUT

by: samadams_2006 | last post by:

Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express...

ASP.NET

SQL 6.5 server connection problem

by: sherifbk | last post by:

Problem description ============== - I have 4 clients and 1 server (SQL server) - 3 clients are Monitoring console 1 client is operation console - Monitoring console collects some data from...

Microsoft SQL Server

by: eruth | last post by:

There are loads of post on this, but nothing that seems to cover my exact problem ;) I have an ASP.Net 1.1 web application running on my local machine. I want to connect to an SQL 2005 server...

ASP.NET

ASP and SQL Server 2005 Express

by: Anil Gupte | last post by:

I am using the following to try to connect to the database, but it does not seem to be working. Dim sConnString sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security...

ASP / Active Server Pages

Mysql database in UTF8, PHP shows latin1 (iso-8859-1)

by: alex | last post by:

I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...

PHP

Error "SQL Server does not allow remote connections"

by: Cirene | last post by:

I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice