Sunday, February 26, 2012

Driving me insane with remote connections in SQL 2005

I have developed an application that utilize SQL server 2005. The application is a clickonce application and launched from the IIS. The problem is that when im trying to connect from outside the company i get the Error that the server does not accept remote connections.

I have used the surface manager and setup the protocol to accept remote connections. Nothing happens.

I have changed the IIS to use the configuration screens under the .NET configuration in IIS. Nothing helps there either.

I have open the ports 445 ,1433, 1434

Anyone knows what i could do to get the connections working on the %%%%%%

I'm moving your question to the data access forum where you should get an answer.|||

Can you post the exact error msg here?
Is your SQL instance the default instance? Can you check whether it's listening on NP and/or TCP? and TCP port number? You need to run SQL Browser. I assume you opened port UDP 1434, not TCP 1434.

or at best, collect information according to
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

Thanks,

|||Have a look at:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2464749&SiteID=1

Mortaza Doulaty
http://www.mrt-web.com

No comments:

Post a Comment