PC Scale Tower - SQL Server Rebuild

Posted on 2009-07-06
Medium Priority
Last Modified: 2012-05-07
I lost my SQL server a couple of weeks ago to a lightning storm.  I realized after the fact that my backups were backing up files, but no SQL Server agent to save all my SQL database/connection info.  This SQL server has only one purpose... to house the databases for an application we pull historical data from called PC Scale - Tower.  It seemed like a simple phone call to the "Tower" people to help set it back up.  Well, they are refusing to help us.

So, I have no idea how any of this was setup before and I'm having no luck making it work.  Does anyone out there use PC Scale Tower that might be able to lead me through some specific setup issues, or even provide some documentation on the SQL Server setup?  We're willing to pay for phone/remote support, but I can't find anyone to take our money.

Your help is greatly appreciated.
Question by:nwadatarecovery
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
LVL 38

Expert Comment

by:Jim P.
ID: 24788382
Can you access the disk(s) at all?

Can you access the C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL hive?

Or  do you have backups of the master and model databases as well as your data databases?

If so -- there are a number of ways to recreate your SQL databases and get close to your original setup.

Author Comment

ID: 24807148
I have the databases.  I've reinstalled SQL Server 2005 to my newly built server and attached the old databases.  It appears that my users are orphaned, so I can remove the DB_Owner user, "tower", then recreate that user but I don't know the password to assign it.  So, my application fails with a "An error occurred in the Retrieve Client Files Service: Login failed for user 'tower'." message.  It appears that the application is hard coded to access the database via user 'tower' with a password that I do not know.

Is there an easy way to recover the password from an orphaned user?
LVL 38

Expert Comment

by:Jim P.
ID: 24807968
You didn't recover the original Master DB I take it?

Do you have a copy or backup of the original master?

If you can restore it -- then it should be as before the crash.  

Or alternatively -- I have not tried this, so I won't guarantee it will work. If you can restore the master DB as something like master_temp. Then copy the sp_help_revlogin from the link below. Where it says master change it to master_temp. Then run the procedure to extract the logins.

How to transfer logins and passwords between instances of SQL Server
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.


Author Comment

ID: 24808286
I'm sorry, let me explain better/differently... My server's C: drive died, but all of my SQL databases were on the D: drive in a safe place.  I fired up a new C: drive and installed Win2k3 Server, then Backup Exec, then restored my backups from the previous day.  Backup exec 9.1 was set to backup everything on the C: drive, but did not have any SQL Agents or "system state" options.  So, I restore the entire C: drive and see that my SQL Server did not fix itself after the file recovery.  I then installed SQL 2005 and reattached the databases from my D: drive.  That directory on my D: drive still has the "master" and the "model" databases in it along with all the others, but it appears that my most important user, "tower", cannot connect to the database "COMPANYDATA" because ???  I was told by someone better with SQL than I that the users were orphaned.  Does this make any sense?

I'm wodering too... if I installed Win2k3, then SQL 2005, then backup exec and did the recovery if I would get a different result.  
LVL 38

Accepted Solution

Jim P. earned 2000 total points
ID: 24808549
There are two levels of user ids in SQL Server

There is the Login -- which is at the general level of SQL Server. Information about the login, including passwords, is stored in the master database in the sysxlogins table.

Then there is a User which is tied to the individual databases. They are both keyed off a SID (Security IDentifier) that has to match from the master to the individual database.

In SQL 2000 you could reconnect the two easily. In this case, because you don't know the password, you have to recover the login. You can either delete the login and user and totally re-install the Tower app to have recreate the login. In that case it would probably have to detach the db, have it recreate the database. After the new tower user and db were in place, detach the new blank db, re-attach the old and then you could drop the user from the old DB and reassign the login back to the old DB.

But if you have the original master from before the reinstall -- you can use that to get back to where you were. Or in this case the sp_help_revlogin will pull out the original list of logins, their SID and the original password in a hashed value. That way you can cut down on some steps.

Considerations for Backing Up and Restoring System Databases
LVL 38

Expert Comment

by:Jim P.
ID: 24992556
If the user doesn't respond -- I would say delete -- no refund.

It would have been nice to see if my suggestions would have worked, but to have this lying around in an "un-proven" state -- not a good thing.

Author Closing Comment

ID: 31600309
You provided some very good information and links to some good resources.  I was not able to get my SQL server back to a running state with this information, but helped me determine that I do not have all appropriate pieces to put this puzzle back together.  Thank you.
LVL 38

Expert Comment

by:Jim P.
ID: 24995995
I'm sorry that you couldn't get it back to its original state. Thanks for letting us know.

May all your days get brighter and brighter.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally published Entrepreneur.com Booming numbers of freelancing professionals are changing the face of work. In the United States alone last year, the number of workers freelancing grew from 700,000 to 54 million, according to a Freelancers’…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…
Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question