An error occurred while attempting to start the service (1460)

[Guest_imported]

Hello,
When I was trying to install SQLServer(7.0) in my Windows2000 operating system, It was

not properly installed and given an error message saying that,

'Setup failed to configure the server, refer to the server error logs and 'cnfgsvr.out' for

more information'

Please help me in this problem.

Waiting for your valuable reply..
..............V.Thandava Krishna.



This is the content of the above said file.


Starting Service ...

Connecting to Server ...

driver={sql server};server=.;UID=sa;PWD=;database=master

Remapping Server Databases ...

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'model'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error

messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'model'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'msdb'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error

messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'msdb'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'pubs'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error

messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'pubs'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'Northwind'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error

messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'Northwind'.

Disconnecting from Server ...

Stopping Service ...

Starting Service ...

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

 

[muthaamit]

Hi Thandava,

The error occured during restarting the server may be because the account under which the service (sql 7.0) is running may not be an administrator of that machine. Please check this aspect.

 

[Guest_imported]

I'm having the exact same problem...
The service doesn't show up in the Services list, so I don't know how to set it up to run as a different user.

Would this have someting to do with running SQL7.0 on a Win 2k machine?

Sam

 

[Guest_imported]

I was having the same problem a while back because I was attempting to install it through terminal services. Try installing it locally using the administrator account, and it should work.

 

[k2ps]

jdraper3 had it exactly right! When I installed directly, without Terminal Services, it worked perfectly. Thanks!

 

[Guest_imported]

Hey - you're all quite correct!
Microsquash even says so on their site!!
Try VNC (It's free) or PCAnywhere!

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246694

 

[Guest_imported]

Just had the same problem and just found out from a Developer what the problem stems from;-
I put the SQL7.0 CD in the W2K machine then went back upstairs to use terminal server as i'm lazy and couldn't b bothered hooking up a terminal. So anyway i got the same error message and the problem was you need to be present at the server and use a terminal hooked up to it for the Install. So 1st you must do an Uninstall and then re-install. Good Luck