Solved

Cant access database engine through SQL Management Studio

Posted on 2014-10-28
15
105 Views
Last Modified: 2014-10-29
Hello experts,

When trying to connect to the database engine with SQL Server Management Studio the server name doesn't show in the login box. I can reach Analysis Services but not database Engine.  I also get “Access is Denied” error when I try to log in to the Integration Services.

TCP/IP is enabled and the Firewall contains a rule that allows SQL Server through port 1433.

Is there any way I can get the server to allow remote connection without using SQL Management Studio?

I should say that the Server is on a network and I have full access to it.

One more thing, when I run SQL Configuration Manger, I don't see the database Engine.
I see SQL Server Integration services, analysis services and sql server browser .  I can stop and run each one of them.
But where is database Engine....??

Thanks
0
Comment
Question by:adamtrask
  • 8
  • 7
15 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40409468
Can you run  SQL Server Management Studio on the server and confirm that you are using the Instance name corectly?

Can you try to use the IP address of the server instead of server name ?
0
 

Author Comment

by:adamtrask
ID: 40409504
When I put the IP address instead of the server name it took me to the analysis server
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40409510
Did you try to connect directly to server and start SSMS there ?
0
 

Author Comment

by:adamtrask
ID: 40409516
I did, SSMS is run from the server.. it is not on my mschine
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40409529
Can you post here screenshot like mine? i.e. on the server name from the dropdown you select browse for more and then switch to Network servers and post results
Capture3.PNG
0
 

Author Comment

by:adamtrask
ID: 40409537
I can, but there are several names that appear under the Database Engine -  all the ones on the network obviously - but non of them is the name of my server
0
 

Author Comment

by:adamtrask
ID: 40409541
Looking under Server Manager > All Servers I see only one name:
SQL-Server2 IP Address 10.10.1.72 and under Manageability I see:
Online - Performance counter not started
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40409542
Can you check is the SQL Server (YOUR INSTANCE NAME) service started?
0
 

Author Comment

by:adamtrask
ID: 40409547
here is a screen shot
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40409550
No attachment... ;)
0
 

Author Comment

by:adamtrask
ID: 40409555
here it is againscreen-shot.jpgscreen-shot.jpg
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40409572
There are a lot of error there, are they related to SQL server mean the service not the machine?
0
 

Author Comment

by:adamtrask
ID: 40409656
My apologies,  Harris - I was at work and had to leave to pick up my neighbor's child from school - forgot all about her!
I'll be checking things again tomorrow. i hope I haven't been too much bother.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40409661
No worries, I'm here until we figure it out...
0
 

Author Closing Comment

by:adamtrask
ID: 40410714
Thank you so much for your patience.
I re-installed  SQL Server, and everything works as it should.
I am relatively new to doing serious work with SQL and so is my network Admin. We are both wading through like two blind bats!
Thanks a  lot.
Adam
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Backup 24 70
SQL server 2008 SP4 29 34
Finding records between to times and spanning over midnight 21 44
Sql query for filter 12 23
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now