Tag Archives: SQL Error

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

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

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information Error 8623 / 8632

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer [...]

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

SQL Dumper Error – failed initialization Solution

SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer One of my friend called me and said, he is getting this error Every time when he starts his laptop ROOT [...]

SQL server Error 53 – FIX

SQL ERROR 53 : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL [...]