Login to database engine in SQL 2008 R2 failed

Using MS SQL Server Management Studio I try to login to database

Server type - database engine
server name - nameofserver\databasename
authentication - Windows Authentication
user name - grayed out (ntdomain\useraccount  user account is a member of domain admins group
Password - grayed out and blank

Every time login failes with error

TITLE: Connect to Server
------------------------------

Cannot connect to TST-DPM-PRI01\MSDPM2010.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
vadimmikhalAsked:
Who is Participating?
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.

Tony303Commented:
Take the DB name out of the SERVERNAME

So, server name - nameofserver\databasename
Becomes server name - nameofserver
0
vadimmikhalAuthor Commented:
Still cannot connect
0
Tony303Commented:
What is written in your ServerName parameter is the SERVER\INSTANCENAME

There can be many instances of SQL Server installed on one Computer.

So, do you know what the instance of SQL Server is called?

It can be found by looking at the Services running from Administrative tools.

Look for the name MSSQLSERVER
If you see it with an instance name you will see something like MSSQLSERVER\INSTANCEName

What does it tell you?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

vadimmikhalAuthor Commented:
TST-DPM-PRI01\MSDPM2010.
0
Tony303Commented:
Cool, is the SQL server actually running?
0
Tony303Commented:
Check while you are there that the SQL Browser is a service that is running too.
0
sarabhaiCommented:
On machine  TST-DPM-PRI01
Sql server instance name MSDPM2010 should be in running.
And this sql instance must be install using the Windows Authentication mode
Also This instance tcp or named pipe should be enabled
0
geek_vjCommented:
Please ensure that the SQL Services are up and running fine (Goto services and check for SQL Services --> should be in running state)

Server type - database engine
server name - TST-DPM-PRI01\MSDPM2010
authentication - Windows Authentication

If the sql services are up and running fine and still you are unable to connect using the above authentication, try giving the port number (you can find the port number in sql server configuration manager --> SQL Server Network configuration --> TCP/IP Properties --> IP Addresses Tab --> TCP Port

If it is running under a different port, you need to provide the server name as

TST-DPM-PRI01\MSDPM2010,9432
(assuming 9432 is the port number)

Hope this helps!!
0

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
Tony303Commented:
So the browser was off? just wondering.
Thanks

Tony
0
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.