Help Please...Users Passwords Lost

Jan 15, 2008

Hello, there this is my first post and Iīm desperate seeking for help, I have almost not knowledge of SQL as it is not my usual work.

However, suddenly it has converted in mine....Hopefully I will got help in here.

Well the issue is that our database manager has resigned suddenly and before doing it he has changed the passwords of all the users in

our database of a monitoring web application. So all our users have no access now to the application. After many tryouts I finally got

access to the database and to the users table. However I have the issue that the passwords looks as below showed and I donīt know what

the real password is.

I have tried to decrypt using web decrypting pages as it looks like normal base64 strings, but it returns weird stuff. Also as I donīt

know the real encryption used I canīt change to a know string. So if some could help me getting how it was encrypted or better to find

out the real passwords it will be truly appreciated. If it is needed more info please tell me so I can send it to you, or if you need the

database itself I can send you a backup.

Best Regards to everyone.

Quote:
NumberUSERNAMEPassword
11***uFHNaI0yloE=
22***uQ7f4zrS+I8=
33***vZLMcLSYGgU=
44***X1huNktKxiE=
55***Xj7X/j7IJlY=
66***xnjJfMyiK24=
77***YcQhuzE8ZKM=
88***yPkatR/yu34=
99***Z/+ujjLnAPI=
1010***Z/+ujjLnAPI=
1111***/E4vCqpZ0HWGa5akKPfeGg==
1212***+/IkfCripBiyGKX+0BOq5Q==
1313***+wv6aVBpAdoaVOIop5k7hA==
1414***0Xn9c0+SZLfFS+jEYqBUuQ==
1515***1CvLvdtfMemipN6agFOUcw==
1616***1YVYxTctsZlar9Vv7btVTw==
1717***4PVwBey0bOkwC3NA183F5g==
1818***5thrQN8LxHNhaMr4RJz1Bg==
1919***6qk+WBaRa9+GiOdvR5pEjw==

View 2 Replies


ADVERTISEMENT

Lost Account Passwords When I Imported A Database

Feb 9, 2006

I used a DTS package to import data from one database to a new database (different servers) and it seemed to work fine with the exception that it lost all the passwords. I got one error telling me that for security reasons, it left all passwords NULL. Sure enough - they are now all blank.

Ideas - any good articles with quick fixes ???

Thanks a bunch - I am just getting into a lot of unusual problems this week.
Nancy

By the way - what happened to the SQL*Pass message boards ??? Nobody visits there now....

View 2 Replies View Related

Users And Passwords

Apr 11, 2008

How can we change the passwords of users in 2005 and in 2000

View 2 Replies View Related

How Do I Backup My Users + Passwords?

Mar 6, 2006

I can backup my logins but without passwords....using SQL 2005 , generate sql scripts...

any idea i can generate a SQL script with the passwords in cleartext?





View 4 Replies View Related

Re-attached DB Lost Users

Aug 10, 2005

If you re-attach a db to a different server, presumably you are shutting out your users (by them not having logins to the new server). If you are moving to a different domain I can only think that having the sa pwd and switching to "Mixed Authentication" would be the only way to get back in to start adding new logins/users, is that correct?

View 2 Replies View Related

Db Restore Lost All The Users.

May 18, 2007

i restored a database from a .bak file.
from production to development.



But i dropped the database from development before restoring. Now all the users are gone from this database. Anyone know how to recover them?

the users from development are different from production's

View 14 Replies View Related

SQL 2005 Passwords, Can It Be Configured To Accept Case-insensitive Passwords???

Jul 7, 2006

Users were able tolog on to our SQL 2000 servers with their passwords being case-insensitive.

Now with SQL 2005 some users can't logon because SQL 2005 passwords are case-sensitive.

Can SQL 2005 be configured so that passwords are NOT case sensitive???

Thanks!

View 6 Replies View Related

Reporting Services :: Adding (new) Child Domain Users To SSRS As System Users?

Jul 28, 2015

We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.

I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.

Is there any additional step I should/could take to get this active?

View 5 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!

View 6 Replies View Related

SQL Security :: Did Not Create Any New Users And There Are No Other Users Listed In Accounts Section

Sep 28, 2015

I am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.

View 2 Replies View Related

Stored Procedure To Get All Users Or All Users Of A Specific Country

Apr 30, 2008

hi alli've got two tables called "webusers" (id, name, fk_country) and "countries" (id, name)
at the meantime, i've a search-page where i can fill a form to search users. in the dropdown to select the country i included an option which is called "all countries".
now the problem is: how can i make a stored procedure that makes a restriction to the fk_country depending on the submitted fk_country parameter?it should be something like
SELECT * FROM webusers(if @fk_country > 0, which is the value for "all countries"){    WHERE fk_country = @fk_country}
who has an idea how to solve this problem?

View 9 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

View 1 Replies View Related

Passwords

Feb 5, 1999

Is there a way I can enable my end users to change
their own passwords within SQL 6.5 every 30 days to
something unique?

Currently, I don't see that they have the option to change
it anywhere.
Any thoughts?
Thanks!
Toni

View 1 Replies View Related

Passwords In SQL 6.5

Mar 24, 1999

