SQL Server :: Set Execute Permissions For Website At Web Host?
Sep 8, 2010
I have just 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 dreaded
The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'.
error. I can't set the permissions from within Visual Studio, can I?
What should I ask the web host to do?
a) Should I ask them to globally set execute permission on ...?
b) Should I ask them to set execute permissions to ... for only INSERT/DELETE/UPDATE stored procedures?
c) Should I ask them nothing, and handle this myself? If so, then how? And, the question remains, should I set execute permissions globally or on a per stored proc basis? And what's the name of the user who needs the property set correctly?
The reason why I ask these questionsis that I used to work with winfomrs at a university. There people should have different permissions depending on what group of users they belonged to.
View 4 Replies
Similar Messages:
Jun 17, 2010
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 Replies
Sep 9, 2010
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.
View 4 Replies
Sep 14, 2010
I have my SqlServer 2005 database at a web host. I recently figured out how to set permissions for the stored procedures (see this link if you face the same problem:
[URL]
Now I wonder: What permissions should I give the website's visitors?
In a stored procedure's Properties window, I have three availabale users, the db owner (the db name), "guest" and "public". My bet is on public.
As far as permission types go, I hev the following available:
Alter, Control, Execute, Take Ownership, and View Definition. My guess is that the one of interest is Execute, correct?
In other words, should I set all stored procedures to Execute for public (not that I seem to have the permission to do that myself - I get an error message when I try to alter them)? If so, could I ask the web host to set them globally for me? Or should I only set stored procedure using UPDATE/INSERT/DELETE to Execute?
View 4 Replies
Feb 19, 2011
I'm trying to run a website (site2) that I've placed inside a folder (dir-site2) of another website (site1). The default file of site2 displays fine in every browser on my local computer, as in when I type http://localhost:45912/www.site1.com/dir-site2/default.aspx. But when I upload everything to my host's server and type this
http://www.site1.com/dir-site2/default.aspx I get a server "can't access" error message. I can't display any file that is inside the subdirectory, dir-site2.
View 2 Replies
Mar 3, 2011
A client has sent me their web site and I got it to work on my local machine, but after hosting it on my website under a sub domain I get the following error:Required permissions cannot be acquired.did some searching and tried messing with the trust tag in web.config, but then that told me:This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using from an inherited configuration file.
View 1 Replies
Aug 19, 2010
ot the following error when click print report button.Application : asp.net 3.5Crystal report : 10.5Host: godadRequired permissions cannot be acquired.
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.
[Code]....
View 2 Replies
May 14, 2013
I have created a asp.net website.At present its wokng in local host.How to host my site in IIS.What are the steps to be followed
View 1 Replies
Feb 1, 2011
We have a virtual server hosted to the third party which we access through remote desktop. We have Sql server 2008 on Windows 2008. I created a website on my local hard drive and now we are ready to deploy. My question is what are the recommendations for publishing websites? What steps I need to take care of? Is it possible not to deploy the "code-behind" files. Incase of hacking of windows server, I do not want somebody to see my .vb files or Is it possbile that I can convert the whole thing except aspx files in to a strong dll?
View 3 Replies
Aug 28, 2013
How to host asp.net website on server when I am using mysql database i have turned off iis services so how can i used http in start of creation of new website i have database mysql...
View 1 Replies
Mar 10, 2011
I am looking through a sql stored procedure which I might need to update in the near future. Basically the stored procedure is about 20 lines long. The stored procedure first builds a query
and stores it in a variable named "@Sql". And then for the last two lines of the stored procedure it appears that the big sql statement stored in "@Sql" is executed by using the "EXEC" command. See below. What is confusing though is that the query appears to be exectuted twice? Why was the query written in this way. Don't both lines do the same thing? Why is it being done twice? Could this possibly be a mistake on the
part of the person who wrote the query. Below are the two lines I am talking about?
EXEC sp_executesql @sql
EXEC (@sql)
View 4 Replies
Mar 30, 2010
I need to run the HttpContext.Current.Server.Execute method in my ASP.NET application. This application has a WCF operation that does some processing. Currently, I am to do my processing correctly from within my WCF operation. However, I would like to do this asynchronously.
In an error to attempt this asynchronously, I tried running Server.Execute in the DoWork event handler of a BackgroundWorker. Unfortunately, this throws an error that says
"object reference not set to an instance of an object" The HttpContext element is not null. I checked that. It is some property nested in the HttpContext object that appears to be null. However, I have not been able to identify why this won't work. It happens as soon as I move the processing to the BackgroundWorker thread.
My question is, how can I asynchronously execute the Server.Execute method?
View 1 Replies
Oct 7, 2010
I've got an ASP.NET website, and its connecting to a database I've created on SQL Server 2k8 and I'm using windows integrated security on my connection string between asp.net and SQL Server. What account should I give permissions to my database inside SQL Server? Should I give NT AUTHORITYNETWORK SERVICE permission to my database? Right now, I right clicked the network service account, and went to properties, and then I checked my database under "users mapped to this login:" and then in the "database role membership for" diaglogue I then selected public and db_owner. Is that right?
View 1 Replies
Nov 24, 2010
I have a website has already hosted on EasyCgi (suppose that it's called website1). I have to host another one (website2). So I created a folder called "website2" under the website1 root folder. then I FTP all the content of website2 to the "website2" folder.After that, I tried to request the URL: and nothing happen...Just an error page display that contains:
View 1 Replies
Mar 9, 2010
I'm new to .NET. And created a website using
ASP.net 3.5 (.aspx as frontend)
VB.net(aspx.vb as backend)
SQL Server 2000 as backend
Now I want to host the site within our intranet network. But I can't.
I don't know about web.config in detail.
View 2 Replies
Jul 24, 2010
I have developed a website named MyWebsite. All the .aspx and .aspx.cs files and the App_Code folder resides in C:MyWebsite folder.
I have IIS 7 installed on my PC (OS windows 7 professional). I developed the site in visual studio 2005 in c# and used sql server 2005.
Now I want to set up a web server on my pc and host this site so that i can access this site from this or any other computer on the network.
I searched the internet and found many articles on it. Accordingly I tried to add a new site through the IIS Manager dialog box. But things did not work out.
View 4 Replies
Dec 20, 2010
I have the public ip i want to access my website in another system through internet how can i host through public ip
View 2 Replies
Jan 12, 2010
I'm trying to run a little ASP.NET project in a subfolder of my hosting. My domain is [URL], but i want to run my app in www.gorangligorin.com/testmvc. ASP.NET MVC runs with no problems on the top level, but not in subfolders.
The server says this (line 58 is colored red):
Line 56: ASP.NET to identify an incoming user.
Line 57: -->
Line 58: <authentication mode="Forms">
Line 59: <forms loginUrl="~/Account/LogOn" timeout="2880" />
Line 60: </authentication>
What can I do to make this ASP.NET MVC website work? This isn't hosted on my computer, so I don't have access to IIS configirations.
View 3 Replies
Oct 6, 2010
Can we have a solution which has a webservice project alone and host it in IIS. Or do we always need a website attached to webservice, and the website is to added into IIS
View 2 Replies
Jul 9, 2010
I've followed this link [URL] to configure my application on iis7.
- I've published it
- create a folder in inetpubwwwrootMyApp
- I've created my virtual directory to point on MyApp
but then to log on it, I need to point on http:\localhostMyApp but i would like to point on http:\localhost
View 1 Replies
Feb 9, 2010
how to host asp.net website using sql data base. i published sql.mdf file. is it (sql.mdf) possible to place in app_data folder?
View 1 Replies
Jan 5, 2011
I am developing an ASP.NET Web Service and a PHP Web site consuming the Web Service. They are meant to be run on different machines. However, only for development purposes, I need to run both on my machine. I cannot use virtual machines.
I would like to know if it is possible to configure IIS Apache to host both my Web Service and my Web site? Or, do I need to host the PHP site using Apache?
I am using
IIS 7.5 Apache HTTP Server 2.2 (NOTE: I have nothing against Apache. In fact, so far I like it more than IIS, however, I would rather not have two Web server applications installed in the same machine.)m PHP 5.3.4
.NET Framework 2.0 3.0 or 3.5 (whichever comes with Visual Studio 2008)mod_aspdotnet for Apache 2.2
View 4 Replies
Jul 26, 2010
I have done an application in my PC i would like to access it on other pc how can i do this.
View 4 Replies
Mar 9, 2011
I have created a C++ dll. It works fine and does the job. I have created methods in asp.net that call the methods in C++ dll. DLL path is absolute. It works fine too. I then published the website onto a folder and hosted the website on IIS. I get an error message Exception Details: System.DllNotFoundException: Unable to load DLL 'FilesCreator.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
View 1 Replies
May 4, 2010
I have a Windows 7 machine hosting a Windows 7 virtual machine. I am developing a web application using visual studio 2010 on my host machine. I want to run the application in debug mode and access my localhost server from a browser on the virtual machine. (The purpose of this is to be able to debug an application that uses Windows Authentication using different users without having to log off and on for different users on my host machine...)
I am using a bridged connection for the virtual machine. I googled how to solve this problem and most of the threads that I found said that if I was using a bridged connection, I could access the server on the host machine by just entering the IP address of my host machine into the url in the browser of the virtual machine. I have tried some different urls using the IP but none of them have worked.
As an example, suppose I run my web application in visual studio on my host machine and its url is
http://localhost:62789/MyPage.aspx
Assume also that I ran ipconfig in CommandPrompt on my host machine and found out that the IP address for my host machine is xxx.xxx.xxx.x. What url should I enter on the virtual machine to access my web application?
EDIT:
I set up IIS to host the web project. After that, I just added the following line (xxx.xxx.xxx.xxx is my IP) to my hosts file and I was able to access the website from the virtual machine:
xxx.xxx.xxx.xxx MyWebsite.net
I also had to edit my firewall settings.
View 2 Replies
