Configuring AspNetSqlProvider to use a different database

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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?

I tried to change default connection in web.config file.

Now it looks like this:

<?xml version="1.0" encoding="utf-8"?>
<configuration
xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<add name="SqlServices" connectionString="Data
Source=TEHNOWEB;Initial Catalog=TehnoDB;Integrated Security=true;" />
</connectionStrings>

<system.web>
<roleManager enabled="true" />
<authentication mode="Forms" />
</system.web>
</configuration>

This is not possible to be connected, returned error 26 - Error
Locating Server/Instance Specified and I understand what does it mean
but I don't understand how to do that properly???

1. My question is that all what I need to do, only to change default
connections in web.config file?

2. What does it mean "SqlServices" exactly. I can not see any
conection with something...

Thanks to all
 
Thank you so much. This is very usefull.

Now I'm in trouble with roles configuration...

You help me a lot, thanks again.

Mike
 
Back
Top