windows groups

Question

windows groups

SVR

Ten Centuries

Points: 1366
More actions
June 27, 2011 at 10:19 am

#252587

Hi,
I have some windows group logins that are permitted access to sql server. When I tried to transfer the logins they all scripted out but are not getting created on the new server. Why is this happening and how can I solve it ?
Thanks for responding
Samata

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Are you creating them at the server level or the database level? (Logins or Users?)

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SVR Ten Centuries Points: 1366 More actions · Answer 2

I am migrating them from sql 2000 to sql 2008. And I see they have access to sql server in 2000 . Other windows level logins similar to them are created. I am trying to do at server level.

GSquared SSC Guru Points: 260824 More actions · Answer 3

Are you using anything beyond:

CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;

Any options?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SVR Ten Centuries Points: 1366 More actions · Answer 4

This is what I have been using:

IF NOT EXISTS

(SELECT * FROM sys.server_principals

WHERE [name] = 'FORESTCITY\CorpSPLANDBAdmins')

CREATE LOGIN [FORESTCITY\CorpSPLANDBAdmins] FROM WINDOWS

GSquared SSC Guru Points: 260824 More actions · Answer 5

Have you tried just running the select statement by itself?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SVR Ten Centuries Points: 1366 More actions · Answer 6

Yes , I did. But there is no sys.server_principals in sql server 2000.

GSquared SSC Guru Points: 260824 More actions · Answer 7

You're running a query that can't possibly work on your server??? Now I'm confused.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon