I Have Made My SQL Server To Allow Remote Dekstop Connections From Another Computer. But I Want To FIX That It shud allow Remote Connections From A Fix IP ie 12.13.14.15. Please Help
Sounds like something that should be done via a firewall. You could maybe create a trigger that fires on login to check the connection?
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Follow the below steps to open firewall from a specific IP address
1. Open Sql Server Configuration Manager 2. Open Sql Server Network Configuration 3. Double click Protocols for MSSqlServer (Instance Name) 4. Double click TCP/IP (Properties) 5. Go to IP Address tab and enter the specific IP address you wanted to allow connections (leave the default port to be 1433)
Restart the Sql Server when done with above steps.
Is this a named instance? , in that case, check the instance port number, it would not be 1433, may be dynamic too. Once you found out the port, you can check the connection this way too (12.13.14.15,portnumber) from SSMS. If this is not working, check the port blocking from server or firewall level. You can check if the connections are established or not through 'net stats' command.
SQL Remote Access
Posted - 12/11/2012 : 06:40:41
