Can I execute any query in SQL Server without passing the credentials, is this normal?

0

I was looking to restart the SQL Server service, that's when I discovered a way to manipulate the database without logging into the system. See:

  • Open Management Studio.
  • Icanceledtheauthentication.
  • 3.AccesstheViewmenu>RegisteredServers.NoticethattheObjectExplorerisdisconnected.

  • My instance of SQL Server running ...
  • New Inquiry ...
  • Droppingthebank...
  • Anyway, this is kinda weird, does anyone know how to solve this? After all if anyone has access to my machine ...

        
    asked by anonymous 07.09.2015 / 00:31

    1 answer

    2

    Being a local server that is using the credentials of your local user, the answer is yes , this is normal.

    Note, however, that it is normal for a development environment used by a programmer or at most a development or testing team.

    In a production environment, a database administrator must correctly configure the minimum permissions required for systems and users that access the database.

        
    07.09.2015 / 11:17