IIS and SQL Server on separate machine

Hi,
Can anybody please help me how to set up a conncetion between IIS & SQL
Server on seperate machine.
1. Domain is same
2. I've tried as per the article 176380, but we are facing some problem on
IIS. So my Network manager said I need to try something else.
Please let me know the steps that I have to do.
Thanks in Advance.
Kavi
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:B3583882-BE7C-4419-8269-F8F8CA1EF44C@.microsoft.com...
> Can anybody please help me how to set up a conncetion between IIS & SQL
> Server on seperate machine.
> 1. Domain is same
> 2. I've tried as per the article 176380, but we are facing some problem on
> IIS. So my Network manager said I need to try something else.
What's the problem? And, what have you tried so far? More detail helps!
Steve
|||Hi Steve,
OK the following steps I've done.
1. Created a user account on the Domain Controller called
IUSR_MY_WEB.
2. Added this user account to the Guest Group of both SQL
Server & the IIS Machine.
3. On the computer where IIS is running the aninymous
login, the user name is set up as IUSR_MY_WEB
OK, the following step, I don't understand (What the
article 176380 says)
"On the computer that is hosting SQL Server, use the
Security manager to map the IUSR_MY_WEB account to an
existing user logon on SQL Server. For more Info on how
to do this, consult the SQL Server Documentation"
I tried to find more info from the Documentation & I'm
not successful.
What I did was I created a USER LOGIN in SQL Server as
DOMAIN\IUSR_MY_WEB.
In the ASP Program, I've used the OLE-DB Provider as
follows:
Dim oConn: Set oConn=Server.CreateObject
("ADODB.Connection")
'oConn.Open "Driver={SQL
Server};Server=SQLSERVERMACHINENAME;Network=DBMSSO CN;Datab
ase=MYDBASE;Uid=DOMAIN\IUSR_MY_WEB;Pwd="
Even I tried with IP address also.
Hope this info will gives you a clear picture, what am I
doing wrong?
Thanks.
>--Original Message--
>"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
>news:B3583882-BE7C-4419-8269-
F8F8CA1EF44C@.microsoft.com...[vbcol=seagreen]
between IIS & SQL[vbcol=seagreen]
facing some problem on[vbcol=seagreen]
something else.
>What's the problem? And, what have you tried so far?
More detail helps!
>Steve
>
>.
>

IIS

I have .net 2003 installed on my pc without IIS, because in our organisation there is web server separate and there its installed IIS. Can anybody let me know how to configure my application to the server so that i can open my application. because its giving the following error

The Web server reported the following error when attempting to create or open the web project location at the following location URL:http://192.168.0.61/HelpDesk' http/1.1 503 Service unavailable.

im using windows 2000

is it possible to run asp.net application file from web server without installing IIS in my system.. please reply .

Its very urgent. Thanks

Sorry, this is not an IIS forum, but before you move over to another you should check if the Virtual Directory you want to use is exisiting on port 80, if the service is started and ready to answer requests on the WebServer. if you are starting a web application on a remote server, then yes, the execution of an ASP.NET application from a "simple" equiped client with just a brwoser is possible. if you want to host an ASP.NET application on your computer then you probably will need to have some sort of WebServer with support for ASP.NET.

Jens K. Suessmeyer.

http://www.sqlserver2005.de