Authentication Problem

I have an NT domain with an SQL Server 2000 server. Although there is
normally no problem for users to connect to the SQL server, I am now trying
to setup access for the IIS on one of the NT4 servers.
I have setup an ODBC connection on the NT4 server and added the IUSR account
for the NT server on the SQL server. However when I open an ASP page that
uses the DBC connection I get the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.
I have also tried adding an SQL user account rather than a domain account
and tried to setup the ODBC connection using the SQL account but I then get
an error saying that it can't login as it is not associated with a trusted
SQL connection.
See if this helps:
http://support.microsoft.com/default...b;EN-US;247931
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"MJ" <spaamfree@.belmont.co.uk> wrote in message
news:10dvjd2gvhivcb2@.corp.supernews.com...
I have an NT domain with an SQL Server 2000 server. Although there is
normally no problem for users to connect to the SQL server, I am now trying
to setup access for the IIS on one of the NT4 servers.
I have setup an ODBC connection on the NT4 server and added the IUSR account
for the NT server on the SQL server. However when I open an ASP page that
uses the DBC connection I get the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.
I have also tried adding an SQL user account rather than a domain account
and tried to setup the ODBC connection using the SQL account but I then get
an error saying that it can't login as it is not associated with a trusted
SQL connection.
|||Moving a database from one disk to another on the same machine/same instance
of SQL Server should have NO effect on access..
You mentioned that users of OTHER databases are also having problems... The
table which might have the answer is in master..sysxlogins...
Do a dbcc checktable on it ( and maybe dbcc checkdb) on master... you may
have some corruption problems.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MJ" <spaamfree@.belmont.co.uk> wrote in message
news:10dvjd2gvhivcb2@.corp.supernews.com...
> I have an NT domain with an SQL Server 2000 server. Although there is
> normally no problem for users to connect to the SQL server, I am now
trying
> to setup access for the IIS on one of the NT4 servers.
> I have setup an ODBC connection on the NT4 server and added the IUSR
account
> for the NT server on the SQL server. However when I open an ASP page that
> uses the DBC connection I get the error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.
> I have also tried adding an SQL user account rather than a domain account
> and tried to setup the ODBC connection using the SQL account but I then
get
> an error saying that it can't login as it is not associated with a trusted
> SQL connection.
>
|||additionally, you might read in Books On Line about the procedure for moving
a log shipping database into production... It includes the tasks of getting
master..sysxlogins to match up with the database users..
Some of the information there will describe how the two tables work together
and how you might fix yours ( if it has been corrupted..)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MJ" <spaamfree@.belmont.co.uk> wrote in message
news:10dvjd2gvhivcb2@.corp.supernews.com...
> I have an NT domain with an SQL Server 2000 server. Although there is
> normally no problem for users to connect to the SQL server, I am now
trying
> to setup access for the IIS on one of the NT4 servers.
> I have setup an ODBC connection on the NT4 server and added the IUSR
account
> for the NT server on the SQL server. However when I open an ASP page that
> uses the DBC connection I get the error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.
> I have also tried adding an SQL user account rather than a domain account
> and tried to setup the ODBC connection using the SQL account but I then
get
> an error saying that it can't login as it is not associated with a trusted
> SQL connection.
>