Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I Still have problems.
Now I have two win 2k server, one with IIS and one with Sql Server 2k.
When I try to access from a client with 2k professional i have this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'
Im using windows integration in both servers (IIS and SQL)
Can anyone help me!?
Riane Santos
http://www.experts-exchange.com/Data..._20800659.html
"Riane de Oliveira Torres Santos" <riane@.cpunet.com.br> wrote in message
news:OWyejbckEHA.3432@.TK2MSFTNGP14.phx.gbl...
> I Still have problems.
> Now I have two win 2k server, one with IIS and one with Sql Server 2k.
> When I try to access from a client with 2k professional i have this error:
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'
> Im using windows integration in both servers (IIS and SQL)
> Can anyone help me!?
> Riane Santos
>

Login failed for user ''. The user is not associated with a trusted SQL Server connectio

My machine has Win XP and IIS 5.1.
I installed Visual Studio 2005 without SQL Express 2005. SQL Server
2005 is installed on another machine with Win 2003.
I created a Web Site in .NET VB. I created a connection with my SQL
server database, I can retrieve/ change data in SERVER EXPLORER. When I
try to create a gridview with data fron one table and to run the web
page in Internet Explorer I receive the following error.
Login failed for user ''. The user is not associated with a trusted SQL
Server connection.
Can you please help me ?
Which connection string are you using to connect to the database, I
guess you are using SQL Server authentication which isn=B4t setup
properly on your computer.
So switch to mixed authentication, or use a Windows account to connect
to the database-
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Which connection string are you using to connect to the database, I
guess you are using SQL Server authentication which isn=B4t setup
properly on your computer.
So switch to mixed authentication, or use a Windows account to connect
to the database-
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
How do you set up your database? A Windows Authenication or Mixed?
<CLarkou@.gmail.com> wrote in message
news:1142862649.046140.21050@.z34g2000cwc.googlegro ups.com...
> My machine has Win XP and IIS 5.1.
> I installed Visual Studio 2005 without SQL Express 2005. SQL Server
> 2005 is installed on another machine with Win 2003.
> I created a Web Site in .NET VB. I created a connection with my SQL
> server database, I can retrieve/ change data in SERVER EXPLORER. When I
> try to create a gridview with data fron one table and to run the web
> page in Internet Explorer I receive the following error.
> Login failed for user ''. The user is not associated with a trusted SQL
> Server connection.
> Can you please help me ?
>
|||I am using the following:
<remove name="LocalSqlServer" />
<add name="SubDispConnectionString1" connectionString="Data
Source=CYNICSQL1;Initial Catalog=SubDisp;Integrated Security=True"
providerName="System.Data.SqlClient" />
|||Hi, I set it as "Integrated Security=True"
|||No, this is just the connection string, not themode SQL Server is set
to. The one (COnnectionString) is the client, the authentication mode
(mixed) is the server side.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||The reason people keep asking about authentication modes is that this error
message usually means you are trying to connect with a SQL Server login to a
SQL Server instance that only supports Windows authentication. It sounds
like this is not your issue because you are connecting with Integrated
Security and not supplying a user name or password. The other possible
cause is that the Windows user has no right to authenticate a Windows
connection on the server where SQL Server is running. This can be a "double
hop" error if you are using Windows authentication on the Web site. It
could also be a case that ASPUSER has no rights to connect to the SQL Server
machine.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<CLarkou@.gmail.com> wrote in message
news:1142867073.546213.317310@.t31g2000cwb.googlegr oups.com...
> Hi, I set it as "Integrated Security=True"
>
|||I tried creating a website with FILE SYSTEM, not HTTP, and I was able
to open the web page in IE with SQL server data. ASPUSER is used for
connecting to the SQL SERVER machine with FILE SYSTEM web site ?
|||The server authentication is "Windows Authentication Mode".

Login failed

I have a network based on Win 2000 advanced server, and my database is SQL Server 6.5 using replication from a publisher to subscribers. Recently I have changed all "sa" passwords, which were the same on all servers, and after this only change the Replication of data is not working anymore.
I have this error:
28000[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed
How do I fix that?
I need some help about.

Regards,Is the error for the log reader, the distribution agent, or both?

-PatP|||Hi,
The log reader is working properly. The error is from distribution task

ie SERVER1..BD1 -- Replication --> SERVER2..BD2

taskname: SERVER1_BD1_SERVER2_BD2|||See sp_changesubscriber (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_4kaa.asp) for details.

-PatP|||See this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;216848 is any help.

Login Confusion

Hi,

I am Just beginning to get to grips with SQL Server v 7 security on a stand
alone win 98 PC.

I have created a login which only has access to the pubs database and when I
try and connect to any other database (while using this login) I am
correctly told that I don't have access. However, Enterprise Manager does
not request a login and therefore the log in seems to grant full access to
every database.

How can I get Enterprise Manager to request a log in?

Thanks.Stevie D (Steve@.127.0.0.1) writes:
> I have created a login which only has access to the pubs database and
> when I try and connect to any other database (while using this login) I
> am correctly told that I don't have access. However, Enterprise Manager
> does not request a login and therefore the log in seems to grant full
> access to every database.
> How can I get Enterprise Manager to request a log in?

Right-click the server and select Edit Registration properties. There
is a checkbox for always being prompted.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland

This worked fine

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns960F305E4DBEYazorman@.127.0.0.1...
> Stevie D (Steve@.127.0.0.1) writes:
> > I have created a login which only has access to the pubs database and
> > when I try and connect to any other database (while using this login) I
> > am correctly told that I don't have access. However, Enterprise Manager
> > does not request a login and therefore the log in seems to grant full
> > access to every database.
> > How can I get Enterprise Manager to request a log in?
> Right-click the server and select Edit Registration properties. There
> is a checkbox for always being prompted.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp