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 |
|
dragonsting
Starting Member
7 Posts |
 Posted - 2008-03-23 : 16:50:45
|
Hi,I am new to SQL so bare with me.Here is the issue I have:We use a program called Snow inventory which uses SQL 2000 standard.It has 2 databases "LicenseMDB" and "SNOWDB". It has 3 user accounts and uses the sa account, they all have the same password except the sa account. I made a backup of the databases deleted them and reinstalled a newer version of the Snow Software. Now it has installed 2 new databases, I restored the databases with the backup files I created.All went well, except for the fact that I can't login to the databases through the software. I changed all the passwords to same one and it still doesn't grant me access to the database. All the user accounts are stored in the database.How can I fix this in SQL?Any help is welcome,GreetzIwan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 16:54:29
|
| Run sp_helpuser in the db. If db users didn't map to any sql login, fix them with sp_change_users_login. |
 |
|
|
dragonsting
Starting Member
7 Posts |
Posted - 2008-03-23 : 19:14:43
|
quote:
Originally posted by rmiao
Run sp_helpuser in the db. If db users didn't map to any sql login, fix them with sp_change_users_login.
Like I said I am new to this so if you could tell me how to start theses commands.In 2005 you just go to the DB and type and start, but in 2000 I can't find so please help.  |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 19:45:37
|
| Run them in query analyzer. By the way, know how to read books online? |
|
|
|
dragonsting
Starting Member
7 Posts |
Posted - 2008-03-24 : 04:58:41
|
quote:
Originally posted by rmiao
Run them in query analyzer. By the way, know how to read books online?
Thank you, it worked. The connections work again. |
|
|
|
|
|
|
Backup restore blocked accounts