What the title says. kokos137135If you might be doing it through T-SQL:Granting a Windows Login the ability to connect to SQL Server:Develop LOGIN [DomainUser] FROM WINDOWS; or Set up LOGIN [DomainGroup] FROM WINDOWS; If SQL Server-based login:Set up LOGIN [LoginName] WITH PASSWORD = 'SomePassword'; After that,
Windows 7 Activation, it is possible to do among two points. You'll be able to add it to your membership of the sysadmin fixed server position making use of sp_addsrvrolemember:EXEC sp_addsrvrolemember 'LoginName',
Windows 7 Ultimate, 'sysadmin'; or else you can grant the login Control SERVER permissions:GRANT Handle SERVER TO [LoginName];