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 |
|
rieta760
Starting Member
5 Posts |
 Posted - 2009-03-26 : 19:48:45
|
| I have 3 instances installed on a server. The 1st one I am able to connect via the name of the Server, ie. SQL1. The other instances I have to use the IP address and port, ie. 10.33.42.15,2030 (SQL1\DEV) and 10.33.42.15,2222(SQL1\QA).When I'm on the server itselt, I can open the SQL Mgmt tools and access the instances as SQL1\DEV or SQL1\QA, but from other workstations, i have to use the IP address and ports. How can make it so the other machines can access the instances by named instance instead of IP/PORT? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-03-27 : 01:59:41
|
| configure surface area, set remote connections according to your requirments i.e. IP or named pipes or both |
 |
|
|
rieta760
Starting Member
5 Posts |
Posted - 2009-03-27 : 11:35:24
|
| In SQL Server 2005 Surface Area Configuration, under Database Engine, under Remote Connections, I have Local and remote connections checked, I also have Using both TCP/IP and named pipes Checked. Still can't connect using the name SQL1\QA from outside workstations. I have to use IP/Port. I'm also having problems starting SQL Agent for these instances. I will post up another thread about that. |
|
|
|
|
|
|
Accessing SQL Server Instances via name vs. IP/Prt