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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Just cant do anything with this.

Status
Not open for further replies.

Fatih235

MIS
May 30, 2002
19
US
Hi all;

I have SQL Server 7.0 on my stand alone pc.When i want to work on SQL(creating databases,tables etc.) it automatically tries to connect to a server and it fails of course(cause i dont have any server attached to my pc).I cant do anything about it.Any suggestions?


Thanks.
 
Check the properties of Enterprise Manager (Tools | Options | Advanced) and see open console tree to last note option is on.

This option exists nder SQL 2K, and I think under 7.0 EM as well
 
Within Enterprise Manager check the database is listed if not you will have to register the database, right click sql server group and select new server registration - use (local) as server name. Also check its started, right click the server name click start if its enabled. You can change the properties to auto start on boot up.

hope this helps

cjw
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top