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>sqlcmd
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.
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.

Vitor MontalvãoMSSQL Senior EngineerCommented:
this failure may be caused by the fact that under the default settings SQL Server does not  allow remote connections

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.
stlhostAuthor Commented:
It is running and the service is set to automatic
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

stlhostAuthor Commented:
Here is screenshots of the sql setup on the windows 2008 server.

Management Studio is on the Windows 2003 server, if I attempt to use that to connect to the windows 2008 server I get
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
stlhostAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Also run this command (SQLCMD -L) to check if your SQL Server it's listed.
stlhostAuthor Commented:
C:\Users\administrator.>setspn -L stlbackup
Registered ServicePrincipalNames for CN=STLBACKUP,OU=Domain Servers,DC=xxxx,DC

C:\Users\administrator.>sqlcmd -L


stlhostAuthor Commented:
When doing setspn -L administrator I see a lot of servers except stlbackup. How do I add it
Vitor MontalvãoMSSQL Senior EngineerCommented:
administrator it's the SQL Server service account?

What I can see is that you have 3 instances of SQL Server in your machine. Registered ports are 64976 and 53659 and none it's the default. Try to TELNET both ports to see if they're responding.
Also that has 2 named instances (BKUPEXEC and VIM_SQLEXP), so when you want to connect to your SQL Server you need to give this full path (STLBACKUP\BKUPEXEC or STLBACKUP\VIM_SQLEXP).
Now you need to find in which of these instances your database is.

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
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 2005

From novice to tech pro — start learning today.