Home > IT Answers > Microsoft Windows > SQL Server 2005
Trevione
0 pts.
 SQL Server 2005
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
I just installed SQL Server 2005 (Standard Edition) on a Windows Server 2003. I still have SQL Srever 2000 and I used the export utility to copy a database from one of my SQL 2000 server to my new SQL 2005 server. Everything copied over and tables were created. The database is there for me to see in the Management Studio. Thing is when I go to a W2K client and try to do an ODBC connection I get to the step where I select the SQL Server and the database. I don't see my server or database. Am I missing a step? Thanks in advance.

Software/Hardware used:
ASKED: June 5, 2006  7:24 PM
UPDATED: June 6, 2006  10:23 AM
RELATED QUESTIONS
Answer Wiki:
Have you got the latest MDAC version on you w2k client?
Last Wiki Answer Submitted:  June 6, 2006  7:56 am  by  Lsandhar   0 pts.
All Answer Wiki Contributors:  Lsandhar   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

In the surface area configuration on sql 2005. Is the allow remote clients to connect set on?

Lsandhar
 0 pts.
 

I’m not sure what W2K is?? Did you also move the users over?

William

WHDILLON
 0 pts.
 

I have MDAC 2.71 running on W2K (Windows 2000 Pro).
Yes the “Allow remote connections to this server” is enabled.

Trevione
 0 pts.