Connection-problem

[Filips Benoit]

Dear All,

New computer having Windows 7 and office 2007
old computer having Windows XP and office 2003

I have copied a adp from old to new and changed the servername >
computername\SQLEXPRESS and works OK

BUT when i try to make a new adp on new computer using the same
serverpropertied I receive this error

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

any idea where it goes wrong?

Filip

 

[Filips Benoit]

Found a solution:
Have to reset the property 'Network library' to null under the ALL-tab in
the Data-link-properties
It was set to DBMSSOCN ( means nothing to me).
Now I can connect to any existing database but NOT migrate a mdb to a new
sql-database
since Magrating a mdb doesn't show the Data-link-properties-window !

Filip

 

[Sylvain Lafontaine]

DBMSSOCN is for the TCP/IP network library. My guess would be that a
firewall is blocking the connection or that the instance
computername\SQLEXPRESS is not set to accept TCP/IP connection. Another
possibility would be to you forgot to specify the name of the instance -
using only "computername" instead of computername\SQLExpress" - or that the
SQL-Server Browsing service is not running. BTW, you don't tell us where
this sql-server is located: on the same machine or on another?

It's also possible that you have a security problem, for example, yo try to
use a sql-server login instead of a windows login but the Mixed
Authentification mode has not been enable on the sql-server.

I suggest that you take the time to study the various configuration options
for SQL-Server as well as at its security panel.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

Found a solution:
Have to reset the property 'Network library' to null under the ALL-tab in
the Data-link-properties
It was set to DBMSSOCN ( means nothing to me).
Now I can connect to any existing database but NOT migrate a mdb to a new
sql-database
since Magrating a mdb doesn't show the Data-link-properties-window !

Filip

Dear All,

New computer having Windows 7 and office 2007
old computer having Windows XP and office 2003

I have copied a adp from old to new and changed the servername >
computername\SQLEXPRESS and works OK

BUT when i try to make a new adp on new computer using the same
serverpropertied I receive this error

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

any idea where it goes wrong?

Filip

 

[Filips Benoit]

My TCP/IP protocol was disabled !!

All programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server
configuration Manager > Network configuration > Protocols then enable TCP/IP
protocol AND close and reopen SQL-Server 2005.

Done,

Filip

DBMSSOCN is for the TCP/IP network library. My guess would be that a
firewall is blocking the connection or that the instance
computername\SQLEXPRESS is not set to accept TCP/IP connection. Another
possibility would be to you forgot to specify the name of the instance -
using only "computername" instead of computername\SQLExpress" - or that
the SQL-Server Browsing service is not running. BTW, you don't tell us
where this sql-server is located: on the same machine or on another?

It's also possible that you have a security problem, for example, yo try
to use a sql-server login instead of a windows login but the Mixed
Authentification mode has not been enable on the sql-server.

I suggest that you take the time to study the various configuration
options for SQL-Server as well as at its security panel.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

Found a solution:
Have to reset the property 'Network library' to null under the ALL-tab in
the Data-link-properties
It was set to DBMSSOCN ( means nothing to me).
Now I can connect to any existing database but NOT migrate a mdb to a new
sql-database
since Magrating a mdb doesn't show the Data-link-properties-window !

Filip

Dear All,

New computer having Windows 7 and office 2007
old computer having Windows XP and office 2003

I have copied a adp from old to new and changed the servername >
computername\SQLEXPRESS and works OK

BUT when i try to make a new adp on new computer using the same
serverpropertied I receive this error

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

any idea where it goes wrong?

Filip