Tags
#mssql
SQL Server "Cannot open database requested by the login" (error 4060): what to check
Fix SQL Server error 4060 "Cannot open database requested by the login": check the database name and state, map the login to a user, and fix logins after a restore.
Beginner · 3 min read
SQL Server "The transaction log for database is full" (error 9002): read log_reuse_wait_desc
Fix SQL Server error 9002 "The transaction log for database is full": read log_reuse_wait_desc, back up the log or end the old transaction, and size the log properly.
Intermediate · 4 min read
SQL Server "Login failed for user" (error 18456): the state tells you why
Fix SQL Server error 18456 "Login failed for user": find the real reason in the log by its state, then fix the password, mixed mode, a disabled login or the database.
Beginner · 5 min read
SQL Server "A network-related or instance-specific error" (error 40, error 26): how to fix it
Fix SQL Server "A network-related or instance-specific error occurred": check the service, TCP/IP, the instance name, SQL Browser, port 1433 and the Windows firewall.
Intermediate · 4 min read