EXECUTE Permission Denied On Object Sp_OACreate/method/GetProperty/Destroy

Aug 3, 2002

Hi friends

I copy script that use SQL proc to call DTS package from this site.

When I run this procedure in SQL query alalyzer. I got an error messages:
EXECUTE permission denied on object sp_OACreate/method/GetProperty/Destroy.
I did not change anything in spExecutePKG.
Even I used sa as ServerPWD. How to fix this problem? my code is
exec spExecutePKG 'myserver','execl_DTS','sa','0',''
Thanks
jimmy

------proc original code
CREATE PROC spExecutePKG
@Server varchar(255),
@PkgName varchar(255), -- Package Name (Defaults to most recent version)
@ServerPWD varchar(255) = Null,-- Server Password if using SQL Security to load Package (UID is SUSER_NAME())
@IntSecurity bit = 0,-- 0 = SQL Server Security, 1 = Integrated Security
@PkgPWD varchar(255) = ''-- Package Password
AS
SET NOCOUNT ON
/*
Return Values
- 0 Successfull execution of Package
- 1 OLE Error
- 9 Failure of Package
*/
DECLARE @hr int, @ret int, @oPKG int, @Cmd varchar(1000)

-- Create a Pkg Object
EXEC @hr = sp_OACreate 'DTS.Package', @oPKG OUTPUT
IF @hr <> 0
BEGIN
PRINT '*** Create Package object failed'
EXEC sp_displayoaerrorinfo @oPKG, @hr
RETURN 1
END

-- Evaluate Security and Build LoadFromSQLServer Statement
IF @IntSecurity = 0
SET @Cmd = 'LoadFromSQLServer("' + @Server +'", "' + SUSER_SNAME() + '", "' + @ServerPWD + '", 0, "' + @PkgPWD + '", , , "' + @PkgName + '")'
ELSE
SET @Cmd = 'LoadFromSQLServer("' + @Server +'", "", "", 256, "' + @PkgPWD + '", , , "' + @PkgName + '")'

EXEC @hr = sp_OAMethod @oPKG, @Cmd, NULL

IF @hr <> 0
BEGIN
PRINT '*** LoadFromSQLServer failed'
EXEC sp_displayoaerrorinfo @oPKG , @hr
RETURN 1
END

-- Execute Pkg
EXEC @hr = sp_OAMethod @oPKG, 'Execute'
IF @hr <> 0
BEGIN
PRINT '*** Execute failed'
EXEC sp_displayoaerrorinfo @oPKG , @hr
RETURN 1
END

-- Check Pkg Errors
EXEC @ret=spDisplayPkgErrors @oPKG

-- Unitialize the Pkg
EXEC @hr = sp_OAMethod @oPKG, 'UnInitialize'
IF @hr <> 0
BEGIN
PRINT '*** UnInitialize failed'
EXEC sp_displayoaerrorinfo @oPKG , @hr
RETURN 1
END

-- Clean Up
EXEC @hr = sp_OADestroy @oPKG
IF @hr <> 0
BEGIN
EXEC sp_displayoaerrorinfo @oPKG , @hr
RETURN 1
END

RETURN @ret
GO

View 1 Replies


ADVERTISEMENT

EXECUTE Permission Denied On Object 'sp_OACreate', Database 'mssqlsystemresource'

Oct 5, 2006

HI There

I have a user login that is executing an sp. It gets the follwoing error:
Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 1
EXECUTE permission denied on object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1
EXECUTE permission denied on object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1
EXECUTE permission denied on object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1
EXECUTE permission denied on object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAGetProperty, Line 1
EXECUTE permission denied on object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAGetProperty, Line 1
EXECUTE permission denied on object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OADestroy, Line 1
EXECUTE permission denied on object 'sp_OADestroy', database 'mssqlsystemresource', schema 'sys'.

Everything ic an find on the net refers to Sql Server 2000 but this is 2005, all the resolutions say you must grant exec permissions to the user account for these sp's in the master database.

BUT is SS2005 they are in the mysqlsystemresource database.

WHen i try the following

grant exec on mssqlsystemresource.sys.sp_OACreate to UserLogin:

