Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Unable to connect to Database Engine on New Query Window Expand / Collapse
Author
Message
Posted Wednesday, August 11, 2010 1:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, Visits: 105
Yup. Object Explorer can connect to the server.
Integration Services Project can connect to the server.
Only a Query Window cannot.
Post #967786
Posted Wednesday, August 11, 2010 1:53 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
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
Post #967796
Posted Thursday, August 12, 2010 8:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, 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?
Post #968201
Posted Thursday, August 12, 2010 8:59 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
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
Post #968257
Posted Thursday, August 12, 2010 9:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, 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.
Post #968261
Posted Thursday, August 12, 2010 9:22 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
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
Post #968296
Posted Thursday, August 12, 2010 9:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:16 AM
Points: 1,631, Visits: 478
@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 ;) )
Post #968314
Posted Friday, August 13, 2010 12:43 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 1, 2014 8:37 AM
Points: 4,848, Visits: 208
Especially SQL Browser service!!!
Post #969196
Posted Friday, August 13, 2010 12:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 20, 2011 7:47 PM
Points: 21, 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. :)
Post #969204
Posted Friday, August 13, 2010 1:56 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:16 AM
Points: 1,631, Visits: 478
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.
Post #969253
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse