Hello All

 Where in the code/configuration  would I change the default Provider Model  to use SqlServer as the data source rather than XML

I am talking about Catalogs, News, Testimonials they all use the XML Datasource, however in the provide sqlserver database these table are defined and I would like the example to default to these, however I cannot see where I would make this change. Is it in the web.config? if so what are the values?

 Thanks for you help in advance

<SmallBusinessDataProviders peopleProviderName="SqlProvider" testimonialsProviderName="xmlProvider" catalogProviderName="SqlProvider" newsProviderName="SqlProvider">

Is that all that needs to be done? I am using VS 2005 with MS SQL 2005, and not SQL Express. Should I add the any server configuration to the existing connection string, cuz the existing string shows the default data source as ./SQl Express, which does not work out for me. Could you pls give me detailed steps ? Or, is there no modification required when SQL Express is used? I am really confused with this.