Manually configure port for ODBC Data source administrator>Client configuration connection (Vista)

Question

Hi,

 

Wondering whether I'm posting at the right place, please correct me if I'm wrong. I try to manually configure the port for Connection Parameter, but I failed.

 

This is the step to reproduce:

1. Open %systemroot%\system32\odbcad32.exe
2. Under User DSN, select Add>SQL Server>Put in any name for data source and server name
3. Click Next
4. Click on Client Configuration
5. Uncheck the "Dynamically determine port" and enter "4102".
6. Click OK.

I was prompted message "Your login account does not have the permission required to make this operation. Consult your system administrator to obtain the required permission in your windows registry."

 

I get this error in Windows Vista.

 

After some research, I found out that it is attempt to write to a key "HKLM\SOFTWARE\Microsoft\MSSQLServer\Client" and it should be virtualized to "HKU\<User Name>_Class\VirtualStore\Machine\Software\Microsoft\MSSQLServer\Client".

 

I have wrote a simple VBScript to add a key under "HKLM\SOFTWARE\Microsoft\MSSQLServer\Client" and it is virtualized.

 

Then I tried to open the Task Manager and right click on the odbad32.exe and found out that the Virtualization is unchecked. When I checked it, I managed to configure the port.

 

My concern here is

1. Why the "HKLM\SOFTWARE\Microsoft\MSSQLServer\Client" key is not virtualized
2. Why the Virtualization is uncheck by default?
3. Why I should check the Virtualization in the Task Manager in order to setup port for User DSN. This should be ok as I'm setting up a User DSN not a System DSN.

 

Is there anyone can clear my doubt?

 

Thanks.