Home > Sql Server > Hy000 Error 0

Hy000 Error 0

Contents

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! You cannot upload attachments. Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact All Rights Reserved. news

We've restricted the ability to create new threads on these forums. And you can't just use the same login/pwd for SQL Authentication. People who like this Close 0 Comment 10 |3000 characters needed characters left characters exceeded Viewable by all users Viewable by moderators Viewable by moderators and the original poster Viewable this is informing you that you cannot have multiple active queries running on one connection. http://www.sqlservercentral.com/Forums/Topic654688-146-1.aspx

Sqlstate Hy000 Sql Server Error 0

Report Abuse. Feedback Please tell us how we can make this article more useful. Anonymous Sign in Create Ask a question Spaces API Connect Appsecdev BPM Blockchain Bluemix CICS Cloud Analytics Cloud marketplace Content Services (ECM) Continuous Testing Courses DB2 LUW DataPower Decision Optimization DevOps

Privacy statement  © 2016 Microsoft. Thanks for the reply. Thanks so much guys! Connection Failed Sqlstate Hy000 Sql Server Error 0 You cannot post topic replies.

You cannot post IFCode. Odbc Sql Server Driver Cannot Generate Sspi Context The weird thing is, it does show many other SQL servers on their network... Navigation Subscribe: RSS Home About Resources Archives Contact You are here: Home › Technology › [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context by Leo Chat with Support Chat with our experienced staff to receive help right away.

You cannot post replies to polls. Hy000 Odbc Error You cannot delete other events. You cannot edit other topics. Tell them to add a SQL account on the database server and provide the password to you.

Odbc Sql Server Driver Cannot Generate Sspi Context

Tags Spaces API Connect Appsecdev BPM Blockchain Bluemix CICS Cloud Analytics Cloud marketplace Content Services (ECM) Continuous Testing Courses DB2 LUW DataPower Decision Optimization DevOps Services Digital Experience Hadoop IBM Design https://support.microsoft.com/en-us/kb/2465092 All Forums General SQL Server Forums New to SQL Server Programming Access sql server over network but not in domain Reply to Topic Printer Friendly Author Topic prosh0t Starting Member Sqlstate Hy000 Sql Server Error 0 Privacy Policy Safe Harbor Terms of Use Acceptable Use Policy Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag Sqlstate Hy000 Cannot Generate Sspi Context All rights reserved. {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps All apps Windows apps Windows phone

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Why may I get the SQL server error: "HY000 (0):[Microsoft][ODBC sql server Driver] connection is busy with results for other hstmt ". The time on the client, the SQL Server and the domain controller are all the same; likewise the SQL Service account has permission to read and write the Server Principal Name It is important to note that I am using the 32 bit connection manager to set my ODBC data sources. (c:\windows\sysWOW64\odbcad32.exe) to avoid conflict between a 64bit DSN and my 32 Sql State Hy000 Error Code 0

After disabling this option he was able to connect without any problems. When using SQL Authentication the connection works, however the application that uses the ODBC connection requires Windows Authentication to be used. All suggestions, solutions, advice and opinions come as-is with no warranty or responsibility implied. You cannot vote within polls.

Monday, May 16, 2011 12:36 PM Reply | Quote Answers 1 Sign in to vote I seem to have resolved my own query. Cannot Generate Sspi Context Sql Server 2008 R2 You cannot delete other posts. You cannot edit your own topics.

You may read topics.

I know that the name and password I specify work because when I'm remote desktopped in to a machine on the domain with that same name and password, I am able You cannot delete your own topics. You cannot post HTML code. Cannot Generate Sspi Context Sql 2012 I've also checked and double checked the DNS servers and flushed the cache, just to be sure.

I can now confirm that this was an issue with the domain recognising the user I was logged in as. I'm at a client location plugged into their network, but when I log into my laptop I'm not logging into their domain. Each time he attempted to connect to the database he received the error message: ------------------ Microsoft SQL Server Login ------------------ Connection failed: SQLState: ‘HY000' SQL Server Error: 0 [Microsoft][ODBC SQL Server Many thanks in advance for any help or suggestions that can be provided.

keyword2 keyword1 +keyword2 Questions excluding a word, e.g. IBM developerWorks/ Developer Centers Sign in / Register 127.0.0.1 dW Answers Search Search tips Refine your search by using the following advanced search options. I have 3 SQL Servers all on the same domain and all accessed from a number of desktops running Windows XP or Windows 7, the client I am working on gets You cannot edit HTML code.

cool quotes by the way.I did that using 'windows nt authentication' and got an error:Connection failed:SQLState: 'HY000'SQL Server Error: 0[Microsoft][ODCB SQL Server Driver]'Cannot generate SSPI context'when I try to use SQL You cannot send emails. Join group Get this RSS feed Home Forum Blog Wikis Files Members Table of Contents Knowledge Base Silk Performer 9.5 reports WebPageForm(WebEngine: 100 - Uncompressing content failed., internal error-code: -3) '0'