Pointing SIM4.2 to a remote SQL server?

[Phong Thai_2]

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?

[Rob Buxton]

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

[Phong Thai_2]

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

[Larry Clarkson]

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.

[Larry Clarkson]

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

[Phong Thai_2]

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

[Larry Clarkson]

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.

[Phong Thai_2]

That works. Thanks, Larry.

[Larry Clarkson]

No problem at all. Glad to have helped.

[Colin Yates]

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.

[Larry Clarkson]

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.

[Peter Narkotsky_1]

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.

[Derek_31]

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

[Bill_241]

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

[Bill_241]

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