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.
| 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/reric |
|
|
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. |
 |
|
|
|
|
|
accounts have direct access to the 'Connect SQL' p