Re: ASPDBNET.MDF

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


rgelfand2@xxxxxxxxxxx wrote:
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

.

Relevant Pages

  • Re: Add new cluster and use existing LUNs?
    ... Meta-volumes are dedicated to a single host, single activity (OS, swap file, ... varied activity (DBMSes, Messaging Server, File Server, Web Servers, ... Some of the physical spindle limitations can be addressed through the SAN ... >> test would be to run a simulated SQL I/O load on the newly created LUNs ...
    (microsoft.public.sqlserver.clustering)
  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: 4 Queries about DB clustering
    ... SQLInstance1 and 2 refer to the SQL virtual servers\instances. ... The host ... Microsoft SQL Server MVP ... > In your suggestion is the SQLinstance1 and SQLInstance refer to as ACTIVE ...
    (microsoft.public.sqlserver.clustering)
Loading