December, 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...

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...

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...

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...

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:...

Some people have raised the question, "Is SOAP supported in SQL Express? How about SQL Mobile? I've read in a readme that web services isn't supported on WinXP SP2, but I've also heard that SQL 2005 web services require the HTTP.sys kernel support which...

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...