I cant view my web app pages that are linked to SQL database??

[MrNate]

I have been deigning a web application in VB 2005 and I am having great difficulty in getting others to view the web pages. when i type in the url in ie browser to view the application (http://ipaddress/foldername.filename.aspx) it loads fine but then when i click on a link to the page that loads info from the SQL database it gives me the following error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

but i dont understand because the username i use for both SQL and windows is an admin username with all the neccicary rights AND ive used integrated windwos authentication!

If anyone could help i would really greatfull!

Nathan

[Enyi]

Hi,

I think this may help ... hopefully.

First thing is that when anyone runs an ASP.NET Web Application, the application runs under a built-in account on the server computer ( \\localhost\\ASPNET ). It in no way uses your windows account information to run the web pages.

Therefore, when you try to access a SQL database, the web pages use the ASPNET account. Ensure this account has the necessary permissions on the database.

This may also help, go to IIS admin in control panel, click security tab, then the first edit button at the top of the page. You would probably want to check anonymous access, and windows authentication at the bottom.

I'm hoping this helps, IIS is a real bugger when it comes to errors such as this, so is MSSQL. I don't like them.

Either way, it is an IIS or SQL server configuration problem, so I believe.