Browse by Tags

FIX: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials"

Published 23 December 7 1:59 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you jump to another report that uses a shared data...

Filed under: sql server, security, kba, reporting services, 2005, data source, credentials

Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy"

Published 28 October 7 9:53 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message in the SQL Server Errorlog file...

Filed under: sql server, security, kba, password, servers, windows 2003, policy

How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult

Published 12 October 7 5:55 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, security, kba, access, sa, system administrator, operation system

Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration

Published 4 September 7 11:41 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Some or all SQL Server 2005 services are...

Filed under: sql server, security, kba, error log, surface, configuration, area, components, operations

Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"

Published 12 June 7 12:36 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do...

Filed under: sql server, security, login, kba, permission, sa

A user who is not a member of a required role can still connect to a SQL Server 2005 database after you set the user access option for the database to RESTRICTED_USER

Published 22 May 7 12:56 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition KBA - A user who is not a member of a required role can still connect to a SQL Server 2005 database after you set the user access...

Filed under: sql server, security, kba, restrictred

Anti-virus tool on SQL Server

Published 18 May 7 9:33 AM | SSQA.net

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server...

Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba