Thanks for your response Shimon,
So you can still have the application running correctly(connect to the SQL
EXPRESS db) in VS 2005 test web server? If so, the difference between IIS
hosted application and the test webserver hosted one is that when using
Test web server, the process runs under the current logon user(the
interactive user ....). When hosting in IIS, it use the IIS's worker
process identity run the application. I suggest you try the following
things:
Move your web project from the user specific location( C:\Documents and
Settings\Shimon\My Documents\Development\WebRoots\PipeBizWeb\PipeBizW eb\)
to a public location such as D\WebProjects\PipeBizWeb and retest it through
both vs 2005 test server and IIS to see whether it works. If still not
work, you may consider open the SQLExpress manager through SQL 2005
management studio and then try grant your IIS's ASP.NET worker process
account the sufficient permission to access any database in the SQL Express
instance. IMO, it is likely due to the mdf file is under your logon user's
user specific location which can not be correctly referenced by the IIS
worker process account.
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure!
www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)