Problem with ConnectionString

[Jay1b]

Hi

I've created an Intranet site, the site references a SQL Server. If I use the following connectionstring it works:

	<connectionStrings>
		<add name="Conn" connectionString="Data Source=SQLINSTANCENAME\DATABASENAME;Initial Catalog=ADL_Internal;user id=sa;password=PASSWORD" providerName="System.Data.SqlClient"/>
     </connectionStrings>

However this is clearly unsecure! Internal VB.NET applications work with the following connection string, but when i try this connection string with the ASP.NET site, it doesnt.

	<connectionStrings>
    <add name="Conn" connectionString="Data Source=SQLINSTANCENAME\DATABASENAME;Initial Catalog=ADL_Internal;Integrated Security=TRUE;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

This is the error i get:

Login failed for user SQLINSTANCENAME\DATABASENAME$'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user SQLINSTANCENAME\DATABASENAME$'.


On another webserver, we have classic ASP pages, using Integrated Security which works find. What do i do need to do to get it working for my ASP.NET page? The IIS setup is the same as far as I can tell.

I hope this post isnt a bit to 'muddled', I would appreciate any help you may be able to give.

Thanks