Category: Windows

How to Enable Remote Connections to MSSQL Server

This post shows step by step on how to enable remote connections to a sql server by configuring ports and firewalls , etc.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Install SQL Server 2019 on Windows Server 2019 VM of VirtualBox

After Windows server 2019 Oracle VirtualBox VM has been created as per How to Install Windows Server 2019 on Oracle VirtualBox,  now it is time to install SQL server 2019.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Install Windows Server 2019 on Oracle VirtualBox

This post illustrates step by step on how to build a Windows Server 2019 evaluation VM server on Oracle VirtualBox, also screenshots are provided for every step in details.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

To log in, press the host key plus the Delete key to simulate the CTRL + ALT + DELETE key combination. The host key is the right-CTRL key by default.

Failover Cluster: Event ID 1257 Every 15 Minutes

For a newly created cluster,  there are many Event ID 1257 cluster events shown on Failover Cluster Manager.

Cluster network name resource failed registration of one or more associated
 DNS name(s) because the access to update the secure DNS zone was denied.

cluster Network name: 'Cluster Name'
DNS Zone: 'DNS Zone'

Ensure that cluster name object (CNO) is granted permissions to Secure 
DNS Zone.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

SQL Database Volume Full due to Volume Shadow Copy Service (VSS)

One data volume with data files is full, but the database whole size is relatively small.  Finally it is because of Volume Shadow Copy Service (VSS),

To check VSS configuration and how much disk space used by VSS :

Disk Management –> Right Click C: Drive, then Properties –>Shadow Copies –> Settings.