vadimmikhal
asked on
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
--------------------------
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
--------------------------
ASKER
Still cannot connect
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?
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?
ASKER
TST-DPM-PRI01\MSDPM2010.
Cool, is the SQL server actually running?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So the browser was off? just wondering.
Thanks
Tony
Thanks
Tony
So, server name - nameofserver\databasename
Becomes server name - nameofserver