Configuring AspNetSqlProvider to use a different database

[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

[=?Utf-8?B?U2l2YSBN?=]

hi,

See if this helps:
http://www.thedatafarm.com/blog/2006...embership.aspx

"Mike" wrote:

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

[Mike]

Thank you so much. This is very usefull.

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

You help me a lot, thanks again.

Mike

On Sat, 19 May 2007 05:08:03 -0700, Siva M
<sh******@online.excite.comwrote:

>hi,

See if this helps:
http://www.thedatafarm.com/blog/2006...embership.aspx

"Mike" wrote:

>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

[=?Utf-8?B?U2l2YSBN?=]

Check this one:
http://help.maximumasp.com/smarterti...?articleid=878
"Mike" wrote:

Thank you so much. This is very usefull.

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

You help me a lot, thanks again.

Mike

On Sat, 19 May 2007 05:08:03 -0700, Siva M
<sh******@online.excite.comwrote:

hi,

See if this helps:
http://www.thedatafarm.com/blog/2006...embership.aspx

"Mike" wrote:

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

[Mike]

It is great, Thank you very much :)

On Sun, 20 May 2007 03:22:00 -0700, Siva M
<sh******@online.excite.comwrote:

>Check this one:
http://help.maximumasp.com/smarterti...?articleid=878
"Mike" wrote:

>Thank you so much. This is very usefull.

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

You help me a lot, thanks again.

Mike

On Sat, 19 May 2007 05:08:03 -0700, Siva M
<sh******@online.excite.comwrote:

>hi,

See if this helps:
http://www.thedatafarm.com/blog/2006...embership.aspx

"Mike" wrote:

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