MS SQL XML - XML Support in IIS

Author

XML Support in IIS

dgbas_tomahawk

2005-06-09, 3:23 am

I conigure SQL Server XML Support in Windows 2003 IIS 6.
What I have done is as the same as the Microsoft Press " System
Administration ".
And I really read " XML and Internet Support " in Book-on-line.

It just doesn't work while I use query string "
http://localhost/northwind?sql=SELECT+'<ROOT> ';SELECT+ContactName
,+Phone+FROM+Custome
rs+FOR+XML+RAW;SELEC
T+'</ROOT>' " in IE6 .

Perhaps someone know what's wrong with this problem ?
Thanks , anyway.

Graeme Malcolm

2005-06-09, 7:23 am

Make sure:
1. The virtual directory you created is named "northwind"
2. The security account that the virtual directory uses (a) has Read
permission on the VDir's physical folder, and (b) can login to SQL Server
and access the Customers table in the Northwind database.
3. You've allowed "sql=" queries

Hope that helps.

--
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com

"dgbas_tomahawk" < dgbastomahawk@discus
sions.microsoft.com> wrote in message
news:E40A4358-0B22-430A-B74C- 50B733C7D69F@microso
ft.com...
I conigure SQL Server XML Support in Windows 2003 IIS 6.
What I have done is as the same as the Microsoft Press " System
Administration ".
And I really read " XML and Internet Support " in Book-on-line.

It just doesn't work while I use query string "
http://localhost/northwind?sql=SELECT+'<ROOT> ';SELECT+ContactName
,+Phone+FROM+Custome
rs+FOR+XML+RAW;SELEC
T+'</ROOT>' "
in IE6 .

Perhaps someone know what's wrong with this problem ?
Thanks , anyway.

dgbas_tomahawk

2005-06-09, 8:24 pm

1. The virtual directory you created is named "northwind"
Re:
Checked.

2. The security account that the virtual directory uses
(a) has Read permission on the VDir's physical folder, and
Re:
The security account is "IUSR_mycomputername" , Windows account type .
And the "Enable Windows account synchronization" checkbox is selected.

(b) can login to SQL Server and access the Customers table in the Northwind
database.
Re:
I add "IUSR_mycomputername" into the users of Northwind database , granting
it permissions of Public roles which could select Customers table.

3. You've allowed "sql=" queries
Re:
The Checkbox is selected .

After all , it still doesn't work. Oh, No ..........

Thank you , Mr. Malcolm.
Perhaps my instance (SQL Server 2000 SP4 ) is something wrong.
Anyway , I will take the 70-228 exam for MCDBA on June 19th , assuming this
Damned XML support in IIS problem is not important .
Thank you again.

"Graeme Malcolm" wrote:

> Make sure:
> 1. The virtual directory you created is named "northwind"
> 2. The security account that the virtual directory uses (a) has Read
> permission on the VDir's physical folder, and (b) can login to SQL Server
> and access the Customers table in the Northwind database.
> 3. You've allowed "sql=" queries
>
> Hope that helps.
>
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
>
> "dgbas_tomahawk" < dgbastomahawk@discus
sions.microsoft.com> wrote in message
> news:E40A4358-0B22-430A-B74C- 50B733C7D69F@microso
ft.com...
> I conigure SQL Server XML Support in Windows 2003 IIS 6.
> What I have done is as the same as the Microsoft Press " System
> Administration ".
> And I really read " XML and Internet Support " in Book-on-line.
>
> It just doesn't work while I use query string "
> http://localhost/northwind?sql=SELECT+'<ROOT> ';SELECT+ContactName
,+Phone+FROM+Custome
rs+FOR+XML+RAW;SELEC
T+'</ROOT>' "
> in IE6 .
>
> Perhaps someone know what's wrong with this problem ?
> Thanks , anyway.
>
>
>

Bertan ARI [MSFT]

2005-06-17, 11:24 am

What error do you retrieve?
Could you check with the profiler to see if the server get your query?

Thanks.
--
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"dgbas_tomahawk" < dgbastomahawk@discus
sions.microsoft.com> wrote in message
news:ADA66070-E34F-467D-8EC9- C316B35CDDBA@microso
ft.com...[color=darkred]
> 1. The virtual directory you created is named "northwind"
> Re:
> Checked.
>
> 2. The security account that the virtual directory uses
> (a) has Read permission on the VDir's physical folder, and
> Re:
> The security account is "IUSR_mycomputername" , Windows account type .
> And the "Enable Windows account synchronization" checkbox is selected.
>
> (b) can login to SQL Server and access the Customers table in the
> Northwind
> database.
> Re:
> I add "IUSR_mycomputername" into the users of Northwind database ,
> granting
> it permissions of Public roles which could select Customers table.
>
> 3. You've allowed "sql=" queries
> Re:
> The Checkbox is selected .
>
> After all , it still doesn't work. Oh, No ..........
>
> Thank you , Mr. Malcolm.
> Perhaps my instance (SQL Server 2000 SP4 ) is something wrong.
> Anyway , I will take the 70-228 exam for MCDBA on June 19th , assuming
> this
> Damned XML support in IIS problem is not important .
> Thank you again.
>
> "Graeme Malcolm" wrote:
>

Mark J. Ross

2005-07-13, 11:23 am

I've got the same problem. SQL Profiler isn't seeing any queries to the db.

Oddly enough, I've tried it on a Windows 2000 server with SQL Server SP3 and
it works fine, but not on the Windows 2003 server with SQL Server SP4.

Any ideas why IIS doesn't make the request to SQL Server in one case, but
does in the other?

"Bertan ARI [MSFT]" wrote:

> What error do you retrieve?
> Could you check with the profiler to see if the server get your query?
>
> Thanks.
> --
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "dgbas_tomahawk" < dgbastomahawk@discus
sions.microsoft.com> wrote in message
> news:ADA66070-E34F-467D-8EC9- C316B35CDDBA@microso
ft.com...
>
>
>

Sponsored Links