Sunday, April 30, 2006

SQL Server, SP4 installation Quirks

when using MS Remote Desktop, installation doesn't continue. this is the error:

"service control opertaion failed for the MSSQLSERVER service: 1460
This operation returned because the timeout period expired"

i found an article stating this problem: http://www.sql-server-performance.com/forum/post.asp?method=TopicQuote&TOPIC_ID=9483&FORUM_ID=4


Posted - 07/28/2005 : 00:31:56
Might be issue where sql server on restart is taking more time to accept client connection.
What is the size of database and transaction logs on server.

May be you can try to install it from command prompt as below:

setupsql.exe k = dbg.

Also try to install direcly from box and not thru remote desktop or PC anywhere.

That was what MS did in of our cases

heheh, no way i would go to the office just to install SQL Server Service Pack 4, it is sunday today :D

then i use RAdmin, the installation went okay. hmmm... strange :)

No comments: