Access 2007 Project Can't connect to SQL Server 2005 on my machine

[Guest]

I have SQL Server 2005 Developer Edition installed on my PC. I can connect to
it with SQL Server Management Studio and with a Visual Studio web Project
running on the same PC. However, when I create an Access 2007 Project (same
PC) and set the SQL connection to connect to the same SQL Server, I get "Test
connection failed because of an error initializing provider
[DBNETLIB][ConnectionOpen(Connect()). SQL Server does not exist or access
denied.", when I test the connection. If I close the connection dialogue
window, I also get "[DBNETLIB][ConnectionOpen(Connect()).SQL Server does not
exist or access denied."

I can connect to other remote SQL Server databases just fine. I just can't
connect to the one running on my PC.

It seems resonable to be able to use a developer version of SQL server when
I am doing development of an Access Project. So, what am I missing?

Does anyone have a solution? Or does anyone know how to connect MS Access
2007 running on a PC to a SQL Server 2005 DB on the same PC?

Thanks in advance.

K.E.

 

[Paul Shapiro]

You didn't say how you specified the workstation as the server. On my system
"(local)" works (without the quotation marks) as the server name. It also
depends on what connectivity you've allowed the SQL Server. There's a SQL
Server Configuration Manager where you can specify the enabled
communication.

 

[Guest]

Paul,

The instance of SQL Server 2005 Developers Eddition is on my PC; which is a
workstation.

Thanks for the tip. By default, the "Protocals" was only set for "Shared
Memory". Once I added "Named Pipes" and "TCP/IP", I was able to connect to
the Server with Access 2007.

K.E.

You didn't say how you specified the workstation as the server. On my system
"(local)" works (without the quotation marks) as the server name. It also
depends on what connectivity you've allowed the SQL Server. There's a SQL
Server Configuration Manager where you can specify the enabled
communication.

I have SQL Server 2005 Developer Edition installed on my PC. I can connect
to
it with SQL Server Management Studio and with a Visual Studio web Project
running on the same PC. However, when I create an Access 2007 Project
(same
PC) and set the SQL connection to connect to the same SQL Server, I get
"Test
connection failed because of an error initializing provider
[DBNETLIB][ConnectionOpen(Connect()). SQL Server does not exist or access
denied.", when I test the connection. If I close the connection dialogue
window, I also get "[DBNETLIB][ConnectionOpen(Connect()).SQL Server does
not
exist or access denied."

I can connect to other remote SQL Server databases just fine. I just can't
connect to the one running on my PC.

It seems resonable to be able to use a developer version of SQL server
when
I am doing development of an Access Project. So, what am I missing?

Does anyone have a solution? Or does anyone know how to connect MS Access
2007 running on a PC to a SQL Server 2005 DB on the same PC?