Ms Sql Error Code 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 sql server error 4060 server rejected the connection the company Business Learn more about hiring developers or posting ads with us Stack
Sql Server Error 4060 Cannot Open Database
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of microsoft sql server error 4060 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL server Error 4060 up vote 1 down vote favorite 1 4060 "Server rejected the connection; Access to sql server error 4060 access to selected database has been denied 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 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
Connection Failed Sqlstate 08004 Error 4060
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 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| 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 datab
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: SQL Express connection error 4060 SQL Server server rejected the connection access to selected database has been denied > SQL Server Express Question 0 Sign in to vote Hello, sql server cannot open database requested by the login. the login failed I created a program that uses SQL Express on my local machine. I wanted to allow other
Sql State = S0001, Error Code = 4,060
users to use the same program, so I put another copy of SQL Express on a server. I installed the database on this new server. I can use the http://stackoverflow.com/questions/733744/sql-server-error-4060 database with no problem, but other domaint users get an SQLClient error 4060 when trying to use the database. What permissions do I need to set to allow domaint users to use the database? Thanks for any ideas, Tom Monday, June 25, 2007 9:31 PM Reply | Quote All replies 1 Sign in to vote https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6b545b4c-9766-46ba-82bd-17d6e28cbaf8/sql-express-connection-error-4060?forum=sqlexpress The default installation keeps the server 'closed' to net traffic. You may need to alter the configuration to allow remote users. Refer to these articles: Configuration -Configure SQL Server 2005 to allow remote connectionshttp://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuration -Connect to SQL Express from "downlevel clients"http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx Configuration -Connect to SQL Express and ‘Stay Connected’http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html Configuration - Guideline for Connectivity Question Postinghttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1 Tuesday, June 26, 2007 1:15 AM Reply | Quote Moderator 0 Sign in to vote Arnie, I can connect with no problem if I connect from my PC, but other Domain users get the error 4060 when they try and connect. After doing some searches on this error it seems it is related to a username/password issue. I am still not sure how to resolve this error. Thank you for your reply, Tom Tuesday, June 26, 2007 1:26 PM Reply | Quote 0 Sign in to vote The additional users will have to have been provided SQL Server login permissions to their domain accounts (I'm assuming that your SQL
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » SQLServer http://www.sqlservercentral.com/Forums/Topic675541-146-1.aspx Error: 4060, Cannot open database SQLServer Error: 4060, Cannot open database Rate Topic Display 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 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 sql server 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 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 sql server error 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 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