Browsed by
Month: August 2023

How to Enable Remote Connections in SQL Server 2014/2012/2008

How to Enable Remote Connections in SQL Server 2014/2012/2008

When you try to connect to a SQL Server instance from a remote computer, you might receive the following error message: Cannot connect to SQL Server.An error has occurred while establishing a connection to the server. When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server) After installing SQL Server,…

Read More Read More

Difference Between SQL Server Logins and Database Users

Difference Between SQL Server Logins and Database Users

Although the words logins and users are often used interchangeably, they are very different things in Microsoft SQL Server. There has always been confusion over logins and users, especially for most new SQL Server users. Here I’ll explain the difference between SQL Server logins and database users. Part 1: Logins vs. Users Logins are created at the server level, while users are created at the database level. In other words, a login allows you to connect to the SQL Server…

Read More Read More

Disable Hardware Graphic Acceleration for Office 2019 / 2016 / 2013

Disable Hardware Graphic Acceleration for Office 2019 / 2016 / 2013

Starting with Microsoft Office 2013, hardware graphics acceleration is enabled by default, which moves all graphics and text rendering from CPU to GPU (a chip on your graphics card) for getting better performance, but it may also increase the burden on the graphic card. If you experienced crash, slowness, blurred text and cursor hanging when running Office, turning off hardware graphics acceleration should solve the problem. Here are 2 ways to disable hardware graphics acceleration in Office 2019 / 2016…

Read More Read More