Website made in Web Developer 2008 is not running on IIS 5.1

Question

0.00/5 (No votes)

See more:

Hello there,

I made a website using Web developer and SQL Express 2k8, later i Switched to SQL Enterprise edition ten i just made a littele change in machine.config file and website was runing smoothly but wen i tried to run the website using IIS 5.1 it gives me following error

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:......

is it bcoz i have made website using .NET 3.5 and my IIS have 2.0??

Thanks in advance

Posted 31-Jul-11 6:29am

alchemist_NKJ

Add a Solution

3 solutions

Solution 3

Thanks Everyone,Finally it is running on the IIs

For that above problem i changed the user instance in machine.config file to false then that problem was solved but then iis was showing a new error

login failed for MACHINENAME\ASPNET:---

For that i created a user account in SQL server and Granted some permission and ......then i was a free man.. :D

would be haapy to assist if anyone having same kind of problem..

once again Thanks Guys for your time :)

Posted 31-Jul-11 23:26pm

alchemist_NKJ

Comments

Wonde Tadesse 1-Aug-11 7:24am

Nice to hear.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Accepted Answer · 2011-07-31T07:03:00

Solution 1

Here's an idea - why don't you install .Net 3.5 and see if that fixes it... However, that sounds more like a SQLServer error to me.

Did you upload the database specified in the connection string to the server?

BTW, wouldn't it be better to create a web service and use that instead of using a direct connection to your database from the web page?

Posted 31-Jul-11 7:03am

#realJSOP

Updated 31-Jul-11 7:08am

v4

Comments

alchemist_NKJ 31-Jul-11 16:13pm

Thanks for your time John,
I Installed .net 3.5 but in My IIS it is still showing 2.0 and have uploaded the same database specified in Connection String.

as of Web service,i was going through this web service concept(i had no idea) but i dont think i have enough time to start working on that :(

I can guess it is because of of config file(machine.config or web.config) but i am not able to find out.

Abhijit Jana 31-Jul-11 17:24pm

If you installed .NET 3.5, your IIS will still show 2.0, because 2.0 is the CLR version which is targeted for FW 3.5 . If you installed .NET 4.0 , you will see 2 option, 2.0 and 4.0 because .NET 4.0 targeted to CLR 4.0.

Coming to you problem, did you try with registering your IIS with APS.NET using aspnet_regiis - i command ?

Wonde Tadesse · Accepted Answer · 2011-07-31T14:23:00

Solution 2

In addition to the solution what is given by John, take a look at this discussion.Is possible to work with IIS 5.1 and .NET Framework 3.5?[^]

Posted 31-Jul-11 14:23pm

Wonde Tadesse