473,563 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP.NET Identity for Win 2003

I had a working WebService on my WinXp machine. I was using Windows
Authentication for database access. The App and Database are on same machine.
MachineName\ASP NET has execute permissions to the stored procedures.

I moved the app to a Win2003 serverwhich also has SQLServer 2000 installed.
Now the Sqlconnection.O pen() method fails. I granted machineName\ASP NET and
MachineName\IIS _WPG exec permission to the procedure.

What am I doing wriong?
Nov 18 '05 #1
1 1047
Win 2003 doesn't use this identity but the NETWORK SERVICE (unless IIS6 runs
in IIS5 compatiblity mode) or the identity used for the app-pool assigned to
your web app.

"Mori" <Mo**@discussio ns.microsoft.co m> wrote in message
news:21******** *************** ***********@mic rosoft.com...
I had a working WebService on my WinXp machine. I was using Windows
Authentication for database access. The App and Database are on same
machine.
MachineName\ASP NET has execute permissions to the stored procedures.

I moved the app to a Win2003 serverwhich also has SQLServer 2000 installed.
Now the Sqlconnection.O pen() method fails. I granted machineName\ASP NET and
MachineName\IIS _WPG exec permission to the procedure.

What am I doing wriong?
Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
13734
by: Surajit Laha | last post by:
I am firing a query like: SELECT TaskName, StartDate FROMTasks WHERE StartDate >= '01-Aug-2003' Now the result comes as: TaskName StartDate -------------------------- Task1 01-Aug-2003
112
10263
by: Andy | last post by:
Hi All! We are doing new development for SQL Server 2000 and also moving from SQL 7.0 to SQL Server 2000. What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000? Please, share your experience in using IDENTITY as PK .
7
1404
by: Arran Pearce | last post by:
Hi, How can i get my ASP Page or Web Service to run as the LocalSystem rather than a user? cheers
7
960
by: JerryW | last post by:
I just reinstalled .NET 2003 (after repeated attempts to get ASP.NET Web Applications to work). I first did a complete uninstall of .NET 2003, .NET Framework 1.1, and IIS. I also completely deleted c:\inetpub\wwwroot and rebooted before reinstalling. I created a new virtual directory from within IIS (e.g. MyWebTest). Then I tried to create...
3
1655
by: Dsquare | last post by:
CREATE PROCEDURE sp_InsertMaterial @MatEngName nvarchar(100),@MatJapName nvarchar(500),@Comments nvarchar(500),@ImagePath nvarchar(100),@ImageStatus nvarchar(50),@AddedDate datetime AS INSERT INTO MaterialMaster(MaterialEngName,MaterialJapName,Comments,ImagePath,ImageStatus,AddedDate)
3
22000
by: Michael Schwarz | last post by:
Hi, from time to time I get following error message with my ASP.NET 2.0 web application in the event log: An error occurred executing the configuration section handler for system.web/identity. My web.config looks like this: <authentication mode="Forms">
8
3538
by: Doug | last post by:
Visual Studio 2005, SQL Server 2000, ASP.NET/VB.NET Not allowed to use the ASPNET machine account in SQL Server (very strict environment). Need to use Windows authentication, so we use "Identity Impersonate=true" in the web.config file. Trying to implement a system-wide error trapping mechanism. Nothing fancy, just writing to a log...
0
1489
by: Brian | last post by:
Greetings group! I've got a weird one. I have an ASP.NET 1.1 application that has been running on a dual-processor Windows 2000/IIS 5 server for a couple of years. Global.asax has an Application_Error() function that writes an entry to the event log. Everything works great. We're migrating to Windows 2003 on a new server, so I built up a...
2
4712
by: John | last post by:
Help! I've just spend the last three days researching and testing the following issue without any results. I have a test page setup to get the Windows logon name of the user. The site is a private intranet with the following configuration: Two Windows 2003 servers, load balanced. IIS 6.0 is running on both
0
7583
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...
1
7638
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7948
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6250
agi2029
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...
1
5484
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5213
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...
0
3642
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...
0
3626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2082
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.