Advertisement
Guest User

Untitled

a guest
Aug 18th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. setspn -A MSSQLSvc/websrv1.domain.local:1433 svcacct1
  2.  
  3. CREATE LOGIN [YourDomaninNameServerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];
  4.  
  5. USE MyDatabase;
  6. IF EXISTS (SELECT * FROM sys.DATABASE_principals WHERE name = N'YourDomaninNameServerName$')
  7. DROP USER [YourDomaninNameServerName$];
  8.  
  9. USE [Master];
  10. IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'YourDomaninNameServerName$')
  11. DROP LOGIN [YourDomaninNameServerName$]
  12.  
  13. CREATE LOGIN [YourDomaninNameServerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement