Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2019
  • Last Modified:

HP SIM installation on sbs2007

Hi there,

I'm trying to install HP SIM on SBS 2007 with the default settings, in database configuration I have the dafaults, with instance name MICROSOFT##SSEE. When I click next it comes with error message "TCP/IP protocol is not enabled for the specified database server. Please enable the TCP/IP protocol". I have checked in SQL Config. Manager all the TCP/IP's and all seems to be enabled, also the port no (1433) is added in Win firewall as exclusion.

Thank you

0
HandsOnComputersLtd
Asked:
HandsOnComputersLtd
  • 8
  • 7
1 Solution
 
Krzysztof PytkoActive Directory EngineerCommented:
run from command-line

cliconfg

and check if you have enabled TPC/IP protocol with proper port (1433) and Named pipes
0
 
HandsOnComputersLtdAuthor Commented:
I have enabled both, but it comes with the same error.
0
 
Krzysztof PytkoActive Directory EngineerCommented:
Which firewall profile did you configure on SBS 2008?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
HandsOnComputersLtdAuthor Commented:
At the moment I have the firewall off, but no luck.
0
 
Krzysztof PytkoActive Directory EngineerCommented:
OK, check on DNS server in revers lookup zone if you have conigured records for DNS and your SQL server. If not, create them and check once again.
0
 
HandsOnComputersLtdAuthor Commented:
I have checked the reverse lookup zone and there is only "in-addr.arpa Active Directory-Integrated Primary" record,inside that I can see a few PTR records but none of them is for SQL server. Can you please advice me where exactly to look and how to add the DNS record. Thank you
0
 
Krzysztof PytkoActive Directory EngineerCommented:
could you give me your network ID, please? Then I will tell where you can set it
0
 
HandsOnComputersLtdAuthor Commented:
Here it is: 172.16.0.0, thanks.
0
 
Krzysztof PytkoActive Directory EngineerCommented:
ok in reverse lookup zone of your DNS server go to:

172.16.x.x subnet then open third server's IP octet (if your server's IP is 172.16.0.10) -> go to 0
and create new pointer (PTR record) for last octet value (10 in my example) assign IP to proper host from DNS choosing "Browwse" button, point proper DNS server and find its name. Then try again.
0
 
HandsOnComputersLtdAuthor Commented:
I have created the DNS but no change. The database I have on the SIM setup is MICROSOFT##SSEE but if I look through the system I can't find it, there is only SERVERNAME\SBSMONITORING database. Do I need to create new DB Instance so it gives me another option in the setup menu?
0
 
Krzysztof PytkoActive Directory EngineerCommented:
yes, you cannot find it because it is set up on express edition of sql, so it is not managable (I think) :)

Do you have something in event viewer logs?
0
 
HandsOnComputersLtdAuthor Commented:
Nothing at all.
0
 
Krzysztof PytkoActive Directory EngineerCommented:
Does ytur SQL server have more that 1 network card installed?
0
 
HandsOnComputersLtdAuthor Commented:
No just one.

If I can only see the microsoft defaut instance and not the SBSMONITORING one how would i make possible for HP SIM setup to see new instance if i created a new one.
0
 
Krzysztof PytkoActive Directory EngineerCommented:
Sorry for delay. I just remembered one thing, some time ago I also had problem with connection to database (Express Edition of SQL) and I used 3rd party software to access it. It is called HeidiSQL, it's free and simple in use. Could you check it if it works, please?

HeidiSQL -> http://www.heidisql.com/

Additionally, check if your database have set proper permissions Windows authentication/SQL authentication (sa user) and if the database has set password.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now