2012年12月28日 星期五

How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433

Reference:
http://support.webecs.com/KB/a375/how-do-i-configure-sql-server-express-to-allow-remote.aspx

1. open "SQL Server Configuration Manager"

2. Protocols for SQLEXPRESS

3. Right click TCP/IP and select Properties
  • Active: Yes
  • IP address: my_ip_address (ex: 192.168.100.50)
  • TCP Dynamic Ports: (blank)
  • TCP port: 1433
4. Enable "SQL Browser" in SQL Server Services

沒有留言:

張貼留言