Sql Server client Network Utility

Question

Hi,

Iam installing the SQL Express Edition with Advance Services. Using Command prompt.

start /wait setup.exe /qb SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=mypassword ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,Client_Components,Connectivity,SDK,SQL_SSMSEE

after installing the SQL Express. The Named Pipes and tcp/ip is in disable protocols only.

How do i enble the named pipes and tcp/ip through the command line installtion.

Thanks
Kiran

Answer 1

Here's the link : http://msdn.microsoft.com/en-us/library/ms143446(SQL.90).aspx . As per this link http://msdn.microsoft.com/en-us/library/ms165677(SQL.90).aspx if DISABLENETWORKPROTOCOLS=0 then shared memory, tcp/ip, named pipes are enabled. Please check firewall settings in the first link that I mentioned

---

This posting is provided "AS IS" with no warranties, and confers no rights