Alvin, thank you for your comments. I had already set up SQL Server mode as you outline. The problem is that for asp.net applications that I have built which access images from SQLServer and is based on MM.NET 1.3, the image is never served up. However, if I turn off SQL Server mode for session management, the application works properly. This does not appear to happen in none MM.NET asp.net applications.
Regards,
Carl.
>Hi Carl,
>
>SQLServer -> Indicates that session state is stored on the SQL Server.
>
>You need to do the following to use SQLServer mode
>
>(1) Run InstallSqlState.sql (installed by default in
:\systemroot\Microsoft.NET\Framework\version) on the computer running SQL Server that will store the session state. This creates a database called ASPState with new stored procedures and ASPStateTempApplications and ASPStateTempSessions tables in the TempDB database
>
>(2)In the application's Web.config file, set mode=SQLServer and set the sqlConnectionString attribute. For example, sqlConnectionString="data source=localhost;Integrated Security=SSPI;Initial Catalog=northwind".
>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/html/gngrfsessionstatesection.asp
>
>ALSO CHECK THIS SETTING IS SQL:
>If you are going to use Windows Authentication, then the SQL Server needs to
>know about the IUSER account, which it doesn't by default since that is a
>local account on the web server.
>
>As a general rule of thumb you should create a seprate account to run the
>web app the has rights to the app and the sql server and is locked out of
>everything else. If you give IUSR or IWAM access then every request from any
>site that you have will have access to the data in your SQL Server, not just
>the one application.
>
>
>HTH.
>
>Alvin
Carl Olson, Jr.
CEO, Founder
Cerelogic, Inc.
www.cerelogic.com"Applying rocket science to business."