Today I had to change the SQL port used by Service Provider Foundation, but I couldn’t find any information on how to do it. I guess I could’ve gone through the installation again and reconfigured it that way, but that seemed like too much work.
Instead I went to take a look at the website files in “installdirSPF” (in my case this was the default path: C:inetpubSPF). Here you’ll find a web.config file where you can specify your SQL server connection string at the end of the file:
[xml]
<spfDbData>
<SpfDbConnectionString>Data Source=sql01.demo.localSPF;Database=SCSPFDB;Integrated Security=True;MultipleActiveResultSets=True;</SpfDbConnectionString>
</spfDbData>
[/xml]
Here I changed Data Source to serverinstance,port – for example: sql01.demo.localSPF,49000:
[xml]
<spfDbData>
<SpfDbConnectionString>Data Source=sql01.demo.localSPF,49000;Database=SCSPFDB;Integrated Security=True;MultipleActiveResultSets=True;</SpfDbConnectionString>
</spfDbData>
[/xml]
After that I restarted IIS and made sure my connection from Windows Azure Pack still worked.
Cloudpuzzles 