由于啟動(dòng)用戶(hù)實(shí)例的進(jìn)程時(shí)出錯(cuò),導(dǎo)致無(wú)法生成 SQL Server 的用戶(hù)實(shí)例。該連接將關(guān)閉。其英文版本的相同問(wèn)題的錯(cuò)誤信息是:“Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.”
這是微軟的bug,并且微軟已經(jīng)承認(rèn),詳情如下:http://support.microsoft.com/?id=896613出現(xiàn)此錯(cuò)誤的條件是:你用過(guò)遠(yuǎn)程桌面連接,并且安裝了SQL2005+VS2005,就有很大可能觸發(fā)這個(gè)問(wèn)題,微軟說(shuō)會(huì)在將來(lái)的XP SP3里面解決掉這個(gè)問(wèn)題,要想立即解決這個(gè)問(wèn)題,需要交費(fèi)不用理會(huì)MS,咱們自有辦法來(lái)解決,請(qǐng)看如下文章:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=128707&SiteID=1
解決辦法:刪除C:Documents and Settings[USERNAME]Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS目錄即可,[USERNAME]是Windows用戶(hù)名,比如說(shuō)Administrator