Post reply

Unable to connect to Database Engine on New Query Window

  • August 12, 2010 at 9:22 am

    #1206103

    Then it is time to rebuild the workstation. If this has not been done lately, it is way past time. There is something on it that is conflicting, or some type of virus.

    I have never heard of this doing what you are describing.

    Andrew SQLDBA

  • August 12, 2010 at 9:34 am

    #1206118

    @OP - Are you connected to multiple services in Object Explorer? Maybe SQL Server, Analysis Services, and Integration Services? If so, then it COULD be that you have SSAS highlighted in Object Explorer. Default behavior of SSMS is to create a new query in whatever instance is highlighted in Object Explorer. I know it sounds simple, but have seen people not notice that for over an hour, experienced people (like me 😉 )

  • August 13, 2010 at 12:43 pm

    #1206870

    Especially SQL Browser service!!!

  • August 13, 2010 at 12:55 pm

    #1206878

    It turned out to be an Active Directory issue with the permissions from the corporate server.

    But just to add a note, there was only 1 service running, which is a database engine service, and the new query button was pressed with only the database engine service highlighted. 🙂

  • August 13, 2010 at 1:56 pm

    #1206921

    Thanks for posting the resolution. Very few OP's do that, and it's also a learning experience for other folks when you know how it got fixed.

Viewing 5 posts - 16 through 19 (of 19 total)

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