How to Fix cannot Open database requested by the login the login failed?
- In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
- Right-click the Security folder, point to New, and then click Login.
- On the General page, enter the name of a Windows user in the Login name box.
- Select Windows Authentication.
- Click OK.
Can not Open database requested by the login the login failed c#?
Make sure the database is highlighted in the dialog box, then, under the Database role membership for: <database>, check the db_owner role. Click OK to create the login and its role. Close SQL Server Management Studio.
Can not open database requested by the login the login failed SQL Server?
Cannot open database requested by the login. The login failed. ... This error occurs when you have configured your application with IIS, and IIS goes to SQL Server and tries to login with credentials that do not have proper permissions. This error can also occur when replication or mirroring is set up.
Can not open the database?
If you are receiving the error message “Cannot open database. It may not be a database that your application recognizes, or the file may be corrupt.”, check if the database has reached or exceeded the 2 GB limit. If so, running MS Access built-in 'compact and repair' utility may help.