Re: Question about setup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I see, that is why I missed it. Cool. Thanks!

Rod

"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:uSQlYqZ7GHA.3644@xxxxxxxxxxxxxxxxxxxxxxx
It does not create local groups, it assigns local permissions to domain
groups. Slight but distinct difference.


--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:%236bd$$W7GHA.2380@xxxxxxxxxxxxxxxxxxxxxxx
Really? Not the SQL Service account, but the installation user creates
local groups on the clustered nodes? Hmm, did not know that, time to do
more research.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:%231iWp3W7GHA.728@xxxxxxxxxxxxxxxxxxxxxxx
Actually, the SQL install account will need to set permissions on those
groups locally for the host nodes. Your install account must be a
domain-level account and should be local admin on all host nodes.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:O2GCoBV7GHA.3412@xxxxxxxxxxxxxxxxxxxxxxx
I like to have them pre-staged. So no it doesn't. You could have an
admin create the groups for you.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"SAM" <SAM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC84C8C7-D22C-4380-BFF8-7EE9232E8CFD@xxxxxxxxxxxxxxxx
Hi Rodney, thanks for helpful. Another question, the account I used to
install sql, this account needs to have privileges to create these
group
accounts, right?

"Rodney R. Fournier [MVP]" wrote:

Cluster Service Account - must be in a domain.
SQL Service Account - must be in a domain.
3 Groups for SQL 2005 install.
http://support.microsoft.com/kb/910228 Section 2.5.11.

I will let a SQL MVP/DBA answer the can a DB that is mirrored be
accessed
from 2 nodes at a time, I know I would not ever recommend it.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"SAM" <SAM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AE8105A3-C2E7-41C0-A4E1-7189399BC548@xxxxxxxxxxxxxxxx
what accounts are required for SQL cluster setup?

I was trying to install SQL Server and ran into some prompts that I
did
not
see in the books that I read about SQL cluster setup.

I know about SQLservice account. However, I didn't know it requires
a
domain
group for each service, SQL Server, Agent and Full text search. Can
someone
explain? And are there other accounts that I need to be aware that
are
needed?

Also, can both nodes access the database file at the same time? I
read
that
if you use database mirror it is not recommended. I didn't think
having
both
db servers accessing the database files at the same time was a good
idea.

We are going to use SQL Cluster and database mirror for SQL 2005.













.

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)