topic Re: Pointing SIM4.2 to a remote SQL server? in Server Management - Systems Insight Manager

Pointing SIM4.2 to a remote SQL server?

Phong Thai_2 — Wed, 02 Mar 2005 14:51:30 GMT

Does anyone if there is a step-by-step procedure on how to point SIM4.2 management server to a remote SQL server for database access?

Re: Pointing SIM4.2 to a remote SQL server?

Rob Buxton — Wed, 02 Mar 2005 18:50:22 GMT

Are you talking about during the installation or after it has been installed and you want to change the location?

Re: Pointing SIM4.2 to a remote SQL server?

Phong Thai_2 — Thu, 03 Mar 2005 07:45:42 GMT

After SIM has been installed and uses MSDE2000 locally. Now, I'd like to point it to a remote SQL Server 2000 box.

Re: Pointing SIM4.2 to a remote SQL server?

Larry Clarkson — Thu, 03 Mar 2005 10:29:43 GMT

You can copy the MSDE db structure to the SQL server then change the ODBC connections to connect to the SQL server instead of the local MSDE database.

Re: Pointing SIM4.2 to a remote SQL server?

Larry Clarkson — Mon, 07 Mar 2005 12:57:33 GMT

I forgot to mention, you will likely also have to change the database.props file to get this to work.

Re: Pointing SIM4.2 to a remote SQL server?

Phong Thai_2 — Mon, 07 Mar 2005 13:35:24 GMT

What about the account to access the SIM database? Does that need to be moved somehow?

Re: Pointing SIM4.2 to a remote SQL server?

Larry Clarkson — Mon, 07 Mar 2005 13:37:43 GMT

In the DSN configurations, you supply the username/password to utilize. We used a domain account for this. You need to make sure the appropriate portions of database.props are made as well to reference this ID.

Re: Pointing SIM4.2 to a remote SQL server?

Phong Thai_2 — Tue, 08 Mar 2005 09:20:45 GMT

That works. Thanks, Larry.

Re: Pointing SIM4.2 to a remote SQL server?

Larry Clarkson — Tue, 08 Mar 2005 09:38:01 GMT

No problem at all. Glad to have helped.

Re: Pointing SIM4.2 to a remote SQL server?

Colin Yates — Thu, 17 Mar 2005 11:17:34 GMT

Can you help me out - I have a similar issue where we have sql with an existing sim database on it. We have installed sim onto another server and are wanting to point to the original database - is this the same scenario you had? We've amended the dsn and the databse.props file with no joy. Can you explain exactly the procedure you followed? Thanks.

Re: Pointing SIM4.2 to a remote SQL server?

Larry Clarkson — Tue, 22 Mar 2005 09:47:45 GMT

Is the new server named the same as the prior server? If not, I'm wondering if that's your issue as I believe SIM handles its certificates by its own name.

Re: Pointing SIM4.2 to a remote SQL server?

Peter Narkotsky_1 — Thu, 24 Mar 2005 17:06:40 GMT

Here are the steps that I took to migrate SQL DB from the same physical server as SIM to dedicated SQL server. To complicate things a little my dedicated SQL server is in different Windows domain.

1. Build new SQL server. Use same SQL authentication mechanism as for the old one.
2. Stop HP SIM
3. Detach SIM DB (Insight_v42_0_), move it to the new SQL server and attach it there. In my case I had to make sure that I created management account with the same name in the new domain and gave him same rights to HP SIM DB.
4. Modify this line in database.props file:
hp.Database.hostName=
(make sure you can resolve the name to an IP address:))
5. Change these 2 system DSN on your SIM server:
Insight_v1_master
Insight_v42_0
verify that you have proper connectivity to the new SQL server.
6. Change SIM startup account to the new one - this is optional - I needed this because SQL uses windows authentication and HP uses it's startup account to authenticate against its DB
7. Restart SIM.

This is pretty simple but for some reasons HP does not provide for neither wizard way of doing this nor tells you how to do this anywhere in their docs.

Re: Pointing SIM4.2 to a remote SQL server?

Derek_31 — Sun, 27 Mar 2005 23:30:23 GMT

HP should make a Wizard for SIM that does all of this. Their documentation is really bad at times.

Re: Pointing SIM4.2 to a remote SQL server?

Bill_241 — Tue, 05 Apr 2005 11:00:56 GMT

Peter,

Thanks for outlining these steps. I've been digging for awhile for the proper way to do this. I keep failing on step 5)- getting the proper connectivity to the SQL server. See attachment. My original ID that set this up was a local admin account call "simadmin".
Any advice, or should I suck it up and reinstall - the only way I know for sure how it works.

Thanks,

Bill

Re: Pointing SIM4.2 to a remote SQL server?

Bill_241 — Tue, 05 Apr 2005 13:08:38 GMT