Change Service Provider Foundation SQL port

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s