Permission Error Again

Dec 12, 2006

I am using an ERP system with SQL Server as the back end. When our user tried to run a function in ERP system, they got the following error:

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Grant', database 'HEI', owner 'dbo'

I ran "sp_helprotect Grant" to check the permission, it looks okay.

When I used the administrator's User ID to login to the machine and ran the same function in ERP, it works fine.

Anyone knows how to fix it?

View 1 Replies


ADVERTISEMENT

OLE DB Error: OLE DB Or ODBC Error: You Do Not Have Permission To Run 'SP_TRACE_CREATE'.; 42000

Dec 12, 2007

I keep getting this error:
OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000

I do not want to add the login account to sysadmin role on my production server and giving the logon account db_reader rights to my database is not working. Is there another way around it.

View 3 Replies View Related

Permission Error

Aug 7, 2006

i have my sql server database set up but when i try to run my app i get this error:http://img308.imageshack.us/img308/2862/untitledep4.pngany help you be grateful :)

View 4 Replies View Related

Permission Error

Mar 27, 2001

I have developer who is working With VB using COM objects for creating a webpage, and he is making a connection to SQL server using NT account. the NT account has datareader,datawriter and exec SP on the database that the COM objects is calling. But he get the following error 'Login failed for user 'NT AUTHORITYANONYMOUS LOGON''when click on the webpage that was creted using VB.

Does anyone know why would this happend.

Thank You,
john

View 1 Replies View Related

Permission Error

May 5, 2008

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]You do not have permission to use the bulk load statement.

I am getting this error when running from an asp script and trying to execute my stored procedure that reads an xml file.

Please advise?

View 3 Replies View Related

Permission Error

Nov 1, 2007

Salam Friends:

I try to run ETL but i see this message

[OLE DB Destination [8408]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Bulk copy failed. User does not have ALTER TABLE permission on table 'ResearchTable.RD7_JournalAuthor'. ALTER TABLE permission is required on the target table of a bulk copy operation if the table has triggers or check constraints, but 'FIRE_TRIGGERS' or 'CHECK_CONSTRAINTS' bulk hints are not specified as options to the bulk copy command.".


the use i use have select, insert, and delete permission

View 4 Replies View Related

Permission Error

Dec 1, 2006

I am using an ERP system with SQL Server as the back end. Yesterday, I tried to grant the access to myself on one table, but somehow it didn't work successfully.

I dunno if it is because of this, it affect other users's security. When they tried to login to the ERP system, the got the following error message:

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Grant', database 'HEI', owner 'dbo'

Anyone knows how to fix it?

View 1 Replies View Related

Database Permission Error

Jul 20, 2005

Andy,I am new to SQL. It was hard just to figure out how to install it.I know I am logged in as a Admin. in Windows.I have the little server box with the round circle on it in the bottom rightcorner(toolbar). The SQL Server Service Manager.I tried to search for the sp_helpsrvrolemember command on my drive. It'snot on the server.Any ideas?Do anyone have any suggestions?Thanks for your help,T"Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in messagenews:#3883ky6DHA.2628@TK2MSFTNGP10.phx.gbl...[color=blue]> Are you connecting with a trusted connection or as sa. It sounds like you> do not have the access required to create a database. Make sure you are> connecting in as a member of the Administrators group on that machine so[/color]you[color=blue]> become part of the sysadmin (aka System Administrators) role. At a[/color]minimum[color=blue]> you need the dbcreator role level access. Running>> sp_helpsrvrolemember 'sysadmin'> -- or --> sp_helpsrvrolemember 'dbcreator'>> will tell you who belongs to these roles. Looking at the Query window[/color]title[color=blue]> bar will tell you who you are logged in as.>> <servername>.<database name>.<loginname> or <DOMAIN><username> (for Win[/color]NT[color=blue]> authentication)>>> Reboot and sharing the folder will not help. You might want to check the[/color]NT[color=blue]> permissions though.>> --> ************************************************** *****************> Andy S.> MCSE NT/2000, MCDBA SQL 7/2000> Join Bytes!>> Please remove NOMORESPAM before replying.>> Always keep your antivirus and Microsoft software> up to date with the latest definitions and product updates.> Be suspicious of every email attachment, I will never send> or post anything other than the text of a http:// link nor> post the link directly to a file for downloading.>> This posting is provided "as is" with no warranties> and confers no rights.>> ************************************************** *****************> "Taishi" <taishi_bak@hotmail.com> wrote in message> news:%23ZocZIy6DHA.2568@TK2MSFTNGP10.phx.gbl...[color=green]> > Windows Pro> >> > Receiving the following error:> >> > CREATE DATABASE permission denied in database 'master'. Could not attach> > database 'pubs' to file 'D:Program FilesMicrosoft SQL> > ServerMSSQL$NETSDKDatapubs.mdf'.> >> > Here are some things done to try to resolve the problem:> >> > Reboot 4-5 times> > Shared out the folder> > Web shared the folder> >> >> > Thanks for your help,> > T.> >> >> >[/color]>>[/color]

View 11 Replies View Related

SRS Reporting Permission Error

Jan 3, 2007

I have my reporting server running on server1 my web server is running on SERVER2. I have a web application the renders a report using the srs2005 web service. It works fine. I try to add another server server3 the application that runs that code is now getting the following error. I know I had to give permissions to the the server I just do not remember were.

System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user DOMAINSERVER3$' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The permissions granted to user DOMAINSERVER3$' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user DOMAINSERVER3$'' are insufficient for performing this operation. --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Probation.UI.Kiosk.RSWebReference.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) at Probation.UI.Kiosk.ProbationerQuestions.UploadToFileNet(Int32 ResultId) at Probation.UI.Kiosk.ProbationerQuestions.WriteOfficeVisitCompleted() at Probation.UI.Kiosk.BtnYes_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at Probation.PageFrameWork.ErrorHandlePage.ProcessRequest(HttpContext context)

