Can I force a SIMS user off SQL ? Was going to do maintenance work :(

[MrWu]

Hi

 

As per usual staff don't log off SIMS even after prompting, so I'm home just about to run re indexing on SIMS DB when one solitary user I cannot remotely control her PC either via Impero or trying to shut the damn thing down remotely through command line

 

Is there any commands I can run through to force her off SIMS / SQL end?

 

Thanks guys, if anybody knows today it will be a life saver!

[vikpaw]

Why don’t the remote commands work? Can you try from the server? You could try to remotely stop the services. Process Kill or such like. There’s not much with regards to the server side. You can remove permissions to the SIMS share, where the connect.ini and other files are, then reboot to break the connection, this should stop the reconnection I think. That’s probably the best bet.

[MrWu]

Thanks,

 

turns out the PC was probably chugging along and my remote shutdown command took 5 minutes to invoke

 

Now should I run the reindexing first or figure out how to install 4 x SIMS Parent Lite app patches lol

 

Although it says on the instructions its for SIMS Parent Full ,and not run those licence patches .. mm thats another story!

[Ma2]

Reindexing can take a while. Get the patches done then leave the reindexing running.

[dapaulio]

You can disable the TCPIP pipe off in SQL configuration manager essentially putting the database in exclusive standalone mode. you can access it from the server but not from any network computer. after the reindex enable it again and your users will be able to log in.

[ass17]

For MS SQL Server 2012 and above

 

USE [master];

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE database_id  = db_id('MyDB')

EXEC(@kill);

 

For MS SQL Server 2000, 2005, 2008

 

USE master;

DECLARE @kill varchar(8000); SET @kill = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'  
FROM master..sysprocesses  
WHERE dbid = db_id('MyDB')

EXEC(@kill); 

 

Replacing ‘MyDB’ with the name of the database you wish to drop connections to.