I got an error when I added the Repository Module:
"A critical error has occurred.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I'm not getting any other db conneciton errors. I've got a user (DotNetNuke) set up on the db as db_owner. Here's my connection string in web.config:
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" /> -->
<!--Connection String for SQL Server 2000/2005 -->
<add name="SiteSqlServer" connectionString="Server=s31csql03;;Database=DotNetNuke;uid=DotNetNuke;pwd=DotNetNuke;" providerName="System.Data.SqlClient" />
</connectionStrings>
(Notice the string for SQL Server 2005 Express is commented out. I'm using SQL Server 2005.)
Here are the particulars:
DotNetNuke version 04.09.00
Repository version 03.01.15
DotNetNuke is set up on a separate web server from my SQL Server. Both are in the same intranet domain.
Web server (s31cweb01):
Windows 2000
IIS 5.0
.NET Framework 2.0
SQL Server (s31csql03):
Windows 2003
Remote connections have been enabled for TCP/IP using the Surface Area Configuration Tool and SQL Server Browser has also been enabled.
.NET Framework 2.0
I've searched the module's forum and the general forums for any solution besides "enable remote connections" and haven't found an answer. Hope someone can help.
Larry