ÃÂ I installed the sql express edition with Adavance services through command line.
The command line is
start /wait setup.exe /qb SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=mypwd ADDLOCAL=ALL
installtion was succesful.
When i try to connect through osql -E
it gives error "You dont have remote login permission"
after some serach
in sql server configuration Manager>SQL Server 2005 Network Configuration>Protocols for SQLEXPRESS>
TCP/IP properties > IP address TAB > IP ALL > TCP Dynamic Ports
The port no. is 1143
i changed to default port 1433
and the osql is started working.
Now i can install the SQL Express through command line which changes the TCP Dyanmic port to default port orÃÂ change the TCP Dynamic Ports and default port same no.
View Complete Post