How to make MSSQL Offline

Open up MSSQL Management Studio

Then Select Database -> your Database -> right click -> Task -> Take Offline.

If the database does not make offline then you can do the following

ALTER DATABASE <dbname> SET OFFLINE WITH ROLLBACK IMMEDIATE

If this is not working then use the following to find spid

USE master SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID('MyDB')

or

EXEC sp_who2

then use

kill spidNumber

To force disconnections, use

ROLLBACK IMMEDIATE USE master ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Advertisements

How to fix [DBNETLIB]ConnectionOpen (SECDoClientHandshake()) SSL Security error CODE 80004005

I have recently have this issue on SQL Server 2012 with Windows Server 2012 R2.

The error was displayed one using OLE DP Provider in the VB script connection strings.
After looking at various google post explaining this issue nothing has worked.

To confirm the server is PCI DSS compliant and TLS 1.0 < and SSL are disabled.

I have changed the connection string from

‘connstring = “Provider=SQLOLEDB.1;

to

connstring = “Provider=SQLNCLI11;

this is to use native SQL Client Drivers to connect.

This has worked and no more issues the script complained.

Some background:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50131

Connection Strings for SQL Server 2012

https://www.connectionstrings.com/sql-server-2012/

https://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/