Logout problem

xylo · June 1st, 2005, 04:58 PM

I'm using C# + ASP.NET + SQL SERVER 2005

In my testing application I just open and close immediately connection to database doing it in that way

Code:

SqlConnection cn= new SqlConnection("server=(local);uid=agent1;pwd="+passwd+";database=CRM");    
cn.Open();
cn.Close();

Next I try execute in query analyzer:

Code:

 EXEC sp_dropuser 'agent1'

and that cause exception :

Code:

Could not drop login 'agent1' as the user is currently logged in. (Microsoft SQL Server, Error: 15434)

Next I execute query

Code:

select * from dbo.sysprocesses

and there is still record with atributte 'loginame' equal to 'agent1'

What am I doing wrong !?

Thanks for every advice in advance...

ashokparchuri · July 8th, 2005, 05:44 AM

hi,

   May i know how many users exists in your database..?

   the two steps are correct when u give cn.close the connection should be closed and the user will be logged out.

   i fell that u may be logged in as user agent1...make it sure...

hope this helps-Ashok Parchuri