How do I change my webconfig to point to aspnetdb on sql 2000

[Sethington]

I'm a newbie at this so bare with me.

I created a login screen for a website using Visual Studio 2005 using their login tools. Our webserver is running SQL server 2000. I ran aspnet_regsql.exe and imported the database into sql server 2000.

Now I just need to change the web.config file to look for the authentications there.

Can anyone help me or point me in the right direction?

Thanks

 

[jbenson001]

just change the connection string you are using to point to the new server and DB

 

[Sethington]

Like I said I'm a newbie at this so could be elaberate on how I change my connection to the sql 2000 database.

 

[jbenson001]

show the web.config for your current app.

 

[Sethington]

I found an example of what I need to do but I can seem to get it too work.

http://www.c-sharpcorner.com/Upload...rticleID=01cc2bd6-c790-4f00-90dd-030e05feb404

Here is a copy of my web.config file

As you can see i'm trying to get the authentication to look at my instance running on my laptop which is using a default instance name of MSSQLSERVER.

Any suggestions why this still isn't working or how to get this to work.

<configuration xmlns="

http://schemas.microsoft.com/.NetConfiguration/v2.0">

<appSettings/>
<connectionStrings>
<add name="MySqlProviderConnection" connectionString="server=LAPTOP\MSSQLSERVER;integrated security = true;Initial Catalog=aspnetdb"/>
</connectionStrings>
<system.web>
<authentication mode="Forms" />
<roleManager enabled="true" />
<membership defaultProvider="MySqlMembershipProvider">
<providers>
<add connectionStringName="MySqlProviderConnection" name="MySqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</membership>
<compilation debug="true"/></system.web>
</configuration>

 

[jbenson001]

What do you mean it does not work? Are you not able to connect through your code? If so, what is the code?

 

[Sethington]

To be honest I don't have any connection calls in my page code. I thought that I could just make my connection to the database by changing my web.config file.

 

[jbenson001]

In order to connect to the database, you need to use the connection string with one of the data controls.