HELP!
I want to use SQL Server 2005, not the Express edition. How do I do
this? After lots of Googling, help files and reading, I think I figured
out that I need to change the root web config file. I think I need to
modify these lines:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data
source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User
Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>
I found a reference to adding this:
<add name="Personal" connectionString="Data
Source=.\MSSQLSERVER;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDire
ctory|Events.mdf"
providerName="System.Data.SqlClient"/>
But it also says to remove the SQLExpress with this line:
<remove name="LocalSqlServer"/>
Can I have access to both, or do I have to remove the Express? What if
I want some websites, but not all, to use Express? And am I correct in
what I think I need to do? The file is intimidating and I'm afraid to
touch it!
This brings up another question. I can only have 5 databases on SQL
Server (hosting restriction). One is for my primary website, and the
second is for all my other, smaller websites. That leaves three, and I
have more than 5 websites. Do I need one database per website to
implement membership and login controls? Or can I have a differently
named table per website? What about one table in the database and
different records in it? How do I handle membership, roles, and logins
on a number of websites?
Thanks,
Diane
Cheryl D Wise wrote:
Personally I prefer Visual Web Developer Express (free) for ASP.NET 2.0 but
which version you need depends on the type of coding you intend to do. The
controls I work with are all pretty much asp.net 2.0 not IDE specific.
Cheryl D Wise
MS MVP FrontPage
http://by-expression.com
Online instructor led training http://starttoweb.com
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
