What permissions required to create SQL 2000 DB?

[david cheng_2]

Hello. I want to install CIM 7.0 SP2 on a server and connect to a remote SQL 2000 server. This SQL server is in production and the DB Administrator does not want to give me local Admin to the server because he is afraid of what the CIM install might be doing on the SQL server.

We have tried installing CIM using an ID that is a System Administrator in the SQL Server, but it still fails (sorry, can't remember the error here). Can anyone tell me the specific reason why local Admin is required for the install? Is it because the process is trying to create a directory/file on the SQL server? If we gave the ID permissions to the SQL directory, would it work then?

Thanks
David

[Kevin Porter_2]

David. When I did my CIM 7 SP2 install I had to use the SA account for the SQL server. This was just a requirement of the Insight Manager install. I did not need any specific access to the SQL server as far as Windows was concerned. The only exception would be if the SQL server is configured to use NT Autthentication. This would require your ID to have explicit permission in SQL. You will need to talk to your DBA and see how the SQL authentication is configured. Since it seems security is a concern of the SQL admin, he will probably want to change the ID you are using to a DBO account. Just FYI, there is a stored procudure that you need to get from HP that will need to be run prior to changing the ID from the SA account.

Hope this helps.

[david cheng_2]

Sorry, I forgot to state that the SQL server is using Windows authentication. We are using a domain acct for the Insight Manager service, and that same domain acct will be used to connect to the DB. I'm also using this acct for the install process.

[thien nguyen_4]

I am also having the same problem. I think during the install, when you specify remote db and password, the password refers to the db and not the currently logon user? Also when I reviewed my logs, the "SA" account has been hardcoded and that the only account you can use to access the remote db. Currenly I'm trying to figure out if I can use a different account. Please let me know what you think and what was your resolution.
thanks, Thien

[david cheng_2]

My solution was to use a domain ID and password, and give database creation permissions to it. Also, the ID needs permissions to execute xp_cmdshell.

With those permissions, the DB was installed correctly.

cheers
david

[thien nguyen_4]

David,

So was the domain account that you gave the db permissions to, was that the same account the you logged onto to do the install? Also does the password field during the install refer to the current logged in user or does that refer to the "SA" db account?

Thanks,
Thien