Before SSMS...Server 7

Question

Before SSMS...Server 7

malcolm.garbett

Ten Centuries

Points: 1160
More actions
July 11, 2015 at 7:52 am

#298450

Hello,
Apologies for (possibly) dumb question, but...
What do I use to connect to a pre-2005 database?
I used Informix until around 2005. My introduction to MS SQL Server was 2005 edition so I used SSMS from the start.
Now, I need to query a redundant application at work that is running on SQL Server 7.
Can I use SSMS to connect or do I need a different tool? And if I need something different, please URL where I can find it.
Thanks. 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

i still have one sql 2000 legacy machine, and i can connect ot it via SSMS, but the original SQL200 installation had two tools, "Enterprise Manager" and "Query Analyzer"

SSMS combines those tools together, and you should be able to do most of what you need from SSMS.

alternatively, you cna run those tools on the installed instance via remote desktop, i guess.

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!

malcolm.garbett Ten Centuries Points: 1160 More actions · Answer 2

Hi Lowell,

Many thanks for rapid response.

Will attempt the connection from SSMS on Monday.

(Here's hoping my predecessors in the job have left the login password in the documentation!)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

malcolm.garbett (7/11/2015)
Hi Lowell,
Many thanks for rapid response.
Will attempt the connection from SSMS on Monday.
(Here's hoping my predecessors in the job have left the login password in the documentation!)

Hopefully the environment is setup such that domain groups have access and you were added to the domain group. Then you can possibly change the password without needing to know the sa password.

Of course, that also means they, hopefully, can't have used sa for the application connections. If they did and you change the password there might be a bit of a problem.:-D

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lowell SSC Guru Points: 323504 More actions · Answer 4

in SQL7/SQL2000, the Builtin\Administrators group automatically inherits sysadmin in sql instances ont he same server, so if you are in the local administators group on server, you have sysadmin, andn would be good to go, without having to track down the sa password(which might have been defaulted to blank! remember when you could do that?)

it's possible someone removed the permission, but i doubt it, it's the defautl and most people leave that kind of stuff alone.

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!