I recently setup in XP PRO.
I have SQL Server 2005 Express Running. I downloaded a video from dotnetnuke as a guide, but I"ll try to summarize steps. I need some hlep if you don't mind afterwards. My site is working but working through an SQL File database in the App-Data directory and not through a SQL connection. I can't get the SQL 2005 connection to go. I can use it all day through an access ODBC but by default for SOME REASON it does a file based SQL databse thing.
1. Make a folder where you want to put dot net nuke
2. Extract all files to that folder
3.Go into security of that folder and apply to all file ASPNET has modify, RW to that folder
4. Now go into IIS under default website, create a virtual directory to that location. defaults shoudl be fine
5. in properites of the virtual directory after creating goto documents and add document default.aspx to the top of the list. ALso, check ASP.net tab make sure see it is enabled or aka version selectd.
6. Now I went through steps to make a databse in SQL 2005 but it doesn't use, so i'm going to not list those steps becuase you truly do not need them by the way it does this default database CRAP under app-data
7. Goto http://localhost/virtualdirectoryname
8. It will begin to build the install and hopefully if all goes right you will have an active DNN site when complete
9. browse to same location once install loads and you will get the basic pages
10. two logins to note to get in
admin, dnnadmin is admin lgoin
host, dnnhost is the host login
admin is at the portal level
host is at the server level
I hope this helps.
NOW TO MY PROBLEM PLEASE ADVISE
Created DB in sql 2005 created login for dnn gave the db db_owner and enabled tcp/ip and all protocols and added ip addresses to settings of those protocols
((((( NOTE the release.config contains more stuff and looks like by default it does a SQL 2005 Express database under apps-data in the DNN directory. I don't understand this, and kept trying to comment out but blew up so finally just delted it for just the 2000/2005 sql section which is posted below.
modified web.config to look as follows
<connectionStrings>
<add
name="SiteSqlServer"
connectionString="Server=SCOTT;Database=MRO;uid=MRO;pwd=XXXXXX;"
providerName="System.Data.SqlClient" />
</connectionStrings>
I can connect through OBDC without problems inside of access but not run the isntall.
This is a completely blank DB with nothing in it. I have verified pass and user and server name etc. and when I run I get this error.
Error Installing DotNetNuke
Current Assembly Version: 04.03.03
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
I have made an odbc conneciton with the same information, am I missing something. I dont' want to use the file database I want to use a connection into SQL so i can manage etc, and migrate effortlessly to the live launch servers.
CAN SOMEONE PELASE HELP ME, the file based app-data is working fine.
THanks,
Scott Owens