Developing/Deploying a site that has personalized pages

[theBlindRef]

I'm going to be developing a new home page for my company's intranet.
This page will have web parts on it that can be customized by
registered users (employees). My development computer has SQL Server
2005 Express installed so my application uses that by default to handle
the personalization. However, the production server does not have and
won't have it. I do have access to a full version of SQL Server 2005.
So:

1. How can I configure my project to use a remote SQL Server 2005
instance to handle the persoanlization?


2. How do I deploy this project to the production server so that it
also will use the SQL Server 2005 instance?

Thanks in advance,
tBR

 

[Konstantinos Pantos]

In folder C:\Windows\Microsoft.NET\Framework\v2.0.50727 you'll find all the
SQL install scripts that you need to run on you SQL 2005 instance to create
the authorization and personalization database. Once you've done that you
need to change (if it;s already there) or add the SQL connection string :
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=Your data source"
/>
Note that you'll have to leave the "name" attributte intact as it's used by
the default ASP.NET 2.0 Membership provider to locate the connection string.

HTH
____________________
Konstantinos Pantos
MCP Software Engineer