Connecting Access 2003 to SQL Server 2005 Express

[Guest]

How do I configure Access 2003 to connect to SQL Server 2005 Express?

I recently installed SQL Server Express on my WinXP machine. I start Access
2003 and create an .ADP file. When I try to connect to a SQL Server database
using the Data Link Properties dialog, I am able to select the name of the
SQL Server that is running on my machine. I use windows authentication to
connect. But, when I try to select a database, I get the following error
message:

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access
denied.

Window patches are current and I am using SQL Server with service pack 1
applied.

Thanks in advance for your help.

 

[Joan Wild]

I don't believe you can. You need to use MSDE (the SQL Server 2000
equivalent to Express) with Access 2003, or you can try Access 2007 with SQL
Server Express.

 

[Guest]

I know that I can't create new objects using Access 2003 and SQL Server
2005, but I am under the impression that I can still connect and use tables
using ADO. I am also having trouble creating an ODBC connection using ODBC
Administrator. I have the Native Client Driver installed. I get a similar
error message. Can you suggest how to connect using ODBC or point me to a
resource that describes the step to set it up and how SQL Server is to be
configured?

Thanks.
--
joe B

I don't believe you can. You need to use MSDE (the SQL Server 2000
equivalent to Express) with Access 2003, or you can try Access 2007 with SQL
Server Express.


--
Joan Wild
Microsoft Access MVP

How do I configure Access 2003 to connect to SQL Server 2005 Express?

I recently installed SQL Server Express on my WinXP machine. I start
Access 2003 and create an .ADP file. When I try to connect to a SQL
Server database using the Data Link Properties dialog, I am able to
select the name of the SQL Server that is running on my machine. I
use windows authentication to connect. But, when I try to select a
database, I get the following error message:

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or
access denied.

Window patches are current and I am using SQL Server with service
pack 1 applied.

Thanks in advance for your help.

 

[Sylvain L.]

Make sure that you don't have installed a named instance instead of a
default instance. If you have installed a named instance, then you must add
its name after the name of the server. In the case of SQL-Server 2005, I
think that the default name is SQLEXPRESS, which gives you
MYSERVER\SQLEXPRESS as the result.

Here are some references for troubleshooting connection problem with
SQL-Server 2005 Express:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx


--
Sylvain Lafontaine, ing.

I know that I can't create new objects using Access 2003 and SQL Server
2005, but I am under the impression that I can still connect and use
tables
using ADO. I am also having trouble creating an ODBC connection using
ODBC
Administrator. I have the Native Client Driver installed. I get a
similar
error message. Can you suggest how to connect using ODBC or point me to a
resource that describes the step to set it up and how SQL Server is to be
configured?

Thanks.
--
joe B

I don't believe you can. You need to use MSDE (the SQL Server 2000
equivalent to Express) with Access 2003, or you can try Access 2007 with
SQL
Server Express.


--
Joan Wild
Microsoft Access MVP

How do I configure Access 2003 to connect to SQL Server 2005 Express?

I recently installed SQL Server Express on my WinXP machine. I start
Access 2003 and create an .ADP file. When I try to connect to a SQL
Server database using the Data Link Properties dialog, I am able to
select the name of the SQL Server that is running on my machine. I
use windows authentication to connect. But, when I try to select a
database, I get the following error message:

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or
access denied.

Window patches are current and I am using SQL Server with service
pack 1 applied.

Thanks in advance for your help.

 

[dbahooker]

Microsoft should be releasing an Access 2003 / SQL 2005 patch soon

I know that I can't create new objects using Access 2003 and SQL Server
2005, but I am under the impression that I can still connect and use tables
using ADO. I am also having trouble creating an ODBC connection using ODBC
Administrator. I have the Native Client Driver installed. I get a similar
error message. Can you suggest how to connect using ODBC or point me to a
resource that describes the step to set it up and how SQL Server is to be
configured?

Thanks.
--
joe B

I don't believe you can. You need to use MSDE (the SQL Server 2000
equivalent to Express) with Access 2003, or you can try Access 2007 with SQL
Server Express.


--
Joan Wild
Microsoft Access MVP

How do I configure Access 2003 to connect to SQL Server 2005 Express?

I recently installed SQL Server Express on my WinXP machine. I start
Access 2003 and create an .ADP file. When I try to connect to a SQL
Server database using the Data Link Properties dialog, I am able to
select the name of the SQL Server that is running on my machine. I
use windows authentication to connect. But, when I try to select a
database, I get the following error message:

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or
access denied.

Window patches are current and I am using SQL Server with service
pack 1 applied.

Thanks in advance for your help.