Linked Questions

1 vote
1 answer
592 views

Is it possible to restrict SQL Server DB_Owner when connecting using SQL Server Mgt Studio? [duplicate]

Here is the back story. A developer created an EXE program. The exe program has the ability to access a SQL Servre database. In order to do that we create an Active Directory group. Let's call this ...
BobNoobGuy's user avatar
0 votes
0 answers
85 views

Restrict connection to SQL Server By IP [duplicate]

On a QA server I need to give access to specific login from just one IP to log to this server. I wrote This login trigger Create TRIGGER tr_CheckIP ON ALL SERVER FOR LOGON AS BEGIN ...
sebeid's user avatar
  • 1,381
1 vote
0 answers
43 views

How to restrict SQL Server database access to application or server running the application [duplicate]

I have a third-party application that connects to a SQL Server database via a SQL Server Native Client 10 ODBC data source. The application requires that each user of the application must have read/...
paulH's user avatar
  • 1,444
8 votes
4 answers
45k views

How to block user access to perform database application update?

Where I work we have a SQL Server database (Microsoft SQL Server 2008 R2) that serves as the back-end with two different user interfaces, a .NET web interface and a FoxPro interface. Every month we ...
Baodad's user avatar
  • 483
7 votes
2 answers
374 views

SQL Server 2012 - SA account probe

On one of my servers (Win 2012 R2), SQL Server 2012 is constantly under attack with the SA account being hit like 10 times per second with different passwords. I don't have an SA account but still I ...
Nelson Pires's user avatar
1 vote
3 answers
7k views

Protect SQL Server from hackers

Today, my SQL Server 2008 is attacked by hacker from IP address in China [4300 Login failure in last 7 hours]. I contacted GoDaddy support and below is what they told me. EXEC sp_readerrorlog 0, 1, '...
user avatar
0 votes
2 answers
721 views

Make a database inaccessible through "sa" user but should be accessible through another user

I have a database BugTracker which is accessible from "sa" user. I have just created new user AdminBugCatcher. I have also mapped "BugTracker" database with this user. But this database should not be ...
Gaurav123's user avatar
  • 103
2 votes
3 answers
1k views

Deny access to one database, allow all the rest

How can I deny access to specific databases from a login? I know that I can walk through and make the login a db_owner on all the ones I want the login to have access to, but how do I do the opposite?...
blsub6's user avatar
  • 163
0 votes
2 answers
1k views

Avoid user login Directly to AlwaysOn High Availability Primary

I have setup an AlwaysOn High Availability in Sql Server 2014. my IP addresses are according to this : 192.168.1.189 -- Listener 192.168.1.180 -- Replica 192.168.1.181 -- Primary Right now users ...
Hamid Fathi's user avatar
0 votes
2 answers
551 views

How secure is a linked server in SQL Server

I am in a situation in which I should doubt everyone (even my developer team and database admin) so I want to Log all the logons made to my server. I have two SQL Servers, say A and B. I want to log ...
Mahdi Tahsildari's user avatar
1 vote
0 answers
864 views

Denying direct remote access to SQL Server

I am trying to stop our valid database users accessing our SQL Server remotely via applications other than our system application (e.g., MS Excel). These accesses need to be prevented because they ...
Sam Mazed's user avatar