Welcome to MSDN Blogs Sign in | Join | Help

September 2005 - Posts

Sunday, September 25, 2005 4:47 PM

Protecting the SQL Server 2005 'Service Master Key', the root of all encryption

Microsoft SQL Server 2005 introduces a new feature set, known internally as 'Secret Storage'. Secret Storage is the overall umbrella technology for the data encryption facilities in the SQL Server database engine, including the key management story. The
Posted by stuartpa | 4 Comments
Thursday, September 15, 2005 4:40 PM

SQL Server 2005 password change without server restart, small issue with 32 bit installs on x64 OS

In an earlier post , I said it will be possible to change the Microsoft SQL Server 2005 service account passwords without requiring a service restart. Today we found a corner case. It turns out, when you install SQL Server 2005 32 bit editions on an x64
Posted by stuartpa | 0 Comments
Monday, September 05, 2005 9:53 AM

Using SQL Server Management Studio (and Profiler) Tools with SQL Express 'User Instances'

In the SQL Server 2005 Express Edition, available for free here , there is new connection string option: 'user instance=true'. When this connection string option is specified, the SQL Express instance you are connecting to (we call this the parent instance),
Posted by stuartpa | 1 Comments
Friday, September 02, 2005 7:05 PM

Change the SQL Server Service Account password without Server Restart

A couple of weeks ago, we checked-in a feature to Microsoft SQL Server 2005, that allows the various Service Account passwords to be changed, using the SQL Server Configuration Manager, without having to restart the respective services. NOTE: It is going
Posted by stuartpa | 0 Comments
 
Page view tracker