Log in to server failed

(1) Share

Report

Posted on by tborklund

I was having issues with one of my employees computers not being able to log into GP due to the security program. I've changed/deleted that program and now am get the message: "Your attempt to log in to the server failed because an unknown error occurred when the user ID and password were being verified. Attempt to log in again."

I have tried everything I can think of on how to fix this and nothing is working. Any help would be appreciated. Thanks!

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Log in to server failed

Can you log in as 'sa' on this computer? Can you log in as this user into GP on another computer? Can you log into GP as 'sa' and delete this user and recreate this user?

Was this reply helpful? Yes No
tborklund 85 on at

Like (0)

Report

RE: Log in to server failed

I can log on to the computer as "sa"and log in to GP as "sa" another computers but not this one.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Log in to server failed

OK, so you can log onto this computer as 'sa' but not as any other user? That mean we have a password hashing issue. What version of SQL on the server are you using? What version of the SQL client on the workstation are you using? Make sure the version of the SQL client matches what the SQL version on the server requires.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Log in to server failed

Hi, make sure you have same ODBC when you created password and when you want to login.

Example, when you created a password using odbc (computer name), you must using odbc (computer name) too to login. if you are using odbc (ip) to login, you will got an error.

Regards,

Kurniawan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Log in to server failed

I had this same issue but once I rebooted my computer it stopped.

Was this reply helpful? Yes No
Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report

RE: Log in to server failed

Kurniawan Hiu is absolutely correct about this one. If you want to be 100% sure you can reset the user password using their GP client and the sa account. They will then be able to login to GP using that client but not others.

Regards,

Kirk

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Log in to server failed

Hello, I know it is outdated topic, but I am having the same issue: one of my uses getting "Your attempt to log in to the server failed because an unknown error occurred when the user ID and password were being verified. Attempt to log in again." I do not getting it when people talking about IP vs naming convention. Any help will be appreciated. Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Log in to server failed

Try going to All Programs > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager >SQL Server services - and make sure they are running. I had this error last week and SQL Server Agent (MSSQLSERVER) was not running - the error went away after I restarted that. Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Log in to server failed

Thank you Diane. This is not a my case. All my users are running GP just fine except one machine. By machine I mean the same user can logon using her GP credentials on the other computer with no problem. I believe Kurniawan and Kirk is talking about using IP vs named server when you set up ODBC, but when you installing GP it will auto generate ODBC on the client machine. But I could be mistaken.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Log in to server failed

Got it working. Rebuilding DEX_LOCK and DEX_SESSION in tempdb did a trick. Thank you

Was this reply helpful? Yes No