Re: ASPNETDB.MDF when no SQLExpress, only SQL Server 2005?
- From: Peter Bromberg [C# MVP] <pbromberg@xxxxxxxxxxxxxxxxxxx>
- Date: Mon, 19 Jun 2006 13:44:01 -0700
Jon,
You do not need to "upload the MDF file" and attach it. YOu can enable any
database with this code:
Management.SqlServices.Install("server", "USERNAME", "PASSWORD",
"databasename", SqlFeatures.All)
That's in the System.Web namespace, and it can be run from a web page.
I agree that it's too bad MS hasn't really promoted this fact, given that so
many people run ASP.NET 2.0 web sites on hosted environments where they have
no access to ASPNET_REGSQL.
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
"Jon Paal" wrote:
SQL server is a real pain for webhost environments..
You will need to upload the mdf file and have your webhost attach it to the sql server.
Most won't do this.
In which case you will need to recreate the database into the database which is available to the hosted domain if you have signed up
for that service. Typically expensive, and a very clumsy process.
good luck.
"nick" <nick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:56D0A1C8-4C48-407F-8C02-98056DB425EE@xxxxxxxxxxxxxxxx
I have only SQL Server 2005 installed on my PC. And I tried to add the
following rows in web.config to use SQL Server 2005 instead of Express:
<connectionStrings>
<clear />
<add name="LocalSqlServer" connectionString="Data
Source=.\SQL2005;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;user
instance=true;Integrated Security=True;Initial Catalog=ASPNETDB;"
providerName="System.Data.SqlClient" />
</connectionStrings>
However, I still get error:
The user instance login flag is not supported on this version of SQL Server.
The connection will be closed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The user instance
login flag is not supported on this version of SQL Server. The connection
will be closed.
And double click the ASPNETDB.MDF on solution explorer will get error
message: Connections to SQL Server files (*.mdf) require SQL Server Express
2005 to function properly. Please verify the installation of the component
....
I need to deploy the application to my web host server and neither do they
have Sql Server express.
How to fix the problem.
TIA.
- Prev by Date: Re: Do you know a free .net Blog or even paid
- Next by Date: Force 'Full' PostBack in Atlas
- Previous by thread: Re: ASPNETDB.MDF when no SQLExpress, only SQL Server 2005?
- Next by thread: Re: ASPNETDB.MDF when no SQLExpress, only SQL Server 2005?
- Index(es):
Relevant Pages
|
