| View previous topic :: View next topic |
| Author |
Message |
dteich
Joined: 12 Apr 2005
Posts: 132
|
 Posted: Wed May 30, 2012 8:42 am Post subject: SQL not running |
 |
|
Had to reboot the PC today (lost link to printer while printing labels). Now SQL is not there. The tray icon shows no connection.
What to do? |
|
| Back to top |
|
Brett Berger
Site Admin
Joined: 11 Jun 2010
Posts: 2402
|
| Posted: Wed May 30, 2012 9:04 am Post subject: |
|
|
Check in the windows services to see if it's running. Can't say I've ever seen the Microsoft SQL application remove itself from a computer. You can click Start > either RUN (XP) or in the search box type > services.msc > find the Microsoft SQL Server service, ensure it's running and set to automatic startup.
_________________
Brett Berger
Interapptive ShipWorks Support |
|
| Back to top |
|
dteich
Joined: 12 Apr 2005
Posts: 132
|
| Posted: Wed May 30, 2012 10:50 am Post subject: |
|
|
| The SQL server is running but the SQL server agent is stopped and can not be started. I rebooted 3x. |
|
| Back to top |
|
Brett Berger
Site Admin
Joined: 11 Jun 2010
Posts: 2402
|
| Posted: Wed May 30, 2012 1:47 pm Post subject: |
|
|
SQL Agent isn't supposed to be running. Only the SQL Server (ShipWorks) or similarly named would be running. Did the computer name or anything about your Local Area Network change?
Sounds like SQL is there by viewing the services, can you elaborate on what you mean by not there? Are you able to open/use ShipWorks?
_________________
Brett Berger
Interapptive ShipWorks Support |
|
| Back to top |
|
dteich
Joined: 12 Apr 2005
Posts: 132
|
| Posted: Wed May 30, 2012 2:28 pm Post subject: |
|
|
I went through the list of MS SQL installed programs (via control panel) and repaired anyone that had the option of repair (other than remove). Then rebooted and now all is back to normal. No idea how it got polluted.
Thanks for the help. |
|
| Back to top |
|
Brett Berger
Site Admin
Joined: 11 Jun 2010
Posts: 2402
|
| Posted: Thu May 31, 2012 5:19 am Post subject: |
|
|
Fantastic! Glad to hear it's resolved and thanks for the update.
_________________
Brett Berger
Interapptive ShipWorks Support |
|
| Back to top |
|
|
