SQL Server 2008 r2 - It is not a Valid Login or You do not have Permission to Install on Windows 8.1

Introduction:

Here I will explain how to solve “it is not a valid login or you do not have permission to install sql server 2008 r2” problem on windows 8.1. Actually I got this problem while installing SQL Server 2008 r2 on windows 8.1 and I realized this problem occurred because of system name and login name both are same.

Description:

In previous articles xml document load invalid character in the given encoding, sql server invalid use of side effecting operator insert within function, sql conversion failed when converting varchar value 24 and many articles to solve Run time errors in asp.net, sql server.

Now I will explain how to solve the problem of it is not a valid login or you do not have permission to install sql server 2008 r2 while installing on windows 8.1 like as shown below

  

CrystalReport: The Type or Namespace name 'CrystalDecisions' Could not be Found in Visual Studio 2010

Introduction: 

Here I will explain how to solve problem of “The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?” in visual studio 2010 while using crystal reports in windows application in c#, vb.net.

Description:
  
In previous articles I explained lot of articles related to solve errors  in windows application, asp.net, c#,vb.net and jQuery. Now I will explain how to solve problem of “The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?” in visual studio 2010 while using crystal reports in windows application in c#, vb.net.

Crystal ReportViewer Does not Contain a Definition for 'ReportSource' and No Extension Method 'ReportSource' Accepting a first Argument of Type

Introduction: 

Here I will explain how to solve the problem of “'Microsoft.Reporting.WinForms.ReportViewer' does not contain a definition for 'ReportSource' and no extension method 'ReportSource' accepting a first argument of type 'Microsoft.Reporting.WinForms.ReportViewer' could be found (are you missing a using directive or an assembly reference?)” while using crystal reports in windows applications in C#, vb.net.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “'Microsoft.Reporting.WinForms.ReportViewer' does not contain a definition for 'ReportSource' and no extension method 'ReportSource' accepting a first argument of type 'Microsoft.Reporting.WinForms.ReportViewer' could be found (are you missing a using directive or an assembly reference?)” while using crystal reports in windows applications in C#, vb.net like as shown below 

Could not load file or assembly 'file:///' or one of its dependencies.The system cannot find the file specified.

Introduction:

Here I will explain how to solve the problem of “Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.” while using crystal reports in windows applications in C#, vb.net.

Ajax Could not load file or assembly 'AjaxMin, Version = 4.97.4951.28478, Culture = neutral, PublicKeyToken = 3422fdet4' or one of its dependencies. The system cannot find the file specified.

Introduction:

Here I will explain how to solve “Could not load file or assembly 'AjaxMin, Version=4.97.4951.28478, Culture=neutral, PublicKeyToken=21ef50ce11b5d80f' or one of its dependencies. The system cannot find the file specified.” problem in Ajax.

Description:

In previous articles I explained Ajax auto complete textbox, Ajax country state city dropdown, Ajax calendar control example with custom date format, Ajax rating control example with database and many articles related to Ajax and asp.net. Now I will explain how to solve the problem of “Could not load file or assembly 'AjaxMin, Version=4.97.4951.28478, Culture=neutral, PublicKeyToken=21ef50ce11b5d80f' or one of its dependencies. The system cannot find the file specified.”

Actually this problem occurred because of missing “AjaxMin.dll” reference in our application. 

VB.NET - Name of field or property being initialized in an object initializer must start with '.'

Introduction:

Here I will explain how to solve the problem of “name of field or property being initialized in an object initializer must start with '.'” while converting C# code to vb.net.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “name of field or property being initialized in an object initializer must start with '.'” while converting C# code to vb.net.

Ajax Error Unable to Get Value of the Property 'ui' Object is null or undefined

Introduction:

Here I will explain how to solve Ajax control toolkit error unable to get value of the property 'ui' object is null or undefined or Ajax unable to get value of the property 'ui' object is null or undefined.

Description:

In previous articles I explained Ajax auto complete textbox, Ajax country state city dropdown, Ajax calendar control example with custom date format, Ajax rating control example with database and many articles related to Ajax and asp.net. Now I will explain how to solve the problem of unable to get value of the property 'ui' object is null or undefined.

I have installed AjaxControlToolkit and added all Ajax controls to Toolbox in visual studio after completion of this process I started using Ajax controls from Toolbox and added ScriptManager to program. After completion of everything I tried to run the application at that time unexpectedly I got error like “Ajax control toolkit error unable to get value of the property 'ui' object is null or undefined”. 

C# - Could not Load File or Assembly or One of its Dependencies the System Cannot Find the File Specified

Introduction:

Here I will explain how to solve problem of “Could not load file or assembly'xxxxxx’ or one of its dependencies. The system cannot find the file specified” in asp.net, wcf using c#, vb.net.

Description:

In previous articles I explained can function return multiple values in sql,  Query to get database size in SQL Server, Exception handling in SQL Server with try catch, SQL Query to get first & last day of month, difference b/w view and stored procedure in sql and many articles relating to SQL server. Now I will explain how to solve problem of “Could not load file or assembly'xxxxxx’ or one of its dependencies. The system cannot find the file specified” in asp.net, wcf using c#, vb.net.

