Board index » Web Programming » Configuring AspNetSqlProvider to use a different database

Web Programming246
I need to configure the provider to use a database in SQL Server instead of

the SQL Express database default, but the admin tool does not give any

options to change the database. Does anyone know how to change this

configuration?


-

It's very easy! You should change just your connection string to point to

your SQL Server database.



Gaidar



"John Bailey" <JohnBailey@discussions.microsoft.com>wrote in message



-

This is a copy of what is in my web.config file.



<?xml version="1.0"?>

<configuration xmlns="schemas.microsoft.com/.NetConfiguration/v2.0">">schemas.microsoft.com/.NetConfiguration/v2.0">

<system.web>



<authentication mode="Forms" />

<roleManager enabled="true" />

<compilation debug="true"/>

<customErrors mode="Off" />

</system.web>

</configuration>



As you can see there is no connection string in the config file. I am using

Visual Studio 2005 beta 2. The web site runs just fine against the SQL

Express datbase, but in the environment I am deploying it in, it will need to

go against a SQL Server.



"gaidar" wrote: