SIM 5.0 Install - 'Insufficient rights to DB'

[Mike Earnheart]

New instal SIM 5.0 attempting to connect to a local install of MS SQL Server.
DB has been created and I have verified that the administrator login has DBO and DB_creator rights assigned.
Recieved 'Insufficient rights to DB' error when tring to connect to DB.

I have already reviewed the following threads with no success:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1038394
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1047217

Any further assistance would be greatly appriciated.

Thanks,
Mike

[Ondra Ernyei]

Hello Mike,

what MSSQL version are you using ?

Verify that the SQL server is installed with "Mixed" security mode. You can verify that by changing to SQL authentication in the SQL server registration options in the Enterprise Manager.

I hope it helps,

Ondra

[Mike Earnheart]

Hello Mike,

what MSSQL version are you using ?

Verify that the SQL server is installed with "Mixed" security mode. You can verify that by changing to SQL authentication in the SQL server registration options in the Enterprise Manager.

I hope it helps,

Ondra

Ondra-
Thank you for your responce.
I'm not sure how or why, but I got it to install. I ran install as domain admin, at the DB config part of the install, I supplied the domain admin password and used the default DB parameters and it worked (I swear I tried that earlier). Don't know what the difference was and its not an Ideal situation as its using the default DB and not a specific DB of my choice, but I can live with it.
For future reference:
MS SQL server 2000 version 8.00
Mixed mode is verified.

Thank you for your reply.

Mike

[Mike Earnheart]

Please see previous post.