Certificate for SQL Server 2005

Microsoft SQL Server 2005 can use Secure Sockets Layer (SSL) to encrypt data transmitted across a network between an instance of SQL Server and a client application. Certificate is used to encrypt the data transmission. Certificates are stored locally for the users on the computer   In order to be successfully loaded by SQL Server…


Troubleshoot Connectivity Issue in SQL Server 2005 – Part III

Part III – Connection Fail when SqlClient connects to Sql Server 2005 When you connect to SQL Server 2005 either using “SQL Server Managment Studio” or any application compiled with .NET Framework 2.0, you are using SqlClient provider(Access data from within a CLR database object by using the .NET Framework Data Provider for SQL Server.)…


VSS: SQL Server does not exist or access denied

I recently worked on three customer issues. In all those cases, customers were not able to backup databases using Microsoft Volume Shadow Copy Service (VSS). MSDEWriter does not show up with “vssadmin list writers”. And VSS logs the following error message in event log:   Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005….


Introduction to SQL 2005 Native XML Web Services November 30, 2005 webcast

On November 30, 2005, Srik presented in a webcast an introduction to SQL 2005 native xml web services.  The webcast highlighted the ease of exposing existing stored procedures and functions as webmethods.  It also described the ability to manage each of the endpoints and the metadata views.  As with any HTTP related support, security is a…


Unable to correct invalid SQL Server Network Configuration on clustered SQL Server causes clustered SQL Server fail to start “permanently”

Recently, we encountered an issue reported by a customer on a clustered SQL Server. What happens is the following.   The Customer needs to restrict the number of IP addresses SQL 2005 Server is listening. He uses the following procedure for that: open “SQL Server Configuration Manager” (SSCM)  -> “SQL Server 2005 Network Configuration” ->…


Networking Protocols and SQL Server 2005 Virtual Server

SQL Server running on Windows Cluster Service is called SQL Server Virtual Server or SQL Server Cluster. There are three related terminologies in SQL Server Virtual Server. It’s important not to confuse with each other.  Windows Server Name. This refers the physical nodes on which Windows Cluster Service and SQL Server run. SQL Server Virtual…


InfoPath: WSDLOperation: The parameters for element parameters in operation GetSystemDefinition could not be created.

There have been questions raised about how to make InfoPath work with SQL 2005 native web services.  Some people have been hitting the following error in InfoPath when trying to use SQL 2005 native web services as a data source:    WSDLOperation: The parameters for element parameters in operation GetSystemDefinition could not be created. The parameters could…


SQL Express remote connections

Networking protocols are disabled by default in SQL Server Express. The error message you will get when trying to connect from SQL Native Client will look like this   “An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that…