Error Code 229 Sqlstate 42000
Contents |
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/DataSource Controls - SqlDataSource, ObjectDataSource, etc/SELECT permission was denied on Database object SELECT permission was denied on Database object [Answered]RSS 7 replies Last post Jan 06, 2012 07:06 errorcode 1064 sqlstate 42000 AM by kaneXtreme ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts
Errorcode 942 Sqlstate 42000
Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply hani1426 Member 2 Points 21 Posts SELECT permission was denied
Errorcode 933 Sqlstate 42000
on Database object Oct 12, 2007 12:58 AM|hani1426|LINK Hi all, I have my asp.net application with crystal reports which is using OLE DB connection , when I published the application on my test server every
Errorcode 904 Sqlstate 42000
thing was ok and I was able to view,print and exprot my reprot (test server is not a domain controller), BUT when I published the application on the production server which is a domain controller it is giving me this error: Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: The SELECT permission was denied on the object 'MyTable', database errorcode 936 sqlstate 42000 'MyDatabase', schema 'dbo'. SQL State: 42000 Native Error: Failed to open a rowset. Error in File C:\WINDOWS\TEMP\Myreport {C4BCF4E0-469D-4425-8556-A3D2A17059B8}.rpt: Failed to open a rowset I tried to give the IIS user all the permisions on the database, no result I triedalso to make the authentication mode in IIS to Integrated windows authentication (Disable the user IISER_---) but it still give me the same error Please help, any help will be highly appreciated Reply Murthy Puvva... Member 467 Points 231 Posts Re: SELECT permission was denied on Database object Oct 12, 2007 08:09 AM|Murthy Puvvada|LINK I am having exactly the same problem as you are having. Any help would be greatly appreciated. thanks, Murthy here Dont forget to click "Mark as Answer" on the post that helped you. This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped. Reply hani1426 Member 2 Points 21 Posts Re: SELECT permission was denied on Database object Oct 12, 2007 02:22 PM|hani1426|LINK Dear Murthy Puvvada, I solved the problem by adding the (NT AUTHORITY/NETWORK SERVICE) user to the database users and giving him the appropriate permision in the database (make sure that this user has "select" permision on the
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come error code 1064 sql state 42000 on over! We've restricted the ability to create new threads on these forums. execute permission was denied on the object sp_send_dbmail database msdb schema dbo SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question grant exec on sp_send_dbmail answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) New Sql server database problem Reply to Topic Printer Friendly Author Topic http://forums.asp.net/t/1169301.aspx?SELECT+permission+was+denied+on+Database+object marzy Starting Member United Kingdom 2 Posts Posted-06/25/2011: 13:09:22 Hi all,I am not overly familiar with databass but I am having a strange problem.I have recently migrated a database that was for a site running on dotnetnuke. The database is quite large at around 4gb as the site has a lot of flash. The site was running ok on the old http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=162268 windows server 2003 but now the stie keeps going down upto several times a day.when I check the database in sql server management studio the databas has no plus sign next to it as if it is inaccessable. if i take the database offline and straight back online the sites comes staright back up.I have been checking all over and cannot seem to figure out why this is happening and hope someone may be able to shed some light on the matter.Really appreciate anyones help.ThanksLeelm russell Pyro-ma-ni-yak USA 5072 Posts Posted-06/25/2011: 20:48:55 What messages are you seeing in the SQL Server Error Logs and in Event Viewer? marzy Starting Member United Kingdom 2 Posts Posted-06/26/2011: 04:03:14 Hi Russell, Thanks for the reply.in the error log this is an example of one of the files.2011-06-17 03:24:01 - ? [393] Waiting for SQL Server to recover databases...2011-06-17 03:24:10 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)2011-06-17 03:24:11 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_se
24, 20100 0 0 0 Issue The SQL agent services fail to start and give the following error when we try starting it from the services console : When we attempt to start SQL agent services we get the following https://blogs.msdn.microsoft.com/amruthavarshinij/2010/10/24/sqlserveragent-service-fails-to-start-sqlserver-error-229/ error : ------------------ Services ------------------ The SQLSERVERAGENT service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts http://serverfault.com/questions/278005/configuring-sql-server-agent-with-domain-account-still-fails-to-start-agent service. ------------------ OK ----------------- Environment Windows 2003 Service Pack 2 SQL Version: SQL2000 Enterprise Edition SQL Service Pack: RTM SQL Build: 8.00.2039 SQL Platform: x86 SQL Server Name: HRSERVER SQL state 42000 Instance Name: default · We collected the SQL agent logs and saw the following errors 2010-10-24 16:51:19 - ! [298] SQLServer Error: 229, EXECUTE permission denied on object ‘sp_sqlagent_has_server_access', database ‘msdb', owner ‘dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin) 2010-10-24 16:51:19 - ! [298] SQLServer Error: 229, EXECUTE permission denied on object ‘sp_sqlagent_get_startup_info', database ‘msdb', owner ‘dbo'. [SQLSTATE 42000] 2010-10-24 16:51:19 - ? [100] code 1064 sql Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 2010-10-24 16:51:19 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 3696 2010-10-24 16:51:19 - ? [101] SQL Server version 8.00.2039 (0 connection limit) 2010-10-24 16:51:19 - ? [102] SQL Server ODBC driver version 3.86.3959 2010-10-24 16:51:19 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is 2010-10-24 16:51:19 - ? [310] 8 processor(s) and 2048 MB RAM detected 2010-10-24 16:51:19 - ? [339] Local computer is HRSERVER running Windows NT 5.2 (3790) Service Pack 2 2010-10-24 16:51:19 - ! [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin, but ‘(Unknown)' is not a member of the SysAdmin role 2010-10-24 16:51:19 - ? [098] SQLServerAgent terminated (normally) · Just a test changed the startup account from the local system to a domain account and subsequently added it to the sysadmin server role which enabled SQL agent services to start up · SQL server services inspite of having local system account as its startup , was working fine but SQL Agent on the other hand failed to startup w
Start 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 us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Configuring SQL Server Agent with domain account still fails to start Agent up vote 1 down vote favorite I am trying to follow best practices for Sharepoint 2010 installation and SQL Server Agent will not start. My first reference is: Installing SharePoint 2010 using Least Privilege Service Accounts In short, I am using a domain account for starting MSSQLSERVER itself and SQLSERVERAGENT services for both as he suggests (that is, I am using myDomain\SQLsrvcs) Here is the error log (SQLAGENT.OUT) for the agent when it fails: 2011-06-07 15:06:02 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs) 2011-06-07 15:06:02 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin) 2011-06-07 15:06:02 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info', database 'msdb', schema 'dbo'. [SQLSTATE 42000] 2011-06-07 15:06:02 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000] 2011-06-07 15:06:02 - ! [000] Error creating a new session 2011-06-07 15:06:02 - ? [098] SQLServerAgent terminated (normally) MSSQLSERVER starts fine but the agent fails as above. The advice of "Sharepoint George" does not indicate that the instance of SQL needs a LOGIN (and as I read the "least privilege" message i