Monthly Archives: August 2012

Microsoft OLE DB provider for SQL Server error 80004005

While browsing a ASP site, you end up getting SQL Server error 80004005. Microsoft OLE DB Provider for SQL Server error ’80004005′ [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. CAUSE Microsoft OLE DB provider for SQL Server error 80004005, primary occurs because ASP page is unable to connect to SQL Server using connections settings, which you [...]

User already exists in current database. SQL Server Error 15023

This error usually happens after you have restored a database from a backup from one server to another. When you move a databases from one SQL Server to another, and your application might get errors saying “Login failed for <user>” and when you check Database Security and you find that login was already in the [...]

Cannot open database requested by the login. The login failed. SQL Server Error 4060

CAUSE : This problem occurs because login that you used to access database does not have sufficient permissions. SOLUTION : You need to grant permission to the user to access database and/or to execute stored procedure. How to grant reader/writer access to SQL database: Log on to SQL Server Management Studio by going Start >> [...]

Cannot write property IsFileStream.This property is not available on SQL Server

While Creating a New Database on SQL Server 2012 using SQL Server Management Studio 2008 R2, you might get this error. Cannot write property IsFileStream.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo) CAUSE SQL Server Management is unable to set up the default property while creating a database using previous version of SQL [...]

SSRS Cluster, How to Install and Configure SQL Server Reporting Service Cluster Configuration for High Availability VIDEO

How to Configure SQL Server Reporting Service on Cluster (SSRS Cluster) for High Availability ? We can configure SQL Server Database Engine, Analysis Services and Integration Services  for High availability but how to Configure Reporting Services on Cluster (SSRS Cluster) for High Availability that too without using a any third party Load Balancing component. The [...]

SQL AZURE pricing (PROS | CONS) – How costly is to have SQL Database on a Cloud?

Hosting a Microsoft SQL Server Database on a cloud is very cheap, Anyone can afford to have a SQL Server database in Microsoft Cloud Environment. The cost starts from $5 per month, yes Microsoft has an 100 MB option, which costs only $5 a month. Currently many customer / Business managers are unaware of this [...]

PowerShell script error – File not digitally signed : FIX

Today I was working on building PowerShell script to establish SQL Server Database Mirroring. To start with PowerShell, I tried to execute my first built of PowerShell Script on SQLPS, I received the following error.File C:\Temp\Mirroring\Script\DBMirrroringSetup.ps1 cannot be loaded. The file C:\Temp\Mirroring\Script\DBMirrroringSetup.ps1 is not digitally signed. The script will not execute on the system. Please [...]