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

  • Thread starter Thread starter keithb
  • Start date Start date
K

keithb

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
 
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;uid=whosit;pwd=whatsit"
providerName="System.Data.SqlClient" />
</connectionStrings>
 
Back
Top