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 |
|
j0shua
Starting Member
40 Posts |
 Posted - 2009-06-10 : 22:31:23
|
| Hi, i am trying to connect to a remote mssqlserver over the local area network through SQL server management studio however despite many attempts, i could not connect.I am using SQL 2005, as far as what i have read, i tried to configured the server to allow remote access, i have also configured surface area and enabled TCP/IP. i have also configured the server configuration manager's TCP/IP, removed dynamic ports, and indicated a port. I have also exempted that port to allow to pass to the firewall.but still i cannot connect. Is there something i have missed? i appreciate any help. thank you. :) |
|
|
j0shua
Starting Member
40 Posts |
Posted - 2009-06-11 : 03:09:39
|
| i think i found the answer. Firewall. It was needed to excempt EACH instances. for my case, i only excempted One. I had multiple instances in my PC. |
 |
|
|
|
|
|
Remote Database