Member Avatar for Moon466

Hi.

Here's my scenario:
I have a native Windows service running on a machine. The service is installed under Administrator privileges.

Once per day, the service fires, creates a login to SQL (using the administrator account), queries a specific database (read only). The database is stored locally (same machine) and is a non-system DB.

Is there any way I can prevent this service from accessing the data records in the target database? Encryption? Any other preventives?

Thoughts?

Thanks!

  • 2 Contributors
  • 1 Reply
  • 54 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by BitBlt
Member Avatar for BitBlt

Delete the "BUILTIN/Administrators" group from your SQL Server.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.