September 17, 2018 at 2:50 am
Hello All,
I have a QA team that work on a QA SQL Server but they could try to connect to my preproduction SQL Server.
The credentials for both server are the same (I can't disable the login\ reset the password due to my wonderful boss decision).
I would like to disable a connection from specific Computer and IP to my preproduction SQL Server.
Can you please help?
Thanks in advance!
September 17, 2018 at 3:15 am
89netanel - Monday, September 17, 2018 2:50 AMHello All,I have a QA team that work on a QA SQL Server but they could try to connect to my preproduction SQL Server.
The credentials for both server are the same (I can't disable the login\ reset the password due to my wonderful boss decision).I would like to disable a connection from specific Computer and IP to my preproduction SQL Server.
Can you please help?Thanks in advance!
Add a rule to your firewall
😎
September 17, 2018 at 3:22 am
HI Eirikur Eiriksson,
Thank you for your quick response 🙂.
Can you please help me with this rule what should i do?
see below a fake name and IP of my env:
Preproduction - preprodSQL 192.168.1.1
QA - QASQL 192.168.1.2
I don't have an experience with firewall :hehe:.
September 17, 2018 at 4:09 am
89netanel - Monday, September 17, 2018 3:22 AMHI Eirikur Eiriksson,
Thank you for your quick response 🙂.
Can you please help me with this rule what should i do?
see below a fake name and IP of my env:
Preproduction - preprodSQL 192.168.1.1
QA - QASQL 192.168.1.2
I don't have an experience with firewall :hehe:.
This article should help and although it is a bit old, nothing much has changed.
😎
September 17, 2018 at 12:45 pm
Or a login trigger
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply