Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-11-06 : 07:42:21
|
| Im in configuration manager and not of the sql services will start have two instances both are red.Not sure why suddenly stopped get timeout message on both...rebooted still same |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-06 : 07:58:15
|
Any changes in security and/or permissions?Any files missing?What does the log contain for information about not starting?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-06 : 08:18:45
|
| Not getting anything in logs that i can go by.I just reinstalled sql 2005 as another instance that works just fine.Would there be a corrupt file in the bin i can replace....sqlagent.dll was in sql 2000The SQL Server (ASRCFHSQL2005_2) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. Thanks |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-06 : 08:19:22
|
| Timeout (30000 milliseconds) waiting for the SQL Server (ASRCFHSQL2005_2) service to connect.Anyway to increase timeout perhaps. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-06 : 08:36:05
|
| I fixed itC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG Open up the log had something to do withThe SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol. Error: 0x7e.So disabled the via and it worked.... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-06 : 22:21:39
|
| VIA protocol works with specific Virtual Interface Adapter only, shouldn't enable it without such hardware. |
|
|
|
|
|
|
SQL 2005 not start