January 23, 2012 at 10:47 pm
HI
Currently our Splice_M application Run with MSSQL server 2000 and
from application side they are connecting DB with .Net frame work
1.1,Now we will trying to migrate MSSQL 200to MSSQL 2008 server but client whant to connect .net frame work 1.1 only. is it support .netframwork 1.1 on MSSQl server 2008 db?.please help us with links.
Thanks
Ram
January 24, 2012 at 3:24 am
What Class are you using to connecto to SQL Server? If you are using a standard SqlConnection and SqlCommands, then it should work just fine. These are both available in .NET 2.0 and 3.5. Depending on which version/edition of SQL Server 2005/2008 you installed to test, it won't be setup to have Remote TCP connections. You can enable this by opening the SQL Server Configuration Manager in the Configuration Tools on the Start Menu. Expand the SQL Server 2005/2008 Network Configuration node in the tree, and then click the Protocols for MSSQLSERVER or the Instance name you are connection to. Then see if TCP/IP is Enabled. If it isn't then open the properties, set it to enabled, and make sure that it has Listen All to Yes and click ok. You have to restart the instance of SQL Server before it takes effect. Then retry the connection. It should succeed.
For more details check this out:
http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/9299b9c8-4174-4582-962d-68d31edf270e
Thanks,
GG;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply