I'm having some trouble setting up the the Personal Site Starter Kit on my Windows 2K3 test server with SQL 2000. Is there a 'best practices' type of document that might use as a checklist?
Here's what I've done so far:
1. Created the site on my test server remotely via VS 2005 loaded on my XP laptop.
2. Created the SQL databases 'personal' and 'aspnetdb'.
3. Used Query Analyser and populated the 'personal' database using the script from MS and populated the 'aspnetdb' one using the script published here by jgilbert.
4. Created a local user on the test server and gave this user public & db_owner rights to each database.
5. Ran aspnet_regsql.
6. Edited the web.config like this:
I'm alternately getting two errors when I attempt to view the site:
1. Login failed for user '*username*'.
2. Object reference not set to an instance of an object.
After a few attempts, it settles on the second error. I've added "<compilation
debug="true"/>" to the web.config file
without effecting a different result.
I'm feeling the limits of my knowledge. Can someone point me in the right direction here?
JohnnyNoir
Member
105 Points
21 Posts
A little knowlege can be dangerous...
May 25, 2005 03:59 PM|LINK
Here's what I've done so far:
1. Created the site on my test server remotely via VS 2005 loaded on my XP laptop.
2. Created the SQL databases 'personal' and 'aspnetdb'.
3. Used Query Analyser and populated the 'personal' database using the script from MS and populated the 'aspnetdb' one using the script published here by jgilbert.
4. Created a local user on the test server and gave this user public & db_owner rights to each database.
5. Ran aspnet_regsql.
6. Edited the web.config like this:
<
connectionStrings><clear /><add name="LocalSqlServer" connectionString="data source=*sql-server-name*;Initial Catalog=aspnetdb;user id=*machinename\username*;pwd=*password* " providerName="System.Data.SqlClient" />
<add name="*personal database name*" connectionString="data source=*sql-server-name*;Initial Catalog=aspnetdb;user id=*machinename\username*;pwd=*password* " providerName="System.Data.SqlClient" />
</connectionStrings>
I'm alternately getting two errors when I attempt to view the site:
1. Login failed for user '*username*'.
2. Object reference not set to an instance of an object.
After a few attempts, it settles on the second error. I've added "<compilation debug="true"/>" to the web.config file without effecting a different result.
I'm feeling the limits of my knowledge. Can someone point me in the right direction here?
JohnnyNoir
Member
105 Points
21 Posts
Re: A little knowlege can be dangerous...
May 25, 2005 04:01 PM|LINK