meer_alam

The target principal name is incorrect. Cannot generate SSPI context

Introducing the problem scenario Yet another Kerberos authentication failure troubleshooting...

Author: Meer Al - MSFT Date: 05/10/2015

Why SQL Server connection fails, when I change the port from dynamic to static, in SQL Server Configuration Manager, for my named instance of SQL Server, but I do not restart the SQL Server instance?

Introducing the problem scenario Recently I had to investigate the following scenario. SQL Server...

Author: Meer Al - MSFT Date: 12/25/2014

failed to retrieve data for this request .... errors in the metadata manager an error occurred when loading the admin database role from

Scenario My most recent encounter with SSAS DB corruption surfaced slightly differently than normal....

Author: Meer Al - MSFT Date: 09/28/2014

Cannot create a connection to data source 'TemporaryDataSource'........System.Net.Sockets.SocketException: No such host is known

Recently, I was puzzled from one of my troubleshooting experience with our premier customer. The...

Author: Meer Al - MSFT Date: 09/08/2014

SSIS Data Source Connection Information Parameterization with Environment Variable

Scenario We would like to parameterize SSIS 2012/2014 Package connection manager with the...

Author: Meer Al - MSFT Date: 08/11/2014

File system error: The following error occurred while opening the file ?MDTempStore___***.tmp: Access is denied

While working on a recent TFS Analysis Service Database migration scenario, we encountered the...

Author: Meer Al - MSFT Date: 05/25/2014

File system error: The following error occurred while opening the file '....~OLAPConfigmsmdsrv.tmp': Access is denied

I recently worked with the following scenario, did not find any helpful links that explains why we...

Author: Meer Al - MSFT Date: 05/25/2014

..Microsoft.AnalysisServer.Server.."Cannot created Activex Component"

Recently, I worked on a scenario, where a .NET application was trying to use SQL Server Analysis...

Author: Meer Al - MSFT Date: 02/12/2014

SSRS Performance Troubleshooting: Where did we spend the time before the report even started executing?

I recently dealt with couple of scenarios, where, we struggled to understand, at first, why the...

Author: Meer Al - MSFT Date: 02/11/2014