1

I have a SharePoint 2010 environment configured with SQL Server 2008R2. Currently SQL Server is running on 1433. I am willing to change the existing SQL server port from 1433 to some non standard port. I need to know if this is a supported thing by SharePoint and what are the possible implications of doing so.

Additionally, if someone has configured this before it would be helpful if I am provided with links to some hands on guide or short tutorials to achieve this.

Improve this question

1 Answer 1

Reset to default
2

You can do this with a SQL alias. Create an alias on your SharePoint servers with the exact same name as the existing SQL connection. Then point this alias to the correct instance and port. SharePoint will be unaware of the change.

The procedure to move all databases to another SQL server is more or less the same procedure: http://technet.microsoft.com/en-us/library/cc512725.aspx

You can see how a SQL alias works on my blog:

Improve this answer
2
  • Thanks Thomas. I have a quick question here. What do I need to do to install cliconfg.exe in my web front end servers ? Commented Jul 5, 2012 at 13:16
  • Normally it should already be there. Just go to Start and type cliconfg.exe Commented Jul 5, 2012 at 13:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.