Unable to connect to Database Engine on New Query Window

  • 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?

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

  • Can you reboot the computer?

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

    Andrew SQLDBA

  • 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.

  • 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

  • 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.

  • 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

  • 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.

  • 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

  • Yup. Object Explorer can connect to the server.

    Integration Services Project can connect to the server.

    Only a Query Window cannot.

  • 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

  • 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?

  • 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

  • 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.

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

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