Click here to monitor SSC
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
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 105
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?
jerry-621596
jerry-621596
SSC-Addicted
SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)

Group: General Forum Members
Points: 441 Visits: 645
First thing I would check is whether the SQL Server instance is started in the Services control panel.
blackbird
blackbird
Valued Member
Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)

Group: General Forum Members
Points: 64 Visits: 282
Can you reboot the computer?
AndrewSQLDBA
AndrewSQLDBA
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1194 Visits: 3427
Are all the SQL Services running? Are you on a network that has other SQL Servers?

Andrew SQLDBA
airparkroad
airparkroad
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 105
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
AndrewSQLDBA
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1194 Visits: 3427
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
airparkroad
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 105
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
AndrewSQLDBA
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1194 Visits: 3427
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
airparkroad
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 105
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
AndrewSQLDBA
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1194 Visits: 3427
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
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