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 |
|
greatrammurali
Starting Member
1 Post |
 Posted - 2009-05-06 : 09:07:14
|
| Hi All,We are having VB.Net application which uses MS-SQL 2005 database as backend. If we use windows authentication using MS-SQL, apart from our VB.Net application, excel and other application are also connected to that database. How do we restrict the database specific for that application alone and restricting other applications (like excel, other vb.net apps) not to connect with that DB.Can anybody share your ideas.TIA Rammurali Krishnan B |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-05-06 : 14:38:13
|
| Only users who have been setup access to the server can connect to SQL Server. Create users for the application you want access and give them the credentials. None others can connect unless they know the userid/pwd information.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Restrict MS-SQL database for specific application