INSTALLATION OF SQL EXPRESS EDITION FAILS ON WINDOWS VISTA WHILE INSTALLING MICROSOFT OFFICE ACCOUNTING 2008

  There have been a number of instances where we observed that the installation of the sql express edition on Windows Vista which also gets installed along with Microsoft Office Accounting 2008 fails which ultimately causes the installation of the Office Accounting 2008 on Windows Vista to fail. So in order to successfully install Sql… Continue reading INSTALLATION OF SQL EXPRESS EDITION FAILS ON WINDOWS VISTA WHILE INSTALLING MICROSOFT OFFICE ACCOUNTING 2008

HOW TO CHANGE THE DYNAMIC PORT OF THE SQL SERVER NAMED INSTANCE TO THE STATIC PORT IN A SQL SERVER 2005 CLUSTERED INSTANCE

    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 selected when the named instance of the sql server starts. So when we connect to… Continue reading HOW TO CHANGE THE DYNAMIC PORT OF THE SQL SERVER NAMED INSTANCE TO THE STATIC PORT IN A SQL SERVER 2005 CLUSTERED INSTANCE

USE OF KERBEROS AUTHENTICATION IN SQL 2005

Kerberos 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 to have an SPN set for it so that clients can identify the service on… Continue reading USE OF KERBEROS AUTHENTICATION IN SQL 2005

HOW TO CONVERT A STANDALONE INSTANCE OF SQL SERVER INTO CLUSTERED INSTANCE

  FOR SQL SERVER 2000:   Case 1: If the default instance of  sql server is to be upgraded to default clustered instance of sql server 2000   Note: 1)       Only Default instance can be upgraded by this method 2)        This Functionality is not vailable in sql server 2005 so if you want to convert… Continue reading HOW TO CONVERT A STANDALONE INSTANCE OF SQL SERVER INTO CLUSTERED INSTANCE