Link to home
Start Free TrialLog in
Avatar of dotsandcoms
dotsandcoms

asked on

How to Change SQL Server 2008 Port for SQLExpresss instance?

Hello Experts,

I have installed SQL Express 2008 on my development Server, but because of some hacking attacks I need to  change Port of SQL server 2008 from default to any other.

I tried with help given on "http://msdn.microsoft.com/en-us/library/ms177440.aspx".

If I connect with IP address then I must have to give port number but If I use SQLExpress instance it allows me to connect without port number.

Can you please help me to avoid connecting with SQLExpress instance without Port Number ?
Avatar of x-men
x-men
Flag of Portugal image

disable the SQL Browser service

more at: http://msdn.microsoft.com/en-us/library/ms165724(v=SQL.90).aspx
SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dotsandcoms
dotsandcoms

ASKER

Hello Experts,
I did the same steps as per the urls but nothing happens.

I can connect with
<ipaddress>/sqlexpress
username, password

Cannot connect with
<ipaddress>
username,password

but can connect with
<ipaddress>,port
username,password

I want to disable connection
<ipaddress>/sqlexpress
username, password


please see attached images of sql server configuration.
User generated imageUser generated imageUser generated image
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial