giving users outside access to sql server 2k5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jackson Lee - 30 Jan 2008 18:00 GMT

I'm trying to give access to users outside my firewall using an untrusted
sql login but for some reason I'm not able to do this.

I've opened up port 1433 on the firewall and pointed it to the server with
the same port number but I'm still not able to make a connection.

Is there anything I need to do to let external users access the database on
sql server 2005.

TIA,

Jackson

Reply to this Message

Curtis - 30 Jan 2008 18:51 GMT

> I've opened up port 1433 on the firewall and pointed it to the server with
> the same port number but I'm still not able to make a connection.

Do you have local and remote connections for TCP/IP enabled on the SQL
Server? Verify that it is listening on 1433. If you are able to
connect from remote machines on your local network, then your problem
is probably on your firewall layer.

Curtis

Reply to this Message