- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Failed SIM 5.1 sp1 install to remote MS-SQL
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2007 10:23 AM
тАО10-31-2007 10:23 AM
Failed SIM 5.1 sp1 install to remote MS-SQL
local facts: W2K3sp1 SIM to W2K3sp1 SQL2005 db, same VLAN, install domain account has both server admim group and SQL create/edit DB on remote db server. tested using sys DSN successfully over tcp port 1433 with install domain user/service account. Install domain accnt is domain admin. Remote db shows netstat connection from SIM server on port 1433. able to connect from SIM to SQL on remote server with SQL 2005 Server Mgt Studio/Tool using same install accnt. SQL Browsing service is enabled on remote db host, no firewalls running, AV or Windows. NSlookup is good, no other named SQL instances - straight SQL 2005 DB. Also failed install if changed tcp ports to 1453 or 1434. added hosts entry and restarted system after flushing dns didn't work and no change. password of user/service domain account only has ! exclamation mark in password. checked with switch admins and they confirm port 1433 is not blocked.
any help before I have to go out and request HP help...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2007 08:44 AM
тАО11-01-2007 08:44 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
I ran into this problem repeatedly. Your setup sounds similar to mine.
Try this:
1.) Telnet from your SIM box to the SQL box.
c:\> telnet
If the screen goes blank, you have a connection.
2.) In the box when it asks for "Instance", leave it at the default regardless of your instance name.
As soon as I did this, it connected fine.
Hope that helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2007 09:11 AM
тАО11-01-2007 09:11 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
but I have not tried item 2 so I will give that a try..
R....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2007 09:18 AM
тАО11-01-2007 09:18 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
won't that install locally?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2007 03:01 AM
тАО11-02-2007 03:01 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
Let me download SIM again and I will tell you what I did..
....... Ok
On the database configuration screen:
Under "Instance name" I always entered the name of our SQL instance and it always failed.
When I left the setting at
"Use Existing" MSSQLSERVER
It worked. SIM install created the databases it needs on my SQL instance.
Hope it works for you as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2007 03:04 AM
тАО11-02-2007 03:04 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
I entered the Domain User/Password, AD domain name, the machine name of the *remote* SQL server, etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2007 08:36 AM
тАО11-05-2007 08:36 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-06-2007 07:28 AM
тАО11-06-2007 07:28 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
The only other suggestion I might have is to use a copy of Wire Shark, and see what the traffic looks like. See if there is any response from the SQL server. Perhaps even get lucky and be able to inspect a SQL packet.
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2007 01:16 AM
тАО11-12-2007 01:16 AM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2008 05:31 PM
тАО01-21-2008 05:31 PM
Re: Failed SIM 5.1 sp1 install to remote MS-SQL
Struggled with same issue myself.
Trick was to give the MSSQL Instance its own custom port (say 1450) in SQL Configuration Manager, Protocols, TCPIP, IP Addresses.
Remove the 0 next to TCP Dynamic Ports and enter the custom port number in TCP Port field below for all IP addresses.
Restart the Instance.
Back in Insight Manager setup, when defining the Instance name to connect to, click the "Use this one" radio box but leave the field empty & define the custom port below.
Good luck!