I have to create some type of an sp that will force users to change
their passwords every 30 days. It sounds like I should be able to
create a simple table with the login and the password expiration date.
Then, I should create some type of function to check the expiration, get
the new password and run sp_password. Has anyone done this before?
Where would this table be created? In Master? Would that also be where
I should create this sp? Should this be an xp?

I'm fairly light on creating sp's. Can anyone suggest a starting point
for me or give any suggestions?
I would appreciate any help.
Thanks!
Toni E.

View 3 Replies View Related

Sql/nt Passwords

May 28, 1999

Does some one know of a way to use windows passwords in sql w/o having to enter them in? Like a program or sql statement?
As of now, we are having to enter them in ourselves , and would like to make our jobs easier....Thanks!!

View 2 Replies View Related

Need Help With Passwords

Feb 6, 2005

hey guyz
in the database, is there anyway to chnage the password field to * instead of showing what is inside?

View 5 Replies View Related

Passwords

Sep 30, 2007

Hi

I have SQL Server 2000 and in one of the databases we store the Application passwords as a Clear text. we would like to encrypt
these passwords so that we will pass the auditing.

Can some one please suggest a good way to encrypt these passwords.

Thanks

View 12 Replies View Related

[HELP]passwords

Jan 7, 2007

for example i will set the password as chicken

http://img515.imageshack.us/my.php?image=chickenqs6.gif

then i press ok and it seems like it works i open it right away and

http://img295.imageshack.us/my.php?image=notchickenao0.gif

^^clearly not chicken......

then,ontop of that when i open the login name is a query script its some 15 character password that everytime u open in script the code changes..

http://img401.imageshack.us/my.php?image=screenhunter04jan062317zu0.gif

any help would be greatly appreciated

View 3 Replies View Related

List Users Then Disconnect Users

Jun 4, 2008

I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.

can this be done in SQL and if so how?

View 1 Replies View Related

Users Get Blocked By Other Users Alot

Sep 26, 2007

We are using Navision with SQL server 2003.

What kind of methods is there out there to reduce hwo often this happens?

View 10 Replies View Related

PGP Files And Passwords

May 2, 2001

I have a pgp file requiring a password that is emailed to me. Is it possible to set up a DTS package that will open the file (using the password), and insert the data into a table, file, etc.
TB

View 1 Replies View Related

User Passwords

Oct 8, 2001

Hello,

Is there a way to pull user id's and passwords from a database?

TIA,
Anita

View 3 Replies View Related

Changing Passwords

Dec 5, 2000

I have a problem where our developers would like to change the passwords of the SQL Logins without knowing the users old password.

The only way they can use the below syntax is that they must be a member of the SYSAdmin Server Role.

sp_password NULL, 'newpassword',Max

I need a way to allow them to change the passwords without making a user a member of the SYSAdmin Server Role.

Any thoughts would be greatly apprecitated. Thanks in advance.

Max

View 1 Replies View Related

Sqlserver Passwords

Dec 1, 2004

Hello all,

Is there anyway to tell in sqlserver when a users' password has been changed?

View 3 Replies View Related

User Passwords

Apr 27, 2004

Is there a way that I can prevent SQL Authenticated users from changing their passwords?

View 6 Replies View Related

Passwords For The Logins

Jun 1, 2004

Hi All,
Sql server 7

There are set of logins in sql server some are NT authentication and some are sql server authentication. How can i retrieve the passwords for both these logins.


TIA
Adil

View 1 Replies View Related

Passwords And Usernames

Mar 15, 2006

i have been reading many asp.net books

where is a good place to hold user name and password while the user is on your side in a cookie or applicaion user variable?

and if the user closes the navigator..what command removes the log in information ?

View 1 Replies View Related

Encrypting Passwords

Feb 22, 2006

A friend of my self asked me how he can save a password not as clear text. He wanted to encrypt the password and save the encrypted string in the database.

How can he do this? Maybe somebody can help me here.

Regards Markus

View 7 Replies View Related

Asking For Userid And Passwords On 28

Feb 28, 2008

I have installed Sql Server 2000 Reporting Services.
I desinged report in VS 2003.When press F5 key.Every time it is asking for user id password then only it is giving List of Report Names.

Is there any way to avoid giving user id and pwd every time.
Regards.

View 1 Replies View Related

Update Passwords Every 10days

Apr 22, 2004

I'm looking for a way to upgrade the passwords of all users in a database every 10 days.

What I have is, generating random passwords, md5 encryption etc... but still clueless about how I should update em every 10 days.

Thanks in advance

View 3 Replies View Related

Store Encrypted Passwords In SQL

Jan 14, 2005

Hello,

I have a simple .NET page that asks the user to create a new account. One of the fields on that page is 'Password'. I store the password in a SQL 2000 Database. However, it appears in the database as clear-text.

Is there a way to encrypt this so it doesn't appear as clear-text in the DB?

Thanks!
Jason

View 1 Replies View Related

Transfer Passwords Between Boxes

Nov 10, 2001

Wondering on how to script over the passwords from one 2000 box to another. We are cutting a box over from dev to production and need to copy userids and passwords from another box.

Any suggestions?

Thanks,

Steve

View 1 Replies View Related

Moving Logins And Passwords

Feb 5, 2002

Hi,
WE are moving one of our applications to oracle from sql server.For this migration is there any way I can move passwords from sql server syslogins table to oracle or extract the passwords.
thanks in advance
Mohan

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved