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 |
|
McGurk
Starting Member
21 Posts |
 Posted - 2009-08-11 : 17:00:17
|
| Can an application role be used for a database that users connect to through a web application as well as a windows application? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-08-12 : 11:19:27
|
| Sure. SQL Server does not really care what sort of application is connecting to it. However, web applications tend to proxy users into the database via a Application pool, or a single SQL Server ID. |
 |
|
|
McGurk
Starting Member
21 Posts |
Posted - 2009-08-12 : 11:49:00
|
| Thanks! Are there any cons to using it for a windows application used across a network? Any security issues? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-08-12 : 16:57:42
|
| There should be no performance problems. Admittedly, you will need to play around with the connections, especially if you are in a connection pooling environment. As for security issues, those are usually what trigger people looking into application roles. Make sure the password for the role is kept safe. |
|
|
|
McGurk
Starting Member
21 Posts |
Posted - 2009-08-12 : 18:25:31
|
| Thanks so much! You have been very helpful. |
|
|
|
|
|
|
Application Role