|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ASPDBNET.MDFDo 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 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 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 |
|||||||||||||||||||||||