Problem Installing SP2 to 2005 1

[JohnBates]

hi everyone,

I'm trying to install SP2 to SQL Server 2005, but I've hit a wall.

At the Authentication step it fails with "Your account information could not be verified. For setup to verify your credentials the services must be startable, connectable and you must be a SQL Server administrator." All the services are startable and my login does have sys admin permissions.

I'm thinking that maybe 1 of the SQL Server services needs to be running (I stopped MSSQLSERVER and AGENT before trying to install it) to enable it to verify my login.
This server is set for Mixed mode authentication.

Has anyone had this problem installing SP2?

Thanks much. John

 

[mrdenny]

There is no need to stop the SQL Server when installing. Leave the SQL service running. Stop the SSIS service in order to avoide a reboot.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

Thanks mrdenny.

I rebooted the server.

Then stopped only the Integration Services service - all other SQL Server-related services are running.

I still get the error "Your account information could not be verified."

I created a local acct, granted it sysadmin permissions but that did not work either.

There is only 1 instance abd the OS is Windows 2003 Server.

After googling this, I see that a few people have encountered this problem - but it is not common.

John

 

[mrdenny]

I know that we had problems like this in SQL 2000. Try stopping the SQL Server service, and run the SQL Server from a command line window with the -c -m switches. Then start the SP installer and see if that does the trick.

What happens if you run the package as sa.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

mrdenny, I logged in as sa, but got the same error "Your account information could not be verified..."

You suggested "Try stopping the SQL Server service, and run the SQL Server from a command line window with the -c -m switches."

I'll stop the MSSQLSERVER service and the Agent as well, then run SQLServer.exe -c -m I know the -m switch puts it in single-user mode. I'm not familiar with the -c switch.

Thanks for this suggestion. I will post back.
John

 

[mrdenny]

The -c switch runs the SQL Server in console mode instead of running it as a service.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

... over a week later:

I stopped Agent and SQL Server, then ran this:
SQLServer.exe -c -m
I suppose it worked because at that point only 15 processes were running. MSSQLServer service did not saying executing however-I suppose that' because it came up in single-user mode.

Ran the setup for SP2 and still got the same error "Your account information could not be verified..."

This server normally starts the sql services as 'Local System' or 'NT Network'.

The server has SP1, I'm trying to install SP2.
Am I looking at doing a reinstall of SQl Server 2005 ?

Thanks, John

 

[mrdenny]

The service wouldn't have said it was running because you were running it from the command line window.

What does it say in the install log?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[JohnBates]

... summary.txt does not contain any helpful information

HotFix.log has:
10/12/2007 16:48:18.969 PFR Check: PFR was found, but no files to be serviced were being referenced
10/12/2007 16:49:03.859 Authenticating user using Windows Authentication
10/12/2007 16:49:03.968 SQL Service MSSQLServer was previously running, ready for authentication
10/12/2007 16:49:03.984 SQL Agent Service SQLSERVERAGENT was not previously running
10/12/2007 16:49:04.796 User authentication failed
10/12/2007 16:49:49.264 Authenticating user using SAPWD
10/12/2007 16:49:49.280 SQL Service MSSQLServer was previously running, ready for authentication
10/12/2007 16:49:49.296 SQL Agent Service SQLSERVERAGENT was not previously running
10/12/2007 16:49:49.327 User authentication failed
10/12/2007 16:50:51.076 Hotfix package closed


as you can see, I used my domain login, and also tried sa
The server is set for mixed mode.

I don't have any more ideas.

Thanks, John

 

[mrdenny]

Check for any logs here.

C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\xxxx-SQLsupport.log

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[JohnBates]

mrdenny,

Yeah, I had read that was a good place to check but...
Lots of files there for the original install a few months ago, but no files since then.

Thanks, John

 

[mrdenny]

There's another log file somewhere (I think). Check windows\system32 maybe?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog