Solved

ASP.NET front end server with content on back end.

Posted on 2004-04-14
4
333 Views
Last Modified: 2010-04-17
Is it possible to do this?  The two computers are not part of a domain, and have separate SAMs.  I keep getting an error.
0
Comment
Question by:ojfahoum
  • 2
4 Comments
 
LVL 1

Expert Comment

by:someman4oneman
ID: 10829048
Sorry ojfahoum if I have picked you up wrong

 but are you talking about
ASP.NET with IIS on one machine with the SQL Server database on the another.

If so I would suggest that your asp.net is using the user that IIS is running under to try and
authenticate against the sql server and this won't work as the sql server doesn't know who you are.

If your connection string is like

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=(local);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DESOLATE;Use Encryption for Data=False;Tag with column collation when possible=False

With
      Integrated Security=SSPI;
Then this is your problem.

You should change your connection so it uses SQL Server authentication

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=(local);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DESOLATE;Use Encryption for Data=False;Tag with column collation when possible=False;password=;

If it is not an sql server you are authenticating to then the porblem may be between the two machines.
If this is the case make sure you are running IIS with a username and password that is also valid on
the server machine
0
 

Author Comment

by:ojfahoum
ID: 10829085
Actually.  I have IIS 5 (with Net Framework installed) on a front end.  For one of the virtual directories, it gets content from a shared network directory on another server (the aspx files are on another server).  

.asp and HTML files work, but .aspx returns an error.  In the Event Viewer it records this:
"aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account has insufficient rights to read the .NET Framework files. Please ensure that the .NET Framework is correctly installed and that the ACLs on the installation directory allow access to the configured account. "
0
 
LVL 19

Accepted Solution

by:
Melih SARICA earned 500 total points
ID: 10830945
ASP_NET user have access to network directory of the ASPx files?

r u sure ur .NET framework working.. Try to use a simple aspx file in ur local IIS folder.. If u ave any errors it means ur Frame work is not wortking correctly. If no errors. User ASP_NET cannot access to aspx files ..
0
 

Author Comment

by:ojfahoum
ID: 10838543
Net Framework was not working on the server itself.    Thanks non_zero.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now