Re: A newbie need help for SQL XML

From: Irwin Dolobowsky [MSFT] (irwind_at_mail.microsoft.com)
Date: 11/01/04 

Date: Mon, 1 Nov 2004 15:35:22 -0800

What OS is this machine running? 

-- 
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"SN" <SN@discussions.microsoft.com> wrote in message 
news:4FD030C3-B878-4B2E-B8FA-5B3505756371@microsoft.com...
>I am trying to set up my SQL server so that I can get recordset in XML 
>format
> over HTTP.
>
> In a seperate IIS server (with SQL tools):
> 1) I created a directory (C:\nwind) and underneath created 
> C:\nwind\template
> and C:\nwind\schema.
> 2) Opened the IIS virtual dir. for SQL (IISsql) and created a virtual
> directory nwind and pointed to C:\nwind.
> 3) Set the security to either sql or windows.
> 4)Selected the SQL server and appropriate database.
> 5)Checked allow POST and allow URL query.
> 6) Created virtual names
> template->type-template->location-C:\nwind\template, 
> dbobject->type-dbobject,
> schema->type-schema->location-C:\nwind\schema.
>
> I have both a windows account and sql account "test" that has access to
> northwind database.  When I type the following in a workstation:
>
> http://IISserver/nwind?sql=SELECT * FROM Employees FOR XML AUTO&root=root
>
> I get the:
>
> HTTP Error 404 - File or directory not found.
> Internet Information Services (IIS)
>
> But when I ran the IIS in XP machine I didn't have any problem.  Any help 
> is
> greatly appreciated.   Thanks

Relevant Pages

  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Standalone IIS server access to sql in Domain
    ... There is no way to "trust" a domain from a non-domain machine - the only workaround is to replicate the account used on both ends. ... That means you need an account on IIS and the same account on the sql server machine. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Alternate to RDA
    ... Saves me a lot of time on researching. ... strict group and local policies rights, why was IIS chosen ... > I'm not aware of any other way to connect to SQL Server. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Active sync and SQL CE
    ... IIS is a requirement for either merge replication or RDA. ... ActiveSync to play with take a look at the Data Port line of products ... These work over ActiveSync to port SQL CE databases to ... and from SQL Server 2000 and Access. ...
    (microsoft.public.pocketpc.developer)
  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... You can fix the problem by using IIS 6.0 on Windows.NET with Windows.NET ... Domain Controllers using constrained delegation - but I assume this is out ... > uses NT group based permissons on the SQL Server, ...
    (microsoft.public.inetserver.iis.security)