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 |
|
JezEling
Starting Member
4 Posts |
 Posted - 2009-06-21 : 16:11:56
|
| Hi All,I'm looking for some tips regarding server instances and aliases. I have a server which will very shortly have a named instance running on it, however i'm trying to find out if it's possible to connect to the instance via just a DNS or Server name without specify the instance name as well.I've done a large amount of research and tried out aliases on a test server, I can connect to an alias locally from the the server which points to an instance however when I try from a remote machine it fails until I put the instance name after the alias name.Any hints or tips would be very much appreciated.Many Thanks in advanceJez |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-22 : 08:45:44
|
| There is no way you can access the instance.You can only achieve the default instance. Unfortunately you have to access using the instance name only.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
 |
|
|
|
|
|
Server Aliasing