Microsoft Sql Server Error 4060
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 sql server error 4060 server rejected the connection Tips and Tricks192 commentsThis error is quite common and I have sql server error 4060 cannot open database received it few times while I was working on a recent consultation project.Cannot open database requested sql server cannot open database requested by the login. the login failed by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE'.This error occurs when you have configured your application with IIS, and IIS goes to SQL
Server Rejected The Connection Access To Selected Database Has Been Denied
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.If you search online, there are many different solutions provided to solve this error, and many of these solutions work fine. However, I will be going over a solution that works sql server error 4060 access to selected database has been denied 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, 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 - Select and Delete Duplicate Records - SQL in Sixty Seconds #036 - Video December 19, 2012Pinal Dave SQL SERVER - UDF - Remove Duplicate Chars From String December 5, 2007Pinal Dave SQL SERVER - Disabled Index and Index Levels and B-Tree September 14, 2010Pinal 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
360 games PC games connection failed sqlstate 08004 error 4060 Windows games Windows phone games Entertainment All Entertainment
Cannot Open User Default Database. Login Failed
Movies & TV Music Business & Education Business Students & educators
Sql State = S0001, Error Code = 4,060
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet 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/ 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 Lumia All https://support.microsoft.com/en-us/kb/307864 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
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home http://www.sqlservercentral.com/Forums/Topic14305-20-1.aspx » Programming » Connecting » sql error 4060 sql error 4060 Rate http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88971 Topic Display Mode Topic Options Author Message SalSal Posted Thursday, July 17, 2003 4:13 PM Forum Newbie Group: General Forum Members Last Login: Thursday, July 17, 2003 12:00 AM Points: 4, Visits: 1 I had to restore an access db into sql server. ODBC works successfully on client computer sql server but when I start access application i get an error.Connection failed:SQLState: ''SQL Server Error:0[Microsoft][ODBC SQL Server Driver]Invalid connection string attributeConnection failed:SQLState: '08004'SQL Server Error: 4060Server rejected the connection; Access to selected database has been denied. Any help would be greatly appreciated.thanks,Sal Post #14305 RitchRitch Posted Friday, July 18, 2003 1:44 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, April sql server error 2, 2007 10:55 PM Points: 134, Visits: 1 Hi Sal,4060 is a login failure. Not sure how sql copes with rights and permissions when restoring from access. Accoring to BOL quote:Microsoft Access 2000 requires the installation of either Microsoft Office 2000 Service Release 1 (SR1) or Access 2000 SR1 to operate correctly with SQL Server 2000. If running an earlier version of Access 2000, you cannot test automatic data processing (ADP) applications against SQL Server 2000. You cannot access database diagrams, stored procedures, table designs, or view designs.Other issues to be addressed in a future Access Service Release: When you run Access 2000 with SR1, you can test ADP applications. You can also alter database diagrams, stored procedures, table designs, or view designs, but you cannot save any changes. A future Access Service Release will allow limited ability to save changes.The Access 2000 Create Database Wizard cannot successfully create a SQL Server 2000 database. You can work around this by first creating the database using SQL Server Enterprise Manager, and then creating an ADP for the database using the Pro
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums General SQL Server Forums New to SQL Server Programming MSSQLServer Error: 4060 Reply to Topic Printer Friendly Author Topic Jazzcrime Starting Member 6 Posts Posted-09/06/2007: 08:35:07 Hi, i just installed SQL 2005, and to get started im trying to follow the reporting service tutorial the Creating a Basic Report'whehave to do is n im at lesson 3 i have to 'setting up connection information' i have to create a new dataset, called adventure works when im trying to add it i get the following error: 'a connection cannot be made to the database set and test the connection suesttring'additional information: Cannot open database 'Adventureworks'requested by the login. The login failed. Login failed for user 'SRVDBTEST\Administrator'. (microsoft SQL Server, Error: 4060)how can i solve this problem?Thx in advance! jen Flowing Fount of Yak Knowledge Sweden 4110 Posts Posted-09/06/2007: 15:15:41 is your sql server instance mixed mode or sql authentication only?logon to your instance and verify, check if builtin administrator is there otherwise explicitly provide yourself the permission using your sa accountHTH--------------------keeping it simple... Jazzcrime Starting Member 6 Posts Posted-09/07/2007: 03:00:41 my server instance is mixed mode, i tried to give my sa account all possible rights by using the sql server management studio but when i check logins i see the users and their is a red arrow @ 'sa'account and when im trying to change anything it says 'create failed for user 'sa'. (an exception occured while executing a transact-SQL statement or batch (microsoft.sqlserver.connectioninfo) -> Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405 rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-09/07/2007: 22:41:29 You don't need give more rights to sa in sql since it has all rights by default. Did you use windows authentication to connect to sql? Is 'SRVDBTEST\Administrator' a valid sql login? By the way, sql2k5 doesn't have 'sql authentication only' mode. jen Flowing Fount of Yak Knowledge Sweden 4110 Posts Posted-09/08/2007: 14:24:08 create failed?did you remove your