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 |
|
Kristen
Test
22859 Posts |
 Posted - 2004-09-09 : 04:58:22
|
| Whats the best plan for installation - in particular the User Account to use for SQL Server and SQL Agent - I'm thinking there scheduled DTS tasks will be used between servers, presumably I *need* to get the User Account and Passwords to be the same on both servers (to make the job easier, even if this is not an actual requirement), set up the accounts as "Log on as a service", anything else?Anything special to make SQL become part of Active Directory?What do I set up the DTS Packages to run under?I'd like to make the IIS connections use a Trusted Connection, and NO have the machines allow SQL login at all - do I just add IWAM_<computerName> to the Logins? (or is it IUSR... - I forget!)Kill off all use of Pipes, and stick to TCP/IP (these servers are on a LAN)?Anything else I ought to put in my installation notes?ThanksKristen |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-09 : 05:12:38
|
After installation, ensure that the service account and DBA has system admin rights in the logins, then remove builtin\administrators.Run on a non-standard port  Remove the Northwind and Pubs databases from production machines.-------Moo. :) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-12 : 08:11:52
|
| * bump *Any more thoughts pls?Kristen |
|
|
|
n/a
deleted
35 Posts |
Posted - 2004-09-13 : 14:39:17
|
| Try this article, it may help[url]http://www.databasejournal.com/features/mssql/article.php/3349561[/url]HTHPaul |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-13 : 14:54:11
|
| That's very helpful, thanks.I still reckon someone has got a .DOC "Standard Operating Procedure" that they aren't sharing with me ;-)Kristen |
|
|
|
|
|
|
Install "Best Practice"?