0

I don't want anyone to connect SQL Server from another domain except some of them.

I tried to block the port of SQL server through Kaspersky on my database server. But it doesn't block

Kaspersky block port

Liam neesan
  • 2,282
  • 6
  • 33
  • 72
  • Why you don't use SQL Server integrated security? How other domain users are connecting actually? – serge Oct 25 '18 at 12:05
  • @serge for every one hour the data will move to another sql server(which is in another domain).. so except that ip I want to block rest of them – Liam neesan Oct 25 '18 at 12:08
  • So you have several SQL Servers. How other domain users are connecting to these SQL Servers actually? – serge Oct 25 '18 at 12:14
  • @serge using crystal report xi application. they are running the report from another domain. – Liam neesan Oct 25 '18 at 12:16
  • I mean how users are authenticated by SQL Server? – serge Oct 25 '18 at 12:19
  • @serge i created one common sql server integrated security to run report for users. that authentication without password to run report only – Liam neesan Oct 25 '18 at 12:22
  • Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/182497/discussion-between-liam-neesan-and-serge). – Liam neesan Oct 25 '18 at 12:26

0 Answers0