Author: Andreas Plahn

Set up SQL Server on home network – Stack Overflow

Step by step from Stack overflow.
Trouble finding SQL Server Configuration Manager?
Its at “C:\Windows\System32\SQLServerManager11.msc” (2012)
or “C:\Windows\System32\SQLServerManager10.msc” (2008)
———————————————

Test Open Port The network on your LAN, can you ping SQL Server remotely on the default port 1433 on the specific IP Address (you can use PuTTY or Telnet to check this)

SQL Configuration Manager Check SQL Configuration Manager and see if the Network Protocol for SQL is enabled for TCP/IP, Named Pipes or Shared Memory

Firewall and Default Port Check the Windows Firewall make sure its allowing 1433. Since you are testing, best thing to do is to disable the Firewall in Windows Services to confirm whether its a firewall issue or not.

SQL Server Browser SQL Server Instances (instances have the form SERVER\SQLEXPRESS or SERVERNAME\SQL1 for example). Check in services and makes sure the “SQL Server Browser” is running. Also, you must allow a Firewall rule for port 1434, which is the default port of the “SQL Server Browser”. This is necessary because the SQL Server maps and forwards the traffic based on the Instance Name, so this is the service that resolves the instance name.

SQL Server Instance Port Varies SQL Server Instances does not necessarily run on port 1433, in this case you will have to have the SQL Browser Running which maps the name to the port and directs traffic to the correct instance. In your firewall, instead of allowing port 1433, you will have to allow sqlservr.exe Executeable Program. The port also can be determined by looking at the SQL Server log File in the MSSQL\LOG folder in Program Files. There will be an entry for “Server is listening on port …”

My recommendation for you is to install SQL Server Express Management Studio (SSMS) which is the GUI interface to manage the SQL Server Express instance. The link is below for both SQL Express and SQL Management Studio. And see if you can connect to the servers that way first. Another suggestion is for you to install both on a Local Computer and simply familarize yourself with SQL Server first before exposing it on the Network.

http://www.microsoft.com/en-us/download/details.aspx?id=29062

via webserver – Set up SQL Server on home network – Stack Overflow.

Visual Studio 2013 really slow when pasting inside ASPX files solved

Whenever I pasted some code in my aspx pages inside Visual Studio got this dialog:
ScreenShot1162

To solve this, I just deleted all the files from this folder:
%USERPROFILE%\AppData\Local\Microsoft\WebSiteCache

Perhaps do a backup first (zip file etc).

Solution from here:
via Slow Visual Studio Performance … Solved! | Geocortex Blog.

The Future of .NET in the Server: ASP.NET vNext optimized for Cloud and Server workloads – Cesar de la Torre Microsoft – BLOG – Site Home – MSDN Blogs

The best thing: change some c# code for your website. Wait 2 seconds, see the results for the code change, is it possible? In memory compilation? Sounds great to me.

http://blogs.msdn.com/b/cesardelatorre/archive/2014/05/12/the-future-of-net-in-the-server-asp-net-vnext-optimized-for-cloud-and-server-workloads.aspx

Upgrading EPiServer Commerce R3 to EPiServer 7.5 – upgrade script errors

Here is a little summary of problems and solutions with the Commerce upgrade script.

Run Deployment Center as administrator. The upgrade script upgrades both EPiServer 7.0 and EPiServer Commerce R3 to EPiServer CMS and Commerce 7.5. So the first step is to choose: “Upgrade EPiServer Commerce”

Next step choose the CMS 7 “Commerce enabled” www site to upgrade. (Not the Commerce manager site)

This is the running script:
“C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Commerce 7.5.394.2\Install\Upgrade EPiServer Commerce.ps1”

This is where you could inspect the log if it fails: (latest modified file)
C:\Program Files (x86)\EPiServer\Shared\Install\Logs

Errors

Could not find file ‘C:\sites\MySite.Web\b\web.config’1.

Solution: Set  <appSettings> key “CommerceManagerApplicationName” to the Commerce Managers current IIS ApplicationPool name.
E.g:

<add key="CommerceManagerApplicationName" value="MySiteCommerceManager_v4.0" />

 

Line 418 fails: Could not find file ‘C:\commerce\MySite.CommerceManager.Web\b\web.config’.

Solution: this line:  $commerceManagerPath = $commerceManagerBinPath.trimEnd(“Bin”)
Is hardcoded in the ps1 script. Replace the appsetting “CommerceManagerBinPath” in wwwroot web.config file “bin” in the path to “Bin”. E.g:

<add key="CommerceManagerBinPath"         value="C:\Commerce\MySite.CommerceManager.Web\Bin"

 

“Could not find Tools.zip”

Copy Tools.zip from wwwroot\MediachaseECF\* (from a functioning, or demo, epi7 commerce r3 site) to upgradeprojects\wwwroot\MediachaseECF\*.

This file also seems to be deleted after every upgrade attempt.
Download here: Commerce_Tools.zip_for_r3_and_75

Cannot find package “EPiServer.Business.Commerce.AddOns.Manager” in local repository.

–  In your wwwroot\modulesbin folder there should be a EPiServer.Commerce.AddOns.Manager.dll file, the EPiServer.Business.Commerce.AddOns.Manager.dll is EPiServer Commerce R3 specific and should be deleted.

Remove-Item : Cannot find path ‘C:\commerce\MySite.CommerceManager.Web\bin\Mediachase.Cms.Website.dll’ because it does not exist.

At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Commerce 7.5.394.2\Install\Upgrade EPiServer Commerce.ps1:378 char:3

Solution: copy the Mediachase.Cms.Website.dll from C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\EPiServer Commerce 7.0.243.0\ECF\Data\ConsoleSite\bin to manager bin folder.