I've been reading forums for hours now and tried everything I can think of.

I'm getting:
Error Installing DotNetNuke
Current Assembly Version: 04.04.01
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

I've checked and rechecked my connection string, reinstalled IIS and SQL server 2005, deleted and recreated my users trying for both SQL and windows authentication. Tried leaving my database owner as "dbo" and setting it to my username. I've deleted my project files and re-unzipped them multiple times.
I followed installation instructions in the Professional DNN4 book and on a couple websites for installation on a local machine.

I'm not an expert with IIS or SQL, but I have been working with both on a limited basis for some years. I have dnn4 installed sucessfully on another (remote) server, but am trying to set up the source to run off my local machine in visual studio.

I'm outa ideas and any thoughts would be appreciated.

Hi,

I am having similar problem installing dnn 4.4.1. Here is the error msg:

-------------------------------------------

ERROR: Could not connect to database.

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist

--------------------------------------------

I did my research, looks like that I am not the only one, but I just could not find the right answer.

I am running SQL 2005 and window 2003. SQL server is on separate machine.

Here is my connection string:

-------------------------------

<add
      name="SiteSqlServer"
      connectionString="Server=SQLSERVER01;Database=DNN;Integrated Security=SSPI;"
      providerName="System.Data.SqlClient" />

---------------------------------

Please help! (my email address: pzhang@pcsigroup.com)