Re: Can't authenticate on Win 2K machine thru SQL 7.0
From: Joe Stephens (joe@rummelcreek.com)
Date: 06/07/02
- Next message: J. v.d. Bovenkamp: "SSL question"
- Previous message: x y: "Re: SSL Security Alert"
- In reply to: x y: "Re: Can't authenticate on Win 2K machine thru SQL 7.0"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Joe Stephens" <joe@rummelcreek.com> Date: Fri, 7 Jun 2002 04:34:21 -0700
It worked!!
I just went in to the client config on the IIS server
and selected IP.
Thanks so much!
>-----Original Message-----
>If you just need access to the SQL server, I would use a
local account on
>the SQL server rather than a domain account, to be sure
the account does not
>get access to other resources on the domain. I believe
if you are using
>named pipes or Windows authentication in SQL you will
need a windows login
>ID set up.
>
>If you're trying to use a SQL login ID using SQL
authentication, you may
>need to confirm that you are using IP instead of named
pipes to connect to
>SQL. My understanding is that if you use named pipes,
you need to first
>have a valid windows networking connection and account
to the SQL server
>before you can authenticate to the SQL server using SQL
authentication. If
>you use IP instead of named pipes, I believe you do not
need a SQL ID.
>Microsoft seems to recommend Windows authentication
instead of SQL
>authentication as being more secure, but if the web
server is on the
>internet, it seems easier and more secure to me to be
allow SQL
>authentication through a DMZ firewall to your internal
network and disallow
>any netbios traffic to your web server.
>
>I assume the settings on the IIS server have not
changed. I understand that
>IWAM_user is used if the application isolation setting
on the folder in IIS
>is set to medium or high, but IUSR_user is used if set
to low.
>
>If your web server is on the internet, I would think
twice about allowing it
>to access a domain controller that contains your
internal users for security
>reasons, although if you have a limited amount of money
and servers, you may
>have no choice.
>
>"Joe Stephens" <joe@rummelcreek.com> wrote in message
>news:b71101c20cd1$241ca370$9ae62ecf@tkmsftngxa02...
>> I have a Win2K IIS 5.0 machine that has been querying
a
>> SQL 7.0 database on a Win 4.0 machine.
>>
>> We are retiring the 4.0 machine and set up a new Win 2K
>> machine an installed SQL 7.0 and imported the master
>> database and the database that we run the query on.
>>
>> We are getting some type of failure to connect, and
doing
>> a bit of research, it seems that the new Win 2k machine
>> which is running the new SQL 7 install doesn't like the
>> IWAM_IISMACHINE account making a query while the old
4.0
>> maching didn't care.
>>
>> Also the new Win 2K machine (the one with SQL 7) is a
PDC
>> emulator.
>>
>> What extra do I need to do? Do I need to set up a
domain
>> account called IWAM_IISMACHINE on the new Win2K with
the
>> same password as the IIS machine?
>>
>> Am I looking in the right place?
>
>
>.
>
- Next message: J. v.d. Bovenkamp: "SSL question"
- Previous message: x y: "Re: SSL Security Alert"
- In reply to: x y: "Re: Can't authenticate on Win 2K machine thru SQL 7.0"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
