Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.4.1 installstion problems - Could not connect to database4.4.1 installstion problems - Could not connect to database
Previous
 
Next
New Post
3/31/2007 9:53 AM
 

Hello (and help please?),

Same issue. Win 2003 Server, Standard Ed. with MS SQL 2005 Workgroup Ed.

"ERROR: Could not connect to database specified in connectionString for SqlDataProvider".

I created a new db "DotNetNuke", after my alternate name did not work.

From the MS SQL Connection Properties I tried several variations of the ConnectionStrings / appSettings :

  1. (local) with empty uid and pwd
  2. (local) with actual uid and pwd
  3. ( [actual server name here] ) with empty uid and pwd
  4. ( [actual server name here] ) with actual uid and pwd

Commented out Express elements and uncommented the SQL Server 2000/2005 connection strings.

One example of many sting/app attempts (this one with "local" used - strings are all on a single line):

   <connectionStrings>
    <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=********;pwd=-********;" providerName="System.Data.SqlClient" />
  </connectionStrings>
  <appSettings>
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=********;pwd=-********;"/>
  </appSettings>

Every iteration change returns the above failure to connect. I stop and start services and try again.

Any help would be greatly appreciated.

 
New Post
3/31/2007 10:35 AM
 

There are some check points you have to do. First of all, is to check if you will use Windows Authentication ou SQL Server Authentication. BY DEFAULT in 2005 Sql Server, SQL Auth is disabled.

Check that out first. And read my post at http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/107/threadid/119569/scope/posts/Default.aspx

that has some info on that.

Don't forget that the new database has to be DB_OWNER on the user. Check that out too.

Good luck.

 
New Post
4/1/2007 6:06 PM
 

I changed the servername value in config file from (local) into 127.0.0.1 and teh error fixed but I faced new Error.The Error log is:

 

Installing DotNetNuke
Version: 04.04.01

 Installation Status Report
00:00:00.140 - Installing Version: 4.4.0
00:00:00.203 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.421 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeD:\Nuke\WebSite\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:09.656 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeD:\Nuke\WebSite\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:16.453 - Installing MemberRole Provider:
00:00:16.468 -   Installing Script: InstallCommon.sql
00:00:17.031 -   Installing Script: InstallMembership.sql
00:00:17.546 -   Installing Script: InstallProfile.sql
00:00:17.687 -   Installing Script: InstallRoles.sql
00:00:18.015 - Upgrading to Version: 4.4.1 Success
00:00:18.171 - Performing General Upgrades

Server Error in '/Nuke' Application.
--------------------------------------------------------------------------------

Invalid object name 'vw_Tabs'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'vw_Tabs'.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

  <%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
   <system.web>
       <compilation debug="true"/>
   </system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.


The DotNetNuke.Data.log is empty but DotNetNuke.schema.log content is:

System.Data.SqlClient.SqlException: Invalid object name 'ModulePermission'.
Invalid object name 'Permission'.
Invalid object name 'Roles'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_ModulePermissions]
AS
SELECT    
 MP.ModulePermissionID,
 MP.ModuleID,
 P.PermissionID,
 MP.RoleID,
    CASE MP.RoleID WHEN - 1 THEN 'All Users' WHEN - 2 THEN 'Superuser' WHEN - 3 THEN 'Unauthenticated Users' ELSE R.RoleName END AS 'RoleName',
    MP.AllowAccess,
    P.PermissionCode,
    P.ModuleDefID,
    P.PermissionKey,
    P.PermissionName
FROM ModulePermission AS MP
 LEFT OUTER JOIN Permission AS P ON MP.PermissionID = P.PermissionID
 LEFT OUTER JOIN Roles AS R ON MP.RoleID = R.RoleID

 

System.Data.SqlClient.SqlException: Invalid object name 'TabPermission'.
Invalid object name 'Tabs'.
Invalid object name 'Permission'.
Invalid object name 'Roles'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_TabPermissions]
AS
SELECT    
 TP.TabPermissionID,
 TP.TabID,
 P.PermissionID,
 TP.RoleID,
    CASE TP.RoleID WHEN - 1 THEN 'All Users' WHEN - 2 THEN 'Superuser' WHEN - 3 THEN 'Unauthenticated Users' ELSE R.RoleName END AS 'RoleName',
    TP.AllowAccess,
    P.PermissionCode,
    P.ModuleDefID,
    P.PermissionKey,
    P.PermissionName,
    T.PortalId
