in Visual Studio 2005 I have a what is now called in 2005 a web site that
when run as a file base web connects fine to SQL Express running on the
local machine. However, when I publish this web to a sub web of the default
web in IIS on the local machine, and load the page that accesses SQL Server
Express in the browser it produces a permission error for ASPNET.
How do I grant ASPNET permission to SQL Server Express? I have read that I
should add ASPNET to the Administrators group, but that didn't work, and it
is something that I don't really want to do for security reasons. 2 2559
You need to give the account you are running the website under access to the
SQL Database. When running in IIS (and depending on your config settings)
the website may be attempting to access the database with the IUSR_[Machine
Name] or ASPNET account. You'll need to give the proper account permission
to the tables or stored procedures it needs.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"William LaMartin" <la******@tampa bay.rr.com> wrote in message
news:er******** ******@TK2MSFTN GP11.phx.gbl... in Visual Studio 2005 I have a what is now called in 2005 a web site that when run as a file base web connects fine to SQL Express running on the local machine. However, when I publish this web to a sub web of the default web in IIS on the local machine, and load the page that accesses SQL Server Express in the browser it produces a permission error for ASPNET.
How do I grant ASPNET permission to SQL Server Express? I have read that I should add ASPNET to the Administrators group, but that didn't work, and it is something that I don't really want to do for security reasons.
Exactly were do I go to change the account permission? I have looked
everywhere I can think of but can't find it. All I can find is the SQL
Server Configuration Manager, but it does not appear to have anything in it
to do this. Is it done via a command prompt command? And if so, what
command?
"S. Justin Gengo" <justin@[no_spam_please]aboutfortunate. com> wrote in
message news:uk******** ******@TK2MSFTN GP10.phx.gbl... You need to give the account you are running the website under access to the SQL Database. When running in IIS (and depending on your config settings) the website may be attempting to access the database with the IUSR_[Machine Name] or ASPNET account. You'll need to give the proper account permission to the tables or stored procedures it needs.
-- Sincerely,
S. Justin Gengo, MCP Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order." Nietzsche "William LaMartin" <la******@tampa bay.rr.com> wrote in message news:er******** ******@TK2MSFTN GP11.phx.gbl... in Visual Studio 2005 I have a what is now called in 2005 a web site that when run as a file base web connects fine to SQL Express running on the local machine. However, when I publish this web to a sub web of the default web in IIS on the local machine, and load the page that accesses SQL Server Express in the browser it produces a permission error for ASPNET.
How do I grant ASPNET permission to SQL Server Express? I have read that I should add ASPNET to the Administrators group, but that didn't work, and it is something that I don't really want to do for security reasons.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Wayne Wengert |
last post by:
I am using VS.NET 2003, VB.NET, ADO.NET and an Access 2000 database. I want
to display a list of all tables in an Access database. I want to put that
list of table names in a listbox so the user can select the table they want
to use. How can I do this?
--
------------------------------------
Wayne Wengert
wayne@wengert.org
|
by: Paul D. Fox |
last post by:
Hi
I'm running Windows Server 2003 as a Domain Controller (with Active
Directory) as a development server. I created an app that uploads graphics
but it doesn't have permission. ASPNET machine account requires permission.
The problem is, this server is a domain controller so there is not a local
ASPNET account. How can I rectify this ?
Paul
|
by: Keith |
last post by:
I have a small ASP.NET app that someone designed which I need to run on our
server.
The server is Windows 2000 Server and has the .NET Framework installed.
How can I give ASP.NET permission to run?
On my dev machine I give the local ASPNET user read/write permission to the
folders it needs to access, but as this is a server, the ASPNET user does
not exist.
|
by: Ian Taite |
last post by:
Hello All,
ASP.NET has stopped working on my development server. I've read the
various posts re this subject, but my circumstances seem unique. I
need to know what causes the problem and how to remedy it. If possible
I would prefer not to rebuild the server, as the SQL setup is quite
involved, and I'd prefer not to add the ASPNET account to the local
administrators group since that defeats the point of having the ASPNET
account.
|
by: jay |
last post by:
I am attempting to impersonate an account in ASPNET. I am using
aspnet_setreg to store the username and passwords. I have given the
ASPNET account permisision to read the registry values. However, the
application throws:
"Could not create Windows user token from the credentials specified in
the config file. Error from the operating system 'A required privilege
is not held by the client'."
This occurs even when the ASPNET account has...
| |
by: fniles |
last post by:
In our ASP page, we call XMLHttp to download XML files. When calling our
page using localhost (localhost/myWebSite/myPage.htm), it works, but when
calling using the IP address of the web server
(xx.x.x.xxx/myWebSite/myPage.htm), I got "Permission denied" error in the
HTTP.Open statement.
Set http = CreateObject("Microsoft.XmlHttp")
http.open "Get", "http://" & "xx.x.x.xxx" & "/XMLFiles/N-1min.xml",
ALSE --> permission denied error
|
by: torus |
last post by:
Is the aspnet account called "aspnet" for all non-English versions of
Windows and IIS?
|
by: raylopez99 |
last post by:
I am trying to program a database from inside C++.NET via Visual
Studio 2005 using the ADO.NET set of classes, but this I believe is a
SQL Server 2005 Express permissions question under Windows XP
Professional OS.
In another thread, http://tinyurl.com/373lzx, I was able to open a
database successfully using VS2005 (thanks to a suggestion by Erland
Sommarskog). But subsequent to this I played around with the local
policy permissons...
|
by: Mich |
last post by:
Hi,
i'm building an web application for anonymous users. They can take a look in
the website, nothing more. In order to perform other actions, the anonymous
user must be logged. So i create an aspx page with the CreateUserWizard
control. The user can fill his username, password etc ....
My problem is: when an user fills everything and clicks on button "create an
account", nothing happens (no error, but no user account created).
I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |