Showing posts with label howto. Show all posts
Showing posts with label howto. Show all posts

Tuesday, March 7, 2023

BlueScreen Error

Your laptop/PC has encountered a blue screen error. A blue screen error, also known as a "blue screen of death" (BSOD), can occur for a variety of reasons, such as hardware or software issues. Here are some steps you can try to troubleshoot and fix the issue:


Restart your laptop: Sometimes a blue screen error can occur due to temporary issues. Try restarting your laptop and see if the problem persists.


Check for any recently installed software or hardware: If you recently installed any software or hardware, it could be causing the issue. Try uninstalling any recently installed software or removing any recently installed hardware to see if the problem is resolved.


Check for any driver issues: Outdated or corrupt drivers can also cause blue screen errors. You can check for any driver issues by going to the Device Manager and checking for any devices with a yellow exclamation mark next to them. If you find any, try updating the drivers for those devices.


Run a virus scan: Malware or viruses can also cause blue screen errors. Run a virus scan using your preferred antivirus software to check for any malware.


Check for any hardware issues: Faulty hardware, such as a failing hard drive or faulty RAM, can cause blue screen errors. You can run hardware diagnostics to check for any hardware issues.


If none of these steps work, you may need to seek help from a professional computer repair service or the manufacturer of your laptop.






Allow MSSQL server to be accessed from a network | How To

 To allow MSSQL server to be accessed from a network, you need to perform the following steps:


Enable TCP/IP protocol on your MSSQL server:

Open SQL Server Configuration Manager

Expand SQL Server Network Configuration

Select "Protocols for MSSQLSERVER"

Right-click on "TCP/IP" and select "Enable"

Restart the MSSQL service for changes to take effect

Configure the Windows Firewall to allow incoming traffic on MSSQL port:


Open Windows Firewall with Advanced Security

Click on "Inbound Rules"

Click on "New Rule"

Select "Port" and click "Next"

Select "TCP" and enter the MSSQL port number (default is 1433)

Select "Allow the connection" and click "Next"

Select the appropriate network profile and click "Next"

Enter a name for the new rule and click "Finish"

Enable SQL Server Authentication:


Open SQL Server Management Studio

Right-click on the server instance and select "Properties"

Select "Security"

Under "Server Authentication", select "SQL Server and Windows Authentication mode"

Click "OK"

Create a login account for remote connections:


In SQL Server Management Studio, expand "Security"

Right-click on "Logins" and select "New Login"

Enter the login name and password for the new account

Under "Server Roles", select "sysadmin"

Click "OK"

After completing these steps, your MSSQL server should be accessible from other computers on the network using SQL Server Management Studio or other MSSQL client tools.


#MSSQL

#howto

#microsoft

#follow365