Re: "System.InvalidCastException: Specified cast is not valid." during connection.open

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 10:06:45 GMT

Hi Roy,

I'm puzzled at this, too.

Please try to check this with SQL profiler to see what's actually wrong
with the SQL server. Profiler can expose the operations on server to us.
Here are the steps:

1. Open SQL Profiler from the Start menu.
2. Create a new trace. Make sure that the login events have been selected.
3. Run the trace.
4. Try to reproduce the problem.
5. Check the trace log to see what's happening on server.

HTH. If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: Access Linked server generates (Error 7399 / 7312)
    ... i'll try to trace the problem if it occuurs again. ... > I was thinking of SQL Profiler, which requires a sysadmin on the SQL ... > reproduce the problem. ... >>think SP on my actual server is SP1. ...
    (microsoft.public.data.oledb)
  • RE: SQL Profiler wont allow a developer to login
    ... Sure enough when I tried to connect to the SQL ... server using Management Studio I got the expected "Invalid Login". ... Your developers could not load SQL Profiler although you had assigned ALTER ... Did you mean that you assign ALTER TRACE permission to the Active Directory ...
    (microsoft.public.sqlserver.tools)
  • Re: Access Linked server generates (Error 7399 / 7312)
    ... I was thinking of SQL Profiler, which requires a sysadmin on the SQL ... Server box to set up and configure. ... If you could create a trace on ... >>>I restarted the jobs when the problem occured, ...
    (microsoft.public.data.oledb)
  • Re: Problems launching DTS package from Stored Procedure
    ... Not too suprising as I think teh problem is with file permissions to the ... I'm not very skilled with the sql profiler ... >>>>Audit Logout ... I cannot run enterprise manager on our server because it is not ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Debugging
    ... > to get the actual command that is sent to the server. ... Sql Profiler is a tool that gets installed alongwith Sql Server - not a part ... - Sahil Malik ...
    (microsoft.public.dotnet.languages.csharp)