I get this error:

Cannot find the object sp_OACreate, becuase the object does not exist or you do not have permission.

I am logged in as sysadmin so i doubt it is permission.

How do i get a user login to be able to exec these sp's?

Thanx

View 11 Replies View Related

EXECUTE Permission Denied On Object 'sp_OACreate', Database 'master', Owner 'dbo'.

Sep 21, 2005

I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error.
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.
EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'.
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.
EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.
How canI solove this problem?

View 1 Replies View Related

EXECUTE Permission Denied On Object 'sp_OACreate', Database 'master', Owner 'dbo'.

Sep 21, 2005

I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error.

EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'.

EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.

EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.

How canI solove this problem?

View 2 Replies View Related

SQL Server - Permission Issues : Execute Permission Denied On Object 'SprocName'

Dec 13, 2005

I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I  could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
 

View 2 Replies View Related

[Help] EXECUTE Permission Denied On Object

Dec 3, 2004

Microsoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'wwfSpTimeAndDateSettings', database 'iobmi6_ETSasp', owner 'dbo'.

/forum/functions/functions_date_time_format.asp, line 82


What does the EXECUTE permission denied on object... line mean?

View 4 Replies View Related

EXECUTE Permission Denied On Object On .NET

Oct 17, 2007


When I create the chart from the query it works fine but when I convert the same query to the procedure I get the following error. I have proper execute permission of the users.

PLEASE HELP...........

Server Error in '/' Application.



EXECUTE permission denied on object 'mscrm_procname, database 'Servername', schema 'dbo'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'mscrm_procname, database 'Servername', schema 'dbo'.

Source Error:







An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:







