perensla bazy na drygoi server :
sp_detach_db , potom sp_attach_db

logins and users konechno ne pereneclic" ( ia eto znala )
togda ia delay :

declare @login sysname , @password sysname
declare sourcelogins cursor for
select name , password
from SourceServer.master.dbo.syslogins
where isntname = 0 and charindex( 'repl_' , name ) = 0 and
charindex( 'distributor' , name ) = 0 and name != 'sa'
open sourcelogins
while ( @@fetch_status = 0)
begin
fetch sourcelogins into @login , @password
exec sp_addlogin @login , @password , @encryptopt = 'skip_encryption'
end
close sourcelogins
deallocate sourcelogins
go


ona vipolniaetcia , no ia users ne vishy v EM !
pri popitki dobavit" new user - ona govorit chto yshe ect" !

sp_helpusers na etoi base vidaet vcex userov pravil"no


chto ia delayu ne tak ?


pomogite poshalyicta !!!!


cpacibo

yshe probovala Disconnect mnogo raz , toto she rez-tat

procila moix userov poprobovat" icpol"zovat" ety bazy ( co cvoimi logins )

oni ne mogyt !

sp_helpuser daet neponiatnii rez-tat :
colomn 'UserName' daet pravilnoe username , a 'LoginName' - Null

pochemy ?

to Glory :
cpacibo za @defdb , ia dobavila etot parametr , eshe raz prokrytila script , no poka net rezyl"tata

to cvasil : users mogyt podklychictia k servery , no kogda v Query analizer pitaytcia vibrat" ety basy - error , govorit
chto eta basa dlia etogo usera not accesible .

sp_helpusers pishet pravi'no username a loginname - null
sp_helplogins : vce pravil'no vrode bi : loginname ( pravilnie ), sid etc

mne kashetcia y menia narysheno imenno cviaz" meshdy username i logins

to cvasil :

probovala tak kak vi pocovetovali , no ona govorit chto vce eti logini yshe ect" v etoi base

ogromnoe cpacibo vcem !

vot kak ia reshila ety problemy :

How to detect & rectify Orphaned Users in a Database

Logins are associated to users by the security identifiers (SIDs), which are stored in the Master database.
When you restore a database to a different server, the SID may be different resulting in a
mismatch between the Login-User association. These users, without a valid login association,
are called 'Orphaned Users'.
Here's how you can Detect Orphaned Users :-

Use Northwind
Go
sp_change_users_login 'Report'

To associate a Orphaned User with a Login :-

Use Northwind
Go
sp_change_users_login ‘update_one’, ‘username’, ‘loginname’


vce polychiloc" , eshe ect" xorohsaia statia :

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp

cpacibo cvasil