How to excute sql scripts which are in sqlscripts folder in sql server 2005

rated by 0 users
This post has 3 Replies | 2 Followers

Not Ranked
Posts 16
Points 310
renxunsaky Crying [:'(] Posted: Wed, Aug 2 2006 4:42 AM
hello, when I try to open the default.aspx file. An error occured which is provided bellow. It seems that I need to excute the sql scripts in the sqlscripts folder. And my cs is web version and my sql server is microsoft sql server 2005. What I want to kniow is after I excuted the scripts, where are the data stored,and how can I save them. I don't know how the web version cs connect to the database. The error says: 

Procedure or Function 'aspnet_Profile_GetProperties' expects parameter '@TimeZoneAdjustment', which was not supplied. 

Top 10 Contributor
Male
Posts 2,364
Points 15,695
MVPs
Dave replied on Wed, Aug 2 2006 7:52 AM

You need to run the ASP.NET 2.0 schema upgrade script (cs_ASPNET2_Membership_Schema_Update.sql)

Why have you added all those tags to your post?

  • | Post Points: 20
Not Ranked
Posts 16
Points 310
Thanks for your answer. Yes, I have found the sql scripts. But I am not a database expert, could you tell me how to save the result after I excute the scripts. Because I am using sql server 2005. And I tried to excute them. But I don't know how to save the results to my database. Do I need to create a database named "communityServer"? And shall I modify something in the web.config file? Regards to the tags, that is because I have a project to achieve this in a limited days. I want more people to help me.Thank you very much! best regards!
Top 500 Contributor
Posts 88
Points 1,695

Hello.

The database setup process is described here :

http://docs.communityserver.org/Installation/Manual_Installation_Process.htm

 

Regards, CommunityServer guy Available for hire for small jobs!!!!!
  • | Post Points: 5
Page 1 of 1 (4 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com