Browsing articles from "December, 2011"
Dec
25
2011

[241] Startup error: Unable to initialize error reporting system (reason: Access is denied)

In SQL Server 2000, while updating SQL agent account to run under Domain account, recieved following error, (SQL services started successfully but agent gave error), 2011-12-xx 19:17:15 – ! [241] Startup error: Unable to initialize error reporting system (reason: Access is denied) 2011-12-xx 19:17:15 – ? [098] SQLServerAgent terminated (normally) On search found following useful article link which helped in fixing the issue, I followed following steps to resolve it, As per article, this issue […]

Dec
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’[email protected]′, 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 […]

Dec
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’[email protected]′, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE MASTER CREATE […]

Dec
20
2011

SQL Server 2005 is inaccessible remotely – error:26-Error locating server

Today while working with one Veritas cluster server, faced following error (one of the common error – error:26), There are few basic troubleshooting steps a normal DBA follow, 1. Under ‘SQL Server Surface Area configuration manager’, go to ‘Surface Area configuration for services and connections’, go to ‘Server instance’ > ‘Database Engine’ > ‘Remote connections’ 2. In remote connections, first and foremost, your ‘local and remote connections’ should be enabled in case you would like […]

Dec
15
2011

How do I check SQL replication status via T-SQL?

While searching for t-sql script which can check replication agent status came across a good script which works well for all versions of SQL Server i.e. 2000/2005/2008/2008R2 and above…

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 34 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

View Post by Categories

%d bloggers like this: