?
Solved

Connecting to SQL Server 2000 From Windows Vista Client

Posted on 2009-02-10
16
Medium Priority
?
1,394 Views
Last Modified: 2013-11-29
I am using SQL Server 2000 installed on Windows Server 2003 on a seperate dedicated server machine.

When Trying create a DSN from Windows Vista Client I am not able to create this DSN

Screen shot of the error message is attached.

This error message only occurs when the user tries to connect from the Vista Client.
There are several other Clients that run XP or 2000 professional and these can connect without any problem

Does anyone have any idea what might be causing the problem? and how can we get around it?

All Machines are on same local area network.

Thanks in advance

Vimal Sheth

sqlserverlogin.jpg
0
Comment
Question by:VimalSheth
  • 9
  • 5
  • 2
16 Comments
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 80 total points
ID: 23599117
Try this from the command prompt:

telnet serverip 1433 (ur port opened on server firewall)

If you are able to connect, then its not an issue with server instead it is with the client.
Otherwise you need to enable or open ports from the server for the clients to access.
0
 

Author Comment

by:VimalSheth
ID: 23599280
i tried
telnet 172.16.0.1 1433
this is wat i get

Connecting to 172.16.0.1...Could not open connection to the host, on port 1433: Connect failed

but this fails even on XP n 2000 client machines where it works
0
 

Author Comment

by:VimalSheth
ID: 23599334
i am having mixed OS on clients
most of them are XP machines and a few of them are 2000 machines
i can create ODBC DSN from those machines to the same server
It is a problem only on vista machines

even on xp machines where i can create the DSN s
if i telnet i still get the errorr
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 23599337
Kindly check whether Local and Remote Connections are enabled in Surface Area Configuration and Both TCP/IP and named pipes are enabled in that server.

I hope till now, you have been connecting within your network.

To connect to this machine, check for the earlier one and then add an exception in Windows Firewall on the server machine for the port which you use to connect to server. The default is 1433.
0
 

Author Comment

by:VimalSheth
ID: 23599387
What is Surface Area Configuration?
TCP/IP and Named pipes are both enabled on 2000 server

as i told earlier i am able to connect ot same server from my other XP n 2000 clients

itz only with these new installations of vista that i have this problem with

i have other vista clients installed 3 months back...i can connect from them

but not from these new vista machines

all of them have same hardware configuration too
0
 

Author Comment

by:VimalSheth
ID: 23599409
i am using sql server 2000
do they have any surface area configuration tooll for that?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 23599411
Surface Area Configuration is a tool in SQL Server 2005, I just confused it over here.

Check this out:

http://www.ditii.com/2008/05/22/update-fix-for-sql-server-connection-in-windows-vista-xp-or-windows-server-2008/
0
 

Author Comment

by:VimalSheth
ID: 23599479
checked the link

the machine on which my sql server runs is windwows 2003 server
and the sql server is 2000
i am not using nything 2008

0
 
LVL 21

Expert Comment

by:mastoo
ID: 23602001
Just to isolate the problem, turn the vista firewall off temporarily.
0
 

Author Comment

by:VimalSheth
ID: 23603527
turned off the firewall

still does not work :|
0
 
LVL 21

Expert Comment

by:mastoo
ID: 23604522
Wouldn't think this would matter but you're signed on with admin rights on the Vista box?
Otherwise, last thought would be 64 bit.  If you're doing 64 bit we had a couple that wouldn't work until we selected 32 bit native sql drivers.  Then I'm out of ideas :-(
0
 

Author Comment

by:VimalSheth
ID: 23608688
i'm signed in with admin rights in on vista box

n i am using 32 bit version of windows

still this is not working

earlier it was working.....but after reinstallation of windows vista it is not working :-(
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 23610210
This should help you out:

http://support.microsoft.com/kb/827422
http://michael.omnicypher.com/2006/10/sql-server-2000-on-vista.html

As per the second post, In Vista eventhough you set the SQLSERVER service to automatically start, it will say it as started but actually it wont. Hence we may obtain this kind of problems.

To resolve this, you need to set it as Automatic(Delayed Start) which should fix your problem.
0
 

Author Comment

by:VimalSheth
ID: 23621666
my sql server is not installed on vista
itz installed on windows 2003  server machine
itz my client that is on vista
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 23622099
Ok.. First site is for you, confused the second site..
0
 

Accepted Solution

by:
VimalSheth earned 0 total points
ID: 23772992
Finally i found the solution
the problem was need to install SQL server 2000 service pack 4 in the sql server

Thanks all
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article covers five tools all IT professionals should know about, as they up productivity by a great deal!
Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
Viewers will learn how the fundamental information of how to create a table.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decadeā€¦

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question