Skip to content

Instantly share code, notes, and snippets.

View tomekjuranek's full-sized avatar

tomekjuranek

  • Alan Systems
View GitHub Profile
@tomekjuranek
tomekjuranek / gist:4031574
Created November 7, 2012 13:26
Grants the specified user or group access to the IIS metabase and other directories that are used by ASP.NET.
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -ga {server}\{user}
C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -ga {server}\{user}
C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -ga {server}\{user}
C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -ga {server}\{user}
@tomekjuranek
tomekjuranek / ConnectionStrings.xml
Created November 8, 2012 10:44
Sitecore connection strings with integrated security
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
<add name="core" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Core;Integrated Security=SSPI"/>
<add name="master" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Master;Integrated Security=SSPI"/>
<add name="web" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Web;Integrated Security=SSPI"/>
<add name="analytics" connectionString="Data Source=host\SQLDBNAME;Database=Sitecore_analytics;Integrated Security=SSPI"/>
</connectionStrings>
@tomekjuranek
tomekjuranek / gist:4109920
Created November 19, 2012 09:59
sitecore configuration transformation
<Target Name="TransformConfigFiles" AfterTargets="AfterBuild" Condition="'$(TransformConfigFiles)'=='true'">
<Copy SourceFiles="Web.config" DestinationFiles="Web.Original.config" />
<Copy SourceFiles="$(WebProjectOutputDir)\App_Config\ConnectionStrings.config" DestinationFiles="$(WebProjectOutputDir)\App_Config\ConnectionStrings.Original.config" />
<TransformXml Source="Web.Original.config" Transform="$(ProjectConfigTransformFileName)" Destination="$(WebProjectOutputDir)\Web.config" />
<TransformXml Source="$(WebProjectOutputDir)\App_Config\ConnectionStrings.Original.config" Transform="$(WebProjectOutputDir)\App_Config\ConnectionStrings.$(Configuration).config" Destination="$(WebProjectOutputDir)\App_Config\ConnectionStrings.config" />
</Target>
@tomekjuranek
tomekjuranek / gist:4110016
Created November 19, 2012 10:30
Transformations build parameters
/Target:Clean;Build /Property:Configuration=Release /Property:TransformConfigFiles=true
@tomekjuranek
tomekjuranek / gist:4110054
Created November 19, 2012 10:44
Remove debug attribute from web.config
<?xml version="1.0"?>
<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
<system.web>
<compilation xdt:Transform="RemoveAttributes(debug)" />
</system.web>
</configuration>
@tomekjuranek
tomekjuranek / gist:4110080
Created November 19, 2012 10:51
Sitecore connection strings transformations
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
<add name="core" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Core;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)" />
<add name="master" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Master;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)"/>
<add name="web" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Web;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)"/>
<add name="analytics" connectionString="Data Source=host\SQLDBNAME;Database=Sitecore_analytics;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)"/>
</connectionStrings>
@tomekjuranek
tomekjuranek / gist:4110450
Created November 19, 2012 12:45
Sitecore set read only rights
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Data",setAclUser=IIS_IUSRS,setAclAccess="Read"
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Website",setAclUser=IIS_IUSRS,setAclAccess="Read"
@tomekjuranek
tomekjuranek / gist:4110472
Created November 19, 2012 12:50
Sitecore deploy application to iis
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:iisApp="%WORKSPACE%\Website" -dest:iisApp="Home Page",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=dirpath,absolutePath=.*\.svn -skip:objectName=dirpath,absolutePath=\\obj$ -skip:objectName=filepath,absolutePath=\\App_Offline.htm$ -skip:objectName=dirpath,absolutePath=\\temp$ -skip:objectname=filepath,absolutePath=web\..*\.config -skip:objectname=filepath,absolutePath=ConnectionStrings\..*\.config
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:contentPath="%WORKSPACE%\Data" -dest:contentPath="C:\inetpub\wwwroot\HomePage\Data",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=dirpath,absolutePath=.*\.svn -skip:objectName=filepath,absolutePath=.*logs\\.*\.txt$ -skip:objectName=dirpath,absolutePath=indexes\\.*$
@tomekjuranek
tomekjuranek / gist:4110476
Created November 19, 2012 12:52
Sitecore set Read Write Modify ACL
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Data",setAclUser=IIS_IUSRS,setAclAccess="Read,Write,Modify"
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Website",setAclUser=IIS_IUSRS,setAclAccess="Read,Write,Modify"
@tomekjuranek
tomekjuranek / gist:4110895
Created November 19, 2012 14:23
Take app offline
if exist C:\inetpub\wwwroot\HomePage\Website\App_offline.test ren C:\inetpub\wwwroot\HomePage\Website\App_offline.test App_Offline.htm