Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Select Data Provider GSP v2.6
Options
Previous Topic Next Topic
purkleturkle
#1 Posted : Monday, 23 January 2012 6:10:30 AM(UTC)
Rank: Member

Joined: 23/01/2012(UTC)
Posts: 4
Quote:
The installer does not have permission to modify web.config, which is required to configure the data provider. Do one of the following: (1) Give the IIS application pool identity write permission to web.config (by default this is Network Service in IIS 6/7 and IIS AppPool\DefaultAppPool in IIS 7.5) (2) Edit web.config manually so that the SQL Server providers are specified for membership, roles, and gallery data (3) Replace web.config with the one named web_sqlserver_2.0.config (.NET 2.0), web_sqlserver_3.5.config (.NET 3.5) or web_sqlserver_4.0.config (.NET 4.0). They are all pre-configured for SQL Server.


Where can I find the file called web_sqlserver_4.0.config?
Back to top
Roger Martin
#2 Posted : Tuesday, 24 January 2012 9:48:51 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Oops, that message was relevant for an earlier version, but not any longer. Only the first two options are valid. To manually configure web.config to point to SQL Server, open web.config in a text editor and set the three provider sections to point to SQL Server. They will look like this:

Code:
<dataProvider defaultProvider="SqlServerGalleryServerProProvider">

...

<membership defaultProvider="SqlMembershipProvider">

...

<roleManager enabled="true" cacheRolesInCookie="true" cookieProtection="Validation" defaultProvider="SqlRoleProvider">


Finally, update the connection string to point to your SQL Server:

Code:
<add name="SqlServerDbConnection" connectionString="server=(local);uid=;pwd=;Trusted_Connection=yes;database=YourDbName;Application Name=Gallery Server Pro" />

Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
daveburke
#3 Posted : Tuesday, 24 January 2012 8:12:06 PM(UTC)
daveburke

Rank: Advanced Member

Joined: 12/01/2009(UTC)
Posts: 62
Location: Vermont
Roger Martin;8251 wrote:
Oops, that message was relevant for an earlier version, but not any longer. Only the first two options are valid.


I'm glad you confirmed that, Roger. I looked through both my copies of v2.5 and v2.6 and could NOT find web_sqlserver_4.0.config. The thing is that I KNEW I saw it before! :-)

-Dave
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET