Home All Groups Group Topic Archive Search About
Author
7 Aug 2006 10:51 PM
rgelfand2
Do you need to have sql server 2005 installed for this db?

If not, how do you connect to it using non- windows integrated
authentication?

Thanks in advance

Author
8 Aug 2006 8:57 AM
eblanco
Tips on moving the db:
http://www.dotnetslackers.com/sql/re-27019_moving_aspnetdb_mdf_sql_express_to_a_hosted_production_environment.aspx

I think (please correct me if not) that you can host that db in another
server, all you have to do is setup the connection string. If you dont
find in web.config, it mught be using this on machine config:

<connectionStrings>
    <add name="LocalSqlServer" connectionString="data
source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User
Instance=true" providerName="System.Data.SqlClient" />
  </connectionStrings>

I think that Simply put this on web.config (to override de setting) and
change the conn string.

I think it should work in sql 2000, it uses 2005 by default because sql
express is easy/free to install in a development environment


rgelfa***@hotmail.com wrote:
Show quote
> Do you need to have sql server 2005 installed for this db?
>
> If not, how do you connect to it using non- windows integrated
> authentication?
>
> Thanks in advance
Author
8 Aug 2006 2:42 PM
Siva M
Check this out:
http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-us/dnaspp/html/configaspnet_sql.asp

<rgelfa***@hotmail.com> wrote in message
news:1154991089.107557.216870@i3g2000cwc.googlegroups.com...
Do you need to have sql server 2005 installed for this db?

If not, how do you connect to it using non- windows integrated
authentication?

Thanks in advance

AddThis Social Bookmark Button