RE: connect to a sql server 7 instance

SSC Guru

Points: 323504

August 20, 2010 at 12:09 pm

#1209850

VNC/Remote Desktop/ TeamViewer / PCAnywhere / GoToMyPC are desktop viewers,

you don't need that.

SQL Server Management Studio is the interface of choice and is backwards compatibile, and can connect to any version of SQL Server...so if you have the client tools on your machine, just put in the servername and connection info and you should be good to go.

now if you don't have a username/password for that old SQL 7 instance...that's another story.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!