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 |
|
JaiVerma2k2
Starting Member
3 Posts |
 Posted - 2009-04-20 : 06:25:00
|
| Dear All,I'm using SQL server 2005, some users has been created in database, which is used in one application to connect the server, i wan't to restrict these user for registration of SQL server in their own system, I want to restrict the users, so they connect SQL Server through some specific application and NOT through their local SQL Server.please reply if more clarification required.Thanks in advance |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-04-21 : 07:30:39
|
| Create some kind of application role(Service account)..and deny all users connecting to the sql server.http://www.sqlserver007.com |
 |
|
|
JaiVerma2k2
Starting Member
3 Posts |
Posted - 2009-04-21 : 10:15:34
|
| If i deny all users connecting from SQLserver, then user can't login through the application also. Give me some brief abt service account.Is there something where i can define that user can only access through "XYZ" application. |
|
|
|
|
|
|
How to Stop remotely registration of MSSQL server