SqlServer-QA.net

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete 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 ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications 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 ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications How to make unwanted access to SQL Server 2005 by an operating system administrator more ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a ''No SQL Server 2005 components ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification 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 not have permission''http://support.microsoft.com/kb/917827/en-US

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 option for the database to RESTRICTED_USER

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 that is dedicated to databases, rather tighten the access on the file access and share on ...

Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances.  SQL Server setup information is as follows:provider:SQL native ClientProduct Name: SQLNCL1Data Source: Somewhere IN this world (SQLServer 2000 default instance)catalog=Northwind 1. Remote connections: using both TCP/IP and Named ...