Showing posts with label SQL 2012. Show all posts
Showing posts with label SQL 2012. Show all posts

February 08, 2014

The provider did not return a providermanifest instance

Errors:
- EntityDataSource error ...
- Error in Visual Studio 2013 and EntityDataSource
- EntityDataSource have error "the provider did not return a providermanifest instance"
- How to Fix "The provider did not return a ProviderManifest instance ...

Full Error:
The metadata specified in the connection string could not be loaded. Consider rebuilding the web project to build 
assemblies that may contain metadata. The following error(s) occurred: 
The provider did not return a ProviderManifest instance.


Solution:
Open the EDMX file and change ProviderManifestToken="2012" to ProviderManifestToken="2008"

Other Solutions (not useful for me):
1- I know this is a ridiculous solution but i think that the star (*) is not working in connection string field of Web.config :-( you can change it with project name as a project namespace reference
Before: <add name="TestEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl blah blah
After: <add name="TestEntities" connectionString="metadata=res://PROJECTNAME/Model1.csdl|res://PROJECTNAME/Model1.ssdl blah blah

2- Go to Run%temp% and empty the temp folder
3- Set integrated security=False in connection string field of Web.config

November 10, 2012

Fusion Active Template Library (ATL)

ERROR:
Rule "Fusion Active Template Library (ATL)" failed.
A computer restart is required because of broken fusion ATL. You must restart your computer before you continue.



SOLUTION:
Go to setup media (SQL DVD) and install this package and it'll be solved after a restart ;-)

32bit: DVD\1033_ENU_LP\x86\Setup\sqlsupport_msi\sqlsupport.msi
64bit: DVD\1033_ENU_LP\x64\Setup\sqlsupport_msi\sqlsupport.msi

November 09, 2012

SQL Server cannot process this media family


ERROR:
Specified Cast is not valid (SqlManagerUI)

ERROR:
Msg 3241, Level 16, State 13, Line 1
The media family on device 'D:\1.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

CAUSE:
- Microsoft SQL Database fails to restore from higher ms-sql version
- Restoring the backup from SQL 2008 to SQL 2005 instance
- Restoring SQL backup file from SQL 2012 to SQL 2008

SOLUTION:
- Upgrade your destination sql server to upper version
- Prepare SQL data script instead of sql data backup file

October 18, 2012

CREATE FILE encountered operating system error 5


Problem:
- CREATE FILE encountered operating system error 5(Access is denied.)
- CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'PATH\FILE.mdf'.
- CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'PATH\FILE.mdf'.

Solution:
- Go to Control Panel > Administrative Tools > Services
- Right click on SQL SERVER (BLAH BLAH) and select the Properties
- Stop service
- Go to Log On tab and change the Log on as: to Local System Account
- Apply and Start service again ans enjoy ;-)

September 24, 2012

CREATE DATABASE failed


Error:
Message:  CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XYZ.mdf".
Line Number: 2
Source: .Net SqlClient Data Provider
Procedure: 

Error:
Message: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Line Number: 2
Source: .Net SqlClient Data Provider
Procedure:

Solution:
- Start application with Run as Administrator 
- Change the SQL Server service