Unable to connect to Database Engine on New Query Window

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unable to connect to Database Engine on New...

20 posts, Page 1 of 2

1 2 »»

Unable to connect to Database Engine on New Query Window

Rate Topic

Display Mode

Topic Options

Author

Message

airparkroad

Posted Wednesday, August 11, 2010 11:57 AM

Grasshopper

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

jerry-621596

Posted Wednesday, August 11, 2010 12:08 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 4:18 PM
Points: 363, Visits: 574

First thing I would check is whether the SQL Server instance is started in the Services control panel.

Post #967707

blackbird

Posted Wednesday, August 11, 2010 12:09 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:34 AM
Points: 54, Visits: 237

Can you reboot the computer?

Post #967708

AndrewSQLDBA

Posted Wednesday, August 11, 2010 12:09 PM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 4:46 PM
Points: 788, Visits: 2,250

Are all the SQL Services running? Are you on a network that has other SQL Servers?

Andrew SQLDBA

Post #967710

airparkroad

Posted Wednesday, August 11, 2010 12:44 PM

Grasshopper

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

AndrewSQLDBA

Posted Wednesday, August 11, 2010 12:53 PM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 4:46 PM
Points: 788, Visits: 2,250

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

airparkroad

Posted Wednesday, August 11, 2010 12:55 PM

Grasshopper

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

AndrewSQLDBA

Posted Wednesday, August 11, 2010 1:00 PM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 4:46 PM
Points: 788, Visits: 2,250

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

airparkroad

Posted Wednesday, August 11, 2010 1:05 PM

Grasshopper

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

AndrewSQLDBA

Posted Wednesday, August 11, 2010 1:17 PM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 4:46 PM
Points: 788, Visits: 2,250

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 »

20 posts, Page 1 of 2

1 2 »»

Permissions