Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connect & Manage remote SQL 2000 DB from Vista Ultimate (64 Bit)

Posted on 2007-03-23
3
Medium Priority
?
393 Views
Last Modified: 2010-02-09
I am running Vista Ultimate 64 bit.  I have installed SQL Server 2000 & CLient Tools.  My local database is running fine with no errors and my ASP.NET apps are connecting locally without any issues.

My LIVE server is housed in a datacenter and I need to access the LIVE SQL server remotely from my PC.  With windows XP I simply run the "Client Netwrok Utility" that comes as part of the client tools and setup an alias, using TCPIP to my server.  Then in Query Analyser or Enteprise Manager I simply connect to that alias.  I can confirm that on a windows XP machine all this is working fine on the same local network, so Firewall issues have been ruled out, and server issues have been ruled out.

When trying to do the same on Vista I can setup the alias in the "Client Network Utility" using the same settings, ports, as windows XP.  However when I try to connect to this through Query Analyser, or Enteprise Manager, I get a SQL server does not exist or access is denied.  

Clues:

In the "Client Network Utility"  the tab called "DB-Library Options" gives the DB-Library Information for the ntwdblib.dll.  In XP all the info is displayed, but in Vista it just says "N/A" for each of the items.

In Enteprise Manager, normally after creating an alias through the "Client Network Utility" I can see the Alias as a choice of database to connect to (When registering a new database).  In Viusta However this does not show,

I am logged in as an administrator and I have tried all this with all apps running as administrator.

Any Ideas anybody?

0
Comment
Question by:thechatking
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
MikeToole earned 2000 total points
ID: 18778853
I had a feeling that SQL Server 2000 wasn't supported for installation on a Vista machine. Not sure about the client tools. You can always try installing SQL Server 2005 and use the Management Studio tool from that to access your SQL Server 2000 instance
0
 

Author Comment

by:thechatking
ID: 18791916
Hi Mike,
Thanks for your reply.  I did what you said and It now works.  The problem was related to the 64bit verison of Vista I am using.  I 'think' the SQL Server Client Network utility from 2000 would have worked fine with the 32 bit version of Vista.

I installed the client tools for SQL 2005, when I ran the SQL Management Studio I still could not connect to my remote SQL 2000 DB. However what I found through the help was that I needed to run the "SQL Server Configuration Manager" that comes with SQL 2005.  This has a section called "SQL Native Client Configuration"  (There is one with (32bit) after the name too and so I assume the one I used was the 64 bit version.)  I added an alias to my LIVE server in here just like you would using the SQL 2000 Client Network Utility.  After I did this I could connect using the SQL 2005 Management Studio - on top of this I can now connect to this alias through SQL 2000 Enteprise manager and Query Analyser.

Thanks very much for your help!
0
 
LVL 27

Expert Comment

by:MikeToole
ID: 18791964
Glad to oblige, thanks for the rating :¬)
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

An article on effective troubleshooting
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

670 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