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?