ODBC Error : state id : -HY000

(0) Share

Report

Posted on by eSSL

135

Error: [Miscrosoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server. State ID: HY000 SQL SERVER STANDARD 2012

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

Please check this link

dynamicsuser.net/.../miscrosoft-odbc-sql-server-driver-unspecified-error-occurred-on-sql-server.aspx

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

follow community.dynamics.com/.../98882.aspx

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I've seen this error message when the user is locked in AD.

This article describes how to troubleshoot:

support.microsoft.com/default.as ... duct=sql2k

Here is something else I came across:

The SQL Server in Q was a test server on a physically seperate LAN.

The DOM Admins had called it "SLQ1".

They later renamed it to "SQL1", but renaming an object in AD is not foolproof nor as simpel as in NT, there are lots of places where it stays the same.

I'd trawled the KB and Google, I checked NTLM settings and timezones, no joy.

The clue lay in the Windows Event Log, lots of Kerberos ticket errors, and this pointed to duplicate object names on teh LAN. Renaming the server back to "SLQ1" fixed it.

The SID was the same for SLQ1 and SQL1 thus coudl not be resolved.

To rename the object they should have dropped it from AD, renamed it, changed the SID and then added back to AD.

Was this reply helpful? Yes No
eSSL 135 on at

Like (0)

Report

I tried looking into the link support.microsoft.com/default.as ... duct=sql2k but its showing a message as :

"Oops!

The page you are looking for may have a new location, or is no longer available."

Kindly suggest me the article link once again.

Thanks in advance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you check account is locked or not in AD?

Please try other steps like as AD & SQL activities in my last post.

Was this reply helpful? Yes No
eSSL 135 on at

Like (0)

Report

We are trying the other steps also, but kindly provide us the correct link of that trouble shoot article.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you check account is locked or not in AD?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This article describes how to troubleshoot:

http://support2.microsoft.com/default.aspx?scid=kb;en-us;811889&product=sql2k

Was this reply helpful? Yes No