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 |
|
lopezpleonel
Starting Member
3 Posts |
 Posted - 2009-09-02 : 12:15:44
|
| Hi,I need that only sa must connect to the SQL Server management Studio 2008. How can I deny autentication to the users to connect to SQL Server management Studio 2008?The users only must login in the aplication created in Visual basic 6.In fact, they log in with public and sysadmin functions in the server. But, they have grant to connect to SQL Server management Studio, too. This is not helpful.I removed the sysadmin role to the users. But, they don't connect to the application in VB.Thanks in advance for any help.Regards, |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-02 : 12:22:01
|
| You can use an application role. And remove the users login. |
 |
|
|
lopezpleonel
Starting Member
3 Posts |
Posted - 2009-09-02 : 12:44:21
|
Thanks...How can I create the application role? Is this like allow to the application connect to the database |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-02 : 13:27:00
|
| It's best to read about them in SQL Server Books Online. It describes how to create and use them. |
|
|
|
lopezpleonel
Starting Member
3 Posts |
Posted - 2009-09-02 : 13:50:08
|
| In fact, I restricted access to insert, delete and update to several tables and the user can modify sucessfully in the Managemet Studio. This is too weird, I don't know where the security is.I quit, I've read a lot of documents and I don't find the answer. |
|
|
|
|
|
|
Only allow connection to sa to SQL Server