October 12, 2006 | Mark Paradies

Tech Support Thursday – SQL Problems and Resolutions

Hello again, folks.  It looks like another week has passed, and we all know what that means. Tech Support Thursday has arrived, and only one more day until Friday.  Unfortunately, tomorrow is Friday the 13th, so if you have Paraskevidekatriaphobia (Fear of Friday the 13th), just take tomorrow off.

Inside I’ll go over some basics on the MSDE SQL engine that runs the single version of TapRooT System Software.

Today we are addressing an issue many people have, and we get quite a few calls for help on also.  Does the picture look familiar?

SQL error

If so, read on and we’ll show you why this happens and how to fix it!

Reason: This can occur when your MSDE-powered SQL Server on your PC is not running.  No worries though, a few simple steps will get you back up and running in no time at all! 

First, if you get this error, look at the bottom right hand side of your screen.  You should see a small computer with a green arrow on top of it:

This shows that MS SQL is running fine.

SQL running

 

Or, perhaps you see the computer with a red dot on it:  This shows that MS SQL is not running.  Don’t panic though, its easy to turn it back on!

 

SQL not running

Double Click on the icon, and the SQL Server Service Manager will open:

SQL server manager 

Now, click on start/Continue.  The SQL Server starts after a few seconds.  If not, click the “Refresh Services….” button.  That also starts the Service.

However, when you look down to the clock in the bottom right hand corner, you may not see the computer at all.  Oh my!! 

Sql not there

Not a problem!!  Simply navigate to C:\Program Files\Microsoft SQL Server\80\Tools\Binn, double click on the “sqlmangr.exe”, and press Start/Continue.  Again, if it doesn’t start at first, click on “Refresh Services…”

SQL folder

And there you have it.  You have just started your SQL server running again (if it wasn’t running in the first place).  That concludes this weeks edition of Tech Support Thursday.  Have a good weekend, a Happy Friday the 13th, and we’ll see you next week! 

Categories
Show Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Follow us on Facebook
Follow us on Twitter
Check out our videos
Join us on LinkedIn