iis connection problem with sql server

Hi all,
I am new to this so please bear with me. I have scoured the ms help pages
and could not find the answer so here goes:
I have a web serverwith iis and a db sql server on separate boxes.
I am trying to use the tool configure sql xml support in iis to connect to
the server.
I tried following the instructions given. However, when I try the connect
option and type in the computer name of the webdev server (which does have
iis installed) I get the following error: 'An error occurred connecting to
'webdev'. This server does not exist or is unavailable.'
I have double-checked to make sure that iis does exist in the webdev server.
there is no iis installed on the sql server box.
What am I doing wrong here?
Please help me out if you can.
Thanks : )Hi there,
To Clarify, webdev is the name of the Web Server? When you say you try the
"connect option", the connect option in what? Our IIS tool? That is
supposed to connect to the db server.
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://msdn.microsoft.com/xml
This posting is provided "AS IS" with no warranties, and confers no rights.
"mari" <mari@.discussions.microsoft.com> wrote in message
news:9575E87B-56BD-4767-9E70-3237B2124A2A@.microsoft.com...
> Hi all,
> I am new to this so please bear with me. I have scoured the ms help pages
> and could not find the answer so here goes:
> I have a web serverwith iis and a db sql server on separate boxes.
> I am trying to use the tool configure sql xml support in iis to connect to
> the server.
> I tried following the instructions given. However, when I try the connect
> option and type in the computer name of the webdev server (which does have
> iis installed) I get the following error: 'An error occurred connecting to
> 'webdev'. This server does not exist or is unavailable.'
> I have double-checked to make sure that iis does exist in the webdev
> server.
> there is no iis installed on the sql server box.
> What am I doing wrong here?
> Please help me out if you can.
> Thanks : )|||Unless you mean right-clicking the IIS Virtual Directory Manager node in the
tree-pane and clicking Connect, in which case it's looking for an IIS server
to manage (in other words you want to use the Configure SQL XML Support in
IIS tool to create a SQLISAPI application on a remote IIS server). I assume
SQLXML has to be installed on the Web server you're connecting to (and you
might as well download and install SQLXML 3.0, which is the latest version,
rather than use the version that shipped with SQL Server 2000).
If that doesn't resolve it, it could simply be a network name resolution
issue. Can you ping the Web server from the computer where the SQL XML
config tool is installed? Can you manage IIS remotely using the standard IIS
Manager tool?
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Irwin Dolobowsky [MS]" <irwind@.mail.microsoft.com> wrote in message
news:uYMODJx4EHA.2192@.TK2MSFTNGP14.phx.gbl...
Hi there,
To Clarify, webdev is the name of the Web Server? When you say you try the
"connect option", the connect option in what? Our IIS tool? That is
supposed to connect to the db server.
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://msdn.microsoft.com/xml
This posting is provided "AS IS" with no warranties, and confers no rights.
"mari" <mari@.discussions.microsoft.com> wrote in message
news:9575E87B-56BD-4767-9E70-3237B2124A2A@.microsoft.com...
> Hi all,
> I am new to this so please bear with me. I have scoured the ms help pages
> and could not find the answer so here goes:
> I have a web serverwith iis and a db sql server on separate boxes.
> I am trying to use the tool configure sql xml support in iis to connect to
> the server.
> I tried following the instructions given. However, when I try the connect
> option and type in the computer name of the webdev server (which does have
> iis installed) I get the following error: 'An error occurred connecting to
> 'webdev'. This server does not exist or is unavailable.'
> I have double-checked to make sure that iis does exist in the webdev
> server.
> there is no iis installed on the sql server box.
> What am I doing wrong here?
> Please help me out if you can.
> Thanks : )