Auditing SQL Server Security

Auditing SQL Server Security

http://www.theiia.org/itaudit/index.cfm?fuseaction=forum&fid=5611

Unable to connect to Citrix Server from some Workstations

Root Cause:
When Citrix client try to connect to Citrix Server, Server not able to issue client license. (Its not able to generate Client license key on Client computer HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing\Store Registry hive)

Workaround:
Open regedit.exe from client workstation Go to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing\Store" Delete all the keys start with 'LIC' (It will remove existing Terminal Services client license key) Try to login to Citrix Server. Citrix Server will reissue new client license.

System Error No List

System Error Codes (0-499)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/system_error_codes__0-499_.asp

Example:

ERROR_DISK_FULL112
There is not enough space on the disk.

Microsoft Product Support's Reporting Tools

The Microsoft Product Support Reporting Tool facilitates the gathering of critical system and logging information used in troubleshooting support issues. The reporting tool DOES NOT make any registry changes or modifications to the operating system. There are 8 specialty versions, one for each of the following support scenario categories: Alliance, Directory Services (not for Windows NT 4.0), Networking, Clustering, SQL, Software Update Services, MDAC and Base/Setup/Storage/Print/Performance. Each version gathers some of the same basic information but there are specific reports unique to each of the support scenario categories

Link :
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en

SQL Server Agent not starting

SQL Server Agent on SQL Server 2000 not started.

There are One SQL Server Service account and one connection setting for the serivce account this need to be checked for any password change and accont change if not windows authentication

It almost relevant of "http://support.microsoft.com/default.aspx?scid=kb;en-us;237604".



From Event Viewer
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Service Control
Event ID: 103
Date: 30/07/2005
Time: 4:01:50 PM
User: N/A
Computer: AAUNSW047
Description:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Output on SQL Agent when tries "SQLAgent -c -v " from the command prompt
2005-07-30 16:01:50 - ? [094] SQLServerAgent started from command line
2005-07-30 16:01:50 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
2005-07-30 16:01:50 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2005-07-30 16:01:50 - ? [098] SQLServerAgent terminated (normally)

INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server

INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server

How to stop the transaction log of a SQL Server database from growing unexpectedly

How to stop the transaction log of a SQL Server database from growing unexpectedly

SQL Server 2000 Analysis Services - INF: Permissions That You Must Have to Administer an OLAP Server

2147221466 : Your permissions on the server computer do not allow you to administer this OLAP server.Error: Path/File access error

SQL Server 2000 Analysis Services - INF: Permissions That You Must Have to Administer an OLAP Server