Logon failed for user ". but only for membership tables in same database that other request work
- From: "Sir Bill" <SirBill@xxxxxxxxxxxxx>
- Date: Mon, 10 Apr 2006 22:50:17 -0500
What am I missing? Computer A is windows xp sp2 with visual studio 2005.
Computer B is Server2003 with SQLServer2005.
Computer A: local website directory security configured for anonymous access
using a local user computer_A\username and password. The password is NOT
managed by iIIS.
Computer B: SQLServer2005 allows local and remote connections, sql server
and windows authentication. Local user computer_B\username and password is
defined.
User computer_B\username is defined in the sql server security logins with
login properties allowing access to database mydb. The default scheama
db_owner. The database (mydb) properties/permissions/effective permissions
are Authenticate, connect, delete,execute,insert,select and update.
The webconfig file has a connection string defined as:Name=LocalSqlServer
Connection String=Data Source=server.domain-name,1433;Initial
Catalog=mydb;Integrated Security=True;. The webconfig file contains <remove
name="LocalSqlServer" and then an <add name="LocalSqlServer" with the above
information. The webconfig file also has <identity impersonate="true" /> and
<authentication mode="Forms">
<forms name=".ASPXFORMSAUTH" loginUrl="login.aspx"
protection="Validation"/>
</authentication>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
My login page manually reads a table called usrTbl via a stored proceedure
to check for the existance of the username and password presented.(Yes I
know it is in the clear-bad bad me, just bear with me for the problem). It
then formsredirectfromlogin to the original requested page whice is
Default.aspx.
Default.aspx has a gridview defined. The datasource is defined in the page
load event as:
gridview1.datasource = membership.getallusers()
gridview1.databind()
I get an error Login failed for ". User not associated with a trusted
connection
How can that be, the database has been access earlier with the same
connection string. I checked to make sure user computer_B\username can log
on to computer B.
Please help me to understand a solution to this
.
- Follow-Ups:
- Prev by Date: Re: How to create system catalog view in sql server 2005
- Next by Date: RE: Logon failed for user ". but only for membership tables in same database that other request work
- Previous by thread: Re: How to create system catalog view in sql server 2005
- Next by thread: RE: Logon failed for user ". but only for membership tables in same database that other request work
- Index(es):
Relevant Pages
|
