I am getting this error while creating a new user login and trying to
login - No utmpx entry you must exec "login" from the lowest level
"shell", OS ver Solaris 8 , in Enterprise v 220R .Pl send the possible
resolutions.
Re: Import Logins from text or spreadsheet ...set psw to generic value ... add user to database...EXEC sp_addrolemember 'SomeRole', 'SomeLogin' ... Let's assume your Excel spreadsheet has 3 columns: Login,... (microsoft.public.sqlserver.server)
Re: Import Logins from text or spreadsheet ... Good suggestion, Steve....EXEC sp_addlogin $, $, $(Database)... EXEC sp_addrolemember $, $(Login)... (microsoft.public.sqlserver.server)
Re: dbo association ... The dbo user is a special case; database ownership determines the login...EXEC sp_changedbowner 'MyLogin' ... (microsoft.public.sqlserver.security)
Re: Using osql.exe to set account permissions? ... To accomplish mentioned tasks one may do the following: ...EXEC sp_defaultdb 'Domain\UserName', 'box_LM_W3SVC_1_Collab' ... > Create a New Login... > Permit database access for that login to that database ... (microsoft.public.sqlserver.security)
Re: users with no logins ... > User login mapping can get out-of-sync following a restore. ... > an error stating 'the proposed owner is already a user in the database'...EXEC sp_changedbowner 'TempLogin'... (microsoft.public.sqlserver.security)
