have SQL server 05, trying to make a data connection from Visual Studio 03
and get
connection failed
sql state 08001

Running Windows Server 2003 and SQL Server 2000
If we disconnect our 'primary' domain controller we can still log in to our
domain as we have another domain controller. Everything seems to work, other
than we can no longer log in to SQL Server using Windows Authentifiction. We

I'm running SBS 2003 Premium SP1 and all is well.  I've installed a new SQL
based application that requires a simple ODBC connection to the SQL database.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or ...

I'm curious about KB article (903002).
http://support.microsoft.com/default.aspx?scid=kb;en-us;903002
In this KB, it says that users that connect with a network packet size
greater than 8060, that it requires SQL Server to allocate memory from

in sql2000 I use msdasql, oledb provider for odbc (using openrowset) -- and
this works good to import odbc data right in a stored proc...
is there a clean way to access odbc data in sql2005? in a stored proc?, also
since msdasql is being phased out & its altogether not avail on ...

I am using SQL Server on my office.
I'm rather new to SQL but i was wondering if is possible to connect to this
SQL and read / modify a database from my home ?
I 'm not intersting to connect to the server over the web.

We attempted to create a link server between an MSDE database and MySQL 4.1
database using ODBC.  However, whenever we attempt to look at the tables
associated with the link we are greeted with the message:  Could  not create
an instance of OLE DB provider 'MSDASQL'. OLD DB error ...

I want to import varying excel spreadsheets into a sql server 2000 database
using the DTS import wizard. The excel spreadsheets are in various formats,
differing columns all the time, and the column sizes change all the time.
I want to be able to import data from the excel ...

I have a Windows 2003 svpk 1 server running SQL Ser 2000 svpk 3.  Trying to
access a asp.net application on the same server and get the following:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
Here is my connection string:

After a while, I figured out that I cannot connect to my local SQL Server 2k5
unless I specify "localhost\SQLEXPRESS" in the Server Name field.
Why can't you just specify "localhost"...  what does the "SQLEXPRESS"
imply...the service name?  The port?

My application is an Internet Application and is running in the
following environment:
- SQL Server 2000 Standard Edition EN
- Windows Server 2003

I have a sql server application program developped with ODBC. The program can
run at different computer and realize synchronization operation. But
sometimes it has error message :
"Attemp to scroll  past end or before beginning of data".

I'm trying to use the sample JDBC code provided in this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;313100
The stack trace I get when I run the program is this:
Exception in thread "main" java.lang.AbstractMethodError

I've just installed sql server 2005 enterprise on my Windows XP Professional
SP2 machine.
I can't find a way to connect with it.
I'm totaly new to SQL Server and have installed it to learn about it.

Does anyone know an easy way to detect whether a LinkedServer is running
without waiting for the TSQL statement to timeout? In otherwords, is there
some secret stored proc or exe or some library that will allow me to write
code to detect whether the LinkedServer is up and running ...