IIS7/2008 to my SQL Server 2000 machine: Not associated with a trusted SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Security » IIS7/2008 to my SQL Server 2000 machine: Not...

IIS7/2008 to my SQL Server 2000 machine: Not associated with a trusted SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

bob-696486

Posted Friday, October 17, 2008 5:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 23, 2009 10:04 AM
Points: 1, Visits: 6

I am setting up a windows 2008 IIS7 web server, and trying to connect to a windows 2000 sql server 2000 database. I have an IIS6 Windows 2000 web server activately connected just fine.

I have anonymous and windows authentication enabled. And in my web.config I have identity impersonate="true"

My sql server 2000 typically uses the IISUSER anonymous user set up in IIS6 on my original windows 2000 web server. But this new IIS7 is giving me grief. I can't seem to setup the IUSR or IISUSER or anything in it. I can't even use sql server credentials in my connection string althought my SQL Server supports both. I get: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

On my windows 2008 box, I can setup an ODBC connection in the control panel and test it just fine, so I know I'm getting to the database server and test fine. It's just in IIS7 that it won't give me a break.

Can you please help with any advice?

Thanks.

Post #588043

SLX

Posted Monday, February 23, 2009 4:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 12:22 PM
Points: 2, Visits: 11

Hi, did u found a solution for this problem.

Im running against the same problem...

I'm trying to migrate a Virtual directory from an old Windows 2000 server to a new W2008 box.

I downloaded SQLXML3 and successfully installed it on the 2008 box.
Configuration is exactly the same than on the old server.

I allowed IIS7 to run in 32 bit mode.

Now, when I try to open the url (http://192.168.32.43/TEST?sql=select @@version).

Im getting a 500.0 error
Module IsapiModule
Notification ExecuteRequestHandler
Handler AboMapperCustom-68254
Error Code 0x800700c1

any chance to find a solution for that ?

thanks

Post #662457

Gift Peddie

Posted Monday, February 23, 2009 6:37 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:43 AM
Points: 3,432, Visits: 14,334

Hi,

Parts of the original post was wrong because Windows 2000 comes with IIS 5 not IIS 6 and if you are using IIS 7 with SQL Server 2000 may need to use it in IIS 6 mode. And IIS 7 if run in IIS 7 mode does not require IIS to be in x86 that is 32bit mode because you can run both x86 and x64 applications in one IIS 7. And the reason for the problem is Asp.net is using the limited permissions Network service account so you need to Add Asp.net at the server level and in the database or your application will not run. You are having double hop issues so go to your C drive and run aspnet_regiis in you .NET folder in your C drive and use the link below to configure IIS 7 in IIS 6 mode.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

http://blogs.msdn.com/webdevtools/archive/2006/09/18/developing-web-applications-on-windows-vista-with-visual-studio-2005.aspx

Kind regards,
Gift Peddie

Post #662514

Jack Corbett

Posted Monday, February 23, 2009 7:12 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 10,613, Visits: 11,952

You may want to check out this article, http://www.sqlservercentral.com/articles/Security/65169/. Here is another older article that may still apply as well, http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #662548

Gift Peddie

Posted Monday, February 23, 2009 7:20 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:43 AM
Points: 3,432, Visits: 14,334

Those configurations don't work in Asp.net in some cases because SQL Server and Windows are just made by Microsoft security in both are very different.

Kind regards,
Gift Peddie

Post #662557

SLX

Posted Monday, February 23, 2009 8:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 12:22 PM
Points: 2, Visits: 11

OK, thanks for the information,

but I want to make sure I understand:

1) I have to use IIS7 in IIS6 mode.
I checked the Roles installed on my 2008 server and IIS6 management console,metabase compatibility,management compatibility are installed.
When I start this mmc I can only see the server name, but no web site is displayed.

2) on both servers (2008 = IIS 2000 = SQL+IIS5) .net v2.0.50727 is installed.
Should I run aspnet_regiis -i on both machines?

thanks again

SLX

Post #662612

Gift Peddie

Posted Monday, February 23, 2009 8:21 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:43 AM
Points: 3,432, Visits: 14,334

Running aspnet_regiis is required for any development using Asp.net 2.0 and above IIS version is not relevant. So yes run the aspnet_regiis and you also need to add the Asp.net account in the server running SQL Server on the server level and database level.

Kind regards,
Gift Peddie

Post #662620

« Prev Topic | Next Topic »

Permissions