298 Sqlserver Error 4060 Cannot Open Database Requested In Login
Contents |
SERVER - FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE'. August 20, 2009Pinal DaveSQL, SQL Server, SQL Tips and Tricks192 commentsThis error is quite common and I have received it few times while I was working on cannot open database requested by the login. the login failed. login failed for user a recent consultation project.Cannot open database requested by the login. The login failed. Login
Cannot Open Database Requested By The Login C#
failed for user ‘NT AUTHORITY\NETWORK SERVICE'.This error occurs when you have configured your application with IIS, and IIS goes to SQL Server and
Cannot Open Database Requested By The Login. The Login Failed. Clientconnectionid
tries to login with credentials that do not have proper permissions. This error can also occur when replication or mirroring is set up.If you search online, there are many different solutions provided to solve this error, and
Cannot Open Database Requested By The Login The Login Failed Windows Authentication
many of these solutions work fine. However, I will be going over a solution that works always and is very simple.Fix/Workaround/Solution:Go to SQL Server >> Security >> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select PropertiesIn 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. On the lower screen, cannot open database requested by the login visual studio check the role db_owner. Click OK.In almost all such cases, this should fix your problem.Reference : Pinal Dave (http://blog.sqlauthority.com) Tags: SQL Error Messages, SQL Login, SQL Scripts, SQL Server Security3Related Articles SQL SERVER - A Guide to Integrating SQL Server with XML, C#, and PowerShell - Book Available for SQL Server Certification September 7, 2011Pinal Dave SQL SERVER - Enable and Disable Index Non Clustered Indexes Using T-SQL February 19, 2009Pinal Dave SQL SERVER - CASE Statement/Expression Examples and Explanation April 14, 2007Pinal Dave 192 comments. Leave new Jay May 21, 2014 7:20 pmAwesome solution, thanks a load :)Reply alireza June 28, 2014 11:52 amtank you very much . my problem solved (:Reply Muhammad Rafi July 8, 2014 12:22 pmnot working for me. Please tell me why?Reply Rajeev August 7, 2014 3:11 pmThanks, saved my dayReply G September 7, 2014 12:00 amCannot open database "mydb" requested by the login. The login failed. Login failed for user ‘GARIMA-VAIOGARIMA'Reply Liviu Dumitrascu September 9, 2014 5:52 pmHi, I have an Server connected to Iseries machine via shadow. On Iseries I do not find any error codes. On Server I get the following error:Date 9/8/2014 10:36:00 AM Log Job History (Read queue SHADOW)Step ID 1 Server SRV001 Job Name Read queue SHADOW Step Name Read queue Duration 00:00:09 Sql Severity 11 Sql Message ID 50000
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » SQLServer Error: 4060, Cannot open database SQLServer Error: java.sql.sqlexception cannot open database requested by the login. the login failed 4060, Cannot open database Rate Topic Display Mode Topic Options Author Message branovukbranovuk Posted cannot open database requested by the login entity framework Friday, March 13, 2009 1:35 PM Valued Member Group: General Forum Members Last Login: Friday, May 30, 2014 9:03 AM Points: 68, cannot open database requested by the login. the login failed. localdb Visits: 307 Strange behavior:[298] SQLServer Error: 4060, Cannot open database "TestDB" requested by the login. The login failed. [SQLSTATE 42000][298] SQLServer Error: 18456, Login failed for user 'DOMAIN\Administrator'. [SQLSTATE 28000]The problem is: I deleted that TestDB http://blog.sqlauthority.com/2009/08/20/sql-server-fix-error-cannot-open-database-requested-by-the-login-the-login-failed-login-failed-for-user-nt-authoritynetwork-service/ a day ago. It does not exist anymore!What am I missing?ThanksBrano Post #675541 Roy ErnestRoy Ernest Posted Friday, March 13, 2009 1:54 PM SSCrazy Group: General Forum Members Last Login: Thursday, September 22, 2016 10:30 AM Points: 2,381, Visits: 6,848 Do you have any Jobs, Scheduled tasks or something running that connects to that DB? -Roy Post #675553 branovukbranovuk Posted Friday, March 13, 2009 2:07 PM Valued Member Group: General Forum Members Last http://www.sqlservercentral.com/Forums/Topic675541-146-1.aspx Login: Friday, May 30, 2014 9:03 AM Points: 68, Visits: 307 Thank you, that solved issue. I overlooked that sharepoint installation created job CDW_SHAREPOINT for that database.It is gone.Regards,Brano Post #675559 Roy ErnestRoy Ernest Posted Friday, March 13, 2009 2:10 PM SSCrazy Group: General Forum Members Last Login: Thursday, September 22, 2016 10:30 AM Points: 2,381, Visits: 6,848 Glad I could help.. :) -Roy Post #675565 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You cannot send private messages. You cannot send emails. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post Emot
One games Xbox 360 games PC https://support.microsoft.com/en-us/kb/283860 games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security cannot open Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft cannot open database Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft