Ok, for SQL server 2000, I need to change the account it runs under. <BR><BR>I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and at ...

I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.

They created accounts in SQL Server, and Windows was ignorant of these accounts. SQL Server has continued with this concept, largely for maintaining backward compatibility. In addition to what you're ...

Understand SQL Server Security SQL Server grew out of the UNIX world, and administrators maintained accounts (at that time) in a fashion similar to the "no domain" scenario in Windows. They created ...