?
Solved

Websites work in Visual Studio Development & IIS6 but NOT in IIS7

Posted on 2010-11-09
13
Medium Priority
?
914 Views
Last Modified: 2012-05-10
Dear Experts

we have upgraded our server from Windows Server 2003 to Windows Server 2008 R2.

1) All our websites work fine on WS 2003 IIS6.

2) All our websites work fine in Visual Studio (also on visual studio on WS 2008 R2)

3) None of the websites work on IIS7. They all use webservices (on the same server).

4) Webservices work if you 'browse' them direct from -> Manage Application -> Browse

5) Application pool is in 'Classic'

6) Identity is 'Network Service'

----------------------------

Tests Already Completed in small tester programs within IIS7 and visual studio.
a) Ajax tester - completed ok
b) Session Variables - completed ok

----------------------------

Please help. I've been pulling my hair out over this.

ps: I know this is a 500 authentification error but how do I overcome this?

Thanks for all your help in advance!

Darren
iis7-error.png
0
Comment
Question by:Darrenshome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
  • 2
13 Comments
 
LVL 2

Expert Comment

by:tan_dev
ID: 34092025
your physical path to the folder should be the folder which has web.config inside it. that solved similar problem for me.

also which version of .net framwork are you using for your app pool? 2.0 i hope i think that works with classic pool?
0
 

Author Comment

by:Darrenshome
ID: 34092117
Dear tan_dev

This is already the case.....

a) .NET Framework version V2.0.50727
b) Pipeline mode Classic
c) web.config is within physical path

Any other ideas?
0
 
LVL 2

Expert Comment

by:tan_dev
ID: 34092166
your app pool on the diagonostic is default app pool. Also you are trying to access the webservice. Does you application work fine when you browse it?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Darrenshome
ID: 34092312
Yes...webservices work.

As described in the question number 4.
0
 

Author Comment

by:Darrenshome
ID: 34092602
Does anyone else know how to solve my IIS7 problem?

Please help.

Darren
0
 
LVL 2

Expert Comment

by:tan_dev
ID: 34092843
its probably just the security permissions on your webservice folder.
can you try to grant all access to the user you're trying to run your application with.
0
 

Author Comment

by:Darrenshome
ID: 34093811
Dear tan_dev

The webservices are being called from the Inetpub website.

Please be more specific. Which permission should be allowed to call the web services? I already have Network Service including Anonoymous and Everyone on full control on the WebServices folder!

I said from the start this is an Authentification error. No further down the road.....

I think its deeper than this. Theres something not right elsewhere!

Any more suggestions?

Regards
Darren
0
 

Author Comment

by:Darrenshome
ID: 34101732
Update

Have created a simple program with a connection string.

Get the error

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Therefore, it seems that it is 32 bit and 64 bit related issue.

IIS7 is pointing to the 64bit odbc admin whilst Visual Studio is pointing to 32bit odbc admin.

The connection string points to a 32bit Pervsaive database odbc and there is no 64 bit available.

Will look at using a 64bit odbc driver to connect to Pervasive.

Regards
Darren
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 34101949
You have a few options:

- You can upgrade to Pervasive PSQL v11 to get the 64 bit ODBC driver.  

- You can switch from ODBC to the PSQL Managed Provider to get 64 bit support with PSQL v10.  

- You can make sure your web application is set to "x86" for the Active Solution Platform setting rather than "AnyCPU".  That will force the .NET to use 32 bit.  You might also need to enable 32 bit support within IIS.  
0
 

Author Comment

by:Darrenshome
ID: 34102470
Dear Mirtheil

Upgrading Pervasive is out the question....

I have set the Active Solution Platform to 'x86' in Configuration Manager

I have published it direct ti IIS7 but still fails.

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

ps: feels like were going in the right directiion though!!!

Any more ideas?

Regards
Darren
x86-visual-studio.png
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 34102967
What is your connection string?  Are you using an ODBC DSN?  If so, did you use the ODBC ADministrator in c:\windows\syswow64\odbad32.exe?  
0
 

Accepted Solution

by:
Darrenshome earned 0 total points
ID: 34119959
Dear All

Got the website working by changing the user permissions on the SQL Server Database

'Select' was not authorised for the logon credentials -> Security settiings within SQL Server. This was the 500 error shown origionally.

Problem Solved By:
1) Databases -> Security -> Users (Click on user to grant permmissions)
2) Database User (Login) opens
3) Securables tab -> Check permission 'Select'

Also, Identity within the AppPool should be ApplicationPoolIdentity.

Therefore:
a) It was NOT to do with 32 or 64 bit
b) Not the permissions on the webservices folder
c) It was NOT the connection string.

ps: Thanks for all your input mirtheil and tan_dev

Regards
Darren
0
 

Author Closing Comment

by:Darrenshome
ID: 34153278
Gave detailed instructions on how to allow permissions on SQL Server Database that held data for webservices used by a website.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

718 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