Cannot login to SQL 2008 Express SP3 remotely - Error 1326 - Incorrect user/pass
-
0
down vote
favorite
I have a problem trying to connect to SQL Server 2008 SP3. It's really strange, I have looked everywhere for an answer and couldn't find anyone experiencing the same problems. I'll try to explain.
I can connect to my server locally, both using Windows login and SQL Server Authentication, but when I try to connect remotely, I get error 1326 and an error message specifying "Incorrect username or password". Then I login locally to SQL, but the error log doesn't show up anything. Yesterday, it showed the login errors, but now it's not showing up anymore. It's like it's trying to connect to another instance of SQL, though I checked by doing "SELECT @@VERSION" and running "osql -L" from the command line, and both of them show just one server instance running.
What's even more strange, I just tried stopping the SQL Server service and logging in again. It still shows the same error: 1326 - Incorrect username or password. It should have told me that the server cannot be found or something like that. How does it show incorrect user or pass when the server is offline?
Any kind of help would be greatly appreciated. Thank you very much in advance.
-
DNS redirects? Ask your network admin for help, it does sound like the connection's going to a different instance somewhere.
Also, check you haven't made a spelling mistake in the server name.
What are you using as a server name, for that matter?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
I don't think there are any DNS redirects. This is a new computer and I'm the first one to install SQL and configure it.
Besides, right now it's not showing anything in the error log, but yesterday it did show login failures when I tried connecting. The reason was "Unable to open the explicitly specified database" (default database was master and I had the necessary rights).
I use a no-ip hostname to connect, namely mycompany.ddns.net. But when I try doing it with IP directly, it still does the very same thing. It's really strange that it shows incorrect username/password when the server is offline. I'd think it's bogus info, but yesterday the problem was indeed a login problem. I don't know what else to try or think...
-
diego_vizia (6/24/2016)
It's really strange that it shows incorrect username/password when the server is offline.That's why I think you're connecting to something other than what you expect.
This is what I get when the instance is not running
and this is what I get with incorrect login details
I don't think there are any DNS redirects. This is a new computer and I'm the first one to install SQL and configure it.
Which is kinda irrelevant, since I'm talking about a redirection in Active Directory. Hence ask your network admin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply