Ms Sql Server Error 4060
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with sql server error 4060 server rejected the connection us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow sql server error 4060 cannot open database Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up
Server Rejected The Connection Access To Selected Database Has Been Denied
SQL server Error 4060 up vote 1 down vote favorite 1 4060 "Server rejected the connection; Access to selected database has been denied". How can I troubleshoot this error? sql-server-2005 security share|improve this question edited Apr 9 '09 at 11:15 Will 96.3k41233337
Sql Server Cannot Open Database Requested By The Login. The Login Failed
asked Apr 9 '09 at 11:06 Haranadh 2272610 from where are you trying to connect to the sql server? if from code, then it would be good to give us the connection string that you are using –Konstantinos Apr 9 '09 at 11:18 my case was misspelled database name –shareef Jun 22 '15 at 11:45 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote Do you have permission to access the database using the credentials sql server error 4060 access to selected database has been denied that you are supplying? What provider are you trying to use? TCP/IP, Named Pipes? Has that provider been enabled? Is there a firewall in place and have you opened up the port to the client? Does this happen intermittently? If so, do you have enough licenses available when the error occurs? You might want to check the server error logs (and your client event log, too) for more information. share|improve this answer answered Apr 9 '09 at 11:18 tvanfosson 352k65571700 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 1 down vote User credentials are ok, but user doesn't have the right to connect to the given database, you should grant him all rights needed... share|improve this answer answered Sep 24 '12 at 16:44 que dal 711 1 could you elaborate how this might be done? –Andy Hayden Sep 24 '12 at 20:57 what happens is that the user/pass are provided to sql, AND credentials are correct, AND before connecting the user to the database requested for the connection, sql tries to connect the user to the user's default database, which turns to be, in Haranadh's case not granted to the user in question. that's it. –que dal Jun 6 '13 at 14:31 add a comment| up vote 0 down
up Recent PostsRecent Posts Popular TopicsPopular Topics Home
Connection Failed Sqlstate 08004 Error 4060
Search Members Calendar Who's On Home » SQL Server 2005 » sql state = s0001, error code = 4,060 Administering » SQLServer Error: 4060, Cannot open database SQLServer Error: 4060, Cannot open database Rate Topic Display sql state 08004 Mode Topic Options Author Message branovukbranovuk Posted Friday, March 13, 2009 1:35 PM Valued Member Group: General Forum Members Last Login: Friday, May 30, 2014 9:03 AM http://stackoverflow.com/questions/733744/sql-server-error-4060 Points: 68, 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 a day ago. It does not exist anymore!What am I missing?ThanksBrano Post #675541 Roy ErnestRoy Ernest http://www.sqlservercentral.com/Forums/Topic675541-146-1.aspx Posted Friday, March 13, 2009 1:54 PM SSCrazy Group: General Forum Members Last Login: Yesterday @ 7:19 AM Points: 2,382, Visits: 6,850 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 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: Yesterday @ 7:19 AM Points: 2,382, Visits: 6,850 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 can
and SafetyAsset NetworkAsset https://scn.sap.com/thread/2127307 Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bb665e34-f9f5-4675-a932-e9f2854cd102/sql-server-2008-express-error-4060?forum=sqlexpress Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital sql server AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel sql server error Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT Managem
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: SQL Server 2008 Express Error 4060 SQL Server > SQL Server Express Question 0 Sign in to vote Problem: see JPEG image attached regarding the error message I get when I try to insert a single row in a table. SQL Error 4060. I can access this database, CutSysDB, in Sql Server Management Studio, SSMS, and insert values in each of the five tables that comprise the database which runs under Windows 7, Visual Studio 2008 Standard SP1, SQL Server Express 2008 R2 SP1. When I try to add the first row in the empty table with my VS2008/Visual Basic 2008 project under Debug, I get the 4060 sql error. Before you expend to much effort on this, you should first look at the following thread that Cathy is suggesting may be due to a VS2008 SP1 install problem: Terry01 Thread - Studio Setup and Installation/Visual Studio 2008/devenv.exeTerry 01 Monday, December 26, 2011 8:48 PM Reply | Quote All replies 0 Sign in to vote Hi Terry, Login to SQL Server using Management studio and go to Security. Select 'Terry-HP\Terry' login, in newly opened screen of Login Properties you will have User Mapping section. In that window give permission to databases in which this user required permission. On the lower screen, click the role db_owner. Click OK. For more information, you could refer to 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/. Thanks, MaggiePlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread. Proposed as answer by Papy NormandModerator Tuesday, December 27, 2011 10:17 AM Tuesday, December 27, 2011 8:29 AM Reply | Quote Moderator 0 Sign in to vote Maggie, I believe I followed your instructions, but to no avail. My Login Properties screen is included as a JPEG for your review. Where do I go from here? Terry By the way, when I try to create a new login I get