Lgin failed for user <XXXX\ASPNET>

Question

User-419034929 posted

When I test the TimeTracker i VS2005 it runs fine, but when it is published on ISS I get the error: LoginFailed For User <XXXX\ASPNET>

I had the MDF file attatched to SQL Express Management and ran the following script:

sp_grantlogin 'XXXX\ASPNET'
GO

sp_grantdbaccess 'XXXX\ASPNET'
GO

sp_addrolemember 'db_owner', 'XXXX\ASPNET'
GO

And after I detatched it again.

 I'm runninng it on XP-pro, using SQL Express.

Somtimes It won't even show the Login.aspx, and it show the same error, then when i hit refresh It show the page. Then when i try to login, the error reappears.

 I think i't a Timeout problem but I added 'Connect Timeout=30' in the web.config connectionstring, and that didnt solve the problem.

Answer 1

User886463885 posted

Hi,

I suggest you try following :

1. Go to computer management console (mycoputer>rightclick>manage)
2. Navigate to local groups
3. Add XXX\ASPNET in all SQL Server gorups

Then try following

1. Go inet mgr
2. Check whether "Integrated windows authentication is checked"

Reset IIS and try.

Answer 2

User-419034929 posted

Thanks.

 Now it dosen't throw an unhandled execption. Now I just can't login on the page. But somebody else have a thread on that 'Login issue'.

Answer 3

User555306248 posted

Can u post the error that you are getting ....

It will be useful for solving the problem...