View 3 Replies View Related

DBMail Permission Error

Feb 18, 2006

I am using DBMail to send an email notification at the completion of service broker process and have been getting the following security error:


Msg 229, Level 14, State 5, Procedure sp_send_dbmail, Line 1

EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

I have given the userID used to run the Service Broker, databasemailuserrole in msdb as per instruction in the msdb. I have also given it execute permission on the sp_send_dbmail but keep getting the error. The service broker is run using a sql login and the dbmail profile is set as public profile. Any suggestions would be much appreciated.

View 6 Replies View Related

Permission Error On Drillthrough

Jun 27, 2007

I've published a matrix type report through report builder to my report server, based on the model I created. When I click the subtotals to drillthrough, I receive the following error:



"The permissions granted to user 'Domainuserid' are insufficient for performing this operation. (rsAccessDenied)"



If I explicitly specify another report to tie to the drillthrough property on the entity via the model property page in SSMS, the drillthrough stuff works fine. But if I just rely on Reporting services to auto generate ( see "Autogenerated" here ) the clickthrough report I get the error above. Can anyone help?

View 1 Replies View Related

Do Not Have Permission Error Message

May 24, 2007

I have been trying to run a script that modifies objects in a SQL Server 2005 database. I am trying to drop an index but I am told the index does not exist or I do not have the correct permissions. An example of one of the commands in the script that I am trying to execute are as follows.

command:
DROP INDEX spices.ADAPTER_MESSAGE.ADAPTER_MESSAGE_SET;

response:
Msg 3701, Level 11, State 6, Line 1
Cannot drop the index 'spices.ADAPTER_MESSAGE.ADAPTER_MESSAGE_SET', because it does not exist or you do not have permission.


The index does exist in the table so the problem must be related to permissions. I am the one who created the database so I am the dbo. I should have permission to do anything in the database, right? So why am I getting this error when my script runs?

thanks,
shimo

View 9 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

User Does Not Have Permission (error 15247)

Apr 1, 2007

Hi,I have installed sql server 2005 express on a Windows xp system with windows authentification. I did this with my administrator account (dan). When i start sql server management studio, i see: user name: myserverdan .Now i want to create a new login, so i rightclick on 'logins' in 'Security' of 'Database'. I take an existing windows-account, but when i click on OK, i get the error: user does not have permission to perform this action (error 15247).I also tried to delete a login, but same error.Any help would be appreciatedT.

View 2 Replies View Related

Error: Grantor Does Not Have Grant Permission

Jan 4, 2006

Hi all,Before using SQL Server 2000 Developer Edition I did not get this error message. I had been using the trial edition of SQL Server 2000.I only get it with stored procedures.I solved my problem by giving the ASPNET login "db_owner" privs, which I didn't need to with the trial edition and is not best practice from a security angle.I login under the Windows based admin account. (not using mixed mode).Hope someone can shed some light.Thanks.

View 1 Replies View Related

Permission To View Error Logs

Jan 4, 2001

How can a person view the error logs without being an sa?

View 1 Replies View Related

Error In Report Server Priveleges Permission

Mar 20, 2007

I have just installed sql server 2005 developer edition with ssrs

I am getting following error

When Browsing

http://localhost/ReportServer$Yukon/
Reporting Services Error
--------------------------------------------------------------------------------

The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

--------------------------------------------------------------------------------
SQL Server Reporting Services

**********************************************************************************************************

When editing Surface Area Configuration


TITLE: Surface Area Configuration
------------------------------

System.Web.Services.Protocols.SoapException: The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService.SetSystemProperties(Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties) (System.Web.Services)

------------------------------
BUTTONS:

OK


**********************************************************************************************************

Also When I connect from management studio for the reporting services instance I get the same error of insufficient privilge

TITLE: Microsoft SQL Server Management Studio
------------------------------

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

------------------------------

The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

------------------------------
BUTTONS:

OK
------------------------------

**********************************************************************************************************





What Am I missing ?

But While browsing report {not server } works fine

View 1 Replies View Related

Getting Permission Denied Error In ExecuteSQL Task

Aug 21, 2006

The purpose of the Package is to load an SQL table with data from text files in a subdirectory. The parameter is parsed from the text filenames. It is a zipcode.

I have an ExecuteSQL task inside a ForEach container. The SQL in the task is:

IF EXISTS (SELECT * FROM dbo.ZipCodeRadius
WHERE CenterPostalCode = ?1)
BEGIN
DELETE FROM dbo.ZipCodeRadius
WHERE CenterPostalCode = ?1
END

I also have a Data Flow task in this container which populates the ZipCodeRadius table. The same parameter is also passed to the Data Flow task which specifies a zipcode to delete and afterward load.

I am using Windows authetication for the package.
What am I doing wrong?

Fred

View 21 Replies View Related

Error:User Does Not Have Permission To Perfor This Action.

Feb 7, 2006

I just installled the Visual web developer - express addition. When I try to add aSQL database to my project it gives the following error - "User does not have permission to perfor this action" . Can someone please help?

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

SQL 2012 :: Select Permission Error On Insert Statement

Jul 28, 2015

Have run to a select permission error when attempting insert data to a table. received the following error

Msg 229, Level 14, State 5, Line 11
The SELECT permission was denied on the object 'tableName', database 'DBname', schema 'Schema'.

Few things to note
- There are no triggers depending on the table
- Permissions are granted at a roll level which is rolled down to the login
- The test environments have the same level of permission which works fine.

View 6 Replies View Related

Insert Permission Denied After Granting Permission

Sep 19, 2007



SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B" -
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema?

Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D". No Problem - stored procedure executed fine with the Insert.
I attempted the Insert statement again - straight SQL - as User "A" and got the same error as above ("Insert Permission Denied.....")
Strange behavior - cannot do a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?


View 2 Replies View Related

ERROR 229: SELECT Permission Denied On Object 'sysobjects', Database ....

Sep 27, 2007

Hi,

I granted all the rights on the database to the user (db_owner, public, db_datawriter, etc...) However, I didn't grant the "System Administrators" role. I also specifically granted the select on those tables (sysobjects and sysindexes) for the user and checked through ‘sp_helprotect sysobjects’ command whether there are no specific revokes for for that user.

However, the user is still getting the below error while trying to expand the "Tables" view in the Enterprise Manager.

ERROR 229: SELECT permission denied on object 'sysobjects', database 'My_test', owner 'dbo', SELECT permission denied on object 'sysindexes', database 'My_test', owner 'dbo'.

Also, the user claims that he can’t seem to do anything with the database, he can’t view any objects, and, when he goes to Query Analyzer, if he tries to run a SELECT query on a table (that he know that this table exists), he gets this error:



SELECT permission denied on object 'tblBillingTrans', database 'My_Test', owner 'dbo'.

Any help would be greatly appreciated!
Thanks,
Alla

View 7 Replies View Related

Severe Error Occurring When Creating Assembly With External Access Permission

Jul 11, 2006

I had created a CLR function in my db and was able to execute it successfully a couple of months ago. But when I tried to execute it today it was throwing errors saying there was something wrong with the permissions on the assembly. So I decided to drop everything and recreate it except I can not longer create the assembly with EXTERNAL ACCESS permissions. Whenever I try to create the assembly I get the followng error:

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

I also tried to create the assembly with Unsafe permissions and got the same error. Does anyone know why this error would be occurring now? I tried creating the same assembly on a different SQL 2005 server and it creates successfully and can be executed successfully. Any help would be greatly appreciated!!