[SqlException (0x80131904): EXECUTE permission denied on object 'mscrm_procname', database 'servername', schema 'dbo'.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188

System.Data.SqlClient.TdsParser

View 1 Replies View Related

EXECUTE Permission Denied On Object 'aspnet_CheckSchemaVersion'

Mar 19, 2008

 I add DB to my apllication using the ASPNET membershipBut I got this ErrorEXECUTE permission denied on object 'aspnet_CheckSchemaVersion',  Here is the problem page:http://www.tslaw.co.il/default.aspx any Idea how can I fix this problem.Thanks 

View 6 Replies View Related

SQL Server: EXECUTE Permission Denied On Object

Mar 16, 2004

Environment: Visual Studio .NET 2003 on pc (Windows XP Pro) in workgroup A, ASP .NET application on server (Server 2000 w/ IIS 5 in workgroup A), SQL Server 2000 on same server (Enterprise Edition)..........all on Intranet with static IP's for all machines.

I have the {servername}VSDevelopers group with sysadmin priveleges on SQL Server.
I have the {servername}ASPNet user with public on SQL Server.

I can create stored procedures in database ABC on SQL Server from Visual Studio on pc(default named to dbo.{stored_procedure_name}).

I can edit same stored procedures in database ABC on SQL Server from Visual Studio.

I get EXECUTE error when trying to run stored procedure via ASP.NET application on server.

I check, and permissions to objects on SQL Server for VSDeveloper group shows as no permissions.

I set the permissions for all user created objects (tables, stored procedures) to "full" for VSDevelopers.

Works..............til I create a new object.

Any ideas? Suggestions? Solutions?

If need more detail, let me know. Thanks.

View 2 Replies View Related

EXECUTE Permission Denied On Object 'sp_dts_getpackage'

Apr 21, 2006

trying to execute an ssis package from the web - classic asp page

I am using windows authentication to login to the web site

which I assume means i am executing the package under that account

That account being administrator

I am using the code below to execute

Dim objWshShell, obj, objStdOut
Set objWshShell = Server.CreateObject("Wscript.Shell")
set obj = objWshShell.EXEC("cmd /c dtexec /sq single /ser MPDNETWEB")

this runs find on the command line but I cannot get it to run from the web page.I get the following error.

The LoadFromSQLServer method has encountered OLE DB error code 0x80040E09 (EXECUTE permission denied on object 'sp_dts_getpackage', database 'msdb', schema 'dbo'.). The SQL statement that was issued has failed.

Please help.

Im desperate!

View 4 Replies View Related

Error: EXECUTE Permission Denied On Object...

Apr 10, 2007



I get this error when I try to preview a report that uses a stored procedure. The stored procedure does not exist in the database, but in the directory I run the report from. The stored procedure declares which database to use, and to create the temp table I want. Do I require special permissions on the sql db I am using to be able to create temp tables? Any help would be great, thanks!





Michael



View 3 Replies View Related

EXECUTE Permission Denied On Object 'sp_fulltext_getdata'

Oct 15, 2007

A development database server is receiving "EXECUTE permission denied on object 'sp_fulltext_getdata'" when trying to run fulltext-related commands such as the following:

Exec sp_fulltext_catalog N'Catalog_Name', N'start_incremental'
Exec sp_fulltext_table N'[dbo].[Table_Name]', N'start_incremental'


These commands appear to run successfully in that the job does not fail or report any error messages, but when I enable auditing for Error 229 the error is logged for every execution. The job is run under the security context of the SQL Server service account so permissions should not be an issue. This problem does not occur on any other servers and I can replicate the problem on the same server by creating a fulltext index in another database and running the same commands.

Any suggestions?

By the way, the server is SQL Server 2000 SP3a Enterprise Edition.

Thanks, Dave

View 1 Replies View Related

EXECUTE Permission Denied On Object 'xp_sqlagent_enum_jobs'

Sep 13, 2007

SQL Server 2005 SP2, v9.00.3042

Last week, I set up a SQL Server login and assigned it to the MSDB role of SQLAgentOperatorRole. A couple of jobs were created and this login was assigned as being the owner of those jobs.

The login was able to successfully edit and execute the jobs. Per the documentation, only these 2 jobs would show up in the jobs list for the login to view.

Now, when the login attempts to expand the jobs list, the following error appears:
EXECUTE permission denied on object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'

I'm not excited about granting explicit execute permissions to extended stored procedures . . . . but will if I have to.

I think the senior DBA changed something that hosed this up.

What should I be looking for?

View 1 Replies View Related

EXECUTE Permission Denied On Object 'x', Database 'y', Owner 'z'.

May 12, 2008

Hi,

I have SQL Server 2005 database, and have linked it with three SQL Server 2000 databases, and using Windows Authentication.


I'm using ASP.NET with my main database (SQL Native Client), which is authenticating to the linked databases with the computer hostname (DOMAINCOMPUTER$) credential, which is all working fine on all databases for doing SELECT queries.

However, now I'm trying to run a stored procedure on the linked databases. Two of the three databases are working flawlessly in this regard, but the third I'm getting the error: EXECUTE permission denied... I've checked the logs, and it's showing the connection as being trusted, and I've already added the execute permission for the stored procedure in question, but I'm not getting anywhere.


I have restarted the database server, but that hasn't helped any.

Thanks,

Jessica Hamilton

View 10 Replies View Related

Reporting Services :: EXECUTE Permission Denied On Object

Jul 11, 2015

I am using SSRS in sharepoint Mode

In order to enable the report cache and set data refresh options, in sharepoint library on report file,I am selecting "Manage processing options" as mentioned in MSDN

[URL] ....

But I am getting error "EXECUTE permission was denied on the object xp_sqlagent_enum_jobs" I have granted the execution rights for all procedures as mentioned here but still error isnot going

[URL] .....

Where can I find SSRS failure logs, I can see execution3 but it is not storing this information...

View 3 Replies View Related

EXECUTE Permission Denied On Object 'Test', Database 'DI', Owner 'dbo'

Jun 8, 2005

hi,I use DataGrid in name UserTable.I use this code:
SqlCon.Open()
UserTable.DataSource = SqlCom.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
UserTable.DataBind()and i get this error: EXECUTE permission denied on object 'Test', database 'DI', owner 'dbo'I craete stored prcedure in name Test with the simple SQL code:CREATE PROCEDURE [dbo].[Test] ASselect Users.*from UsersGOIf instead i put the SQL code : select Users.*    from Usersin my command as a text i get the error : SELECT permission denied on object 'Users', database 'DI', owner 'dbo'i have already create a local premmision for my DB & tables as MYMACHINE/ASPNETHow i can solve this problem?Thanks, Moshe

View 2 Replies View Related

EXECUTE Permission Denied On Object 'aspnet_CheckSchemaVersion', Database 'dbname', Owner 'dbo'.

Aug 30, 2007

Hi!I have a problem. i have created a website with a login page, i have moved all my aspnetdb tables to my remote host. but when iam trying to logon i get this error messages.
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'dbname', owner 'dbo'.
Someone? I really need help...

View 3 Replies View Related

EXECUTE Permission Denied On Object 'MySPorDB', Database 'MyDatabase', Owner 'dbo'.

Aug 11, 2004

I just installed this application on my new server and I get this error for each object in the database including the tables and the stored procedures. I have been going in for each one and opening the properties and then going to permissions and making the changes for each one.
Is there a way to do this for the entire database at once?
Thanks

View 2 Replies View Related

EXECUTE Permission Denied On Object 'xp_startmail', Database 'master', Owner 'dbo'.

Dec 7, 2007



Hi All,

I am having this issue with my application developed in VB.Net. The thing was working properly for the last couple of years. But suddenly it is giving me this error message when ever I try to execute the following code.



mycommand = New SqlCommand(sqlstr, SqlConnection1)

SqlConnection1.Open()

mycommand.ExecuteReader()



The operation is never related to sending e-mail and even the master Database, it is used just to display records on grid.

Here is the error message comeing out when it reaches the mycommand.ExecuteReader():



EXECUTE permission denied on object 'xp_startmail', database 'master', owner 'dbo'.



Any help?

Thank you,

View 5 Replies View Related

Permission Denied On Object

Oct 30, 2005

Hi all,

I've seen a few posts about this problem here but, apparently my case is a bit different :

I keep having this error :SELECT permission denied on object 'myTable', database 'myDB, owner
'thisUser', when I try to test my project from Visual Studio 2003 using Ctrl + F5

But
1) I use SQL authentication, and the connection seems to work fine (connections string : "Server=localhost;Database=myDB;User ID=thisUser;Password=hisPwd;Trusted_Connection=False")
2) I've granted thisUser all the possible rights & roles (just to see if something would work).
3) When I check the permissions on thisTable, thisUser has green ok marks everywhere.

