ALTER LOGIN [Laura] WITH DEFAULT_DATABASE=[AdventureWorks2012], DEFAULT_LANGUAGE=[British], PASSWORD=N'myStr0ngPW' Finally, you can .