Possible even if you use OLEDB providers...... What you have to do follow as below
SQL Server 2005 and 2008 ship with network protocols disabled by default in an attempt to tighten security. I believe the only default enabled protocol is Shared Memory which is only useful if you are on the physical machine. Run the SQL Server Configuration Manager, expand SQL Server 2008 Network Configuration and then select the Protocols node. Then right-click and Enable TCP/IP and/or Named Pipes. Restart the instance of SQL Server and it should all work. On Fri, Jul 17, 2009 at 11:31 AM, Harsha <sriharsha.ga...@gmail.com> wrote: > > Hi Experts. > > Is it possible to connect SQL server 2008 as a backend from .net 1.1 > (Client dont want to migrate this as of now)? > > Often I am reading in web that people are facing issue when they try > for it. > Has Microsoft released patch for this? > > Any help is much appreciated. > > Thanks > Sriharsha Karagodu. > -- Regards Jay Dan
