SQL Server problems

Topics: ASP.NET 2.0
Jan 29, 2009 at 3:43 PM
I am trying to convert to using SQL Server. The script ran fine and created the tables. I get the following error when connecting after making the changes to my web.config.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load type 'BlogEngine.Core.Providers.MSSQLBlogProvider'.

Source Error:

Line 9:  		<blogProvider defaultProvider="MSSQLBlogProvider">
Line 10: 			<providers>
Line 11: <add name="MSSQLBlogProvider" type="BlogEngine.Core.Providers.MSSQLBlogProvider"/>Line 12: 				<add name="XmlBlogProvider" type="BlogEngine.Core.Providers.XmlBlogProvider, BlogEngine.Core"/>
Line 13: 				

Source File: D:\HTTP\blog\web.config    Line: 11

Jan 29, 2009 at 3:53 PM
Never mind. I figured it out. I followed the instructions. :)

I was using the web based steps, but when I simply copied the version in the SQL Server folder in setup and modified the connection string it worked perfectly.