I have been following directions from books and docs - I have unzipped the files, created the virtual directory, set the web.config connection string and setup the sql server. When I try to browse I get some type of SQL error.
Am using sql2000 - here is the connection string part of web.config (note: I have checked and rechecked the spelling and such, I have also created a system DSN that seems to work).
-------------------------------------------------------------------
<!-- Connection String for SQL Server 2000/2005 -->
<add
name="SiteSqlServer"
connectionString="Server=(ntsql);Database=DNNntWWW;uid=DNNntWWWuser;pwd=MyPwd!;"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Server=(ntsql);Database=DNNntWWW;uid=DNNntWWWuser;pwd=MyPwd!;"/>
-------------------------------------------------------------------------------------------
The really long error page I get when I try to browse is (the error goes on and on):
Error Installing DotNetNuke
Current Assembly Version: 04.00.02
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
If anyone has any thought, I would greatly appreciate it.
thanks
BJ Daniels
Director of Technology
The Gunnery School