Casey

Have you sorted the issue out by this morning?

You need to confirm the Admin ID in the database.

The Admin is either going to be

select * from users where user_logon ='Admin'

or can be identified by their rights.

select * from users where user_per_admin =3

Once you have done that you need to go through the entries of the user checking their logon details.

It may be that your Admin user has a password. This will be encrypted in the database. e.g.

User_logon : Admin

User_password: ^ACOABICKODIPJANBBLOGEHODDHGGFOGHPJCEDIBH

If this is the case then you will not be able to guess it, if you don't know it.

But you can set the password to null.

update users

set user_password = null

where user_logon = 'Admin'

You should then be able to logon.

Jeff:

I am now getting the following error:

Incorrect UserID or Password.

Please try again

Log On Again

Note: We have made no changes to 'ADMIN' User and / or 'default' Password

Please help!

Thanks, CB

Thanks for your help, Jeff. I really appreciate it! Signed, CB

You should be able to download the Management Studio from the Microsoft Web Site. If you can't find that or you wish to use an alternative then you could also use a 3rd party like 'Toad'.

I could find SQL Server Management Studio for my version of MS SQL Server 2008, or MS SQL Server 2008 R2.

How do I go about configuring that workaround?

And yes, for Partners that needed those demo data, this is bad design or design flaw. Please do improve on it, many thanks.