Go to cannot open database susdb requested by the login page via official link below
Login using your username and password. Login screen appears upon successful login
If you still can't access cannot open database susdb requested by the login then see Troublshooting options or contact us for help.
The error log indicates that WSUS is unable to open and connect to DB. (internal DB) Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.~~ After some research this issue started when latest updates where installed.
Cannot open database "SUSDB" requested by the login. The login failed -- WTF this sucks.. I deleted everything and started over and now I cannot get to the SUSDB and Authenticate … I have added the user that was failing.. how do I know what DATABASE SCCM is pointing too.. · It sounds like you are using WID database (Windows Internal Database). As you ...
1. Event ID 421 - Windows Server Update - Connection to the database failed. Reason=Cannot open database "SUSDB" requested by login.
WSUSCtrl.log on the new remote SUP/WSUS box was thankfully giving me more juice: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'DOMAIN\SERVER
I bet you that the database is in recovery mode or single user mode. This is normally what causes these types of errors (Cannot open database "SUSDB" requested by the login.
Reason: Failed to open the explicitly specified database. [CLIENT:
The WSUS administration console was unable to connect to the WSUS Server Database. Verify that SQL server is running on the WSUS Server. If the problem persists try restarting SQL. System.Data.SqlClient.SqlException -- Cannot open database "SUSDB" requested by the login.
Go to SQL Server >> Security >> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties In newly opened screen of Login Properties go to the "User Mapping" tab. Then on the "User Mapping" tab select the desired database - especially the database for which this error message is displayed.
Since "Login failed" might indicate that the database cannot be located I decided to copy-paste the Connection String in Visual Studio Server Explorer found by right-clicking the database and picking "Properties". So the new command was
Create an empty text file on desktop name it with a.udl extension. Once created double-click on it and you will see a GUI open up to guide you through to build the connection string. Step through it and click on test connection if successful then open the udl file up in a text editor and copy the connectionstring and paste it in your code