• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

Cant access database engine through SQL Management Studio

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
adamtrask
Asked:
adamtrask
  • 8
  • 7
1 Solution
 
Haris DjulicCommented:
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
 
adamtraskAuthor Commented:
When I put the IP address instead of the server name it took me to the analysis server
0
 
Haris DjulicCommented:
Did you try to connect directly to server and start SSMS there ?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
adamtraskAuthor Commented:
I did, SSMS is run from the server.. it is not on my mschine
0
 
Haris DjulicCommented:
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
 
adamtraskAuthor Commented:
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
 
adamtraskAuthor Commented:
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
 
Haris DjulicCommented:
Can you check is the SQL Server (YOUR INSTANCE NAME) service started?
0
 
adamtraskAuthor Commented:
here is a screen shot
0
 
Haris DjulicCommented:
No attachment... ;)
0
 
adamtraskAuthor Commented:
here it is againscreen-shot.jpgscreen-shot.jpg
0
 
Haris DjulicCommented:
There are a lot of error there, are they related to SQL server mean the service not the machine?
0
 
adamtraskAuthor Commented:
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
 
Haris DjulicCommented:
No worries, I'm here until we figure it out...
0
 
adamtraskAuthor Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now