So I don't understand what's going on. Can anybody help me on that ?

View 2 Replies View Related

Permission Denied On Object

Apr 19, 2004

I connect in my database "test" with the user "teste" by SQL QueryAnalyzer (localhost;DatabaseName=test;SelectMethod=cursor),
but when i run the SQL (select * from user) return the error
"SELECT permission denied on object 'user', database 'test', owner 'teste'.


I already put all permission to the user "user".

My database test has a table "user". The owner´s "teste" and the Type´s "User"
The user "teste" has all permission to the table "user" (select, update, insert ...)

what i need to do ? What´s wrong ?

View 1 Replies View Related

SELECT Permission Denied On Object

Mar 26, 2005

Hello guys,
Been trying out to use SQL server, so got a copy of SQL Server 2000 on windows xp pro, rather old it seems but the only version I can get my hands on.
However, I just couldn't get it to work in a simple datagrid. The error message:
SELECT permission denied on object 'classList', database 'ck', owner 'dbo'.
Code on asp.net page:
SqlConnection1.Open()
DataGrid1.DataSource = SqlCommand1.ExecuteReader
DataGrid1.DataBind() 'Put user code to initialize the page here
SqlConnection1.Close()
Dim a As SqlCommand
a.ExecuteReader()
I have already added a localhost server (windows NT) under SQL server group, added localhost/ASPNETas a user for my imported database from access, granted SELECT Permission to the database and all tables, any idea what may be wrong with my configuration. I know it's pretty hard to pinpoint the exact problem since it's on my computer, but I have been clicking around and allowing everything on SQL for a few hours, but nothing good. So please any suggestions? Thanx

View 2 Replies View Related

SELECT Permission Denied On Object

