Prev: db backups and time outs
Next: single user mode
From: shapper on 14 Jun 2010 22:16
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
From: Erland Sommarskog on 15 Jun 2010 17:05
shapper (mdmoura(a)gmail.com) writes:
> 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?

Preferrably a domain account. Just create an account in Windows, and then
set this as the service account from SQL Server Configuration Manager,
and it will arrange for all required Windows permission for the account.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: db backups and time outs
Next: single user mode