'System.InvalidOperationException' and 'Instance failure'

cuddling101 · November 28th, 2010, 12:28 AM

I am in the process of following through on your request to create new website etcetera. On page 715 of Beginning ASP.NET 4 I am reading point 4.

I am operating Windows Vista and Windows Server 2008 R2.

I have chosen ApplicationPoolIdentity BUT I am unsure about the next instruction.

Quote:

In the same dialog, set the Load User Profile option to True if you're using Windows 7 or Server 2008.

I find that my option is currently set to True. Is this correct for a Vista and R2 configured machine?

Imar · November 28th, 2010, 06:00 AM

I think you misunderstood my request about a new web site. I didn't mean a new deployed web site in IIS, but simply a new one in Visual Studio. E.g.:

1. File | New Web Site

2. Add a Model to your database. When asked for a connection, use . (a dot) as the server name.

3. Add some code to target your new entities.

I have the feeling you're making this a bit harder than it needs to be by using lots of different connection strings copied from different projects targeting different SQL Server. By starting from scratch, you can easily target EF correctly and see what connection string it adds to your project. You can then drop the other connection strings and just use the new one.

Quote:

I find that my option is currently set to True. Is this correct for a Vista

IIRC, this is the default for Vista.

Just curious: are you trying to make this work under IIS on Vista to understand how this all works? Or just to reproduce and fix the EF problem? In the latter case, I would skip it. IIS on Vista is not a good platform to host production sites. If it's all about learning, then it's well worth the time of course.

Cheers,

Imar

cuddling101 · November 28th, 2010, 07:25 AM

Hello Imar

I am certainly not doing this just for learning's sake. I am trying to get an operational website running asap. I have already wasted one year of registration of domain names and don't want to completely waste the second.

I had thought I needed to work out the new connection string. I did not understand that all you wanted me to do was choose new connection string and then put a dot for server name, when I went to add the entity data model.

The Object Model stuff does seem to be working in the new web site.

Are you telling me that what I should do now is -

1. Delete all the connection strings in my main site web.config file, and then
2. Copy in what was generated in the new try it out?

Just one other point, you did lose me a bit with the reference to IIRC; I did not understand how that related to the Load User Profile option, and its setting to True or False?

Please advise.

Thank you

Philip

Imar · November 28th, 2010, 07:29 AM

Quote:

Are you telling me that what I should do now is -

1. Delete all the connection strings in my main site web.config file, and then
2. Copy in what was generated in the new try it out?

Yes. You seem to have messed some settings in the config file. Manually changing them could make things worse. So, by creating a brand new site with a new model, you can see the connection string that VWD creates for you.

The setting is true by default in Vista so you don't have to change it from False to True as the instructions tell you to do for other OS's. If you find it's false, you need to set it to true. but you don't have to do that as it already is true.

Cheers,

Imar