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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-04-26 : 05:52:32
|
| Hi,What is the difference between creating an Alias using SQL Configuration manager and creating an Alias using SQL Server client Network utility?Does both come along with SQL Server 2005 installation?Recently i have run into an issue where in am not able to connect to sql server using server name (default instance) but i was able to connect using IP and '.'.I have checked if there is any alias which is cofigured in SQL Server configuration for sql server which is causing the problem. Later we found that when we open up the SQL Server Client network utility we found an Alias with the server name. I clicked on Edit and saw the properties of the Alias.An the server name and port no 1433 was given correctly and only one thing i observed is multiprotocol was selected in the Alias.What does Multi protocol mean? In sql config mgr i see Shared memory,TCP/IP and named pipes and enabled due to this alias i was not able to connect to SQL using server name.Note: the name of the Alias and server name both are same. If that is the case , then it should allowed me to connect to sql but it did nt allowed me.Is there anything wrong in choosing the multiprotocol???Books Online also sayshttp://msdn.microsoft.com/en-us/library/ms187892(v=SQL.90).aspxMicrosoft SQL Server 2005 does not support the Banyan VINES Sequenced Packet Protocol (SPP), Multiprotocol, AppleTalk, or NWLink IPX/SPX network protocols. Clients previously connecting with these protocols must select a different protocol to connect to SQL Server 2005.I really didnt understand what it says but once i deleted the alias i was able to connect.Again my question if it is not supporting Multi protocol, then why the option is given in SQL Server Client Network utility for creating a Alias???Appreciate if anyone would share their thoughts.Thanks in Advance. |
|
|
|
|
|
creating Aliases