R W
asked on
Installing HP SIM 7.3
Stuck at the database part. The system has sql on it but I get this at the command line.
C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn>sqlcm d
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
If I supply the local admin account I get the same thing. If I try to use a remote host I get a similar error that I do when trying to install it locally. It just says Unable to connect to the specified host. Please check the Host database and port values and be sure the target database is running. Also be sure that the target database installation has the latest service pack. THis is a WIndows 2008 machine. The remote machine I tried is Windows 2003. In the surface area configuration I have remote connections allowed.
C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn>sqlcm
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
If I supply the local admin account I get the same thing. If I try to use a remote host I get a similar error that I do when trying to install it locally. It just says Unable to connect to the specified host. Please check the Host database and port values and be sure the target database is running. Also be sure that the target database installation has the latest service pack. THis is a WIndows 2008 machine. The remote machine I tried is Windows 2003. In the surface area configuration I have remote connections allowed.
ASKER
It is running and the service is set to automatic
Then check is if Remote Connections are enabled on your SQL Server. Open SQL Server Management Studio, connect to the server in question, right click the server and click in Properties. Go to Connections and ensure that Allow remote connections to this server is checked.
ASKER
Here is screenshots of the sql setup on the windows 2008 server.
http://i.imgur.com/GTxUFw1.jpg
http://i.imgur.com/QYEzZMK.jpg
Management Studio is on the Windows 2003 server, if I attempt to use that to connect to the windows 2008 server I get
http://i.imgur.com/oCzbj4Y.jpg
http://i.imgur.com/GTxUFw1.jpg
http://i.imgur.com/QYEzZMK.jpg
Management Studio is on the Windows 2003 server, if I attempt to use that to connect to the windows 2008 server I get
http://i.imgur.com/oCzbj4Y.jpg
There is still some things that you can validate, such:
1 - Ping the servername
2 - Run the telnet command (TELNET <Server name> <SQL Server port number>)
3 - If the SQL Server instance is a named instance, did you wrote it well and in the correct format (ServerName\InstanceName)?
4 - Check the error.log for more information about the error
1 - Ping the servername
2 - Run the telnet command (TELNET <Server name> <SQL Server port number>)
3 - If the SQL Server instance is a named instance, did you wrote it well and in the correct format (ServerName\InstanceName)?
4 - Check the error.log for more information about the error
ASKER
I can ping the server but I can't telnet to the port 1434. Backup exec is on this server to so I assume sql is working properly or backupexec wouldn't be working. What else am I missing
By default SQL Server is listening on port 1433.
Also check the SPN for that server (SETSPN -L <servername> or SETSPN -L <SQLServerServiceAccount>) if it's listed the SQL Server service (MSSQLSvc). If not you need to add it manually.
Also check the SPN for that server (SETSPN -L <servername> or SETSPN -L <SQLServerServiceAccount>)
Also run this command (SQLCMD -L) to check if your SQL Server it's listed.
ASKER
C:\Users\administrator.>se tspn -L stlbackup
Registered ServicePrincipalNames for CN=STLBACKUP,OU=Domain Servers,DC=xxxx,DC
=local:
MSSQLSvc/STLBACKUP.xxxx.lo cal:64976
MSSQLSvc/STLBACKUP.xxxx.lo cal:VIM_SQ LEXP
MSSQLSvc/STLBACKUP.xxxx.lo cal:53659
E3514235-4B06-11D1-AB04-00 C04FC2DCD2 -ADAM/STLB ACKUP.xxxx .local:389
E3514235-4B06-11D1-AB04-00 C04FC2DCD2 -ADAM/STLB ACKUP:389
ldap/STLBACKUP
ldap/STLBACKUP:389
ldap/STLBACKUP.xxxx.local: 389
ldap/STLBACKUP.xxxx.local
WSMAN/STLBACKUP.xxxx.local
WSMAN/STLBACKUP
TERMSRV/STLBACKUP.xxxx.loc al
TERMSRV/STLBACKUP
HOST/STLBACKUP
HOST/STLBACKUP.xxxx.local
C:\Users\administrator.>sq lcmd -L
Servers:
STLBACKUP
STLBACKUP\BKUPEXEC
STLBACKUP\VIM_SQLEXP
Registered ServicePrincipalNames for CN=STLBACKUP,OU=Domain Servers,DC=xxxx,DC
=local:
MSSQLSvc/STLBACKUP.xxxx.lo
MSSQLSvc/STLBACKUP.xxxx.lo
MSSQLSvc/STLBACKUP.xxxx.lo
E3514235-4B06-11D1-AB04-00
E3514235-4B06-11D1-AB04-00
ldap/STLBACKUP
ldap/STLBACKUP:389
ldap/STLBACKUP.xxxx.local:
ldap/STLBACKUP.xxxx.local
WSMAN/STLBACKUP.xxxx.local
WSMAN/STLBACKUP
TERMSRV/STLBACKUP.xxxx.loc
TERMSRV/STLBACKUP
HOST/STLBACKUP
HOST/STLBACKUP.xxxx.local
C:\Users\administrator.>sq
Servers:
STLBACKUP
STLBACKUP\BKUPEXEC
STLBACKUP\VIM_SQLEXP
ASKER
When doing setspn -L administrator I see a lot of servers except stlbackup. How do I add it
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check in the SQL Server machine if the SQL Server Browser service it's running. If not, start it and set it to Automatic since you'll need that service running to allow remote access.