Problems connecting ASP.net to SQL database

[AspGuy817]

I have two servers:

Server A: "Website Server" This server is running an ASP.NET 2.0 website on Windows Server 2003 Web Edition with IIS6. I am attempting to use membership roles to allow users to login to my website.

Server B: "Database Server" This server is running a SQL Server 2005 Enterprise Edition database on Windows Server 2003.

Both machines are part of a domain that I created.

The implementation I am hoping to achieve is for the website on the website server to use the sql database on the database server to manage its users.

I ran the aspnet_regsql.exe from
C:\Windows\Microsoft.net\framework\v2.0.50727 on the Website Server to create the sql database schema and the database on the Database Server. The website on the Website Server is using Windows forms authentication as a login mechanism for users. I was able to successfully create an account using the ASP.net website administration tool and the account shows up inside of the users table in the SQL database on the Database Server, but when I attempt to login to the website using this new account I receive the following error message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Any help would be greatly appreciated. Thanks.

 

[ca8msm]

If you have a look on google for this error message you'll get thousands of results as this is a very common problem. One of the articles I'd suggest reading is

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html/secmod03.asp?frame=true

which shows you the various authentication methods and procedures you'll need to be aware of when setting up a scenario like yours.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[AspGuy817]

Nothing on that website discusses how to allow connections into a SQL database on a remote machine.

 

[jbenson001]

http://www.connectionstrings.com

 

[ca8msm]

Nothing on that website discusses how to allow connections into a SQL database on a remote machine.

It's irrelevant whether the machine is remote or not, the principle of security is still the same and you still should still read and try to understand it.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[rdgerken]

I'd check the surface area configuration and firewall... lots of times that can prevent connections into a remote SQL DB.