Hi,
I have a problem with my SQL Server 2005 instance after trying to install SP2.
My machine has a default instance of SQL server 2005, and 2 instances of SQL 2005 express.
I installed Express SP2 and this installed without a hitch.
Then I installed SP2 for SQL Server 2005. After the install, all the components had installed correctly except the Database Engine, which had a status of failed. I did not investigate why, I simply re-ran the install.
It failed again, so I investigated further and I found out it failed because it had not been able to start the service VSS Writer. I looked at the service, and found I had changed the user which gives the service rights to start. I changed this back to Local System so the service could start correctly.
I then re-ran the SP2 install. This time it failed in a different place. The reason this time was my user was not a valid user for my server. This is a first, because I logged onto the database using this user name minutes before running the install. The install must have deleted my user. Then I tried to login using the sa account only for my server telling me that the sa account has been disabled.
I now cannot log into my database at all, and am stuck. If I try to rerun the install it tells me it cannot connect to the server to perform the update because there is no user.
Please Help!
Are you able to proceed past the Authentication screen in the SP2 installation Wizard? If not what error are you seeing? Can you post your summary.txt file, which will be in %programFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
Thanks,
Peter Saddow
|||There was a failure during installation search up in this log file for this message:
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'TSI\Sean'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<EndFunc Name='ComponentUpgrade' Return='18456' GetLastError='0'>
PerfTime Stop: CommitSqlUpgrade : Mon Feb 26 14:11:18 2007
Gathering darwin properties for failure handling.
<EndFunc Name='LaunchFunction' Return='18456' GetLastError='0'>
MSI (s) (84:64) [14:11:19:083]: Transforming table InstallExecuteSequence.
MSI (s) (84:64) [14:11:19:083]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (84:64) [14:11:19:099]: Transforming table InstallExecuteSequence.
MSI (s) (84:64) [14:11:19:099]: Transforming table InstallExecuteSequence.
MSI (s) (84:64) [14:11:19:099]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (84:64) [14:11:19:099]: Transforming table InstallExecuteSequence.
MSI (s) (84:64) [14:11:19:099]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (84:64) [14:11:19:099]: Transforming table InstallExecuteSequence.
MSI (s) (84:64) [14:11:19:099]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 14:11:19: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 14:11:19: INSTALL. Return value 3.
--
Microsoft SQL Server 2005 Service Pack 2 Setup
--
Feature Selection
This setup program detected the following SQL Server 2005 features. Select the program
features that you would like to update. To see the details of a feature, click on the feature.
O Setup Support Files
X MSSQLSERVER
X Database Services
X Analysis Services Language ENU
X Reporting Services Platform x86
O SQLEXPRESS Edition DEVELOPER
O Database Services Status Upgraded
O Notification Services
O Integration Services
O SQL Server Native Client
O Client Components
O MSXML 6.0 Parser
O SQLXML4
O Backward Compatibility
O Microsoft SQL Server VSS Writer
|||After the previous screen I select next, then make sure Windows Authentication is selected then click next again.
-
Your account information could not be verified.
Press Ok to return to Authentication Mode screen to determine the reason for failure.
For setup to verify your credentials the services must be startable, connectable, and you must be a SQL Server administrator.
After I click Ok & Back the Feature Selection screen shows details of:
Login Failed: HResult 0xE9, Level 16, State 1 Shared Memory Provider: No process is on the other end of the pipe. Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure.
And it shows a status of:
Not Valid
|||I am getting the same issue.. can you help? When i am trying to install SP2
Your account information could not be verified.
Press Ok to return to Authentication Mode screen to determine the reason for failure.
For setup to verify your credentials the services must be startable, connectable, and you must be a SQL Server administrator.
