23
2011
Msg 911, Level 16, State 1, Line 3 – Could not locate entry in sysdatabases for database ‘MASTER’
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 […]
23
2011
Script to create SQL login and assign read privileges on master and msdb database for automation purpose
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 […]
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5