Solved

HP SIM installation on sbs2007

Posted on 2010-09-05
15
1,955 Views
Last Modified: 2012-05-10
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
Comment
Question by:HandsOnComputersLtd
  • 8
  • 7
15 Comments
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33609324
run from command-line

cliconfg

and check if you have enabled TPC/IP protocol with proper port (1433) and Named pipes
0
 

Author Comment

by:HandsOnComputersLtd
ID: 33609654
I have enabled both, but it comes with the same error.
0
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33609852
Which firewall profile did you configure on SBS 2008?
0
 

Author Comment

by:HandsOnComputersLtd
ID: 33610946
At the moment I have the firewall off, but no luck.
0
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33610971
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
 

Author Comment

by:HandsOnComputersLtd
ID: 33612472
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
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33613182
could you give me your network ID, please? Then I will tell where you can set it
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:HandsOnComputersLtd
ID: 33613548
Here it is: 172.16.0.0, thanks.
0
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33615228
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
 

Author Comment

by:HandsOnComputersLtd
ID: 33615579
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
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33615646
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
 

Author Comment

by:HandsOnComputersLtd
ID: 33615905
Nothing at all.
0
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33616006
Does ytur SQL server have more that 1 network card installed?
0
 

Author Comment

by:HandsOnComputersLtd
ID: 33617028
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
 
LVL 39

Accepted Solution

by:
Krzysztof Pytko earned 500 total points
ID: 33635766
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
RDWeb 3 50
Group Policy & Netlogin Services 5 30
clearing an obsolete 2003 server from our domain 8 47
What is this Task? 4 34
The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now