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 |
|
gnr
Starting Member
4 Posts |
 Posted - 2009-01-25 : 13:45:09
|
| I want to connect with my application to remotely located MS SQL server 2005. Is that possible?Currently I have to login via Remote Desktop and run my application on the server which is no good for me.Pls advise. |
|
|
gnr
Starting Member
4 Posts |
Posted - 2009-01-27 : 11:28:52
|
| bump |
 |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-01-27 : 16:03:41
|
| You should be able to. See if this helps:http://support.microsoft.com/kb/914277 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gnr
Starting Member
4 Posts |
Posted - 2009-01-29 : 18:53:04
|
| I should have clarified -- SQL server and client machine are not on the same network. They are miles away from each other.If I follow the Microsoft write up on enabling remote connection, what TCP port(s) do I need to open on the router?thank you |
|
|
|
gnr
Starting Member
4 Posts |
Posted - 2009-01-29 : 18:55:38
|
quote:
Originally posted by gnr
I should have clarified -- SQL server and client machine are not on the same network. They are miles away from each other.If I follow the Microsoft write up on enabling remote connection, what TCP port(s) do I need to open on the router?thank you
Looks like I found the answer here http://msdn.microsoft.com/en-us/library/ms165724(SQL.90).aspx |
|
|
|
|
|
|
Remote SQL server