Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- setspn -A MSSQLSvc/websrv1.domain.local:1433 svcacct1
- CREATE LOGIN [YourDomaninNameServerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];
- USE MyDatabase;
- IF EXISTS (SELECT * FROM sys.DATABASE_principals WHERE name = N'YourDomaninNameServerName$')
- DROP USER [YourDomaninNameServerName$];
- USE [Master];
- IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'YourDomaninNameServerName$')
- DROP LOGIN [YourDomaninNameServerName$]
- CREATE LOGIN [YourDomaninNameServerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement