Last week, I got an opportunity to present on BI SQLPASS Virtual Chapter on All about Kerberos in Microsoft BI. Kerberos Troubleshooting is one of the highest call volume generator for Microsoft CSS and hence I thought I would choose this topic to educate our Customers on steps to configure Kerberos for SQL & SQL… Continue reading All about Kerberos in Microsoft BI
Category: CONNECTIVITY
Unable to run DTS Package fetching data from Oracle using ODBC Driver after migrating to 64 bit
Recently one of my customers migrated and upgraded their servers from SQL 2000 32 bit to SQL 2005 64 bit following which their DTS packages stopped working. In this blog post I intend to explain the troubleshooting approach, we adopted to resolve the issue along with the resolution to the problem. When you migrate DTS… Continue reading Unable to run DTS Package fetching data from Oracle using ODBC Driver after migrating to 64 bit
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