FROM TabPermission AS TP
 INNER JOIN Tabs AS T ON TP.TabID = T.TabID 
 LEFT OUTER JOIN Permission AS P ON TP.PermissionID = P.PermissionID
 LEFT OUTER JOIN Roles AS R ON TP.RoleID = R.RoleID

 

System.Data.SqlClient.SqlException: Invalid object name 'FolderPermission'.
Invalid object name 'Folders'.
Invalid object name 'Permission'.
Invalid object name 'Roles'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_FolderPermissions]
AS
SELECT    
 FP.FolderPermissionID,
 F.FolderID,
 F.FolderPath,
 P.PermissionID,
 FP.RoleID,
 CASE FP.RoleID WHEN - 1 THEN 'All Users' WHEN - 2 THEN 'Superuser' WHEN - 3 THEN 'Unauthenticated Users' ELSE R.RoleName END AS 'RoleName',
 FP.AllowAccess,
 P.PermissionCode,
 P.PermissionKey,
 P.PermissionName,
 F.PortalID
FROM FolderPermission AS FP
 LEFT OUTER JOIN Folders AS F ON FP.FolderID = F.FolderID
 LEFT OUTER JOIN Permission AS P ON FP.PermissionID = P.PermissionID
 LEFT OUTER JOIN Roles AS R ON FP.RoleID = R.RoleID

 


System.Data.SqlClient.SqlException: Invalid object name 'Files'.
Invalid object name 'Tabs'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_Tabs]
AS
SELECT    
 T.TabID,
 T.TabOrder,
 T.PortalID,
 T.TabName,
 T.IsVisible,
 T.ParentId,
 T.[Level],
 CASE WHEN LEFT(LOWER(T.IconFile), 6) = 'fileid'
  THEN
   (SELECT Folder + FileName 
    FROM Files
    WHERE 'fileid=' + convert(varchar,Files.FileID) = T.IconFile
   )
  ELSE
   T.IconFile 
  END
 AS IconFile,
 T.DisableLink,
 T.Title,
 T.Description,
 T.KeyWords,
 T.IsDeleted,
 T.SkinSrc,
    T.ContainerSrc,
    T.TabPath,
    T.StartDate,
    T.EndDate,
 T.URL,
    CASE WHEN EXISTS (SELECT 1 FROM Tabs T2 WHERE T2.ParentId = T .TabId) THEN 'true' ELSE 'false' END AS 'HasChildren',
    T.RefreshInterval,
    T.PageHeadText
FROM nuke.Tabs AS T

 


System.Data.SqlClient.SqlException: Invalid object name 'Users'.
Invalid object name 'UserPortals'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_Users]
AS
SELECT
 U.UserId,
    UP.PortalId,
    U.Username,
    U.FirstName,
    U.LastName,
    U.DisplayName,
 U.IsSuperUser,
 U.Email,
    U.AffiliateId,
    U.UpdatePassword,
    UP.Authorised
FROM Users U
 LEFT OUTER JOIN UserPortals UP On U.UserId = UP.UserId

 

System.Data.SqlClient.SqlException: Invalid object name 'Files'.
Invalid object name 'ModuleDefinitions'.
Invalid object name 'Modules'.
Invalid object name 'DesktopModules'.
Invalid object name 'ModuleControls'.
Invalid object name 'Tabs'.
Invalid object name 'TabModules'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_Modules]
AS
SELECT 
     M.PortalID,
     TM.TabId,
        TM.TabModuleId,
     M.ModuleID,
     M.ModuleDefID,
        TM.ModuleOrder,
        TM.PaneName,
        M.ModuleTitle,
        TM.CacheTime,
        TM.Alignment,
        TM.Color,
        TM.Border,
  CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid'
   THEN
    (SELECT Folder + FileName 
     FROM Files
     WHERE 'fileid=' + convert(varchar,Files.FileID) = TM.IconFile
    )
   ELSE
    TM.IconFile 
   END
  AS IconFile,
       M.AllTabs,
       TM.Visibility,
       M.IsDeleted,
       M.Header,
       M.Footer,
       M.StartDate,
       M.EndDate,
       TM.ContainerSrc,
       TM.DisplayTitle,
       TM.DisplayPrint,
       TM.DisplaySyndicate,
       M.InheritViewPermissions,
       DM.*,
       MC.ModuleControlId,
       MC.ControlSrc,
       MC.ControlType,
       MC.ControlTitle,
       MC.HelpURL