C# - Xmldocument.load Invalid Character in the Given Encoding. line 23 position 5 in XSLT Compilation

Introduction:

Here I will explain how to solve the problem of “xmldocument.load invalid character in the given encoding in C#”.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “xmldocument.load invalid character in the given encoding in SQL Server”.

SQL Server - Invalid Use of a Side-Effecting Operator 'insert' within a Function

Introduction:

Here I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

SQL Server - Conversion Failed when Converting the Varchar Value '24,' to Data Type int

Introduction:

Here I will explain how to solve the problem of “COALESCE function: Conversion failed when converting the varchar value '24,' to data type int in SQL Server”.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “COALESCE function: Conversion failed when converting the varchar value '24,' to data type int in SQL Server”.

C# - Adding the Specified Count to the Semaphore would Cause it to Exceed its Maximum Count in SQL Server / Asp.net

Introduction:

Here I will explain how to solve the problem “adding the specified count to the semaphore would cause it to exceed its maximum count in c# / Asp.net / sql server .” When running asp.net web application in c#, vb.net with SQL Server database.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “adding the specified count to the semaphore would cause it to exceed its maximum count in sql server”. To solve this problem we need to add “Pooling=False” in database connection string to disable connection pool in web.config.

C# - The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data

Introduction:

Here I will explain “The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.” problem solution in asp.net using C# and VB.NET.

Description:

In previous articles I explained Import/upload data from excel to gridview in asp.net, Export selected rows of gridview to excel/word document, Export gridview data to pdf in asp.net and many articles relating to Excel, Gridview, SQL ,jQuery,asp.net, C#, VB.NET. Now I will explain how to solve the problem of “The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.” in asp.net using C# and VB.NET.

C# - Microsoft.ACE.OLEDB.12.0 Provider is not Registered on the Local Machine in IIS7

Introduction

Here I will explain “the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine” problem solution in asp.net using C# and VB.NET.

Description

In previous articles I explained Asp.net, C#, VB.NET, SQL interview questions, Send values from one page to another page using QueryString, Joins in SQL Server, Highlight Gridview records based on search and many articles relating to Gridview, SQL ,jQuery,asp.net, C#, VB.NET. Now I will explain how to solve the problem of “the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine” in asp.net using C# and VB.NET.

SQL String or Binary Data Would be Truncated. The Statement has been Terminated

Introduction: 

Here I will explain how to solve the problem of “string or binary data would be truncated. The statement has been terminated.” in sql server. 

Description:

One day I am trying to insert data into one table using SQL queries at that time I got error like “String or binary data would be truncated. The statement has been terminated.” Actually this problem because of I declared column datatype varchar(25) but I am inserting data more than 25 characters in that column. To solve this problem I modified column datatype varcha (25) to varchar(50)

the files use a different language which is not allowed since they need to be compiled together

Introduction: 

Here I will explain how to solve the problem “the files use a different language which is not allowed since they need to be compiled together” when running web application using asp.net. 

Description:

In previous article I explained JQuery autocomplete text with webservice. During work with that sample I created WebService in both the languages C# and VB.NET and I placed both languages code behind files in App_Code folder and I tried to run the application at that time I got error like “the files use a different language which is not allowed since they need to be compiled together” as shown below

Asp.net-cannot open database requested by the login. the login failed. login failed for user 'iis apppool\DefaultAppPool'

Introduction:

In this article I will explain how to solve cannot open database requested by the login. The login failed. Login failed for user 'iis apppool\DefaultAppPool' problem in IIS7. 

Description:

In previous posts I explained many articles to solve Run time errors in asp.net. In IIS7 I published one website and started running my deployed application at that time I got some error message like cannot open database requested by the login. The login failed. Login failed for user 'iis apppool\DefaultAppPool'. To solve this problem I did some modifications in IIS for that check below post to make required modifications in iis

Asp.net-Unable to start debugging on the web server. IIS does not list a web site that matches the launched URL

Introduction: 

Here I will explain how to solve the problem “Unable to start debugging on the web server. IIS does not list a web site that matches the launched URL.” When running web application using visual studio in asp.net.

Description

In previous posts I explained many articles to solve errors in asp.net. Now I will explain how to solve the problem of “Unable to start debugging on the web server. IIS does not list a web site that matches the launched URL”. During work with one application error like as mentioned above. We can solve this problem in different methods.

Ajax the operation could not be completed invalid formatetc structure in visual studio

Introduction:

Here I will explain how to solve the problem the operation could not be completed invalid formatetc structure during the time of working with Ajax AsyncFileUpload control in asp.net.

Description:

In previous post I explained Ajax AsyncFileUpload control example in asp.net. During working with that one suddenly I got error like “the operation could not be completed invalid formatetc structure”. 

JSError- microsoft jscript runtime error object doesn't support property or method 'addeventlistener'

Introduction: 

In this article I will explain how to solve problem of “microsoft jscript runtime error object doesn't support property or method 'addeventlistener'” during working with click events in JavaScript.

Description:

In Previous posts I explained how to integrate facebook login button in asp.net during implement that functionality I written functions like this to handle hyperlinks click events in JavaScript