configure sql express 2005 to listen to tcp port

Question

configure sql express 2005 to listen to tcp port

isaac_cm

Newbie

Points: 3
More actions
March 5, 2010 at 7:10 pm

#217496

Hello,
I am making silent installation for sql express 2005 using the following command
Code:
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD="****" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,Client_Components,Connectivity,SDK
I need to know is there a parameter or a command line utility to configure the service to list to port 7005 (see picture)
http://www.databasejournal.com/img/2007/01/mak_CLT_image002.jpg
- Also I need to create an alias using command line
Thanks

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Have you looked at the Powershell Utility?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

isaac_cm Newbie Points: 3 More actions · Answer 2

isaac_cm

Newbie

Points: 3

March 5, 2010 at 8:33 pm

#1129547

I did now, but how it can help me ?

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Basically what you are doing when you change the default POrt is change a registry entry.

WHen you create an alias you are modifying the registry as well.

THis can be performed by using a tool such as WMI and call VB script.

I tried very hard to find a solution.

Listed below are some articles. I hope that they give you some ideas & point you in the right direction.

I suspect that you are going to have to Goggle at lot as I did unless someone else on this forum provides you with a better answer than I.

Good luck to you.

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.serveralias.aspx

http://technet.microsoft.com/en-us/library/ms174212.aspx

http://technet.microsoft.com/en-us/library/ms180499.aspx

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.aspx

http://www.yaldex.com/sql_server/progsqlsvr-CHP-13-SECT-1.html

http://blogs.msdn.com/sql_protocols/archive/2006/04/08/572057.aspx

http://www.databasejournal.com/features/mssql/article.php/10894_3709441_2/Microsoft-Windows-PowerShell-and-SQL-Server-2005-WMI-Providers--Part-1.htm

http://www.2000trainers.com/windows-scripting/using-wmi/

http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Powershell is a very powerful tool, however there is a bit of a learning curve to master the capabilities of it.

I did not send you the link listed below. I believe that I stumbled across some VBScript's to create an alias, etc. There are many examples included with this link. I suspect that it may take you so digging around. 🙂

http://www.activxperts.com/activmonitor/windowsmanagement/powershell10/

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

isaac_cm Newbie Points: 3 More actions · Answer 5

thanks alot and sorry for tired you,

I googled alot and finally found that registry key is the most suitable thing and I managed to change the tcp port using the registry key

I will try to do the same for the alias

one question please , what alias used for ?