Re: Login failed for user '(null)'.

The version information follows:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 1)

When I changed IIS on my machine to not allow anonymous, I was able to
access it. However, I am finding that others can not and they get the error
mentioned in my first post. They do have access to the SQL Server because
they are using VBA though excel to hit the same database. I am stupmed!

"Bob Barrows [MVP]" wrote:

ShadowVixen wrote:
Getting the following error when attempting to access my web app from
a machine other than my local machine (housing the IIS server).

Error Type:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
/wfhv/content.asp, line 12

I am connecting to a SQL server that uses trusted security using the
following Connection String (Names changed to protect the innocent):

Provider=sqloledb;Data Source=asdfjkl,1433;Initial
Catalog=TstDB;Integrated Security=SSPI;

The web server is currently on my local machine and after tweaking the
settings I can access without issue locally. However, when another
member of my team attempts to access they get the message shown
above. I have verified that their domain account is set up as a user
on the SQL Server. Any ideas?

Verify that your website has Anonymous disabled. Verify by using

Response.Write "The logged in user is """ & _
Request.ServerVariables("LOGON_USER") & """<BR>"

If you don't see the login name of the user, then neither will SQL
Server.

If that's not it, go through the FAQ on SQL Server connections
(http://databases.aspfaq.com/database/what-should-my-connection-string-l
ook-like.html) and make sure you've followed all the recommendations.

Then look at the results of this Google search:
http://www.google.com/search?ie=UTF-8&oe=UTF-8&sourceid=gd&q=Login+failed+for+user+%27Null%27&hl=en&rls=GGLD,GGLD:2005-37,GGLD:en

If you still have problems, provide more details (SQL Server version and
service pack).

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.



.

Relevant Pages

  • Re: Newbie: SQL Server connection, help needed
    ... Mike Epprecht, Microsoft SQL Server MVP ... > trying to setup an ODBC connection from another XP and win2000 machines. ... Not associated with a trusted SQL Server connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: OWC11 with Vb.Net
    ... mentioned as "SQL Server Connection String" since I am posting in the forum. ... Response.Write(pivotTable1.HTMLData) so the pivot report is going to be ... OWC Blackbook now on download at www.lulu.com/owc ...
    (microsoft.public.office.developer.web.components)
  • Re: Please help with DTS filter
    ... I am going to have to guess what the package looks like but I am guessing that there is an XL Connection and a SQL Server connection and a blank line between the two going from XL to SQL Server. ... It is here on the first tab that you could see the filter being applied through a WHERE clause. ...
    (microsoft.public.sqlserver.dts)
  • Re: OWC11 with Vb.Net
    ... Is it pointing to SQL server or a cube? ... The pivot table writes MDX expressions, SQL server does not understand MDX expressions. ... OWC Blackbook now on download at www.lulu.com/owc ... pivotTable1.ConnectionString = "SQL Server Connection String" ...
    (microsoft.public.office.developer.web.components)
  • Re: Users lost access to SQL Server
    ... A connection could not be established to DEV-SVR-1. ... Reason: ... associated with a trusted SQL Server connection.. ... Please verify SQL Server is running and check your SQL ...
    (microsoft.public.sqlserver.security)
Loading