Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 accounts have direct access to the 'Connect SQL' p

Author  Topic 

eirikr_1
Starting Member

27 Posts

Posted - 2015-02-19 : 18:24:56
When i create new "testLogin", it is automatically granted with 'Connect SQL' permission. I use this sql login in my application web config file to connect to SQL database, so i can pull out some data to post them on the web site. However there is a SQL STIG said: SQL server must not grant users direct access control to the Connect SQL permisson, so i revoke the 'Connect SQL' permissionfrom testLogin. As soon as i revoke it, my application does not work any more. Please help. What should i do? What did i do wrong. Thank you in advanced.

v/r
eric

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-02-20 : 09:42:16
Is Testlogin a SQL Server login or a WIndows login?

If a Windows login, add testlogin to a domain group that has the necessary permissions. If a SQL login, you can't do anything with it if you can't connect.
Go to Top of Page
   

- Advertisement -