Solved

Installing HP SIM 7.3

Posted on 2014-09-05
11
914 Views
Last Modified: 2014-09-12
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.
0
Comment
Question by:stlhost
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40305838
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.
0
 
LVL 2

Author Comment

by:stlhost
ID: 40305853
It is running and the service is set to automatic
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40305865
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.
0
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.

 
LVL 2

Author Comment

by:stlhost
ID: 40305893
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
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40309262
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
0
 
LVL 2

Author Comment

by:stlhost
ID: 40310080
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
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40310102
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.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40310112
Also run this command (SQLCMD -L) to check if your SQL Server it's listed.
0
 
LVL 2

Author Comment

by:stlhost
ID: 40310152
C:\Users\administrator.>setspn -L stlbackup
Registered ServicePrincipalNames for CN=STLBACKUP,OU=Domain Servers,DC=xxxx,DC
=local:
        MSSQLSvc/STLBACKUP.xxxx.local:64976
        MSSQLSvc/STLBACKUP.xxxx.local:VIM_SQLEXP
        MSSQLSvc/STLBACKUP.xxxx.local:53659
        E3514235-4B06-11D1-AB04-00C04FC2DCD2-ADAM/STLBACKUP.xxxx.local:389
        E3514235-4B06-11D1-AB04-00C04FC2DCD2-ADAM/STLBACKUP:389
        ldap/STLBACKUP
        ldap/STLBACKUP:389
        ldap/STLBACKUP.xxxx.local:389
        ldap/STLBACKUP.xxxx.local
        WSMAN/STLBACKUP.xxxx.local
        WSMAN/STLBACKUP
        TERMSRV/STLBACKUP.xxxx.local
        TERMSRV/STLBACKUP
        HOST/STLBACKUP
        HOST/STLBACKUP.xxxx.local

C:\Users\administrator.>sqlcmd -L

Servers:

    STLBACKUP
    STLBACKUP\BKUPEXEC
    STLBACKUP\VIM_SQLEXP
0
 
LVL 2

Author Comment

by:stlhost
ID: 40310254
When doing setspn -L administrator I see a lot of servers except stlbackup. How do I add it
0
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40311404
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.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question