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 |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2010-06-14 : 22:17:11
|
| Hello,I am hosting a web site on IIS 7.5 in a Windows 2008 server.This web site requires an SQL Database so I configured the SQL Server to allow remote connections.What service should I use the the SQL Server?Local Service, Local System or Network Service?Thank You,Miguel |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-06-15 : 03:07:20
|
| You should create a local windows account with default permissions only, and then open up sql server configuration manager and set the sql server service to use this account. The config manager will give the account the proper permissions. Bare in mind that it will only have the minimal permisssions for running sql server, so you might have to add some permisssions yourself later. Write access to a backup-folder for example...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
Local Service, Local System or Network Service?