Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Unable to connect to Database Engine on New Query Window Expand / Collapse
Author
Message
Posted Wednesday, August 11, 2010 11:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, Visits: 105
It worked yesterday but it's not working today.. No changes were made to the system.

But when I click on "NEW QUERY" button, it does not connect to the Database Engine.
When I click on "Connect" button, Server type is greyed out and is fixed on Analysis Services.
The only place where I am able to modify is Server Name, but it wouldn't help at all because the Server Type is fixed onto Analysis Services.
I am able to connect to the server though, I can see the tables from the object explorer. But I can't query anything.


I'm extremely frustrated and have no idea why this is behaving tihs way..
Also, a metadata started to show up whenver I open up a new query window...


Can anyone help?
Post #967691
Posted Wednesday, August 11, 2010 12:08 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:58 PM
Points: 367, Visits: 615
First thing I would check is whether the SQL Server instance is started in the Services control panel.
Post #967707
Posted Wednesday, August 11, 2010 12:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 12:12 PM
Points: 55, Visits: 279
Can you reboot the computer?
Post #967708
Posted Wednesday, August 11, 2010 12:09 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 9:21 AM
Points: 977, Visits: 3,358
Are all the SQL Services running? Are you on a network that has other SQL Servers?

Andrew SQLDBA
Post #967710
Posted Wednesday, August 11, 2010 12:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, Visits: 105
Reboot didn't help. And I'm attaching a screen shot for the services running.
So my computer has a client that connects to a networked server.

Post #967751
Posted Wednesday, August 11, 2010 12:53 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 9:21 AM
Points: 977, Visits: 3,358
So what box are you on? The services that you just showed, are those from your box?

Who installed SQL on the box that you are using? That is what I was talking about, are the services running. You have to have SQL installed on your own box, before you can connect to another server. if you do have SQL installed on your box, are all the services running?

Andrew SQLDBA
Post #967762
Posted Wednesday, August 11, 2010 12:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, Visits: 105
The services screenshot is from my computer.
I'm on my laptop and the SQL Server is of course on the server box. Other people are able to get on it just fine. And this laptop was running it just fine yesterday too.

I installed the SQL SERVER enterprise version with a default instance myself yesterday. It has been running smooth until today.

Post #967764
Posted Wednesday, August 11, 2010 1:00 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 9:21 AM
Points: 977, Visits: 3,358
Ok, you should be able to log into your own box. If the service is running and you have installed all the tools.

What are you using to log into your own box? When you installed SQL, did you set the login mode to "Mixed Mode" or "Single Mode"?

When you try to log into your own box, what are you using for the box name?

Andrew SQLDBA
Post #967768
Posted Wednesday, August 11, 2010 1:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, Visits: 105
I'm not trying to log into my own box. I'm trying to connect to a network server.
The name goes like xxx.xxx.xx.xx/name.
Again, this worked perfectly fine yestserday..

Login mode is set to "Single Mode" but I'm able to select it when I first open up the Management Studio.
Only when I try to open up the new query window to connect to the Database Engine, it wouldn't even give me the option.
Post #967772
Posted Wednesday, August 11, 2010 1:17 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 9:21 AM
Points: 977, Visits: 3,358
Ok, that is a box name\instance name? Is your network cable plugged in? Have you authenticated on to the network?

Are you sure that the box has a named instance?

Can you log into your own box.

Andrew SQLDBA
Post #967784
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse