Re: Login failed for user

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/12/03


Date: Tue, 12 Aug 2003 08:16:37 +0200


Michael,

Possible errors are collected in the "Troubleshooting Guide for 80004005
Errors in Active Server Pages and Microsoft Data Access Components" article
at
http://support.microsoft.com/default.aspx?scid=kb;en-us;306518.

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Michael" <michael.kruk@marriott.com> wrote in message
news:0bfa01c36057$532cebe0$a001280a@phx.gbl...
> I have a SQL 2000 server and use W2K IIS server.  I have
> created a local account on both machines to gain access
> to the SQL database and have placed sed user name and
> password in my asp code.
>
> Sometimes my connection works fine other times I get the
> following error message:
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> Login failed for user 'sql2000'. Reason: Not associated
> with a trusted SQL Server connection.
> /acctg/calendar/Header.asp, line 58
>
>
> If I click "Refresh" after receiving the error I can view
> the page and add, delete, and update records in the
> database.  Sometimes the error appears right away
> othertimes I need to send 5 or 6 requests to the database
> before the error appears.
>
> what am I missing?


Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: Domain Name
    ... Michael Tissington ... it would be difficult to get NetBIOS name from SQL ... > Server. ... You'd better replace "clientComputerName" with the clinet name ...
    (microsoft.public.sqlserver.programming)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)