Unable to connect to Database Engine on New Query Window

Question

Post reply

Unable to connect to Database Engine on New Query Window

airparkroad

SSC-Addicted

Points: 463
More actions
August 11, 2010 at 11:57 am

#224647

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?

Viewing 15 posts - 1 through 15 (of 19 total)

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

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 1

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

blackbird Ten Centuries Points: 1127 More actions · Answer 2

blackbird

Ten Centuries

Points: 1127

August 11, 2010 at 12:09 pm

#1205615

Can you reboot the computer?

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 3

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

Andrew SQLDBA

airparkroad SSC-Addicted Points: 463 More actions · Answer 4

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.

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 5

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

airparkroad SSC-Addicted Points: 463 More actions · Answer 6

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.

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 7

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

airparkroad SSC-Addicted Points: 463 More actions · Answer 8

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.

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 9

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

airparkroad SSC-Addicted Points: 463 More actions · Answer 10

Yup. Object Explorer can connect to the server.

Integration Services Project can connect to the server.

Only a Query Window cannot.

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 11

What has been changed on your box?

I would probably just uninstall SQL and install it again on your box. That would be the less trouble some thing to do.

Andrew SQLDBA

airparkroad SSC-Addicted Points: 463 More actions · Answer 12

I would thought to reiterate my issue here.

When you click on Database Engine Query button, it does not bring up a Database Engine Query window.

Instead, it brings up Analysis Servies Query and attempts to connect to the Analysis Services.

The Server Type box area is greyed out so I can't really select anything.

I am able to connect to the server via other means. But not in SSMS.

I've searched and it seems like this is a known issue for some people.

Does anyone know a solution to this?

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 13

Since this is on your own workstation, I would have removed SQL and reinstalled, plus all service packs. Would take about a full hour.

I would have been done and back up and running by now.

You may search for days and never get what is actually causing this issue.

What version of SQL are you running on your workstation? Did you install all service packs?

Andrew SQLDBA

airparkroad SSC-Addicted Points: 463 More actions · Answer 14

Forgot to mention that this is a recurring issue and have done uninstall/reinstall for 13 times.

After the re-installation it works perfectly fine. But the next day or two, the problem creeps all over again.

This is SQL SERVER 2008 enterprise version.