Access SP2 database on XP

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

Guest

I've installed the XPE SP2 database on XP Pro SP2 and my colleague want to
use the database from the tools on his XP Pro SP2 machine. But he keeps
getting the message Cannot connect to the database at 'MACHINE-NAME' from
Database Manager. What am I missing? From my XP machine I can use an old
database on a Win2K machine... What's the difference?
Thanks
/Göran
 
Maybe MSDE on the database machine is not set to accept connections from
other machines? Try Start->Run->svrnetcn and enable both TCP/IP and Named
Pipes for the MSDE instance you're using. if it's still not working, you
may need to do some troubleshooting to verify network and database
connectivity to the machine with the database. You can test with the Data
Sources control applet and verify if a user can connect to the MantisSQLDB
database.

KS

This posting is provided "AS IS" with no warranties and confers no rights.
 
Just an idea... Did you open proper ports on the XP SP2 machine where you have the SQL server (MSDE) running?
 
I have both TCP/IP and Named Pipes enabled. Exactly how do I test the
connecticity with the Data Sources control applet?
/Göran
 
I have the firewall turned off, so I was under the impression that all ports
would be open then. Isn't that correct?
/Göran
 
Just follow the UI on adding a user or a system DSN. For the driver, choose
SQL Server. Then give the DSN any name and description and point it to the
MSDE instance that your XPe database belongs to, which is by default the
machine name hosting the database. Then leave the authentication selection
as is (Windows NT authentication). Then change the default database to
MantisSQLDB (if you have the full version of the XPe tools) or
MantisSQLDBEval (for the evaluation version of the tools). Hit finish and
then click Test Data Source and see if it's successful. If not, note the
error message.

Alternatively, if you do have a SQL Server 2000 installation on one of your
machines, you can use the Enterprise Manager tool and connect to the
machine that hosts the XPe database and check the database. You might need
to adjust logins, users, permissions, etc.

For more info, see the following topic in the XPe docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xpehelp/htm
l/xetutadministrationguide.asp

Also refer to the SQL Server 2000 Help for additional info.

Also, please try connecting to other databases and see if this works. MSDE
comes with several built-in sample databases such as pubs and northwind.
You might have other networking issue and not necessarily database
connectivity problems.

KS

This posting is provided "AS IS" with no warranties and confers no rights.
 
Back
Top