External Access

Hey all,
I am trying to access SQL Server from external site on internet. I have
set the server to listen on a random port to prevent discovery of the
server at the default 1433. I am forwarding the port through the firewall
to the SQL box. I can connect internally to the chosen port but am unable
to establish a connection externally. The server receives the connection
attempt but the reply doesn't seem to make it back. The firewall does not
perform any filtering of outgoing packets. I would have thought that NAT
would ensure responses were returned to the external network.
Are there any additional parameters or network considerations that must be
made to allow the external access?
Cheers,
Aaron Wolski.INF: TCP Ports Needed for Communication to SQL Server Through a
Firewall
http://support.microsoft.com/?id=287932 - This article documents the
minimum TCP/IP ports that are required to communicate to SQL Server over a
firewall.
HOWTO: Use ADO to Connect to a SQL Server That Is Behind a Firewall
http://support.microsoft.com/?id=269882 - When you use ActiveX Data
Objects (ADO) to connect to a SQL Server 7.0 or SQL Server 2000 server that
is behind a firewall, consider the following: The firewall must be
configured to permit port 1433 incoming (or the port numbers that SQL
Server...
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Aaron Wolski" <ajwNO@.SPAMuqconnectPLEASE.net> wrote in message
news:Pine.OSF.4.58.0310071002140.5903@.fox.uq.net.au...
> Hey all,
> I am trying to access SQL Server from external site on internet. I have
> set the server to listen on a random port to prevent discovery of the
> server at the default 1433. I am forwarding the port through the firewall
> to the SQL box. I can connect internally to the chosen port but am unable
> to establish a connection externally. The server receives the connection
> attempt but the reply doesn't seem to make it back. The firewall does not
> perform any filtering of outgoing packets. I would have thought that NAT
> would ensure responses were returned to the external network.
> Are there any additional parameters or network considerations that must be
> made to allow the external access?
> Cheers,
>
> Aaron Wolski.
begin 666 1ptrans.gif
L1TE&.#EA`0`!`( ``/\SS ```"'Y! $`````+ `````!``$`0 ("A%$`.P``
`
end

External Access

Hello,

I want to access my database server from the internet. I've created a rule
on my router to redirect port 1433 to the desired machine, but still get a
Server does not exist, or access denied message. When I change the
(external) ip to the local IP address, connection succeeds. Is there
anything i need to change within SQL Server to allow external (internet)
access?http://support.microsoft.com/defaul...kb;en-us;287932

Simon|||thnx!

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:1110803406.369995.165930@.z14g2000cwz.googlegr oups.com...
> http://support.microsoft.com/defaul...kb;en-us;287932
> Simon

Express sql database

Hi,

As far as I am aware, I have uploaded my website anddatabases (express) to the internet. I did this in VWD -> website > copywebsite. I assumed that my database would copy within the App_Datafolder..?

But I am getting errors which tend to suggest thedatabases aren't there? Have I done it correctly? If I have, then itmust be my connections - what do I need to adjust for them to work onthe web rather than just locally?

The hosting company definately supports express, and is set to 2.0.

Thanks!

Jon

check your web.config file for proper path for your database on the hosting server. and also make sure ASPNET account has read/write permission to app_data folder.

Expose RS to Internet?

Hello I have just created some reports and I want to expose them to the
internet without windows authentication. I mean that every user outside can
see my reports without being part of the domain.
Thanks for your help.From everything that I have read, I don't think that this is possible. You
need to authenticate against RS using Windows Authentication or some other
type of Forms Authentication (which is only supported in Enterprise Edition).
If you figure out a way, please do share, but I don't think that it is
possible.
I have the same issue, but have SQL Server Standard Edition and can't figure
out away to make this happen.
"Luis Esteban Valencia" wrote:
> Hello I have just created some reports and I want to expose them to the
> internet without windows authentication. I mean that every user outside can
> see my reports without being part of the domain.
> Thanks for your help.
>
>