none
Exactly same steps for Win 2003 server

All replies

  • How to connect by TCP port

    To allow connections to SQL Server by TCP port, perform the following steps.

    1. Click Start | Control Panel | Network Connections
    2. Right click on the network adapter that services inbound connections to SQL Server and select Properties
    3. Select Advanced | Windows Firewall | Settings
    4. Select Exceptions | Add Port
    5. Under Name put "SQL Server" and under Port Number select 1433. Use TCP as the protocol.
    6. Click OK to close out all dialogs.

    If you're using anything other than standard TCP/IP to access SQL Server, you'll need to enable


    El éxito nunca llega solo; hay que trabajar arduamente para conseguirlo.

    Tuesday, October 08, 2013 3:22 AM
  • Thanks. Is it then to choose this below?

    I am not sure which network adapter to choose above?

    Many Thanks & Best Regards, Hua Min

    Tuesday, October 08, 2013 3:46 AM
  • Firewall

    El éxito nunca llega solo; hay que trabajar arduamente para conseguirlo.

    Tuesday, October 08, 2013 3:55 AM
  • Many thanks. Actually I am already having this


    do you know why I'm getting this

    when running the project, while  I can login the database using itelog login in SSMS. Here is the ConnectionString

    	<connectionStrings>
    		<add name="Mssqlconn2" connectionString="Data Source=MYSERVER2\MSSQLSERVER;Initial Catalog=proj_sch;Integrated Security=False;User ID=itelog;Password=myite00" providerName="System.Data.SqlClient"/>
    	</connectionStrings>
    


    Many Thanks & Best Regards, Hua Min

    Tuesday, October 08, 2013 4:05 AM