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
>
>.
>