FROM   ModuleDefinitions AS MD
 INNER JOIN Modules AS M ON MD.ModuleDefID = M.ModuleDefID
 INNER JOIN DesktopModules AS DM ON MD.DesktopModuleID = DM.DesktopModuleID
 INNER JOIN ModuleControls AS MC ON MD.ModuleDefID = MC.ModuleDefID
 LEFT OUTER JOIN Tabs AS T
  INNER JOIN TabModules AS TM ON T.TabID = TM.TabID
 ON M.ModuleID = TM.ModuleID
WHERE     (MC.ControlKey IS NULL)

 

System.Data.SqlClient.SqlException: Invalid object name 'Files'.
Invalid object name 'Files'.
Invalid object name 'Tabs'.
Invalid object name 'Roles'.
Invalid object name 'Roles'.
Invalid object name 'Portals'.
Invalid object name 'Users'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


CREATE VIEW nuke.[vw_Portals]
AS
SELECT    
 PortalID,
 PortalName,
 CASE WHEN LEFT(LOWER(LogoFile), 6) = 'fileid'
  THEN
   (SELECT Folder + FileName 
    FROM Files
    WHERE 'fileid=' + convert(varchar,Files.FileID) = LogoFile
   )
  ELSE
   LogoFile 
  END
 AS LogoFile,
 FooterText,
 ExpiryDate,
 UserRegistration,
 BannerAdvertising,
 AdministratorId,
 Currency,
 HostFee,
 HostSpace,
 PageQuota,
 UserQuota,
 AdministratorRoleId,
 RegisteredRoleId,
 Description,
 KeyWords,
 CASE WHEN LEFT(LOWER(BackgroundFile), 6) = 'fileid'
  THEN
   (SELECT Folder + FileName 
    FROM Files
    WHERE 'fileid=' + convert(varchar,Files.FileID) = BackgroundFile
   )
  ELSE
   BackgroundFile 
  END
 AS BackgroundFile,
    GUID,
    PaymentProcessor,
    ProcessorUserId,
    ProcessorPassword,
    SiteLogHistory,
    Email,
    DefaultLanguage,
    TimezoneOffset,
    AdminTabId,
    HomeDirectory,
    SplashTabId,
    HomeTabId,
 LoginTabId,
 UserTabId,
    (SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
 (SELECT RoleName FROM Roles WHERE (RoleID = P.AdministratorRoleId)) AS AdministratorRoleName,
 (SELECT RoleName FROM Roles WHERE (RoleID = P.RegisteredRoleId)) AS RegisteredRoleName
FROM Portals AS P
LEFT OUTER JOIN Users AS U ON P.AdministratorId = U.UserID

 


 

 
New Post
4/1/2007 10:25 PM
 

It appears that the problems may all stem from using a {databaseOwner} other than the default "dbo." schema.  If you look at the tables that have been created, do you see (for example) one named nuke.ModulePermissions rather than dbo.ModulePermissions or simply ModulePermissions?  If you really intend to use a non-dbo schema, you will find a good video tutuorial by Joe Brickman on how to set up you database for development testing purposes with a non-dbo schema. This would also apply to any non-dbo setup.

Brinkman's blog and tutorial link: http://www.dotnetnuke.com/Community/BlogsDotNetNuke/tabid/825/EntryID/1198/Default.aspx

I'm particularly wondering if in an earlier installation attempt, many of the the core tables might have been created with the default dbo schema, then prior to your last attempt, you had changed the databaseOwner= string in your web.config from "dbo" to "nuke".

Unless you need to use a non-dbo schema and/or non-standard objectQualifer string I would suggest resetting these to the default "dbo" and "" respectively in web.config, deleting entirely then recreating the database, and trying a fresh install. If you do need to use a non-dbo schema then follow Joe's tutorial carefully.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
4/2/2007 4:55 PM
 

I reset  uid and pwd to the default "dbo" and "" , also recreate the DB and install fresh version but the same error generated again.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.4.1 installstion problems - Could not connect to database4.4.1 installstion problems - Could not connect to database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out