Hello, I have a problem connecting to the database. I get an error.
But if delete a user name “sa” that turns a normal connection.
But if I connect to the database through another terminal then this trick no longer works, and writes an error:
Login failed for user ‘Guest’
emre
September 23, 2015, 2:43pm
2
So it says “password for sa user is incorrect”. You need to know password for sa user to be able to connect from terminals. You’ve set password for sa user while setting up sql server. If you didn’t do so check step-3 and step-4 on this documentation.
This was written by @pauln I am just moving it here so it can help other people.
Just in case you are still finding issues I will add the process I used as it highlights all the hotspots where roadblocks can occur. As a “freshman” I had to burn the midnight oil with this as well!
Platforms
Windows 8.1 - fully updated, Workgroups
PC1 - Server ASUS I7 3ghz 16G Ram 27" Touch
PC2 - Laptop ASUS I7 2ghc 4G Ram 15.4 Touch
Check 1 - Services
After install SQL Exp 14 as per tutorials …
3 Likes
Jesse
September 23, 2015, 2:45pm
3
Looks like your using Windows authentication for SQL server. Use MSSMS and change it to mixed mode then enable the sa user and set a password.
Bah Emre your too fast today
3 Likes