MS SQL Server 2008 listening on additional port

Dear Experts Exchange,

We have a SQL Server 2008 server (standard edition) which hosts a number of live databases on one instance. We need to setup a new database on this sql instance which has connectivity to a website. This website needs to connect over a different port (as opposed to using the default 1433) to the new database.

We are proposing to add the new port in the 'SQL Server Configuration Manager' under the 'Sql Server Network Configuration' > 'Protocols for Mssqlserver >  'TCP/IP' properties and specifying it in the 'Ip Adresses' tab by putting a comma next to the default port 1433 and adding the new port there (this is in the 'TCP Port' box which is under the headings IP1, IP2, IP3 and IPAll).

Once the above changes have been made we are proposing to restart the MSSQLSERVER service through the Configuration Manager in order for the changes to take effect.

Are there any considerations that we need to make for this change as we don't want to affect the current live databases on this instance which we are assuming are only listening on port 1433 currently as this is the only one specified in the configuration described above?

Your advice on the above would be greatly appreciated.

Kind regards,
Amy
klwnAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
What you are proposing will work and the instance will respond to multiple IP addresses.  If you want to have just that application access SQL over a specific port then you could add an additional IP address on the server, go to SQL Configuration Manager and then configure the port you want for the new IP address you added.  In either case, your SQL instance will be restarted.

I have used the additional IP method to a specific application where the vendor did not recommend adding two port to the listener.
klwnAuthor Commented:
Hi Mohammed,

Our application vendor will be specifying within their website configuration which port should be used to access the database on the SQL Server 2008 instance (this will be the new port) and we will have a firewall rule in place to route the website traffic to the server using the new port.

Therefore if we went with our original plan in my question, can you see this being an issue? Our main concern is that we don't want to affect the current live databases already on this instance, which could already be listening on the default port?
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
It will be a security issue as regardless of which port the web application connects to, all DBs are in the same instance.  If this is an issue then you might want to separate this DB in its own instance.  At the very least, ensure the web server is connecting to the SQL server with an account that has access to only required DB(s) and does not have privileged access.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.