While creating SQL login on SQL Server 2005 via following t-sql script, SET NOCOUNT ON USE MASTER CREATE LOGIN [test] WITH PASSWORD=N’test@123′, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE MASTER CREATE USER [test] WITH DEFAULT_SCHEMA = dbo exec sp_addrolemember N’db_datareader’, N’test’ GO SET NOCOUNT OFF faced below error, Msg 911, Level 16, State 1, Line 3 Could not locate entry in sysdatabases for database ‘MASTER’. No entry found with that name. Make sure that the name […]

Today got a task to create a common account across all SQL servers which have read privileges on master and msdb database, so to carry out this activity, wrote a small script as follows for SQL 2000 and SQL 2005/2008, Note: Replace test with your account name and password as your desired password Script for SQL 2005/2008, SET NOCOUNT ON USE MASTER CREATE LOGIN [test] WITH PASSWORD=N’test@123′, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE MASTER CREATE […]