Mar 22, 2001

Does any body have this problem? when I execut the store procedure in database A that select from a table in database B. I got error
message "SELECT permission denied on object", I know that if I have the permission to execute the store procedure, I don't need the select permission to table. Is is a bug in SQL 7.0 version or what? In SQL 6.5, as long as we have execute permission to Store procedure it will work.

View 3 Replies View Related

SELECT Permission Denied On Object

Feb 7, 2006

Hi,

I'm trying to upgrade my SQL 2000 to 2005 and use it with a web site. I've copied the DB from a SQL 2000 server machine to a 2005 machine, attached the DB to the SQL server using the relative function in Management Studio, but I still continue to get the same error:
[Microsoft][SQL Native Client][SQL Server]SELECT permission denied on object 'Users', database 'YouPlayIt', schema 'dbo'.

using this query: SELECT UserId FROM USERS.

Querying the DB from an ASP page with the query "SELECT CURRENT_USER", the system return the expected value: NKNLEPETD0IUSR_NKNLEPETD0

In SQL server, I've created a user with this name (taking it from the users list), and granted full access to all the tables of the DB.

In the permission Tab of the USERS table the NKNLEPETD0IUSR_NKNLEPETD0 have all the grant checked.

Which other permission do I have to specify in order to have access to the data ???

Thank you,
Nicola Lepetit.
www.youplay.it

View 25 Replies View Related

SELECT Permission Denied On Object...

Oct 30, 2006

I am using VB 2005 express edition with sql express 2005. I did it this little application that select data from a table. Everything Ok on local but if I use it over lan (it is a workgroup) I obtain this error:

SELECT permission denied on object 'Consensi' on database 'C:dbmarcoplate_dati.mdf' with schema 'dbo'

I used SQL Server Management Studio Express to give all permissions to the user for the Plate_Dati database but nothing changed

this is the program:

