SQL Express 2005 Remote Connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

SQL Express 2005 Remote Connection

Author

Topic

NextComputing
Starting Member

2 Posts

Posted - 2011-05-24 : 02:32:42

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.1MSSQLServer\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.1MSSQLServer\SUperSocketNetLib\Tcp'
@Value_Name ='Enabled'
@type='Reg_DWord'
@Value=1

After that if restart the machine and try to connect SQL Express using SQL Authentication from my VB.net application but it's not working. Can any one help me to run my Apps on LAN without configuring manually.

Thanks in Advanced
NextComputing

Next Computing
Kolkata

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources