[AccessD] Access 2003 and MSDE2000

Thanks Michael! That was it!

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael
Maddison
Sent: Tuesday, June 20, 2006 2:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2003 and MSDE2000

Is it a new installation?

By default installations of MSDE do not allow remote connections.
You can use SVRNETCN.EXE to enable network protocols - it's the SQL
Server Network Utility.

cheers


Michael M

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Tuesday, 20 June 2006 4:50 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2003 and MSDE2000

Hi All,

I am trying to connect to server running a named instance of MSDE2000.
When specifying the settings for the data link connection, I enter the
server name as ServerName\InstanceName but I keep getting the "SQL
Server does not exist or access denied"

>From the Server, I can connect to and manage MSDE2000 using Enterprise
Manager (I installed EM after the fact) by registering
ServerName\InstanceName.

Am I missing something?

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com