Issue time06:54:00 pm, by tom.green Email 26733 views
Categories: Server Configuration

Problem

When trying to execute a remote stored procedure through a linked server called "server_name"  the following error is received:

EXEC server_name.mydatabase.dbo.mysproc

Msg 7411, Level 16, State 1, Line 1
Server 'server_name' is not configured for RPC.

Solution

The problem is that RPC is not configured for your linked server (is not a default option). You can see the configured settings for the linked servers by executing exec sp_helpserver on the host  server. 

Full story »

Tags: rpc

Leave a comment
Issue time11:35:00 am, by tom.green Email 11236 views
Categories: Errors

Problem

After stopping a database backup taking to long to complete (over the network) the associated spid remained in killed/rollback status for several hours.

SPID XX: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0

 

Solution

As a general rule it is best to not attempt to kill any spid which is performing a database backup.

It seems that, sometimes, operating system level operation initiated from SQL Server can't be rolledback.

After spending quite a few time trying to get rid of the blocked spid the only solution that got me out of this situation was to restart the SQL Server Service.

Full story »


Leave a comment
Issue time09:21:00 am, by tom.green Email 14756 views
Categories: Errors, Server Configuration

Problem

 

When trying to send emails from SQL Server using using the sp_send_dbmail stored procedure the following errors can appear:

 

Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107

No global profile is configured. Specify a profile name in the @profile_name parameter.

or

Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62

Could not obtain information about Windows NT group/user ?DOMAIN\user_name?, error code 0x5.

 

This happens on SQL Server 2005 or 2008 even if the Database Mail feature is installed and configured (the Database Mail feature is enabled and the necessary account and profile is created).

 

 

Cause

This happens because there is no database mail profile set as "Global Profile".

 

Full story »


Leave a comment
Issue time05:32:00 pm, by tom.green Email 23655 views
Categories: SSIS, Security, Errors

 

Connecting to a Remote Integration Services Server

 

When attempting to connect to a SQL 2005, 2008 or 2012 Integration Services instance with a user account that is not an windows administrator on the machine running the SSIS services, you receive the following message:

"Cannot connect to SSIS Server
Additional information: Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)
Connect to SSIS Service on machine "SSIS Server" failed: Access is denied."

 

 

OR:

 

 

When a user without sufficient rights attempts to connect to an instance of Integration Services on a remote server, the server responds with an "Access is denied" error message. You can avoid this error message by ensuring that users have the required DCOM permissions.

 

Full story »


3 comments
Issue time04:32:00 pm, by tom.green Email 6507 views
Categories: Errors, SQL Server

Problem

"Generate Activation Context failed for C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL."

and

"Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied."

 

 

 

Solution

To resolve this issue you have to give the "Performance Log Users" List Folder Contents permissions, which is on the Security tab of both of the following folder locations:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin


Full story »


1 comment
August 2017
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

Search

Email Subscription

Enter your email address:

Translate

Advertising











XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
SQL Server More...
SSIS More...
Server Configuration More...
Errors More...

Poll

Which database platform do you use?

View Results

Powered by b2evolution