I am building an application using VB 2008 Express and SQL Server 2005
Express. When connecting to a local SQL server, I have no problems. However,
I want to connect to SQL Server 2005 Express on a remote computer on the
LAN, and I've not been able to accomplish this. All the ...

Because there's no automated way to backup my databases in SQL Server
Express 2005, I'm trying to use sqlcmd and call an sql file to execute the
steps. I keep getting a connection error. Here is what I'm doing:
The AUOTBACKUP.BAT file has a single line to connect the machine

I'm sorry for the lame question, but I'm new to SQL SERVER.
I'm building an application in ASP.NET/C# and I'm connecting to the SQL
SERVER using user sa and its password:
connectionString="Data Source=SQL-SERVER; Initial Catalog=mydb; User

When I try to create DNS connection using SQL Driver from ODBC Data Source
Administrator I am getting an error:
“[Microsoft][ODBC Driver Manager] Data Source Name not found and no
default driver specified. When I check SQL Driver in the Driver’s page of

Has this driver been tested on websphere version 5.1?

Wanted to know how I would go about calling an as400 program on sq server
2000 using tsql's OPENQUERY ?
I read that in 2000, the program can't return a result nor accept
parameters. So I have:

Do we need to purchase licenses from MS for JDBC driver or is it a part of
MS SQL Server License?
If we need to purchase licenses, could some one share the details like web
rsources etc.,

I have some  test programs I run which do repeated simple SQL Select and SQL
update statements.  These test programs consistently take 5 to 10% longer to
run with the new JDBC 1.2 driver than they do with the JDBC 1.1 driver.  Is
this expected? I thought the new driver was ...

Unable to log into remote Sql Server through a local machine using Visual
Studio 2008.  I received  the following error message:
"A connection was sucessfully established with the server, but then an error
occurred during the login process. (provider:TCP Provider, error:0 - The

I'm not really sure the right place for this, but I thought here was the
closest place.
I have been using SS2005 on individual servers for years, never had any
consistent problems with connections. Recently my company has switched to

I really need help on this one.
I have a database application (SQL server 2005 vs Access 2003) that two
users need to access (let's call them A nad B.) In the deployment process,
one of them has successfully connected to the database but the other cannot

We use SQL Server 2005 (with SP2) for multi applications. Since sa password
change requested by Internal/External audit, I start this test now.
I got problem after I change the sa password, DB backup that generate from
Maintenance Plan Wizard job was failed. Try to drop and ...

Hi all, I have written a Windows Service that attempts to connect to an SQL
2005 Express Database when started.  The login always fails.  The login uses
Windows Authentification (NT AUTHORITY/SYSTEM user).
I also tried connecting using the "sa" SQL Server login, and it still fails ...

I have a vb6 application that connects to SQL Server 2005 database (with
compatibility set to 80) using ADO 2.8 (sp1). At some point of time you can
not create temp tables using ADO Connection object. Here is the sample code
that proves it.

Dear all I am having "issues" connecting to the sample DB's on a fresh
install of SQL 2005 via ODBC.
I can create a working ODBC connection on the server, but am unable to
connect from an XP SP2 workstation.