Hi,
I am trying to run an application in VB.net having SQL Express 2005 at back end.it's working fine on stand alone machine but when i try to run in LAN environment i have to manually set the "Locale
and remote Connection " and "TCP/IP and Named Piped " option through SQL Server Surface Area Configuration. I am setting the registry value using SQL stored Procedure as below
EXEC Master.dbo.xp_Rewrite
@RootKet='HKEY_Local_Machine'
@Key='\Software\Microsoft\Microsft SQLServer\MSSQL.1\
MSSQLServer\SUperSocketNetLib\NP'
@Value_Name ='Enabled'
@type='Reg_DWord'
@Value=1
EXEC Master.dbo.xp_Rewrite
@RootKet='HKEY_Local_Machine'
@Key='\Software\Microsoft\Microsft SQLServer\MSSQL.1\
MSSQLServer\SUperSocketNetLib\Tcp'
Go to the complete details ...