Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual directory
using the SQLXML IIS utility and all is well. BUT... when I try connecting
to the web service via VS.NET, I keep getting this...
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: The virtual name could not be recognized
I even get that if I try browsing the WSDL file directly from IE.
Now I've checked the security, I've checked the configuration, I've checked
it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
Now the odd thing is if I disable the application on that virtual directory
(thus stopping the maaping through the DLL, I can properly browse the WSDL
file. HUH?
So... anyone got any ideas and if not, any bullets or a large mallet?
Mark
Please don't shoot.
I forwarded your problem to one of the people of the SQLXML team and hope he
will reply to you.
Best regards
Michael
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
|||Hi there,
Do you have the SOAP Toolkit 2.0 installed? SqlXml 3.0 SP2 requires it for
using web services. However, if you can wait a bit longer, we will be
releasing SP3 which removes that dependency so SOAP Toolkit is no longer
needed.
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.
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
Showing posts with label sqlxml. Show all posts
Showing posts with label sqlxml. Show all posts
Monday, March 12, 2012
Friday, March 9, 2012
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
Subscribe to:
Posts (Atom)