Imports System.Data.SqlClient

Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim Stringa As String = "Data Source=TAPFWSQLEXPRESS;Initial Catalog=c:dbmarcoplate_dati.mdf;
Integrated Security=SSPI;"
Dim cnn1 As New System.Data.SqlClient.SqlConnection(Stringa)
Try
cnn1.Open()
MessageBox.Show("Connection opened")
Dim sqlQuery As String = "SELECT Targa FROM Consensi WHERE Targa = 'AJ385SW'"
Dim cmd1 As New SqlCommand(sqlQuery, cnn1
Dim rdr1 As SqlDataReader
rdr1 = cmd1.ExecuteReader()
Try
Do While rdr1.Read()
MessageBox.Show(rdr1.GetString(0))
Loop
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
rdr1.Close()
End Try
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
MessageBox.Show("Connection closed")
End Try
End Sub
End Class

Please help me I don't know what to do
Thank You

View 4 Replies View Related

Select Permission Denied On Object

Jun 22, 2006



Hello all,

I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error -
Server Error in '/phonebook' Application.



SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.

Error occurs at - reader = cmd.ExecuteReader();

The stacktrace looks like this -[SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742 System.Data.SqlClient.SqlCommand.ExecuteReader() +42 Phonebook.ResultPage.CreateDataSource() in c:inetpubwwwrootphonebook
esultpage.aspx.cs:56 Phonebook.ResultPage.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootphonebook
esultpage.aspx.cs:39 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +750



I have tried managing permissions both on IIS as well as Enterprise Manager and given all rights to the admin. Please help me out

Thanks

Sanchita

View 10 Replies View Related

SELECT Permission Denied On Object 'aspstatetempapplications'

Mar 28, 2007

Hi all,
I know this error (below) has been presented before, but I have tried the typical solutions without any luck. The solutions I have tried involve insuring cross-database ownership is enabled. We have run the following query, without any luck with fixing the error. 
Is it possible we have something wrong with the tempdb, or modeldb? All the settings appear to be normal (dbo public access). Any ideas would be appreciative.
 Thanks,
Oun
 
To reconfigure SQL 2000 SP3 for ASP.net session state you must runuse master
go
EXEC sp_configure 'Cross DB Ownership Chaining', '0';
RECONFIGURE
GO

View 4 Replies View Related

SELECT Permission Was Denied On Database Object

Oct 12, 2007

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 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 'MyDatabase', schema 'dbo'. SQL State: 42000 Native Error: Failed to open a rowset. Error in File C:WINDOWSTEMPMyreport {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 tried also 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
 

View 7 Replies View Related

SELECT Permission Denied On Object (MSDN)

Jul 10, 2004

First off - complete newbie using MSDN.

Getting the error message
System.Data.SqlClient.SqlException: SELECT permission denied on object 'mytable', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteReader...

1. After a lot of googling I've done the following:
EXEC sp_grantlogin 'MYMACHINEASPNET' to grant the ASPNET logon access to the DB

2. Changed the
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode
to 2 to allow mixed mode.

3. using my connection string in web.config - have experimented with different strings with/without trusted_connection and the sa uname and pwd.
(Current connection string is
"server=localhost;Integrated Security=SSPI;Database=master;Data Source=MYCOMPUTERNAME;trusted_Connection=yes"

I'm NOT using SQL Server so what commands do i need to give my db/table SELECT permissions? (and who am I giving permission to - very confused)

I had no bother accessing the server and DB from a simple C# command line program.

Been pulling my hair out for many hours now... any help would be greatly appreciated!

View 1 Replies View Related

SELECT Permission Denied On Object (MSDN) (again...)

Jul 10, 2004

(Not having a great day - didn't mean to lock that last post - apologies)

First off - complete newbie using MSDN.

Getting the error message
System.Data.SqlClient.SqlException: SELECT permission denied on object 'mytable', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteReader...

1. After a lot of googling I've done the following:
EXEC sp_grantlogin 'MYMACHINEASPNET' to grant the ASPNET logon access to the DB

2. Changed the
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode
to 2 to allow mixed mode.

3. using my connection string in web.config - have experimented with different strings with/without trusted_connection and the sa uname and pwd.
(Current connection string is
"server=localhost;Integrated Security=SSPI;Database=master;Data Source=MYCOMPUTERNAME;trusted_Connection=yes"

I'm NOT using SQL Server so what commands do i need to give my db/table SELECT permissions? (and who am I giving permission to - very confused)

I had no bother accessing the server and DB from a simple C# command line program.

Been pulling my hair out for many hours now... any help would be greatly appreciated!

View 5 Replies View Related

SELECT Permission Denied Object 'configurations'

Feb 11, 2008

A client has the following SQL Server 2005 error. The user is unable to log into Management studio. We deleted the user and login and re-created the user and login and get the same error. FYI: If the user is given db_owner and all login privs except sysadmin he gets the error. Only syslogin grants him access. It looks like he is denied access to sys.configurations via the new resource database. Any thought?

The error:

Cannot get to <instance name>.

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The SELECT perrmission was denied on the object 'configurations", database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

View 3 Replies View Related

Execute Permission Denied

Nov 22, 2007

Hi

I'm not really a DBA but can find my way around. I've come across the problem below which I am sure is very simple to fix:

I have given the user webcgbull the following database role membership:

public
db_datareader
db_datawriter

however I receive the below error when trying to run a page that
executes a stored procedure:

EXECUTE permission denied on object 'Entities_GetAll', database 'webcgbull', owner 'dbo'.

The only way I can get around this is to give this user db_owner permission

Any help would be very much appreciated.

Kind Regards

View 7 Replies View Related

SELECT Permission Denied On Object 'database Object', Database 'databasename', Owner 'dbo'.

Mar 27, 2006

I have created a sql login account called "webuser" and has given public role in my database. In my asp.net application i build connection string using above account and its password . We give permission on store procedure for for the above account to execute .We dont give table level permission for the above account . When we run the application with the above settings it runs fine on test server . However Now i have transfered the databse object to live server with its permissions . Now while I executing the aspx page , I am getting above error . I have checked that the store procedure has execute permission for webuser account and dbo(i.e SA) has all the permissions for all database objects . Still why i am getting error ? (Please note , the thing is working fine in test server)



Pl help



Regards

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved