468,101 Members | 1,531 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,101 developers. It's quick & easy.

For permissions and roles, how to use sql server 2005 standard edition instead of express?

I developed a web site that uses sql server express for permissions and
roles. Now I need to deploy it on a server that uses sql server 2005
standard edition instead of sql server express. What do I need to change so
that permissions and roles for my website use sql server 2005 standard
edition instead of sql server express?

Thanks,

Keith
May 29 '06 #1
1 1213
You have to remove the default configuration in your web.config and then add
it back with the actual, new connection string:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer"
connectionString="server=localhost;database=XYZ;ui d=whosit;pwd=whatsit"
providerName="System.Data.SqlClient" />
</connectionStrings>
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"keithb" wrote:
I developed a web site that uses sql server express for permissions and
roles. Now I need to deploy it on a server that uses sql server 2005
standard edition instead of sql server express. What do I need to change so
that permissions and roles for my website use sql server 2005 standard
edition instead of sql server express?

Thanks,

Keith

May 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by NetIdiot | last post: by
14 posts views Thread by Developer | last post: by
2 posts views Thread by kress1963nov22 | last post: by
14 posts views Thread by Guillermo_Lopez | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.