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 |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2007-06-18 : 11:42:59
|
| Dear DBA experts.Over the past one week, I have been trying to schedule data export job using dts but to no avail. Sometimes, it fails due to permission and sometimes, I get an invalid pointer error but there is harm done to the SQl Server db itself.This morning, all applications running on this SQL Server db stopped working.When we went to event viewer, we didn't see any errors or warnings; however, we saw an information that says, MSSQLSERVER with event #17055. When we went into properties, we saw the following:17148 :SQL Server is terminating due to 'stop' request from Service Control ManagerHas anyone encountered this error and what could have caused it?Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-18 : 11:52:08
|
| Someone stopped the service.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-06-18 : 12:02:33
|
| Right!But I wanted to know if what I said I have been doing could have stopped service. It is important for us to figure out what caused and prevent future occurance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-18 : 12:15:33
|
| Not unless you've added a NET STOP MSSQLSERVER command into your package. The system log in Event Viewer should indicate who did it.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-06-18 : 12:59:32
|
| Thank you Tara:It didn't say my name. It simply said N/A.Any abnormal activities by me has shown my name so far. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-18 : 13:05:12
|
| I believe in the Application Log, which I believe is where you looked, it says N/A. However, in the System Log it says the name.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL Server error