Avatar of westone
westoneFlag for United States of America asked on

SQL Express database login

Hi,
I have SQL Server Express 2005 SP2 running on an XP Pro machine. There is an instance running that was created by the installation of some demo software provided by one of our vendors (it is a demo of an upgrade of software we currently own). The vendor stated that we could install the demo and connect multiple users to it over our LAN.

Using Management Studio Express, I connected to the demo instance and set it to allow both Windows authentication and SQL Server Authentication. I then created a login (for the system) set to use SQL Server Authentication. I am now able to connect to the instance use SQL authentication.

Next I created a user for a database in the instance, setting it to use SQL authentication as well. But I cannot open the database using those credentials. I get the message "Unable to connect to server. Error:Login failed foe user 'sa'."

What am I missing here?
Thanks, Bill
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
westone

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rahul Goel

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
westone

Thanks for the suggestion, unfortunately it did not resolve the issue. I am wondering why the error message states "failed for user 'sa'" when I am trying to login with different credentials.
ASKER
westone

I just discovered that I can login as "ADMIN" with a password I set during installation of the demo software, yet there is no User or Login with the login name of ADMIN in any of the databases or SQL Server instances that are available in Management Studio Express. This has me wondering if I am seeing everything that is going on with the SQL instance in MSE.

Just for the record, I am connecting to the SQL instance that was created during the installation of the demo software. I can create users that use Windows Authentication and successfully connect to the database. When I create users or logins that use SQL Authentication, they cannot connect.
Your help has saved me hundreds of hours of internet surfing.
fblack61