Solved

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

Posted on 2010-11-09
13
908 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
  • 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
 

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
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 …

746 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