ODBC Connection failing

[SirGally]

Hi,

I am trying to install SQL Server onto a client windows XP machine.

I have installed SQL but my ODBC connection is failing.

It cant see the server instance, not even (local).

Any ideas on where im goin wrong?

Cheers

 

[fuzzyocelot]

What version of SQL did you install? Did you install any SQL service packs? Is the SQL Server service running? Are you getting any specific error messages?

 

[SirGally]

its SQL Server 2000

8.00.194 - (Service Pack 2)

I didnt install the service packs but above is what its says when i do a SELECT @@version

The services are running and the specific error occurs when i try to set up an ODBC connection

it tells me my sql server does not exist!

I can see my instance of the server in enteprise manager but it is not offered when creating ODBC connection.

within my SQL server groups , my instance appears as

computer name/computer name(Network NT)

Should I reinstall SQL??????

 

[fuzzyocelot]

It shouldn't hurt to download and apply the latest service pack which is service pack 4. Have you checked the Server Network Utility? If not, run it and see if you have TCP/IP and/or Named Pipes enabled. I'm wondering if that has something to do with it.