In sql server the default instance has a listener which listens on the fixed port which is TCP port 1433. However for the named instance the port on which the sql server listens is random and is dynamically … Continue reading
Monthly Archives: May 2008
ERROR 29506 while Installing the SP2 on the sql server 2005
TweetThis post talks about the location of the log folder where all the sql server 2005 setup logs are located. It mainly provides the solution of the error 29506 during installation of the sql server sp2. Continue reading
USE OF KERBEROS AUTHENTICATION IN SQL 2005
TweetKerberos is a network authentication protocol which can be used only with TCP/IP protocol. So if the client connects to the sql server with the Named Pipe Alias Kerberos is not used. Every service that will use Kerberos authentication needs … Continue reading