Connecting to SQL Azure using SQL CLR

• harinarayan-414614

  Mr or Mrs. 500

  Points: 501

  More actions

  January 4, 2010 at 12:53 pm

  #214156

  I use ADO.NET to connect to SQL Azure. The code worked verywell as a console application.

  But the code when run as a CLR Proc, threw the following error

  A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The requested name is valid, but no data of the requested type was found.)

  Any pointers?

  Thanks

• shyamagosti

  Grasshopper

  Points: 22

  More actions

  April 8, 2010 at 11:52 pm

  #1148831

  I think this error is coming because of firewall setting. Please check your firewall setting in azure database.

  Happy Codding...

  My blog: http://www.expertdevelopersblog.co.cc/