An unwanted surprise when changing the SQL Server 2005 Service Account

When changing the Microsoft SQL Server 2005 Service Account you might get back this rather alarming error message box: —————————WMI Provider Error—————————The process terminated unexpectedly. [0x8007042b]—————————OK   ————————— This is related to the problem documented in Books On Line on the page titled: ‘Start and Restarting Services’ (accessible in the index as ‘starting SQL Server’).  I quote from the paragraph…

9

A strange problem with ‘ADD SIGNATURE’ and the new SQLCMD command line utility

This one is a little odd:  But, when using the new ‘ADD SIGNATURE‘ DDL in SQL Server 2005, if you are using SQLOLEDB through the SQLNCLI (SQL Native Client) protocol stack, i.e. the stack the new command line utility SQLCMD uses, you will get the following ‘Incorrect syntax’ error when trying to issue an ‘ADD SIGNATURE’…

9

An error starting a SQL Server 2005 User Instance when using Remote Desktop

Late last week, I was using the new ‘User Instance‘ support in SQL Express 2005.  I was connecting from home using Remote Desktop to my main office machine, and when trying to connect to SQL Express, I was becoming increasingly frustrated with the following error: Error: ‘Failed to generate a user instance of SQL Server…

8