VS2005: Cannot run the website from IIS (database problem)

[TTT]

Hi,

I have developed a website from the model "Starter kits Classified". Well,
the application works good, no problem in my development environment. It
uses a SqlServer 2005 express database (using *.MDF files).

But, when i try to copy it to a IIS website, it dosent work.
- I created a website called "MyApp" under IIS (windows xp pro)
- I copied all the files from my "Visual Studio Express 2005 Web dev" to the
IIS/Default website/MyApp (files in c:\inetpub\wwwroot\MyApp)
- I setup ASP.NET config : ASPNET v2.0, default page = Default.aspx, Runtime
login = ASPNET (without admin rights), Windows integrated authentification
activated.

Results : the login page (login.aspx) works, but it doesnt connect.
It seems that the ASPNET user cannot connect to the Sql server database.
For me it's a mater of access rights to SqlServer 2005 from IIS.

Any ideas to help me please?
Thank you !

[Cowboy \(Gregory A. Beamer\)]

As long as SQL Express is also installed on the machine, then you are
probably right that it is a access problem (I say that rather than access
rights as there is a prime reason for failure that is not "rights" based).

Check and make sure you have a protocol other than in memory (configuration
tool). That will cure most problems. In some instances, you also have to
turn on SQL Browser. That cures another group. In some instances, you will
also have to add users to SQL Server and give rights to the database, as
well.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************************************************
Think Outside the Box!
*************************************************
"TTT" <[e-mail] in message
news:45***********************@news.free.fr...

Hi,

I have developed a website from the model "Starter kits Classified". Well,
the application works good, no problem in my development environment. It
uses a SqlServer 2005 express database (using *.MDF files).

But, when i try to copy it to a IIS website, it dosent work.
- I created a website called "MyApp" under IIS (windows xp pro)
- I copied all the files from my "Visual Studio Express 2005 Web dev" to
the IIS/Default website/MyApp (files in c:\inetpub\wwwroot\MyApp)
- I setup ASP.NET config : ASPNET v2.0, default page = Default.aspx,
Runtime login = ASPNET (without admin rights), Windows integrated
authentification activated.

Results : the login page (login.aspx) works, but it doesnt connect.
It seems that the ASPNET user cannot connect to the Sql server database.
For me it's a mater of access rights to SqlServer 2005 from IIS.

Any ideas to help me please?
Thank you !

[TTT]

As long as SQL Express is also installed on the machine, then you are

probably right that it is a access problem (I say that rather than access
rights as there is a prime reason for failure that is not "rights" based).

Check and make sure you have a protocol other than in memory
(configuration tool). That will cure most problems.

I dit it

In some instances, you also have to turn on SQL Browser. That cures
another group.

I did it also..

In some instances, you will also have to add users to SQL Server and give
rights to the database, as well.

How to do it?

>Hi,

I have developed a website from the model "Starter kits Classified".
Well, the application works good, no problem in my development
environment. It uses a SqlServer 2005 express database (using *.MDF
files).

But, when i try to copy it to a IIS website, it dosent work.
- I created a website called "MyApp" under IIS (windows xp pro)
- I copied all the files from my "Visual Studio Express 2005 Web dev" to
the IIS/Default website/MyApp (files in c:\inetpub\wwwroot\MyApp)
- I setup ASP.NET config : ASPNET v2.0, default page = Default.aspx,
Runtime login = ASPNET (without admin rights), Windows integrated
authentification activated.

Results : the login page (login.aspx) works, but it doesnt connect.
It seems that the ASPNET user cannot connect to the Sql server database.
For me it's a mater of access rights to SqlServer 2005 from IIS.

Any ideas to help me please?
Thank you !