connection error #17:

[Janis]

I am trying to install the ODBC SQL SErver system driver in the System ODBC
Manager in
the ODBC Services control Panel. I have Windows XP Professional. I should
have the latest updates and service packs. I have SQL Server Express 2005
service running. I also have the SQL SErver browser service running.

The complete error:
Connection failed SQL State '08001' SQL Server errpr 2
MS ODBC SQL Server Driver [shared memory] connection open (Connect())
Connection failed
SQL Server error 17
SQL Server does not exist or access denied.

I can find the local server in the System DSN tab and the server name. In
fact both are listed twice but when I click finish I get this error for
connecting to either of them. What can I do to get the ODBC SQL Server
system driver installed? I need to migrate a Filemaker 10 database to SQL
Server. But at this point I can't get the MS SQL Driver to install.

thanks,

[Erland Sommarskog]

The driver is already installed, but apparently you have problem setting
up a data source.

What did you specify for the server name? By default, SQL Server Express
is installed as a named instance, so your best bet is to say .\SQLEXPRESS.
(The dot is short for the local machine. You can also use the machine
name or (local).)

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx