Category Archives: SQL SERVER

SQL SERVER Replication – Troubleshooting Steps for Beginners

Few days back there was a replication issue in one of the QA servers. Since the DBA was out of office that day, I was called in to look into the issue. Though I am not an expert in replication, … Continue reading

Posted in Replication, SQL SERVER | 1 Comment

Passing BIGINT data to SSRS Sub Report

Few days back one of my team mate complained to me that one particular sub report is failing randomly with Error: Subreport could not be shown The particular sub report was called from another report’s tablix control column. It accepts … Continue reading

Posted in SQL SERVER, SSRS | 1 Comment

SQL SERVER connectivity error: SQL Server does not exist or access denied

Recently I was troubleshooting a connectivity issue in a development environment from an application. The application was using the connection string as “Provider=sqloledb;Data Source=myserver\instance1,1433;Network=DBMSSOCN;Initial Catalog=mydb;Integrated Security=SSPI;” I was able to connect to the SQL SERVER from SSMS, however when connecting … Continue reading

Posted in SQL SERVER | 5 Comments

Side by Side installation of SQL Server 2008 and SQL Server 2008 R2

Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER 2008 BIDS. Since SQL SERVER supports side by side installation of same/different versions (in fact we have BIDS 2005 & … Continue reading

Posted in SQL SERVER | Leave a comment