Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Managing SQL when I can't find it???

Status
Not open for further replies.

Mich

IS-IT--Management
Dec 26, 2000
452
US
I have a feeling I'm going to feel pretty stupid when someone points out an obvious answer, but I've been digging for two hours and my brain is locked.

I've got 3 servers set up to function as backup servers via Veritas. My ultimate goal is to strip data out of the Veritas db tables to produce custom reports. I set up one of the servers and I can access the dbs/tables just fine. NOTE - SQL was already installed on this machine. However, another admin set up the other two servers and I can't find the tables ANYWHERE.

I can see that is it a named instance and I can see the data/log files, but I don't see that SQL has been installed on these machines. I cannot find Enterprise Manager, nor can I register these servers through another EM. I don't even see SQL in Add/Remove programs.

This may be an issue for the Veritas forum, but I thought I'd through it out here first. Can someone point me in the right direction?

Thanks in advance.
 
Veritas Backup Exec installs the MSDE version of SQL Server. It's a very basic stripped down version. It doesn't come with the Client Tools (Enterprise Manager, Query Analyzer, etc).

Is it installed? Look in Services and see if you can find the service for it. That will tell you the instance name.

You should be able to register it in your Enterprise Manager.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top