Home » Penelusuran Microsoft SQL Server

Microsoft SQL Server sa login locked out: how to unlock/enable sa login?

Microsoft SQL Server sa login locked out error message 2

Issue: Microsoft SQL Server 'sa' login locked out
So, today, I got myself locked out of Microsoft SQL Server after entering the wrong password multiple times. If suppose “sa” login account is locked out, the above message will be displayed-

How to enable “sa” login account locked out by Microsoft SQL Server?
Read more »

[Resolved] Visual Studio Connect to Microsoft SQL Server Database Failed - A network-related or instance-specific error occurred

Visual Studio Tools Connect to Database
Issue: Visual Studio Connect to Microsoft SQL Server Database Failed - A network-related or instance-specific error occurred
Error Message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)
Description: When attempting to connect to a database from Visual Studio, if you are getting a message from Visual Studio Data Connection that it was not able to connect to SQL Server, check the following workaround.

Read more »

SQL Server 2008 Installation Error - Reporting Service Catalog Database File Existence

SQL Server 2008 Installation Error - Reporting Service Catalog Database File Existence 1
Figure 1: SQL Server 2008 Installation Error - Reporting Service Catalog Database File Existence
So today, I tried to install Microsoft SQL Server 2008 on the same machine and using the same default instance name and I encountered the error saying that the Reporting Server catalog database file already exists.  I finally got this resolved. If you also face a similar issue during installation of Microsoft SQL Server, try the steps below. This error occurs if we use the same instance name for the SQL Server 2008 installation. The following error messages may be displayed: 

ERROR:
  • The catalog database file exists. Select a files-only mode installation.
  • The catalog temporary database file exists. Select a files-only mode installation.
See Figure 1 above.
CAUSE:
This issue occurs because the databases for the SQL Server 2008 Reporting Services instance that you want to install already exist on the computer.
RESOLUTION:
Read more »

How to fix: Error 2502 and 2503 encountered when installing/uninstalling software on Windows

If you encounter Error 2503 and 2502 when installing/uninstalling software on Windows, then try the following steps. The error message would be something like:
  • The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2503.
  • The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2502.

Read more »
Back To Top