- Open up SQL Server Configuration Manager (You can find this in the Start Menu under Microsoft SQL Server).
- Expand SQL Server Network Configuration and then click on Protocols for STEVE2012. Double-click TCP/IP and set the Enabled property to "Yes".
- Then, click SQL Server Services in the tree view, and restart the service for STEVE2012.
So Named Instances are listening on a dynamic port rather than the standard 1433. If your database server has a firewall (mine doesn't...development), you'll need to configure the instance to listen on a static port using the configuration manager. Then open up this port in your firewall.
No comments:
Post a Comment