Thursday, March 29, 2012
Performance of datatable.select() func against database query or
I am developing a webportal on VS2005 and ASP.NET 2.0
Using MsSQL SERVER 2005.
I have some static records(around 15000) in the database.These contents
never changed while the application is running.
what i m doing is querying the database only once at the
application_start event of the global.asax file and storing the records
in dataset...and further no query to database is done for this data.
wherever I need this data I fetch it from the dataset...through
datatable.select(filter expression) method.this is done several time for
a single page request and the website is high traffic portal.
Is it an efficient way of doing or there is any other better way by
which I can achieve the same..,as the amount of data is very
large...approx 15,000 records.
Plz Suggest me ........
Thanxxxxxxxxxxxxxx
Regards
Deepti Yadav
NoidaOK, I will suggest you. 15,000 rows for a select is a lot of data to displa
y
in an ASP.NET web application. Are your users realistically going to need to
see all 15,000 rows? why not have a more restrictive select with some sort
of paging mechanism if they want to move to the next page of results?
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"Mukesh" wrote:
> Hi all
> I am developing a webportal on VS2005 and ASP.NET 2.0
> Using MsSQL SERVER 2005.
> I have some static records(around 15000) in the database.These contents
> never changed while the application is running.
> what i m doing is querying the database only once at the
> application_start event of the global.asax file and storing the records
> in dataset...and further no query to database is done for this data.
> wherever I need this data I fetch it from the dataset...through
> datatable.select(filter expression) method.this is done several time for
> a single page request and the website is high traffic portal.
> Is it an efficient way of doing or there is any other better way by
> which I can achieve the same..,as the amount of data is very
> large...approx 15,000 records.
> Plz Suggest me ........
>
> Thanxxxxxxxxxxxxxx
> Regards
> Deepti Yadav
> Noida
>
Performance of datatable.select() func against database query orthe xquery
I am developing a webportal on VS2005 and ASP.NET 2.0
Using MsSQL SERVER 2005.
I have some static records(around 15000) in the database.These contents
never changed while the application is running.
what i m doing is querying the database only once at the
application_start event of the global.asax file and storing the records
in dataset...and further no query to database is done for this data.
wherever I need this data I fetch it from the dataset...through
datatable.select(filter expression) method.this is done several time for
a single page request and the website is high traffic portal.
Is it an efficient way of doing or there is any other better way by
which I can achieve the same..,as the amount of data is very
large...approx 15,000 records.
Plz Suggest me ........
Thanxxxxxxxxxxxxxx
Regards
Deepti Yadav
NoidaOK, I will suggest you. 15,000 rows for a select is a lot of data to display
in an ASP.NET web application. Are your users realistically going to need to
see all 15,000 rows? why not have a more restrictive select with some sort
of paging mechanism if they want to move to the next page of results?
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"Mukesh" wrote:
Quote:
Originally Posted by
>
Hi all
>
I am developing a webportal on VS2005 and ASP.NET 2.0
Using MsSQL SERVER 2005.
I have some static records(around 15000) in the database.These contents
never changed while the application is running.
>
what i m doing is querying the database only once at the
application_start event of the global.asax file and storing the records
in dataset...and further no query to database is done for this data.
wherever I need this data I fetch it from the dataset...through
datatable.select(filter expression) method.this is done several time for
a single page request and the website is high traffic portal.
>
Is it an efficient way of doing or there is any other better way by
which I can achieve the same..,as the amount of data is very
large...approx 15,000 records.
Plz Suggest me ........
>
>
Thanxxxxxxxxxxxxxx
>
Regards
>
Deepti Yadav
Noida
>
Hi Deepti,
Although you're not directly displaying all 15,000 records to end-user
(used DataTable.Select to filter), it's still not a good idea to cache all
15,000 records at server-side.
I would suggest to optimize at the database side: with careful index
design, I think you should get good performance when frequently selecting
from the table. After all, the database server also does pretty well to
cache data for frequently queried data.
Hope this helps.
Regards,
Walter Wang (wawang@.online.microsoft.com, remove 'online.')
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
performance problem after porting .net 1.1 to 2.0
porting .net project to .net 2.0 cause lot of performance issues .
Server become down because of cpu usage, memory usage.
thanks
You are going to have to supply more details for anyone to be able to offer suggestions. Typically we see sites run much faster moving to 2.0.
hai
we have application which contains
1. client application
2. web application
These application use samewebservice which contains methods that returns datasets.
Dataset contains 7-8 tables (tables are merged in dataset using merge method)
Crystal reports arealso used.
In Web application ,expoted to pdf format
In Client application Crystal reports10 is used.
Aso session and view state is used .
porting .net project to .net 2.0 cause lot of performance issues .
Server become down because of cpu usage, memory usage.
thanks
Performance problems using ASP.NET 2.0
I have just built my first ASP.NET v2.0 app and have it running on a 3 server web farm that runs several other ASP.NET v1.1 apps. The v1.1 apps run great, but the new v2.0 app always seems to run very slowly when first connecting to the site, even if other users have already visited the site. I believe I have pre-compiled the site, and even if I visit each server in turn to ensure the app has been compiled before hitting the load-balanced url, the site just runs very slowly. On our development machines the site runs very quickly, so the poor performance is a bit of a mystery.
The servers in the farm are running Windows 2003 Server and the machine.config on each server has been updated to syncronize the machine keys.
Check the event viewer to see if the app pool is restarting itself. Some people had problems with the application shutting down and if that's your case then when the app (aspnet) restarts itself the code has to recompile. Any other details that you might find, will help on directing you towards the right path.hi
are u working with directory. The asp.net 2.0 application restart as soon as the directory structure changes. see the post below
http://vikramlakhotia.com/Post.aspx?postID=6
Hope this helps
Vikram
Vikram's Blog
Did not know that. If that's the case that's a huge bug on asp.net 2.0. It should be reported. Maybe there's a setting on the Machine.Config for the application not to restart when the directory structure changes.
There was nothing in the event viewer for all three servers (relating to asp.net anyway). The slow responses almost feel like every page request is causing the application to be re-built...
I don't know what else to tell you. Maybe you have indexing on and it's getting ahold of the files and thus restarting. Just throwing one out there.
Try creating another app and see how it behaves. If it behaves normal, then the problem is related to your application.
Performance prolem when deploying
We have a quite simple asp.net application that works fne on my XP
development box. When we deploy it to a Windows 2003 Server performance is
really poor when rendering pages. When I turn tracing on it shows that it
takes more than 15 seconds between "Begin Render" and "End Render". All
application logic is in OnLoad which takes less than 0,1 seconds to complete
on both machines. The weird thing is that if we request this page locally
(from the server box) it takes 0,1 seconds. Authentication is Anonymous and
we don't find any errors anywhere. The statusline text in IE is flickering
while the request is being processed.
So, the question is: How come the times varies depending on where the
request comes from? It must be security related somehow but I can't figure
it out.
Thanks !
Mansyou probably have a large payload whose impact only shows up with a network
request. check how big your viewstate is. if you use netscape, check page
info, if ie, save the page to disk, and check the file size.
-- bruce (sqlwork.com)
"Mans" <mans@.nomail.com> wrote in message
news:uQLgeta5DHA.2496@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We have a quite simple asp.net application that works fne on my XP
> development box. When we deploy it to a Windows 2003 Server performance is
> really poor when rendering pages. When I turn tracing on it shows that it
> takes more than 15 seconds between "Begin Render" and "End Render". All
> application logic is in OnLoad which takes less than 0,1 seconds to
complete
> on both machines. The weird thing is that if we request this page locally
> (from the server box) it takes 0,1 seconds. Authentication is Anonymous
and
> we don't find any errors anywhere. The statusline text in IE is flickering
> while the request is being processed.
> So, the question is: How come the times varies depending on where the
> request comes from? It must be security related somehow but I can't figure
> it out.
> Thanks !
> Mans
There are also some useful tools that let you see what is going on between
your browser and the server. The best is http://www.httpwatch.com/ . There's
also http://www.blunck.info/iehttpheaders.html
If it is the size of the output that is the problem then look at optimising
it - removing viewstate if you aren't using it etc... You can also reduce
the size with Http Compression - http://www.intesoft.net/aspaccelerator/
- Simon Green
InteSoft IT Ltd
"bruce barker" <nospam_brubar@.safeco.com> wrote in message
news:eQZuARd5DHA.632@.TK2MSFTNGP12.phx.gbl...
> you probably have a large payload whose impact only shows up with a
network
> request. check how big your viewstate is. if you use netscape, check page
> info, if ie, save the page to disk, and check the file size.
> -- bruce (sqlwork.com)
>
> "Mans" <mans@.nomail.com> wrote in message
> news:uQLgeta5DHA.2496@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> > We have a quite simple asp.net application that works fne on my XP
> > development box. When we deploy it to a Windows 2003 Server performance
is
> > really poor when rendering pages. When I turn tracing on it shows that
it
> > takes more than 15 seconds between "Begin Render" and "End Render". All
> > application logic is in OnLoad which takes less than 0,1 seconds to
> complete
> > on both machines. The weird thing is that if we request this page
locally
> > (from the server box) it takes 0,1 seconds. Authentication is Anonymous
> and
> > we don't find any errors anywhere. The statusline text in IE is
flickering
> > while the request is being processed.
> > So, the question is: How come the times varies depending on where the
> > request comes from? It must be security related somehow but I can't
figure
> > it out.
> > Thanks !
> > Mans
Hi...
Do you have used any client side implementation in the code behind pages..
As you have written there is flickering in the status bar, there is is some
kind to and from from server to browser before rendering the html..
Can you spcify some portion of the first aspx page....
"Mans" <mans@.nomail.com> wrote in message
news:uQLgeta5DHA.2496@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We have a quite simple asp.net application that works fne on my XP
> development box. When we deploy it to a Windows 2003 Server performance is
> really poor when rendering pages. When I turn tracing on it shows that it
> takes more than 15 seconds between "Begin Render" and "End Render". All
> application logic is in OnLoad which takes less than 0,1 seconds to
complete
> on both machines. The weird thing is that if we request this page locally
> (from the server box) it takes 0,1 seconds. Authentication is Anonymous
and
> we don't find any errors anywhere. The statusline text in IE is flickering
> while the request is being processed.
> So, the question is: How come the times varies depending on where the
> request comes from? It must be security related somehow but I can't figure
> it out.
> Thanks !
> Mans
Monday, March 26, 2012
performance: IIS - Sqlserver locks influence??
We have a web application handling thousands of requests per seconds reading
sql server data which is heavily updated.
We are generally experiencing no performance problems.
On some occasions we get an increase of the traffic of about 15% for short
periods. In this case we observe something really strange: our webserver
CPU goes from about 40% usage to 100%, with memory usage keeping low (about
50%). We see at the same time that the number of sqlserver locks increases.
Are these 2 behaviours correlated? ..or any other ideas?
We are using w2k and sql2K
Thanks for your help
Alex"Alex Callea" <alex.callea@.sellys.com> wrote in message
news:O2QUzVZxEHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> We have a web application handling thousands of requests per seconds
> reading sql server data which is heavily updated.
> We are generally experiencing no performance problems.
> On some occasions we get an increase of the traffic of about 15% for short
> periods. In this case we observe something really strange: our webserver
> CPU goes from about 40% usage to 100%, with memory usage keeping low
> (about 50%). We see at the same time that the number of sqlserver locks
> increases.
> Are these 2 behaviours correlated? ..or any other ideas?
The traffic increases by 15%. The traffic passes through IIS. The
application in IIS calls SQL Server.
If I'm right, then this suggests that the behaviors correlate.
John Saunders
I know it's correlated but my question was to know if the increase number of
locks had cpu usage consequences on IIS.
We already noticed that the number of web requests being processed has huge
impact on webservers CPUs.
I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects need
to wait more resulting in an increase of page processing time, etc...) as
the SQL server CPUs are almost not impacted by the increased traffic.
Thanks
Alex
"John Saunders" <johnwsaundersiii at hotmail.com> wrote in message
news:eIvurHbxEHA.3024@.TK2MSFTNGP14.phx.gbl...
> "Alex Callea" <alex.callea@.sellys.com> wrote in message
> news:O2QUzVZxEHA.1564@.TK2MSFTNGP09.phx.gbl...
> The traffic increases by 15%. The traffic passes through IIS. The
> application in IIS calls SQL Server.
> If I'm right, then this suggests that the behaviors correlate.
> John Saunders
>
"Alex Callea" <alex.callea@.sellys.com> wrote in message
news:uQxGoecxEHA.4028@.TK2MSFTNGP15.phx.gbl...
>I know it's correlated but my question was to know if the increase number
>of locks had cpu usage consequences on IIS.
> We already noticed that the number of web requests being processed has
> huge impact on webservers CPUs.
> I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects
> need to wait more resulting in an increase of page processing time,
> etc...) as the SQL server CPUs are almost not impacted by the increased
> traffic.
Alex, I am certainly not an expert on IIS performance, but I can't think why
it would in any way be affected by SQL Server locks.
John
"John Saunders" <johnwsaundersiii at hotmail.com> wrote in message
news:uEOK$PgxEHA.908@.TK2MSFTNGP11.phx.gbl...
> "Alex Callea" <alex.callea@.sellys.com> wrote in message
> news:uQxGoecxEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Alex, I am certainly not an expert on IIS performance, but I can't think
> why it would in any way be affected by SQL Server locks.
>
The relationship is probably indirect. Sql Server locks are a directly
related to the volume of work being done by Sql Server. Locks don't
indicate that clients are waiting, just that they are doing stuff. Reading
tables generates shared locks, updating tables generates update or exclusive
locks, etc. So the more work, the more locks.
David
performance: IIS - Sqlserver locks influence??
We have a web application handling thousands of requests per seconds reading
sql server data which is heavily updated.
We are generally experiencing no performance problems.
On some occasions we get an increase of the traffic of about 15% for short
periods. In this case we observe something really strange: our webserver
CPU goes from about 40% usage to 100%, with memory usage keeping low (about
50%). We see at the same time that the number of sqlserver locks increases.
Are these 2 behaviours correlated? ..or any other ideas?
We are using w2k and sql2K
Thanks for your help
Alex"Alex Callea" <alex.callea@.sellys.com> wrote in message
news:O2QUzVZxEHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> We have a web application handling thousands of requests per seconds
> reading sql server data which is heavily updated.
> We are generally experiencing no performance problems.
> On some occasions we get an increase of the traffic of about 15% for short
> periods. In this case we observe something really strange: our webserver
> CPU goes from about 40% usage to 100%, with memory usage keeping low
> (about 50%). We see at the same time that the number of sqlserver locks
> increases.
> Are these 2 behaviours correlated? ..or any other ideas?
The traffic increases by 15%. The traffic passes through IIS. The
application in IIS calls SQL Server.
If I'm right, then this suggests that the behaviors correlate.
John Saunders
I know it's correlated but my question was to know if the increase number of
locks had cpu usage consequences on IIS.
We already noticed that the number of web requests being processed has huge
impact on webservers CPUs.
I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects need
to wait more resulting in an increase of page processing time, etc...) as
the SQL server CPUs are almost not impacted by the increased traffic.
Thanks
Alex
"John Saunders" <johnwsaundersiii at hotmail.com> wrote in message
news:eIvurHbxEHA.3024@.TK2MSFTNGP14.phx.gbl...
> "Alex Callea" <alex.callea@.sellys.com> wrote in message
> news:O2QUzVZxEHA.1564@.TK2MSFTNGP09.phx.gbl...
>> Hi there,
>>
>> We have a web application handling thousands of requests per seconds
>> reading sql server data which is heavily updated.
>> We are generally experiencing no performance problems.
>> On some occasions we get an increase of the traffic of about 15% for
>> short periods. In this case we observe something really strange: our
>> webserver CPU goes from about 40% usage to 100%, with memory usage
>> keeping low (about 50%). We see at the same time that the number of
>> sqlserver locks increases.
>> Are these 2 behaviours correlated? ..or any other ideas?
> The traffic increases by 15%. The traffic passes through IIS. The
> application in IIS calls SQL Server.
> If I'm right, then this suggests that the behaviors correlate.
> John Saunders
"Alex Callea" <alex.callea@.sellys.com> wrote in message
news:uQxGoecxEHA.4028@.TK2MSFTNGP15.phx.gbl...
>I know it's correlated but my question was to know if the increase number
>of locks had cpu usage consequences on IIS.
> We already noticed that the number of web requests being processed has
> huge impact on webservers CPUs.
> I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects
> need to wait more resulting in an increase of page processing time,
> etc...) as the SQL server CPUs are almost not impacted by the increased
> traffic.
Alex, I am certainly not an expert on IIS performance, but I can't think why
it would in any way be affected by SQL Server locks.
John
"John Saunders" <johnwsaundersiii at hotmail.com> wrote in message
news:uEOK$PgxEHA.908@.TK2MSFTNGP11.phx.gbl...
> "Alex Callea" <alex.callea@.sellys.com> wrote in message
> news:uQxGoecxEHA.4028@.TK2MSFTNGP15.phx.gbl...
>>I know it's correlated but my question was to know if the increase number
>>of locks had cpu usage consequences on IIS.
>>
>> We already noticed that the number of web requests being processed has
>> huge impact on webservers CPUs.
>> I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects
>> need to wait more resulting in an increase of page processing time,
>> etc...) as the SQL server CPUs are almost not impacted by the increased
>> traffic.
> Alex, I am certainly not an expert on IIS performance, but I can't think
> why it would in any way be affected by SQL Server locks.
The relationship is probably indirect. Sql Server locks are a directly
related to the volume of work being done by Sql Server. Locks don't
indicate that clients are waiting, just that they are doing stuff. Reading
tables generates shared locks, updating tables generates update or exclusive
locks, etc. So the more work, the more locks.
David
Saturday, March 24, 2012
Permission Problem
I'm creating the administration module of the my application. I started by using my local machine as the web server. Currently, the application contains functionality that will: move a file to a server on the network, delete a file from the server on the network, and create a file on the server on the network. All of these functions worked beautifully on my local machine.
Now, I have moved my application from my local machine to the live web server for further testing. All of my functionality, at first, did not work. I would receive "Access denied" messages -- hence, a permission problem. (Keep in mind that there are two separate servers on the network that are used for IO operations in this app)
The network admin and I started at the first logical place -- folder permissions on both of the servers. To make a long story short, we set "Full Control" for "Everyone" on the one directory for server 1. This actually resolved the problem creating, moving, and deleting of files through my app. (Although, not the best solution, obviously) However, when setting the permissions for the other server, (and setting them identical to the first), the application still gets "Access denied" errors.
Can someone throw some suggestions my way, as to what permissions need to be set on these directories to work properly? I'm thrown off by the fact that it worked when my local machine acted as the web server, but not on the live web server. I also confirmed that the IIS settings for both my machine and live web server applications were identical. (Although my machine is running IIS 6, and the live server is 5 I believe)
Thanks!
IIS 5 uses ASPNET to do work - IIS6 uses Network Authority
check outhttp://asp.net/faq/AspNetAndIIS6.aspx
On the servers - you can edit the Local Security Policy to log failed logons - and then you can see the account being used
Hope that Helps
I apologize...my local machine account is using IIS 5 and the web server is 6. I'll check out that article...
The server that is not allowing me to add/move/delete files does not have .NET installed. Stupid question, but is that what's causing the problem here? Do I need to install .NET and then add an ASPNET group to the directory?
Lots of possible issues here. First is how you're authenticating in the app. If you use anonymous access, the user has changed, and may be a network account if the server is a domain controller. Remember that the accounts on your workstation were likely local accounts and you would need to change the account for your app or duplicate that account on the network.
My guess is you're authenticating users since giving the Everyone group full control fixed the access. They may not need Full Control, and Modify might eb enough on the folders. You may even be authenticating without realizing it since IE will pass authentication credentials if the network is seen as being local or in the intranet security zone. Remove Windows Integrated authentication in your web site if you don't intend to authenticate.
Might try Filemon from Sysinternals.com to check access on specific files. This can help quite a bit on the server to server issues.
Jeff
Permission required to execute a DTS package from ASP.NET app
I'm calling a DTS package from my asp.net application.Apparently because of
permission issue I canot run the package within the sql server ,because when
I set it to call a package from my local host it can execute te package.one
step before calling the package I get the IDENTITY of the current security
context and it is my Domian user name and I'm using IntegratedSecurity to
call the DTS package.I'm also memeber of sysadmin rols in Database.Do I have
to give it extra permissions?
Thasnk"Ray5531" <Ray5531@.microsoft.com> wrote in
news:#QTNS10hFHA.3164@.TK2MSFTNGP15.phx.gbl:
> Hello,
> I'm calling a DTS package from my asp.net application.Apparently
> because of permission issue I canot run the package within the sql
> server ,because when I set it to call a package from my local host it
> can execute te package.one step before calling the package I get the
> IDENTITY of the current security context and it is my Domian user name
> and I'm using IntegratedSecurity to call the DTS package.I'm also
> memeber of sysadmin rols in Database.Do I have to give it extra
> permissions?
> Thasnk
Hi Ray,
If you are using SSPI in the connectionstring, you have to impersonate the
call to the DTS.
You can do that by adding the next line to the web.config:
<identity impersonate="true" /
link: http://msdn.microsoft.com/library/d...rl=/library/en-
us/vsent7/html/vxconImpersonation.asp
Pablo
> If you are using SSPI in the connectionstring, you have to impersonate the
> call to the DTS.
> You can do that by adding the next line to the web.config:
> <identity impersonate="true" /
I've done this ,that's why the curent security context is under my
identity:)
Thanks
"Pablo Galiano" <pagaliano@.hotmail.com> wrote in message
news:Xns969288D8242Apagalianohotmailcom@.207.46.248 .16...
> "Ray5531" <Ray5531@.microsoft.com> wrote in
> news:#QTNS10hFHA.3164@.TK2MSFTNGP15.phx.gbl:
>> Hello,
>>
>> I'm calling a DTS package from my asp.net application.Apparently
>> because of permission issue I canot run the package within the sql
>> server ,because when I set it to call a package from my local host it
>> can execute te package.one step before calling the package I get the
>> IDENTITY of the current security context and it is my Domian user name
>> and I'm using IntegratedSecurity to call the DTS package.I'm also
>> memeber of sysadmin rols in Database.Do I have to give it extra
>> permissions?
>>
>> Thasnk
>>
>>
>>
> Hi Ray,
> If you are using SSPI in the connectionstring, you have to impersonate the
> call to the DTS.
> You can do that by adding the next line to the web.config:
> <identity impersonate="true" />
> link: http://msdn.microsoft.com/library/d...rl=/library/en-
> us/vsent7/html/vxconImpersonation.asp
>
> Pablo
Permission script
permission for the ASP.NET account for one of the folders.
c:/inetpub/wwwroot/mysite/logs
Is there a script that can automatically do that? in VBS? or BAT? or NET?
Assume my client has admin permission on the server.
Thanks,
AaronYou could write a bat file to use CACLS.EXE from the command line.
http://support.microsoft.com/?kbid=135268
Scott
http://www.OdeToCode.com/blogs/scott/
On Sat, 2 Apr 2005 16:11:00 -0700, "Aaron" <kuya789@.yahoo.com> wrote:
>I'm going to deploy an web app on a client's server. It requires write
>permission for the ASP.NET account for one of the folders.
>c:/inetpub/wwwroot/mysite/logs
>Is there a script that can automatically do that? in VBS? or BAT? or NET?
>Assume my client has admin permission on the server.
>Thanks,
>Aaron
>
Permission script
permission for the ASP.NET account for one of the folders.
c:/inetpub/wwwroot/mysite/logs
Is there a script that can automatically do that? in VBS? or BAT? or NET?
Assume my client has admin permission on the server.
Thanks,
AaronYou could write a bat file to use CACLS.EXE from the command line.
http://support.microsoft.com/?kbid=135268
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sat, 2 Apr 2005 16:11:00 -0700, "Aaron" <kuya789@.yahoo.com> wrote:
>I'm going to deploy an web app on a client's server. It requires write
>permission for the ASP.NET account for one of the folders.
>c:/inetpub/wwwroot/mysite/logs
>Is there a script that can automatically do that? in VBS? or BAT? or NET?
>Assume my client has admin permission on the server.
>Thanks,
>Aaron
permissions
I have given
ASP.NET MACHINE ACCOUNT and
INTERNET GUEST ACCOUNT
MODIFY
READ AND EXECUTE
LIST FOLDER CONTENTS
READ
WRITE
However, still no luck. Is this a security risk giving these permissions to these accounts? And what do I have to do to get it working!?. Is this because security on win2k3 is tighter? I swear it worked like a charm on win2k
Any help greatly appreciated.
Thanks
Mike123
(Error Below)
Exception Details: System.UnauthorizedAccessException: Access to the path "e:\web\pics\uploads\bob07.jpg" is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired accessso you've made the changes to permisions where? IIS console? You'll also need to alter the NTFS ACLs trhough windows explorer's 'security' pane (under the properties window)
I did that as well , but no luck =[
am i setting the wrong accounts??
Any luck since Mike?
Matt.
Yes I got it.
I believe it was the NT Services account that did not have permission that needed it.
Are you talking about the Windows NT Services, as in the modules which perform functions for Windows NT, or an actual account which I don't appear to have on my system? Where would I look for this?
More importantly, what did you do exactly to get it working?
Thanks muchly,
Matt.
Dont quote me on this but as I remember it an actual account. 2k3 is setup a bit differently. All I did was give this account permissions and it worked.
Permissions Error .. ?
installed on the web server itself or another local server on the LAN. I
tried connecting to an access database on another server, which I could
fine when designing the page. But, when I ran the page on the web
server, I got this error:
The Microsoft Jet database engine cannot open the file
'\\fileserv\database\transportation\trantrack2003B _testing.mdb'. It is
already opened exclusively by another user, or you need permission to
view its data.
I don't believe I could add permissions to this file for the ASP.NET
account on the web server to access it. How would I go about
'impersonating', as I've heard mentioned before, if this would solve my
problem?I don't believe I could add permissions to this file for the ASP.NET
Quote:
Originally Posted by
account on the web server to access it. How would I go about
'impersonating', as I've heard mentioned before, if this would solve my
problem?
Have a look under the web.config section of:
http://west-wind.com/weblog/posts/2153.aspx
which should help.
Wednesday, March 21, 2012
Permissions for ASPNET Account
I've recently install the framework on a web server (First 'production' one
I've done)
Should the ASPNET account have read/write access to the web root and beyond?
Or just the areas where I'll use asp.net? Or perhaps just read access? (With
write access to specific areas where maybe txt files are amended?)
Would appreciate a little guideance.
Thanks!
Simon.It should have whatever permissions it needs to do what it needs to do; no
more, and no less.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:etZmcM28EHA.3260@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I've recently install the framework on a web server (First 'production'
> one I've done)
> Should the ASPNET account have read/write access to the web root and
> beyond? Or just the areas where I'll use asp.net? Or perhaps just read
> access? (With write access to specific areas where maybe txt files are
> amended?)
> Would appreciate a little guideance.
> Thanks!
> Simon.
Check out this link to know about permissions required by asp.net
http://support.microsoft.com/defaul...kb;en-us;317012
--
Saravana
http://dotnetjunkies.com/WebLog/saravana/
www.ExtremeExperts.com
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:etZmcM28EHA.3260@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I've recently install the framework on a web server (First 'production'
one
> I've done)
> Should the ASPNET account have read/write access to the web root and
beyond?
> Or just the areas where I'll use asp.net? Or perhaps just read access?
(With
> write access to specific areas where maybe txt files are amended?)
> Would appreciate a little guideance.
> Thanks!
> Simon.
Permissions for ASPNET Account
I've recently install the framework on a web server (First 'production' one
I've done)
Should the ASPNET account have read/write access to the web root and beyond?
Or just the areas where I'll use asp.net? Or perhaps just read access? (With
write access to specific areas where maybe txt files are amended?)
Would appreciate a little guideance.
Thanks!
Simon.It should have whatever permissions it needs to do what it needs to do; no
more, and no less.
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:etZmcM28EHA.3260@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I've recently install the framework on a web server (First 'production'
> one I've done)
> Should the ASPNET account have read/write access to the web root and
> beyond? Or just the areas where I'll use asp.net? Or perhaps just read
> access? (With write access to specific areas where maybe txt files are
> amended?)
> Would appreciate a little guideance.
> Thanks!
> Simon.
>
Check out this link to know about permissions required by asp.net
http://support.microsoft.com/defaul...kb;en-us;317012
Saravana
http://dotnetjunkies.com/WebLog/saravana/
www.ExtremeExperts.com
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:etZmcM28EHA.3260@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I've recently install the framework on a web server (First 'production'
one
> I've done)
> Should the ASPNET account have read/write access to the web root and
beyond?
> Or just the areas where I'll use asp.net? Or perhaps just read access?
(With
> write access to specific areas where maybe txt files are amended?)
> Would appreciate a little guideance.
> Thanks!
> Simon.
>
Permissions issue running .aspx files...
Server cannot access application directory "C:\Inetpub\www". The directory does not exist or is not accessible because of security settings.
Now of course the directory exists, and the permissions were (and remain) set properly for my other .asp files to run, just not the .aspx files I create with WebMatrix. All my googling indicates I have to set the permissions for an ASPNET user, which apparently 2003 doesn't use; NETWORK SERVICES runs stuff, but as that's not a user per se, I don't know how to "give it rights" so I'm at a loss.
I gave full rights (just to test, I set these back after) for the IUSER, IWAM, and IIS_WPG users, and no soup. I also have a user OWS_xxxxxxx_admin which is described as "MIcrosoft SharePoint role 'admin' for web..." but that also didn't do it. Here's why I definitely think it's a rights issue: I gave "Everybody" full rights and then my page loads. Here's the kicker though; I took away "Everybody" and gave just "Doman Users" full rights, and it doesn't work. So the impression I get is that it's trying to use a username to run scripts that doesn't exist in my domain... as if the user was somehow 'lost'.
I've also heard mention of a machine.cfg file which has the username in it to use for running scripts, but I do not appear to have such a file. Is that normal on 2k3?
Any help would be appreciated. My next resort is going to be to backup my www, and uninstall and reinstall IIS, which I would like to avoid, as my plethora of other web projects are all working. Thanks!!Update: I was wrong about the machine.cfg file, because I had the wrong extension, I see now that it's machine.config. However, I followed a knowledge base article which said to create a weak user, give it log on as a batch rights, and then add it to the machine.config file and reboot. Still no soup.
Um, bump? Anybody have any ideas? I'm still stuck on this, and haven't found anything else in my research.
Thanks in advance!
JazzGilbert wrote:
C:\Inetpub\www". The directory does not exist or is not accessible because of security settings
Who is listed on the security tab for WWW?
FYI I am also on 2003 server with AD
Have you configured the directory as an application and have you configured the web service extenstions for asp.net xxxxx
Is aspx listed in Virtual or Home Directory Tab: Configuration...:Mappings Tab:Application extensions for your application subdirectoy?
Ok, on the WWW folder under Security, I've got the following:
ASPUser with Full Rights (I created this user per the KB article)
IIS_WPG with Read & Execute
the Internet Guest Account (IUSR_machinename) with Read & Execute
the Launch IIS Process Account (IWAM_machinename) with Read & Execute
I've tried, one at a time, giving them full control, that didn't make a difference.
Maybe that's the issue, (configuring the directory as an app) because all I did was create a folder in my WWW and made sure it had the same rights as the WWW folder.
As far as extensions, I am able to run notepad created .asp files. It's the .aspx file I created in WebMatrix that fails. I think I have the right services setup, but here's a screenshot.
http://www.abeyantdestiny.com/services.gif
I think you need to create an app on the directory tab of the folder.
Also check to see which application pool is selected. It should be "ASP.NET"
Then check the identity being used by that pool.
Also to test that is has nothing to do with webmatrix... take a extreamly simple html page that you know already works on your web page and simply change the extenstion from .html to .aspx
If it works then it is webmatrix that is causing the problem if it doesn't then it is a server config issuse.
Also I can perhaps send some screen shots of my config if you need. If desired then send an private email using this site and include your email address.
Permissions Issue
Hello, I am tring to create a .mdb db programatically on my server. It works just fine on my pc but not when I attempt it on my online server. I got a security exception error which stated I needed to chage the applications trust level. So I attempted to change the trust and added this to my config file:
<securityPolicy><trustLevelname="Full"policyFile="internal" />
</securityPolicy ><trustlevel="Full" />
Now i get this configuration error:
Parser Error Message:This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file.
Source Error:
Line 64: <customErrors mode="Off"/>Line 65:Line 66: <securityPolicy>Line 67: <trustLevel name="Full" policyFile="internal" />Line 68: </securityPolicy >
Any Ideas on how to fix this? Thanks!
Have you tried allowOverride=true?
<location allowOverride="true"><system.web><securityPolicy><trustLevel name="Full" policyFile="internal" /></securityPolicy ></system.web>
Thanks for the reply. I did try this before and I got this runtime error:
Description:An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
But i already have<customErrorsmode="off"/> in my config file. Im not sure what to do.
Hi grogo21,
Based on my understanding, this is because the site administrator of your online server has locked access to this section so you are not able to override the setting. In application hosting scenarios, administrator might want to lock some settings of an ASP.NET application to prevent modification at lower levels. You need to contact your site administrator for help if you don't have such permissions.
Please check this document for more details.
http://msdn2.microsoft.com/en-us/library/ms178693.aspx
Permissions needed to run aspnet_regiis.exe -c
I'm trying to install the client side scripts on a server, but I always get
the following error:
An error has occurred (0x80070005).
You must have administrative rights on this machine in order to run this
tool.
I am logged on as a domain admin on the server. Anyone know the specific
permissions needed to run the tool?
Thanks
Ericadmin on the box, not admin of the domain,
"Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> Hi,
> I'm trying to install the client side scripts on a server, but I always
get
> the following error:
> An error has occurred (0x80070005).
> You must have administrative rights on this machine in order to run this
> tool.
> I am logged on as a domain admin on the server. Anyone know the specific
> permissions needed to run the tool?
> Thanks
> Eric
>
Well, obviously I am. When you join a server to a domain, the Domain Admin
group is automatically added to the local Administrators group. I verified
it to be sure that nothing had changed. I think it's really a permissions
problem somewhere.
"Mike" <scoobyDoo@.sbcglobal.net> wrote in message
news:upsvkjyGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> admin on the box, not admin of the domain,
>
> "Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
> news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> get
specific
>
Obviously your not you could run it now.
Check again, just because your an admin on the domain does not make you a
admin on the local machine
I'm currently an admin on my local pc but not the domain.
"Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
news:u8WqsvyGEHA.628@.TK2MSFTNGP10.phx.gbl...
> Well, obviously I am. When you join a server to a domain, the Domain
Admin
> group is automatically added to the local Administrators group. I
verified
> it to be sure that nothing had changed. I think it's really a permissions
> problem somewhere.
> "Mike" <scoobyDoo@.sbcglobal.net> wrote in message
> news:upsvkjyGEHA.3372@.TK2MSFTNGP09.phx.gbl...
always
this
> specific
>
Permissions needed to run aspnet_regiis.exe -c
I'm trying to install the client side scripts on a server, but I always get
the following error:
An error has occurred (0x80070005).
You must have administrative rights on this machine in order to run this
tool.
I am logged on as a domain admin on the server. Anyone know the specific
permissions needed to run the tool?
Thanks
Ericadmin on the box, not admin of the domain,
"Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> Hi,
> I'm trying to install the client side scripts on a server, but I always
get
> the following error:
> An error has occurred (0x80070005).
> You must have administrative rights on this machine in order to run this
> tool.
> I am logged on as a domain admin on the server. Anyone know the specific
> permissions needed to run the tool?
> Thanks
> Eric
Well, obviously I am. When you join a server to a domain, the Domain Admin
group is automatically added to the local Administrators group. I verified
it to be sure that nothing had changed. I think it's really a permissions
problem somewhere.
"Mike" <scoobyDoo@.sbcglobal.net> wrote in message
news:upsvkjyGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> admin on the box, not admin of the domain,
>
> "Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
> news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> > Hi,
> > I'm trying to install the client side scripts on a server, but I always
> get
> > the following error:
> > An error has occurred (0x80070005).
> > You must have administrative rights on this machine in order to run this
> > tool.
> > I am logged on as a domain admin on the server. Anyone know the
specific
> > permissions needed to run the tool?
> > Thanks
> > Eric
Obviously your not you could run it now.
Check again, just because your an admin on the domain does not make you a
admin on the local machine
I'm currently an admin on my local pc but not the domain.
"Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
news:u8WqsvyGEHA.628@.TK2MSFTNGP10.phx.gbl...
> Well, obviously I am. When you join a server to a domain, the Domain
Admin
> group is automatically added to the local Administrators group. I
verified
> it to be sure that nothing had changed. I think it's really a permissions
> problem somewhere.
> "Mike" <scoobyDoo@.sbcglobal.net> wrote in message
> news:upsvkjyGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> > admin on the box, not admin of the domain,
> > "Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
> > news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> > > Hi,
> > > > I'm trying to install the client side scripts on a server, but I
always
> > get
> > > the following error:
> > > > An error has occurred (0x80070005).
> > > You must have administrative rights on this machine in order to run
this
> > > tool.
> > > > I am logged on as a domain admin on the server. Anyone know the
> specific
> > > permissions needed to run the tool?
> > > > Thanks
> > > > Eric
> >
Permissions needed to run aspnet_regiis.exe -c
I'm trying to install the client side scripts on a server, but I always get
the following error:
An error has occurred (0x80070005).
You must have administrative rights on this machine in order to run this
tool.
I am logged on as a domain admin on the server. Anyone know the specific
permissions needed to run the tool?
Thanks
Ericadmin on the box, not admin of the domain,
"Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> Hi,
> I'm trying to install the client side scripts on a server, but I always
get
> the following error:
> An error has occurred (0x80070005).
> You must have administrative rights on this machine in order to run this
> tool.
> I am logged on as a domain admin on the server. Anyone know the specific
> permissions needed to run the tool?
> Thanks
> Eric
Well, obviously I am. When you join a server to a domain, the Domain Admin
group is automatically added to the local Administrators group. I verified
it to be sure that nothing had changed. I think it's really a permissions
problem somewhere.
"Mike" <scoobyDoo@.sbcglobal.net> wrote in message
news:upsvkjyGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> admin on the box, not admin of the domain,
>
> "Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
> news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> > Hi,
> > I'm trying to install the client side scripts on a server, but I always
> get
> > the following error:
> > An error has occurred (0x80070005).
> > You must have administrative rights on this machine in order to run this
> > tool.
> > I am logged on as a domain admin on the server. Anyone know the
specific
> > permissions needed to run the tool?
> > Thanks
> > Eric
Obviously your not you could run it now.
Check again, just because your an admin on the domain does not make you a
admin on the local machine
I'm currently an admin on my local pc but not the domain.
"Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
news:u8WqsvyGEHA.628@.TK2MSFTNGP10.phx.gbl...
> Well, obviously I am. When you join a server to a domain, the Domain
Admin
> group is automatically added to the local Administrators group. I
verified
> it to be sure that nothing had changed. I think it's really a permissions
> problem somewhere.
> "Mike" <scoobyDoo@.sbcglobal.net> wrote in message
> news:upsvkjyGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> > admin on the box, not admin of the domain,
> > "Eric Caron" <ecaron@.nospam.quebecaffaires.com> wrote in message
> > news:e6H#X8wGEHA.712@.tk2msftngp13.phx.gbl...
> > > Hi,
> > > > I'm trying to install the client side scripts on a server, but I
always
> > get
> > > the following error:
> > > > An error has occurred (0x80070005).
> > > You must have administrative rights on this machine in order to run
this
> > > tool.
> > > > I am logged on as a domain admin on the server. Anyone know the
> specific
> > > permissions needed to run the tool?
> > > > Thanks
> > > > Eric
> >