While i am deploying my solution in to sharepoint, it is showing:
"Inner exception(1): The EXECUTE
permission was denied on the object
'proc_putObject', database
'SharePoint_Config', schema 'dbo'".
Unable to deploy the solution.
I have upload my files in domain.after uploading,i run the site.i get the following error The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'. what reason for this error raised and how to solve it?.
View 2 RepliesI am really face with a difficult problem that i have been battling for the past week. My application requires a login. I am Using asp.Net services (membership and roles) to manage members who login. The application performs very well on my local computer.
However, when i transfered it to my web hosting server (production server), I am faced with this horrible execute permission below
(The EXECUTE permission was denied on the object 'aspnet_Membership_GetPasswordWithFormat', database 'GuardwellProjectDatabase', schema 'dbo'.)
Another issue is that i am using a shared hosting site with my hosting company and on contact them with the problem, the said it is not possible to grant me execution permission.
Server Error in '/' Application.
The EXECUTE permission was denied on the object 'aspnet_Membership_GetPasswordWithFormat', database 'GuardwellProjectDatabase', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'aspnet_Membership_GetPasswordWithFormat', database 'GuardwellProjectDatabase', schema 'dbo'.
I only get the below error when trying execute a stored procedure with a linked server table in it when im logged in as a sql user not a windows or domain user.OLE DB provider "" for linked server "" returned message "Unspecified error". Msg 229, Level 14, State 5, Procedure sp_tables_info_rowset_64, Line 7 EXECUTE permission denied on object 'sp_tables_info_rowset_64', database 'master', owner 'dbo'.
View 5 RepliesI am getting the error message "SELECT permission denied on object 'MyTable', database 'MyDB', owner 'dbo'.", when trying to run a small asp.net application via a browser where i work.
I built it on my local machine(VS 2008, C#) and transferred over to an IIS server(i.e. Windows Server 2003) and I have also enabled the application folder in IIS.
It runs fine on my local machine. Connection string in web.config on my local machine <add name="connstring" connectionString="Data Source=DBASE;Initial Catalog=MyDB;Integrated Security=true" providerName="System.Data.SqlClient"/>
on the server, connection string is <.......;User Id=userid;Password="mypassword" />.
But when i swapped connection string on server to use <Integrated Security=true>, and tried to run from a browser again, i get:
Login failed for user 'SVRSERVERNAME$'
I have a couple of other apps I built in the past and they are running fine, I didn't do anything special, just transferred them as normal to server and ran through browser
In fact, one of my previous apps even uses the same table and database. but with this new app, I don't know why it wouldn't work even though it runs perfect on my local machine
I can access the database manually from SQL Management studio, i connect to it using my Windows account or the given username/password credentials.
Other thing I noticed, when I changed the connection string on my local machine web.config to use <User Id=userid;Password="mypassword">, i then get same error as if it was running from the server:
SELECT permission denied on object 'MyTable', database 'MyDB', owner 'dbo'.
my company create for me a new database in new server hosting
the problem is that with new user's database, i cannot execute SP it return error that the user "username" do not have execute permission
the actual permission are :db_datareader,db_written,db_ddladmin
it seems not enought must i ask for add db_owner schema rom to user?
I have recently succeeded doing a Publish to server from my local sql db and run the sql script on my web host's sql server 2005 db. Now, I get the "The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'." error.I have Visual Studio Professional 2010, and that's where I create and manage my tables (in Server Explorer). However, when I right-click a stored procedure, I don't get a Seurity option or the like, where I could possibly set permissions.
I'm a bit usure of what SqlServer applications I have installed (as they are intertwingled with the Aps.Net stuff somewhat). When I look at Add/Remove software, this is what I find:
Microsoft Sql Server 2008 (562 MB)
Microsoft Sql Server 2008 Native Client
Microsoft Sql Server 2008 R2 Data-Tier Application Framework
Microsoft Sql Server 2008 R2 Data-Tier Application Project
Microsoft Sql Server 2008 R2 Management Objects
Microsoft Sql Server 2008 R2 Transact-Sql Language Service
Microsoft Sql Server 2008 Setup Support Files
Microsoft Sql Server Compact 3.5 SP2 ENU
Microsoft Sql Server Database Publishing Wizard 1.3
Microsoft Sql Server Database Publishing Wizard 1.4
Microsoft Sql Server System CLR Types
Microsoft Sql Server CSS Writer
Can I use any of these apps to set the security settings? Or would I possibly not be allowed to change any settings at the web host's Sqlserver 2005 server anyway (due to security reasons)? Frankly I don't think I could ask them to change the settings for over a hundred stored procedures, and then call them each time I create a new one.
And also, I can't understand what the point would be in setting different security levels on SELECTs and UPDATEs etc. After all, all my pages call UPDATE statements (for collecting statistics). I guess that the host could set execute permissions on the entire folder (not sure though) but it would of course be a stupid idea if I'm wrong regarding this matter.
I am having IIS server and SQL server on two different machines.
In the SQL server I created a new user using the SQL Authentication.
In my application I am using a connection string like this:
<add name="UsrConnectionString"
I am following this link:
http://msdn.microsoft.com/en-us/library/aa701256(office.11).aspx to research on Excel project.
Everything works fine during development. When I publish to local computer IIS, I cannot open the excel file. The error is:
Could not load file or assembly 'DiagramOrder, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)
I think it is related to Security Configuration and found this link: http://msdn.microsoft.com/en-us/library/zdc263t0(VS.80).aspx. I use step
To grant full trust to an assembly or folder on your local computer and also
To grant full trust to an assembly or folder on a network computer or mapped drive.
I also refer to
http://msdn.microsoft.com/en-us/library/9w6bd8f1(VS.80).aspx to add Msosec.dll
to have Full Trust.
After all the settings, I do restart computer. All the steps taken just cannot resolve the problem.
I am not try using caspol utility because I think it should same as what I did using UI. Correct me if I'm wrong.
Notes:
- Using ASP .NET Framework v2.0.50727 (.NET Framework 3.5 actually)
- IIS v5.1
how I can correct an error. I've built the MVCMusicStore tutorial here:
http://mike-ciccone.com/Store/
The first time I visit the site and attempt a database connection I get this error:
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
But when I refresh, it all works fine. I'm at a bit of a loss. I don't believe I'm attempting to create a database, but I realise that the error may not really have anything to do with that. This is hosted at GoDaddy shared hosting. The database was created and I used an SQL script to create the tables initially and populate the data. My connection string works as I can pull data from the database, but I do have
a feeling it will be a web.config setting that will correct this.
Using VS 2008, and i downloaded sql server 2008 that came with installation. I created an applicaton, which runs perfectly when i click run from VS. but when i moved it to wwwroot folder, this error poped up:
CREATE DATABASE permission denied in database 'master'.
Cannot attach the file 'C:InetpubwwwrootooksApp_Dataooks.mdf' as database 'books'.
This is my <connectionStrings>
<add name="books" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootooksApp_Dataooks.mdf; Integrated Security=True; trusted_connection = true; User Instance=False; Initial Catalog=books" providerName="System.Data.SqlClient"/>
i have three types of users and i want each one of them to reach only its pages not the othersi want to know what to do in database and the code
View 9 RepliesI have a web application with a textbox and a button. When i click the button with a folder name in textbox a .xml file should be created in C: folder getting all the data from a method which retrives data from DAL. But clicking on button gives the error of access denied. I dont have sufficient permission. But when i run visual studio as administrator, this permission error does not occur, instead some other error i get. How can i get this permission to run this application?
View 3 RepliesI just moved my website from one server to another.It is a simple website to display news. I used dnn for it. The news module is made of a NEWS_ADD.ascx control and a NEWS_EDIT.ascx control. Now on the new server, when I try to edit the existing news, or try to add a new one, it says: "you don't have permission to access /manageadmin/newsadmin/tabid/72/ctl/edit/mid/376/mode/add/language/fr-FR/Default.aspx on this server."
View 3 RepliesI have a SQL Server 2008 DB with many tables filled with data and I used SQL Server Management Studio to generate a SQL dump by using the Script Wizard : Tasks -> Generate Scripts -> Script All objects in the selected database and also selecting the option to Script Data. I made sure to change the value of "Script for Server Version" to "SQL Server 2008". Then I created a new DB and ran the SQL dump on the new DB to generate an identical copy of the old DB. Then I assigned permissions to my default user to the new DB. Then I changed the connection string on my ASP.NET application to use the new DB. But when I run it, it throws the following exception -
Server Error in '/myapp' Application. The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. 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.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
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:.........................
I have a ASP.NET 1.1 application running on IIS 6 / Windows Server 2003.It's our application, but we're trying to specifically replicate a customer's installation so the app folder has been copied entirely from their production server onto our test machine, and then we've created the Virtual Directory and Web Application for IIS manually.
View 1 Repliessing VS 2008 at a workstation, I have successfully developed a local, file-system ASP.NET 3.5 website. The wbesite included a membership page with Windows authentication and a web parts page. The SQL Server 2005 ASPNETDB database has been created at an IIS web servr. Using the ASP.Net development server of the workstation, both the membership Membership/WebParts pages at the local website worked very well.
Then, I copied the website to a virtual directory at the IIS web server and creates a remote website for the workstation. Under theASP.NET development server of the workstation, both membership and webparts pages of the remote website at the IIS web server also worked fine.
However, when running these web pages from the IIS web server machine, something wrong happened with the web parts page. (The membership page still worked very well.) For the ASPNETDB database at the IIS web server machine, there is an EXECUTE permission error on an ASPNET stored procedure.
What are the differences between the ASP.NET development server and IIS web sever, which caused the EXECUTE permission error on the ASP.NET S.P.? How to find and fix the errors?
am trying to implement fluent nhibernate in MVC project...there were no build errors... but when i run the project i get this exception
System.Xml.Schema.XmlSchemaValidationException: The element 'class' in namespace 'urn:nhibernate-mapping-2.2' has incomplete content. List of possible elements expected: 'meta, subselect, cache, synchronize, comment, tuplizer, id, composite-id' in namespace 'urn:nhibernate-mapping-2.2'.
have no idea what am doing wrong here... the following is the code for opening session factory...
[code]....
I am writing an internal web app for a company who wont to use their existing Active Directory Logins (rather than a seperate SQL Database User Login Table).
To do this I have done the following
web.config
<authentication mode="Windows">
<identity impersonate="true"/>
<authorization>
<deny users="?"/>
<!-- Allow Public Users to Access -->
<allow users="*"/>
</authorization>
<roleManager enabled="true"
defaultProvider="AspNetWindowsTokenRoleProvider"/>
End
This seems to work on my localhost but I have a couple of questions for you guys.
1) How does this process know which active directory to authenticate against? I know in code you can do
LdapAuthentication adAuth = new LdapAuthentication("LDAP://Server");
But there seems to be no way to do this in the web.config (I'm guessing it will just use the active directory on current machine it's running on?). Is there away to specify which active directory I'd like it to authenticate against?
2) If a user tries to access this remotely (i.e. not on their native windows account) what will happen, will it just default to a login form or just throw a "Permission Denied" error?
Using MS article http://msdn.microsoft.com/en-us/library/ms998317.aspx, I created a web site to develop a forms authentication solution for our web app. The server is Win 2003 w/IIS 6 and the app is VB.NET. The web.config was updated for forms authentication and settingsappear below:
<authentication mode="Forms">
<forms loginUrl="Login.aspx"
protection="All"
timeout="20"
name=".ASPXAUTH"
path="/"
requireSSL="false"
[code]...
In ASP.NET,How can i know the Specific details about an exception (like What kind of Exception it is (FileNotFound /Arithmentc etc..) )from a General Exception class object.
View 2 RepliesI have an ASP.NET page that calls to a WCF service. This WCF service uses a BackgroundWorker to asynchronously create an ASP.NET page on my server. Oddly, when I execute the WCF Service
[OperationContract]
[WebInvoke(Method = "POST", BodyStyle = WebMessageBodyStyle.WrappedRequest, RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
public void PostRequest(string comments)
[code]...
Oddly, when the currentContext.Server.Execute method is executed, it throws an "object reference not set to an instance of an object" error. The reason this is so strange is because I can look at the currentContext properties in the watch window. In addition, Server is not null. Because of this, I have no idea where this error is coming from.
First, I felt I had a clear understanding of how the Network Service account work. It is the default account ASP.Net runs under and has very limited access. I have verified in the Application Pool that ASP.Net is running under the Network Service Account. I have a UNC file share that is located on another server, let us say "\myservermyfiles". I have logged on to "MyServer" and right-clicked on the shared folder "myfiles" and just for the sake of testing, went to the Shared Tab->Permissions and added the Network Service account and gave it "change and read" access. I then went to the Security Tab, added the Network Service account and gave it all permissions. For some reason, I am still getting an "access denied" exception. I know impersonation is an option at some point, but I would really like to know why my ASP.Net application cannot copy a file to this share just for my own personal understanding given the fact that I gave the Network Service account the proper access. Like always, I will continue to research.
IIS 6
ASP.Net 2.0
I was just wondering if anyone has ever had to port the schema across? Are there any experts that could pitch their opinions on the achievability of this (mad) idea? I'm using the IBM Migration Toolkit and as expected its throwing a bunch of translation errors some of which were relatively easy to solve (vendor specific function calls for example) and some will take quite a while to pin down and work round.... however this is not my main concern.
If completed I expect I am going to have to basically rework all the System.Web.Profile/Roles/Membership namespace classes etc to work round the SQL limitations of informix (i.e. IDS11.x SQL server doesnt have a DEFAULT (newguid()) so that would have to be put into the calling method) (and any MVP comments really as I can slap my boss round with the weight after he ludicrously agreed to this project for a client without doing any research...)
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.