Thanks!

GN

View 3 Replies View Related

Sp_droplogin Gives Error SELECT Permission Denied On Object 'sysjobs', Database 'msdb', Owner 'dbo'.

Mar 19, 2008

Hi,

When I am trying to drop a user using following statement

--First remove access from all databases
Set @SQL =
'
USE [?];
if ''' + @login_name + ''' in (Select name from sysusers )
EXEC [?].dbo.sp_revokedbaccess @name_in_db = N''' + @login_name + ''';
'
Exec sp_msforeachdb @SQL
Print 'Access Removed.'

exec @ret_value=master.dbo.sp_droplogin @login_name

I am getting an error,

User has been dropped from current database.
User has been dropped from current database.
Access Removed.
No permission to access database 'model'.
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'sysjobs', database 'msdb', owner 'dbo'.

Login dropped.

The SQL Version I am using is
-------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)



Please help me to solve this issue.

Mujeeb.

View 5 Replies View Related

Error Creating First SQL Express Database Via VWD 2005 Express: User Does Not Have Permission To Perform This Action

Aug 18, 2006

I get an error dialog when I try to create a new SQL database, both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is:


Local Database File:

User does not have permission to perform this action.

I've searched for help with this.

I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder).
The SQL Server Express error log is clean and indicates full functionality.
Everything is running locally.
No VWD installation errors.

Any ideas?

Thank you!

View 3 Replies View Related

CREATE DATABASE Permission Denied In Database 'master'. Error

Feb 1, 2007

got rid of my error about user login rights, it was all working yesterday. but for some reason i now get this error  CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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: CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

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): CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
  i have this in my web.config file     <connectionStrings>        <add name="ConnectionStringTest" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf;Integrated Security=SSPI;Connect Timeout=30;User Instance=False"            providerName="System.Data.SqlClient" />    </connectionStrings>    <appSettings />         <system.web>        <!--             Set compilation debug="true" to insert debugging symbols into the compiled page.            Because this affects performance, set this value to true only during development.        -->      <compilation debug="true" />      <identity impersonate="true"/>  and my asp connection string is         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringTest %>"            SelectCommand="SELECT [entryID], [compID], [emailAddy], [answer] FROM [entry]"></asp:SqlDataSource>  if i set user instance to true i get a user permission error.  it says on sql server management that i have dbo rights on my database, but it wont let me put datareader or write on this login. any ideas? its driving me insane 

View 4 Replies View Related

&"EXECUTE Permission Was Denied&" Error

Mar 11, 2008

Im having problems executing a stored proc...

here's what i did:
1. create a stored procedure using sql server management studio. it was successfully created.
2. i then tried executing the newly created sp and here's what i get:

The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'.



what shall i do?

View 16 Replies View Related

Cant Create New Database / CREATE DATABASE Permission Denied In Database Master (error 262)

Oct 2, 2007

 
 I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
 
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated
 Prontonet
 
 
 

View 4 Replies View Related

Permission-1

Sep 13, 2007

http://www.abvalve.com/careers/form/
can someone please tell me whats the problem with this?
I actually gave that user permission and and still did not work, the DB is in the appdb folder and the network services user is granted full permisions on that folder!
Any ideas

View 1 Replies View Related

Permission

Jan 18, 2008

every things at sql2005 have to permission
table , create , select , stored procedure
every things have to make permission to NT AUTHORITYSYSTEM
at last i do every thing without permission how can i make it without it

View 4 Replies View Related

Don't Have Permission

Jan 27, 2008

I tru to add connection to my db in Visual Web Developer 2008 express.
Data source: - I use Microsoft SQL Server Database File (SqlClient).
Under Data File Name: I browse and choose the database and I get this error message
"ECommerceDbYou don't have permission to open this file. Contact the file owner or an administrator to obtain permission." WHat should I do? I already give full control to all users.
My environment is ms sql 2005 express and window vista business version. Thanks for any help.

View 1 Replies View Related

DTS Permission

Mar 8, 2001

I have created a DTS package that get a information form a text file and insert the data into a table and package is save as Structured Storage File. Now I am calling this DTS package thru VB application. The pacakge is save under folder that is shared to everyone.

When I run the VB application it runs fine using my login. but when I login as other user(webapp) it does not work. Webapp has DBO rights to the database that importing the data.

I am not sure if this is a permission issue or not.


Thank You,
john

View 1 Replies View Related







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