SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to connect to Database Engine on New Query Window


Unable to connect to Database Engine on New Query Window

Author
Message
airparkroad
airparkroad
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 105
Yup. Object Explorer can connect to the server.
Integration Services Project can connect to the server.
Only a Query Window cannot.
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4182 Visits: 3427
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
airparkroad
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 105
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
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4182 Visits: 3427
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
airparkroad
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 105
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.
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4182 Visits: 3427
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
Source-NH
Source-NH
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2021 Visits: 479
@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 Wink )
Rick.Cornell.SME
Rick.Cornell.SME
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5869 Visits: 208
Especially SQL Browser service!!!
airparkroad
airparkroad
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 105
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. Smile
Source-NH
Source-NH
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2021 Visits: 479
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search