Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peteoc
Starting Member
14 Posts |
 Posted - 2007-10-27 : 09:34:27
|
| Does someone have a guide or a link to a guide to allow remote connections from a default install?Just that I'm currently testing my setup on a work laptop but not having much success but thats probably down to the network admins limiting me far too much on here.However I am getting a new DELL machine, which I'm gonna make sure the network admins get no where near. Once I have this machine I will be forwarding port 1433 to the machine, but need to know what other changes I need to make to allow my friend access to the machine as well.So I'd need to know what server settings I need to change and also what my friend needs to do as a client.thanks in advance! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-10-27 : 12:34:03
|
| use SAC (Surface Area Configuration) tool to allow "local and remote connections." also make sure sql browser service is running |
 |
|
|
peteoc
Starting Member
14 Posts |
Posted - 2007-10-31 : 04:01:06
|
| Cheers Russell,Thought I may need to go arsing about further with other hidden sections of the configuration. Am I also correct with regards to only needing to forward port 1433 to the SQL server machine?Then on the client machine create an alias, pointing to the remote IP address and port 1433.Do I need to make SQL server think its listening on my real world IP address instead of my network address? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-10-31 : 15:36:38
|
| are u opening it up over the internet? else dont need do anything special. |
|
|
|
peteoc
Starting Member
14 Posts |
Posted - 2007-11-01 : 18:39:34
|
| I have reconsidered now and will be doing it another way so it only needs to be on the network :) |
|
|
|
|
|
|
Remote Connections