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

Driving Crazy

hi,
There is something i really don't understand.
There is a remote server shows under Security --> Remote Servers
and I just cannot delete it.
I run sp_dropremotelogin -->
it said "There are no remote users mapped to any local user from remote
server 'repl_distributor'
I run sp_dropserver 'repl_distributor' -->
it said "There are still remote logins for the server 'repl_distributor'
? how am I able to remove that remote login?
Thanks so much
EdThe name suggests that it is a remote server created by replication, which
facilitates communication between the Distributor and Publisher. If you need
to remove the replication and the remote server, use the replication menu
under Tools in EM and click on Disable Publishing and Distributing.
Anith