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
adamtraskAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicIT ArchitectCommented:
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 ?
adamtraskAuthor Commented:
When I put the IP address instead of the server name it took me to the analysis server
Haris DulicIT ArchitectCommented:
Did you try to connect directly to server and start SSMS there ?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

adamtraskAuthor Commented:
I did, SSMS is run from the server.. it is not on my mschine
Haris DulicIT ArchitectCommented:
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
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
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
Haris DulicIT ArchitectCommented:
Can you check is the SQL Server (YOUR INSTANCE NAME) service started?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
adamtraskAuthor Commented:
here is a screen shot
Haris DulicIT ArchitectCommented:
No attachment... ;)
adamtraskAuthor Commented:
here it is againscreen-shot.jpgscreen-shot.jpg
Haris DulicIT ArchitectCommented:
There are a lot of error there, are they related to SQL server mean the service not the machine?
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.
Haris DulicIT ArchitectCommented:
No worries, I'm here until we figure it out...
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.