Tags » SQL Server 2008 R2

Sql Server Replication Error Message: Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure

Quick one today:

Recently, in one of our lab machines, we ran into this errors during replication reconfiguration (rebuilding) efforts.

Msg 18752, Level 16, State 1, Procedure sp_replcmds, Line 1
Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, 
and sp_replshowcmds) can connect to a database at a time. 157 more words
DBA

SSRS Error Message : The dataset `DataSource1' refers to the shared data source `DataSource1', which is not published on the report server. The shared data source `DataSource1' must be published before this report can run.

Quick one today:

Earlier today, in our SSRS lab, after deploying reports using PowerShell, we ran into this error:

The dataset `DataSource1' refers to the shared data source `DataSource1', 
which is not published on the report server. 132 more words
DBA

Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.

Issue – Today I faced very weird issue; on multi instance SQL Server machine, couple of SQL Services was not starting after Server reboot ( In my case it was SQL 2014 and SQL 2016 ) and every time I was trying to restart my SQL Services, I was getting below error message – 99 more words

Sql Server 2005

Sql Server Reporting Services : SSRS : How to send reporting errors to client (or web page) - EnableRemoteErrors

Quick one day:

Lately, while working on SSRS, we’ve uncovered some tidbits that have been helping us identify the root cause. Here is one of them: 129 more words

DBA

SQL Server Installation - Non Canonical DACL Error

I have been approached by my colleagues I used to work previous to previous employer. Two of my ex-Colleagues currently working as System Engineers contacted and looking for information if I have seen the error during SQL Server Installation. 162 more words

Microsoft

Static Code Analyzer for T-SQL - MS SQL Server. Plugs into MS SSMS and can al...

Static Code Analyzer for T-SQL – MS SQL Server.

Plugs into MS SSMS and can also be run from command line.It reports useful clues which you can turn/on off to your liking. 

60 more words
Development