Please help Posted 7-Oct-12 20:52pm adityarao311.3K Add a Solution 2 solutions Top Rated Most Recent Rate this: Please Sign up or sign in to vote. Goodness Giza Golf! 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 - How Simply add users for each Windows user you want or add a Windows group, and you should be good to go.If the above steps don't solve your problem, then you are navigate here
You cannot post replies to polls. When I change the server location (in the ODBC setting) to the new server, the Crystal reports will then allow them to be pointed to the new server and work. Reason : Cannot open user default database. Thank youReply Anaya May 20, 2016 8:24 amToo good. http://www.sqlservercentral.com/Forums/Topic161867-5-1.aspx
THANKS AGAIN! Monday, January 04, 2010 5:31 AM Reply | Quote 0 Sign in to vote Are there other databases on this machine that are working? share|improve this answer answered Apr 9 '09 at 11:18 tvanfosson 354k67577701 add a comment| Did you find this question interesting? You cannot post HTML code.
I suggest that my original post is the most likely solution for this problem. This tells me that the ODBC setting is correct. The user group alone didn't work, perhaps as it needed the restart. Connection Failed Sqlstate 08004 Error 4060 You may read topics.
I'm logged into the machine as a domain admin and sql server admin.Within Enterprise Manager I have full rights on this database. Sqlstate 08004 Sql Server Error 4060 Server Rejected The Connection Only two reports exhibited the error and I found out that I had changed the report database from the default access one to a file dsn that pointed to a SQL Connection: trusted. [CLIENT: 192.168.1.32]2010-02-24 19:29:27.88 Logon Error: 18456, Severity: 14, State: 16.2010-02-24 19:29:27.88 Logon Login failed for user 'WMPJ\support1'. [CLIENT: 192.168.1.32]What I am I missing?I did find this article but I Please enable cookies.
delete all user from the new serverand script the user from the old server and execute it on the new server.Good luck.mom Post #161889 Bob Hoffman-209065Bob Hoffman-209065 Posted Tuesday, February 15, Sql Server Error 4060 Access To Selected Database Has Been Denied This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL) Top Experts Last 24hrsThis month OriginalGriff 190 Jochen Arndt 150 Richard Let's work to help developers, not make them feel stupid. Regards, Dave Patrick ....
The step failed.Reply rahul October 17, 2014 1:06 ami spend my two days on that problemServer Error in ‘/Mvc4_demo' Application. https://archive.sap.com/discussions/thread/2127307 I set up a DSN that points to the database (user is SA) and I have a MS Access 2007 application with linked tables that points to the DSN.When I try Sql Server Error 4060 Cannot Open Database You cannot post events. Server Rejected The Connection Access To Selected Database Has Been Denied Username: Password: Save Password Forgot your Password?
You cannot delete your own topics. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? The network administrator account is the ONLY one that works.This is the error from the log whena regular user tries to use ODBC. his comment is here Login failed for user "user name"Reply hraverkar September 22, 2015 10:49 amhttp://stackoverflow.com/questions/24822076/sql-server-login-error-login-failed-for-user-nt-authority-systemcheck this may be solved your problem ..Reply Robert Meek October 7, 2015 2:48 amThank you so much for ALL
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 selected database has been Sql Server Cannot Open Database Requested By The Login. The Login Failed permalinkembedsaveparentgive gold[–]ramblemnDatabase Administrator 0 points1 point2 points 1 year ago(1 child)The restart probably kicked over to Access was re-opened too?? DROP login corresponding to that user.4.
Post #161867 Sopheap SuySopheap Suy Posted Tuesday, February 15, 2005 3:42 PM Ten Centuries Group: General Forum Members Last Login: Tuesday, March 10, 2015 10:14 AM Points: 1,063, Visits: 357 It Microsoft Certified Professional Microsoft MVP [Windows] Monday, January 04, 2010 3:23 AM Reply | Quote 0 Sign in to vote I'm not sure I understand your last post entirely. Any help is greatly appreciated? Sql State 08004 How fast is Time running in Majora's Mask?
behrman Yak Posting Veteran 76 Posts Posted-01/09/2010: 12:00:10 The file is an MDB. Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows] Thursday, January 07, 2010 4:14 AM Reply | Quote 0 Sign in to vote I granetd sysadmin rights to the SQL login but this had http://lwdrm.com/sql-server/08004-microsoft-sql-server-error-4060.php You may download attachments.
Change to the database in question (Juris6860000?)2. Customers are either Access or MS SQL Server. I did check the security on MASTER and made sure everyone has file and folder access. The problem started whenthe database was upgraded from MSSQL2000 to MSSQL2005.