--Don't know if you need to run this script? If so, run this one line below first --EXEC sp_change_users_login 'Report' USE [master] GO IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'snapstream') Drop login snapstream GO CREATE LOGIN [snapstream] WITH PASSWORD=N'snapstream', DEFAULT_DATABASE=[SnapStreamTV], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF Go use SnapStreamTV GRANT CONNECT TO [snapstream] GO EXEC sp_change_users_login 'Auto_Fix', 'snapstream'