Linking Tables to SQL Server Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am able to link an Access table to SQL Server from my computer. When I do
the same on another computer with the same operator/password, I get the
following error:

Connection failed:
SQL State '01000'
SQL Server Error 2
[Microsoft] [ODBC SQL Server Driver][Named Pipes] Connection Open (Create
File()).

Connection Failed:
SQL State '08001'
SQL Server Error: 6
[Microsoft] [ODBC SQL Server Driver][Named Pipes] Specified SQL server not
found.

Is there something that must be set up on this individuals PC in order for
them to access SQL Server ?
 
The server has not been found, so something must be wrong with the
connection string used or you have a firewall who is blocking the
connection.

In the same way that ODBC can use DNS or DNS-less connection, with the right
parameters, it's possible to connect from another machine to a local
SQL-Server with either setting something or nothing on the local machine or
on the remote machine. Here are some references that will help you resolve
this issue:

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

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
 
Thank you.

Sylvain Lafontaine said:
The server has not been found, so something must be wrong with the
connection string used or you have a firewall who is blocking the
connection.

In the same way that ODBC can use DNS or DNS-less connection, with the right
parameters, it's possible to connect from another machine to a local
SQL-Server with either setting something or nothing on the local machine or
on the remote machine. Here are some references that will help you resolve
this issue:

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

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.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


rmcompute said:
I am able to link an Access table to SQL Server from my computer. When I
do
the same on another computer with the same operator/password, I get the
following error:

Connection failed:
SQL State '01000'
SQL Server Error 2
[Microsoft] [ODBC SQL Server Driver][Named Pipes] Connection Open (Create
File()).

Connection Failed:
SQL State '08001'
SQL Server Error: 6
[Microsoft] [ODBC SQL Server Driver][Named Pipes] Specified SQL server not
found.

Is there something that must be set up on this individuals PC in order for
them to access SQL Server ?
Click to expand...
Click to expand...
 
Back
Top