IT: add windows user to sql instance in single user mode

Monday, March 30, 2015

add windows user to sql instance in single user mode


    
      
        
  
    
    

        


  


  
        
          
          "D:\Microsoft SQL Server\<INSTANCE_NAME>\MSSQL\Binn\sqlservr.exe" -s<INSTANCE_NAME>  -m
        
        
          
          

        
        
          
          wichtig parameter für sqlcmd sind case sensitive
        
        
          
          sqlcmd  -E -S<SERVERNAME>\<INSTANCE_NAME>
        
        
          
          

        
        
          
          CREATE LOGIN [<domain>\<user>] FROM WINDOWS;
        
        
          
          GO
        
        
          
          SP_ADDSRVROLEMEMBER  '<domain>\<user>', 'sysadmin'
        
        
          
          GO
        
  



    

  


      
      
        view raw
        
          add windows user to sql instance in single user mode
        
        hosted with ❤ by GitHub

	"D:\Microsoft SQL Server\<INSTANCE_NAME>\MSSQL\Binn\sqlservr.exe" -s<INSTANCE_NAME> -m

	wichtig parameter für sqlcmd sind case sensitive
	sqlcmd -E -S<SERVERNAME>\<INSTANCE_NAME>

	CREATE LOGIN [<domain>\<user>] FROM WINDOWS;
	GO
	SP_ADDSRVROLEMEMBER '<domain>\<user>', 'sysadmin'
	GO