Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pavneet9
Starting Member
1 Post |
 Posted - 2012-12-11 : 06:40:41
|
| 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 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-12-11 : 07:10:36
|
| 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. |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-12-12 : 01:33:00
|
| Hi Pavneet,Follow the below steps to open firewall from a specific IP address1. Open Sql Server Configuration Manager2. Open Sql Server Network Configuration3. 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.Thanks,Sri. |
|
|
|
johnson_ef
Starting Member
16 Posts |
Posted - 2012-12-12 : 03:17:23
|
| 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.-Johnson |
|
|
|
|
|
|
SQL Remote Access