Re: Login failed for user '(null)'.
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 5 Jun 2007 10:23:46 -0400
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.
.
- Follow-Ups:
- Re: Login failed for user '(null)'.
- From: ShadowVixen
- Re: Login failed for user '(null)'.
- Next by Date: Re: Login failed for user '(null)'.
- Next by thread: Re: Login failed for user '(null)'.
- Index(es):
Relevant Pages
|
