Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connecting to SQL Azure using SQL CLR Expand / Collapse
Author
Message
Posted Monday, January 04, 2010 12:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 6:25 PM
Points: 7, Visits: 45
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
Post #841666
Posted Thursday, April 08, 2010 11:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 28, 2010 8:50 AM
Points: 2, Visits: 1
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/
Post #900203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse