Allow access to IUSR_MachineName

In SQL 2000 SP3.
I was trying to follow this page:
http://support.microsoft.com/default.aspx?kbid=3D299987
It's not that I cannot follow it but that I'd prefer to have the accound = that will access the database be IUSR_MachineName. So I gave = IUSR_MachineName the ability to logon on to this database in SQL 2000 = and no other.
I get to the point in the article where it has this for the connection = string:
StrConnect =3D "Provider=3DSQLOLEDB.1;User = ID=3DIUSR_MachineName;Password=3D<strong password>;Initial = Catalog=3Dhesterlogin;" & _
"Network Library=3Ddbmssocn;Data Source=3DMyServer"
and now I am stuck. What do I assign for the password here? The = IUSR_MachineName password is automatically generated by my Internet = Informaion Services and I really do not know how to access it. All = attempts I have made in the past have been well less then satisfatory. = I suppose I could try it again (requires some Windows Scripting) but I'm = hoping there is a better or easier way. Any suggestions? Thanks.
-- George Hester
__________________________________George,
If I understand your question, you need to specify in the connection string
that you want to do a Windows login. There are examples of connection
strings at www.connectionstrings.com.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:ece5WeTwDHA.2308@.TK2MSFTNGP11.phx.gbl...
In SQL 2000 SP3.
I was trying to follow this page:
http://support.microsoft.com/default.aspx?kbid=299987
It's not that I cannot follow it but that I'd prefer to have the accound
that will access the database be IUSR_MachineName. So I gave
IUSR_MachineName the ability to logon on to this database in SQL 2000 and no
other.
I get to the point in the article where it has this for the connection
string:
StrConnect = "Provider=SQLOLEDB.1;User
ID=IUSR_MachineName;Password=<strong password>;Initial Catalog=hesterlogin;"
& _
"Network Library=dbmssocn;Data Source=MyServer"
and now I am stuck. What do I assign for the password here? The
IUSR_MachineName password is automatically generated by my Internet
Informaion Services and I really do not know how to access it. All attempts
I have made in the past have been well less then satisfatory. I suppose I
could try it again (requires some Windows Scripting) but I'm hoping there is
a better or easier way. Any suggestions? Thanks.
--
George Hester
__________________________________|||Ah maybe trusted? Let me check. Thanks.
-- George Hester
__________________________________
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:Oy659LawDHA.1788@.tk2msftngp13.phx.gbl...
> George,
> > If I understand your question, you need to specify in the connection =string
> that you want to do a Windows login. There are examples of connection
> strings at www.connectionstrings.com.
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at:
> =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:ece5WeTwDHA.2308@.TK2MSFTNGP11.phx.gbl...
> In SQL 2000 SP3.
> > I was trying to follow this page:
> > http://support.microsoft.com/default.aspx?kbid=3D299987
> > It's not that I cannot follow it but that I'd prefer to have the =accound
> that will access the database be IUSR_MachineName. So I gave
> IUSR_MachineName the ability to logon on to this database in SQL 2000 =and no
> other.
> > I get to the point in the article where it has this for the connection
> string:
> > > StrConnect =3D "Provider=3DSQLOLEDB.1;User
> ID=3DIUSR_MachineName;Password=3D<strong password>;Initial =Catalog=3Dhesterlogin;"
> & _
> "Network Library=3Ddbmssocn;Data Source=3DMyServer"
> > and now I am stuck. What do I assign for the password here? The
> IUSR_MachineName password is automatically generated by my Internet
> Informaion Services and I really do not know how to access it. All =attempts
> I have made in the past have been well less then satisfatory. I =suppose I
> could try it again (requires some Windows Scripting) but I'm hoping =there is
> a better or easier way. Any suggestions? Thanks.
> > -- > George Hester
> __________________________________
> >|||Actually I was hoping to use IUSR_MachineName for the Windows Logon =account. But I see I need to put a password in for the connection =string. As my IIS controls the IUSR_MachineName password I cannot =hardcode that into the connection string. That is my issue. What do I =put in for the password so that IIS can continue to automatically =generate the IUSR_MachineName account's password and use that in my =connection string? Thanks.
-- George Hester
__________________________________
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:Oy659LawDHA.1788@.tk2msftngp13.phx.gbl...
> George,
> > If I understand your question, you need to specify in the connection =string
> that you want to do a Windows login. There are examples of connection
> strings at www.connectionstrings.com.
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at:
> =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:ece5WeTwDHA.2308@.TK2MSFTNGP11.phx.gbl...
> In SQL 2000 SP3.
> > I was trying to follow this page:
> > http://support.microsoft.com/default.aspx?kbid=3D299987
> > It's not that I cannot follow it but that I'd prefer to have the =accound
> that will access the database be IUSR_MachineName. So I gave
> IUSR_MachineName the ability to logon on to this database in SQL 2000 =and no
> other.
> > I get to the point in the article where it has this for the connection
> string:
> > > StrConnect =3D "Provider=3DSQLOLEDB.1;User
> ID=3DIUSR_MachineName;Password=3D<strong password>;Initial =Catalog=3Dhesterlogin;"
> & _
> "Network Library=3Ddbmssocn;Data Source=3DMyServer"
> > and now I am stuck. What do I assign for the password here? The
> IUSR_MachineName password is automatically generated by my Internet
> Informaion Services and I really do not know how to access it. All =attempts
> I have made in the past have been well less then satisfatory. I =suppose I
> could try it again (requires some Windows Scripting) but I'm hoping =there is
> a better or easier way. Any suggestions? Thanks.
> > -- > George Hester
> __________________________________
> >