Change VC authentication to database using vpxd-p

[java_cat33]

Hi - I have moved the VC db from a SQL Express 2005 instance to a SQL 2005 SP2 server. I created a sql user for db_owner role etc etc for the VC DB.

When VC was configured to use the SQL Express instance it was using NT authentication, now I want to use SQL authentication.

I need to change the password within the registry using the vpxd-p command on the VC server, however how do I set it to use the new sql user "vpxadmin". I have already set these settings in ODBC.

Attached is what is stored in the registry for the VC DB at present....

Message was edited by: java_cat33

[Dave_Mishchenko]

Stop the VC service

Update the registry entry to change "administrator" to your new sql login

Update the odbc connection to use sql authentication.

Run vpxd -p

Restart the VC service.

[java_cat33]

Thanks for the clarification Dave! :smileygrin:

One other thing - the Virtual Update Manager db still resides on the VC using SQL Express 2005 and NT authentication. Will changing the VC password break this?

Attached is what is stored in the registry for the VUM DB

Message was edited by: java_cat33

[Dave_Mishchenko]

It hasn't seem to have broken anything on my test system where I have change both the VC login and password.

[java_cat33]

hmmm.... so I should be OK to change the login user in the registry to vpxadmin and run vpxd -p and set it to the new password...... and in the mean time leave the VUM alone still using SQL 2005 Express on the VC with NT authentication?

Thanks once again Dave.

[Dave_Mishchenko]

In my setup I used 2 different database and logins and have been able to change the VC login info without any issues. I think you'll be fine with just changing the VC login/password.

[java_cat33]

well...... I ran it..... and it worked with no problems it appears :smileygrin:

Virtual Center is now up and running...... is there any recommended procedures for moving the VUM db from SQL Express 2005 to SQL 2005? sql permissions required etc?