Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alvintiow
Starting Member
4 Posts |
 Posted - 2008-08-19 : 06:28:32
|
| Hi,I had a program which using sql server 2000, it was previously running fine on win2k, but i wish to migrate the sql server 2000 to windows xp.The program can connect to sql server locally on windows XP, but remote computer(windows XP) cannot connect to the sql server 2000. I disable my firewall, in wirewall exception I set the port 1433 and the SQL server program, however this does not help.I am using TCP / IP.I used the script at http://support.microsoft.com/kb/839980/ but I still cannot connect to my Windows XP by remote computer, any advise for this?Thanks. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-19 : 06:52:59
|
You mean you installed the SQL Server on Windows XP ? What edition of SQL Server are you installing ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
alvintiow
Starting Member
4 Posts |
Posted - 2008-08-19 : 20:25:03
|
| Hi, I installed SQL 2000 personel edition on windows XP. My remote computer cannot connect to the SQL server 2000. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-19 : 23:16:21
|
| Did you get any error? Did you enable tcp/ip and/or named pipes in sql server? |
|
|
|
alvintiow
Starting Member
4 Posts |
Posted - 2008-08-20 : 01:04:46
|
quote:
Originally posted by rmiao
Did you get any error? Did you enable tcp/ip and/or named pipes in sql server?
Hi,I test the connection by these pc:(1)Windows 2000 with SQL server 2000(2)Windows XP with SQL server 2000(3)Windows XP with SQL server 2005The Win2k with SQL server 2000 (1) and Windows XP with SQL server 2005(3) can connect with each other successfully, Windows XP with SQL server(2) can connect to station (1) and (3)but both station (1) & (3) cannot connect to station (2). The server alias is correct.I ping the station (2) by server name and IP address and it has responsed, and I can link to the crystal report on station (2) but I cannot connect the SQL server successfully. The TCP/IP and named pipes are enabled, the multiprotocol and NWLink IPX/SPX are disabled.Can SQL server 2000 support remote connection on Windows XP? Do I need to do any configuration? |
|
|
|
alvintiow
Starting Member
4 Posts |
Posted - 2008-08-20 : 01:36:10
|
| Hi KHtan and Rmiao, I fixed the connection problem after I updated the sql server 2000 to SP4, thanks. |
|
|
|
|
|
|
|
|
SQL server 2000 connection on windows xp