September 5, 2014 at 3:03 pm
Having a weird issue, was wondering if anyone has any ideas or suggestions:
I'm working with a SQL Server database hosted at the client (It's SQL Server 2008 R2 (SP2)).
If I log into the database via my local Management Studio (after VPN'ing in), I can log in fine using my windows credentials with the client. The client then created a SQL Server login for us, but I am unable to log in with that SQL user either from my machine, another machine, or from my application code.
The error I get is 'Login failed for user '<user_name>'
I had a GoToMeeting session with the IT guy over at the client, and he demonstrated that he was able to log into the database server remotely with that user. In his error logs, he sees a State code of 8, which indicates mismatched password. However, I've tried copy pasting, and manually typing the password numerous times, and I verified the password with their IT, so I don't think that is the true reason.
I think things we can rule out:
- mismatched password
- mixed authentication mode not set (he can log in with the SQL user fine)
- incorrect server address (I log in to the server fine with Windows credentials)
Only thing different from my environment and his may be that I'm logged in via VPN.
Any help would be appreciated!
September 6, 2014 at 3:17 am
Well you access through SQL authentication also. I got an error code: 18456. After digging a bit I found the solution - SQL server error: 18456 overview - This error occurs when your authentication request is been successfully accepted by SQL Server named, but due to some reason SQL Server is not able to grant the access to connect.
Reason - This error reveals that SQL Server authentication is not enabled in local server.
To enable SQL server authentication, Follow the below steps
Step 1 - Go to SQL server properties by Right click -> Properties.
Step 2 - Enable SQL Server authentication mode.
Step 3 - Restart the SQL server.
I hope it will help
SSMS Expert
September 6, 2014 at 12:46 pm
Thanks Elliswhite.
But as I mentioned before, mixed mode authentication was enabled, and they were able to log in with the SQL user on their end, so I don't think this is the reason.
September 8, 2014 at 5:02 am
par.anthony (9/5/2014)
machine, or from my application code.The error I get is 'Login failed for user '<user_name>'
please supply the state and severity id from the error message
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2014 at 9:05 am
please supply the state and severity id from the error message
Error Number: 18456
Severity: 14
State: 1
I see state 1 from my end, but the IT person sees state 8, which indicates password mismatch. We're pretty sure it's not a password issue, we've tried copy and pasting (carefully ensuring no extra whitespaces) and manually typing the password multiple times.
Again, he's able to log in on his end with that user, while I (and others) cannot. I no longer think it is a VPN issue, as I am now on site at the client and still see the same issue.
September 9, 2014 at 9:24 am
have you checked this is not a keyboard issue. Since " and @ are reversed (amongst other chars) between english and US keyboards this can cause issues.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2014 at 9:44 am
Hmm.. good thought, but surely the copy-paste would've eliminated that issue?
We had a GoToMeeting session where he took control of input and copied and pasted the pw from his system and still no luck.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply