> Hi,
>
> I have a scenario which works fine on a non-clustered SQL server, and I
> now
> want to implement it on a clustered SQL server.
>
> In a stand-alone, non-clustered environment:
> - I have local Windows security groups on the machine; call the groups
> MyGroup1, MyGroup2.
> - I grant these groups login to the server, and access to the DB, as
> follows: (later I add them to DB roles)
>
> declare @servername sysname
> declare @pos int
> set @servername = serverproperty('MachineName')
> set @pos = charindex(N'\', @servername, 0)
> if @pos > 0
> set @servername = left(@servername, @pos-1)
>
> use master
> declare @loginame sysname
> set @loginame = @servername + '\MyGroup1'
> if (not exists (select name from syslogins where name = @loginame))
> begin
> exec sp_grantlogin @loginame
> end
> exec sp_defaultdb @loginame, MyDatabase
>
>
> I'd like to do something similar on a clustered SQL server. But does a
> cluster have a concept of local Windows groups, or must they be domain
> groups?
>
> How would I go about setting this up?
>
> Thanks,
> John.
>
>