Category Archives: SQL Errors

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 [...]

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 [...]

SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state"

"SQL Server Database Services feature state". This was the Error Message, which I received this morning during building / Installing a SQL Server 2012 cluster. FIX / Resolution / Workaround : Change registry key on active node: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQLDEV2012\ConfigurationState] Change all entry values from 2 to 1 Incident happened to me in Detail I [...]

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed – SQL Server Reporting Services Error

User ‘DBATAG-DEMO\cluadmin’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. I received this error, when I was trying to configure SQL Server Reporting Services for “Scale-OUT Deployment” for NLB configuration. I was logged in as Domain / Enterprise Administration account still [...]