Browse by Tags

Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.

Published 10 July 8 3:2 AM | SSQA.net

As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the...

Filed under: sql server, security, services, Analysis Services, data providers, impersonation

Unable to install SQL Server 2008 RC0 Books Online

Published 26 June 8 4:54 AM | SSQA.net

In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate...

Filed under: sql server, services, documentation, books online, rc0, windows installer

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

February CTP: SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Published 1 March 8 7:57 AM | SSQA.net

I was happy to see that February CTP for SQL Server 2008 was ready to download for use, in coinciding with my presentation in SQLBits I wanted to work my demos on this CTP release, nothing worked out successfully!! It is fair that new release will help...

Filed under: sql server, microsoft, services, 2008, bug, connect, error log, fix, thread, spawn

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL...

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"

Published 4 February 8 6:3 AM | SSQA.net

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

Filed under: sql server, services, kba, database mirroring, failover, endpoint, port

FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005

Published 17 December 7 7:19 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you...

Filed under: sql server, services, kba, alert, database mirroring, principal, restart, debug

Unable to install SQL Server Express - Error SQL Server service failed to start?

Published 7 November 7 1:33 PM | SSQA.net

Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default...

Filed under: sql server, microsoft, services, error, sql express, installation, encryption, build, log file, 15029

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

Published 30 October 7 10:41 PM | SSQA.net

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...

Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide

SQL Server MSDTC service - do you need it or not?

Published 11 October 7 7:2 AM | SSQA.net

MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent...

Filed under: sql server, services, kba, transaction, clustering, msdtc, servers, end, begin

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

Published 9 October 7 2:50 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 Description of the SQL Server Integration...

Filed under: sql server, ssis, services, kba, clustering, servers, integration services

New drive in problem resolution by Microsoft Product Support Services - SQL Server

Published 7 September 7 5:32 AM | SSQA.net

Microsoft Product/Customer Support Services has introduced new phase of provision to address the user issues. This program has been divided into various phases such as assessment, configuration and management with a flavour of Performance & Tuning...

Filed under: sql server, microsoft, security, services, customer, support, resources, problem, product, resolution

Unable to start SQL Server service with a specific certificate?

Published 31 August 7 8:5 AM | SSQA.net

You may be aware that using SSL communications a HTTP server can have encryption for us, in this regard certificates must be authorized for server authentication. Microsoft recommends that you can do this by either obtaining an SSL certificate from a...

Filed under: sql server, performance, security, services, certificate, start, ssl, http

How many DBAs you need to manage show in multi-server environment?

Published 30 August 7 5:24 PM | SSQA.net

This sounds like a joke that "How many DBAs you need to change a light bulb?". I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed...

Filed under: sql server, server, services, dba, edition, multiple

How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

Published 30 August 7 2:56 PM | 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 How to enable the SQL Server 2005 Integration...

Filed under: sql server, integration, ssis, services, kba, process, file, dump, exception

The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005

Published 25 August 7 4:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications The "SQL Server:SSIS Pipeline" performance object does not appear in...

Filed under: sql server, performance, ssis, services, kba, x64, int

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

Published 23 August 7 3:15 PM | 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, integration, ssis, ssms, services, plan, kba, maintenance

Reporting Services setup in Vista, simple resolution

Published 22 August 7 8:23 AM | SSQA.net

Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues...

Filed under: sql server, management, ssrs, services, report builder, iis

Spurious errors when using SQL Server 2005 Performance Dashboard Reports

Published 16 August 7 8:25 AM | SSQA.net

You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums & other...

Filed under: dashboard, sql server, performance, ssrs, services, reporting, reports

"Allow Indexing Service to index this disk for fast file searching"

Published 25 July 7 3:3 AM | SSQA.net

I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to "Find...

Filed under: sql server, indexes, microsoft, services, windows, sql express, xp, file search, 2003