.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

"Call to SQLExecDirect failed with %1"

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
Cross post from Windows Server 2008 Forums (MSFT Suggestion).  Original Post:

I am trying to set up Perfmon to log directly to a SQL 2008 Server (trying to avoid binary file + relog).  The SQL server is running locally on the same server I am trying to record perf counters from.  Note that I am NOT using SQL 2008's data collection features, and I am trying to log non-sql related counters.

I set up a SQL 2008 Native Client System DSN with Windows Authentication, but when I try and start my data collecter set I get an error message  that "Call to SQLExecDirect failed with %1", and the in event viewer I get "Call to SQLExecDirect failed with .".  The set is running as System, which has rights to the database.  SQL does not log any errors or a failed logon attempt.

The ODBC DNS 'Test' button says it connected successfully, and I am able to connect to the same database via Management Studio and ASP.Net.  I don't think its a SQL problem, but its hard to say when the error message is blank.

Any help fixing this, or ruling out SQL as the problem, would be appreciated.

View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend