Re: membership, SQLExpress and/or SQLServer
- From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Sep 2006 19:08:35 -0500
Most likely, you have to alter the connection strings to match the server's
SQL location. It will be in the <connectionString> section.
You might also have different accounts or different security settings in
IIS. It is easier to set up SQL Server with sql connection strings (not
windows auth strings) on a server box. It is not necessarily the BEST way to
go, but you are more likely to have a login success locally with windows
authentication.
You can attach a SQL Express database in SQL Server proper. They are
identical.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************************************************
Think Outside the Box!
*************************************************
"dgk" <dgk@xxxxxxxxxxxxx> wrote in message
news:hm5jg29e4ulsnfg98ue4siht8pklmlvn99@xxxxxxxxxx
I'm using the standard provider for membership which is SQLServer
Express. After deploying the app to our server, login fails because of
an SQL problem. I'm guessing that the problem is that the server has
SQLServer 2005 but not express.
I can install Express, but I'm wondering if it wouldn't be better to
change the provider to use SQLServer? This is our intranet and the
number of users will never be over 15 simultaneous users so
scaling/performance isn't an issue.
I think it's easier to maintain using Express since I can just copy
the datafile between production and development as needed. Any reasons
to do one over the other? I don't actually know how to change the
provider but it looks like all I need to do is copy the provider
sections from machine.config into the web.config and create connection
strings as needed. Plus run aspnet_regsql!
.
- Follow-Ups:
- References:
- membership, SQLExpress and/or SQLServer
- From: dgk
- membership, SQLExpress and/or SQLServer
- Prev by Date: Re: __VIEWSTATE different between localhost and server
- Next by Date: Re: WebParts without SharePoint
- Previous by thread: membership, SQLExpress and/or SQLServer
- Next by thread: Re: membership, SQLExpress and/or SQLServer
- Index(es):
Relevant Pages
|
