SQL Server Denali SMO calls with .NET framework 3.5

Question

Hi,

Does SMO expect .Netframework 4.0 to talk to SQL server Denali or 3.5 is enough?

 

I'm trying to migrate my C#, .Net application to support SQL Server Denali. The application currently supports SQL Sever 2008 and uses .Net Framework 3.5. I'm just wondering if just replacing SMO assemblies (as per http://msdn.microsoft.com/en-us/library/dd206977%28v=sql.110%29.aspx) are enough or do I need to migrate to .Net framework 4.0 too. SQL server Denali expects 4.0 to work but SMO library does not talk about the framework to be used. When I try to remotely connect to the Denali server using framework 3.5 I get the following error.

"System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"

 

Thanks for the help,

Hem

Answer 1

Can someone reply this please?

Thanks,
Hem

Answer 2

You can take a look at blog entry http://blogs.msdn.com/b/sqlagent/archive/2012/05/11/create-sql-agent-job-using-c-and-smo.aspx

and a Visual studio sample http://code.msdn.microsoft.com/Create-SQL-Agent-job-using-b95584e7

Thanks

Sethu  Srinivasan  [MSFT]

SQL Server

http://blogs.msdn.com/sqlagent