Re: SQL Connection String using Domain Account

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: royoel@xxxxxxxxx
Date: 23 Mar 2006 06:15:15 -0800

SqlConnection sqlCON = new SqlConnection(@"Password=Password;User
ID=Domain\userID;Data Source=ServerName\\ServerInstance; Initial
Catalog=DatabaseName;");

Above is your connection string with one change in the data source,
after server name add another "\". I am not quite sure why, but with
our web application last night this was an issue once again.

On some servers we can use simply:

Data Source=ServerName\ServerInstance

On others we will not be able to connect until we:

Data Source=ServerName\\ServerInstance

I am actually researching this right now and ran across this thread and
I hope that you figured out what the problem was already, but if not
this might help you.

.

References:
- SQL Connection String using Domain Account
  - From: Tim Sapp
- Re: SQL Connection String using Domain Account
  - From: Willy Denoyette [MVP]

Prev by Date: Re: Why use stored procedure in C#?
Next by Date: Accessing Arraylists
Previous by thread: Re: SQL Connection String using Domain Account
Next by thread: Absolute position of Elements within a web browser activex control
Index(es):
- Date
- Thread

Relevant Pages

Re: OLE DB connection string in SharePoint for Sybase ASA
... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > connection string" radio button and click on edit. ... > Server Error: An error occurred while retrieving the list of Databases ...
(microsoft.public.frontpage.client)
Re: OLE DB connection string in SharePoint for Sybase ASA
... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
(microsoft.public.frontpage.client)
Re: DBIx::DBH - Perl extension for simplifying database connectio ns
... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
(perl.dbi.users)
Re: How do I display data from an SQL server in SharePoint?
... Try again using a connection string including user and password. ... > IIS on a server that also hosts SharePoint Portal Server, ... > separate site from all of the SharePoint stuff. ... > create a database connection in the Data Source Catalog, ...
(microsoft.public.sharepoint.windowsservices)
Re: OLE DB connection string in SharePoint for Sybase ASA
... where I WANT it to say Database Connections. ... and up pops a Data Source Properties Window. ... connection string" radio button and click on edit. ... Server Error: An error occurred while retrieving the list of Databases from ...
(microsoft.public.frontpage.client)