|
Joined: 8/6/2007
Posts: 201
|
|
|
I am also haveing this error with the same site, please see, http://www.dotnetnuke.com/Community/F....
This is a full shot of the error, do you think that the two are related?
| Install Extension |
|
|
|
Package Installation Report
See below for the results of the package installation |
| Error loading files from temporary folder - see below |
| StartJob |
Starting Installation |
| Info |
Starting Installation - DNN_Events |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - Installation\05.01.00.SqlDataProvider |
| Info |
Created - Installation\05.01.00.SqlDataProvider |
| Info |
Executing 05.01.00.SqlDataProvider |
| Info |
Start Sql execution: 05.01.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** *****/ /***** SqlDataProvider *****/ /***** Install/Upgrade for Events module 05.01.00 *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search AND replace operation *****/ /***** for dbo. AND *****/ /***** or use 'SQL' FROM Host Menu AND run this. *****/ /***** *****/ /************************************************************/ /************************************************************/ /************************************************************/ /***** *****/ /***** Delete EventDetailsTemplates2 where *****/ /***** EventDetailsTemplate length < 2000 *****/ /***** *****/ /************************************************************/ /************************************************************/ DELETE FROM dbo.ModuleSettings WHERE SettingName = 'EventDetailsTemplate2' AND ModuleID in (SELECT ModuleID FROM dbo.ModuleSettings WHERE SettingName = 'EventDetailsTemplate' and LEN(SettingValue) < 2000) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /************************************************************/ /***** *****/ /***** Update for [IFTIMEZONEDISPLAY] token *****/ /***** *****/ /************************************************************/ /************************************************************/ /* Add tokens around [event:timezone] */ UPDATE dbo.ModuleSettings SET SettingValue = REPLACE(SettingValue,' ([event:timezone])',' [IFTIMEZONEDISPLAY]([event:timezone])[/IFTIMEZONEDISPLAY]') WHERE SettingName <> 'EventDetailsTemplate' and SettingValue like '%event:timezone%' and SettingValue not like '%IFTIMEZONEDISPLAY%' UPDATE dbo.ModuleSettings SET SettingValue = REPLACE(SettingValue,' [event:timezone]',' [IFTIMEZONEDISPLAY][event:timezone][/IFTIMEZONEDISPLAY]') WHERE SettingName <> 'EventDetailsTemplate' and SettingValue like '%event:timezone%' and SettingValue not like '%IFTIMEZONEDISPLAY%' UPDATE dbo.ModuleSettings SET SettingValue = REPLACE(SettingValue,'>[event:timezone]<','>[IFTIMEZONEDISPLAY][event:timezone][/IFTIMEZONEDISPLAY]<') WHERE SettingName <> 'EventDetailsTemplate' and SettingValue like '%event:timezone%' and SettingValue not like '%IFTIMEZONEDISPLAY%' UPDATE dbo.ModuleSettings SET SettingValue = REPLACE(SettingValue,'>[event:timezone]<','>[IFTIMEZONEDISPLAY][event:timezone][/IFTIMEZONEDISPLAY]<') WHERE SettingName <> 'EventDetailsTemplate' and SettingValue like '%event:timezone%' and SettingValue not like '%IFTIMEZONEDISPLAY%' System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE Table #EventDetailsTemplate (ModuleID Int, SettingValue nvarchar(4000)) INSERT INTO #EventDetailsTemplate (ModuleID, SettingValue) SELECT ModuleID, SettingValue FROM dbo.ModuleSettings WHERE SettingName = 'EventDetailsTemplate' UPDATE #EventDetailsTemplate SET SettingValue = SettingValue + (Select SettingValue FROM dbo.ModuleSettings WHERE SettingName = 'EventDetailsTemplate2' and dbo.ModuleSettings.ModuleID = #EventDetailsTemplate.ModuleID) WHERE ModuleID in (Select ModuleID FROM dbo.ModuleSettings WHERE SettingName = 'EventDetailsTemplate2') UPDATE #EventDetailsTemplate SET SettingValue = REPLACE(SettingValue,'>[event:timezone]<','>[IFTIMEZONEDISPLAY][event:timezone][/IFTIMEZONEDISPLAY]<') WHERE SettingValue like '%event:timezone%' and SettingValue not like '%IFTIMEZONEDISPLAY%' UPDATE #EventDetailsTemplate SET SettingValue = REPLACE(SettingValue,'>[event:timezone]<','>[IFTIMEZONEDISPLAY][event:timezone][/IFTIMEZONEDISPLAY]<') WHERE SettingValue like '%event:timezone%' and SettingValue not like '%IFTIMEZONEDISPLAY%' Update dbo.ModuleSettings Set SettingValue = (Select SUBSTRING(SettingValue,1, 2000) from #EventDetailsTemplate where #EventDetailsTemplate.ModuleID = dbo.ModuleSettings.ModuleID) where SettingName = 'EventDetailsTemplate' Update dbo.ModuleSettings Set SettingValue = (Select SUBSTRING(SettingValue,2001, LEN(SettingValue)-2000) from #EventDetailsTemplate where #EventDetailsTemplate.ModuleID = dbo.ModuleSettings.ModuleID) where SettingName = 'EventDetailsTemplate2' Drop table #eventDetailsTemplate System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /************************************************************/ /***** *****/ /***** Add new fields to EventsNotification table *****/ /***** *****/ /************************************************************/ /************************************************************/ /* Add TabID to EventsNotification Table */ if not exists (select * from information_schema.columns where table_name = 'EventsNotification' and column_name = 'TabID') BEGIN ALTER TABLE dbo.EventsNotification WITH NOCHECK ADD TabID INT NOT NULL DEFAULT 1 END System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.EventsNotification SET TabID = (Select top 1 TabID from dbo.TabModules where ModuleID = dbo.EventsNotification.ModuleID) WHERE TabID = 1 /************************************************************/ /************************************************************/ /***** *****/ /***** Add new fields to EventsSignups table *****/ /***** *****/ /************************************************************/ /************************************************************/ /* Add NoEnrolees to EventsSignups Table */ if not exists (select * from information_schema.columns where table_name = 'EventsSignups' and column_name = 'NoEnrolees') BEGIN ALTER TABLE dbo.EventsSignups WITH NOCHECK ADD NoEnrolees INT NULL DEFAULT 1 END System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /************************************************************/ /***** *****/ /***** Retain moderators as category/location editors *****/ /***** *****/ /************************************************************/ /************************************************************/ -- Ensure Moderators have edit category permissions INSERT INTO dbo.[ModulePermission] ( RoleID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.RoleID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.RoleID is not null AND (MP1.RoleID NOT IN (SELECT MP2.RoleID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSCAT') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.RoleID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSCAT') INSERT INTO dbo.[ModulePermission] ( UserID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.UserID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.UserID is not null AND (MP1.UserID NOT IN (SELECT MP2.UserID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSCAT') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.UserID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSCAT') System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- Ensure Moderators have edit location permissions INSERT INTO dbo.[ModulePermission] ( RoleID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.RoleID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.RoleID is not null AND (MP1.RoleID NOT IN (SELECT MP2.RoleID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSLOC') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.RoleID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSLOC') INSERT INTO dbo.[ModulePermission] ( UserID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.UserID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.UserID is not null AND (MP1.UserID NOT IN (SELECT MP2.UserID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSLOC') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.UserID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSLOC') System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /************************************************************/ /***** *****/ /***** Create Stored Procedures *****/ /***** *****/ /************************************************************/ /************************************************************/ if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsSignupsGetEventRecurMaster]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsSignupsGetEventRecurMaster] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsSignupsGetUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsSignupsGetUser] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsSignupsGetEvent]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsSignupsGetEvent] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsSignupsGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsSignupsGet] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsSignupsMyEnrollments]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.EventsSignupsMyEnrollments System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsSignupsSave]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsSignupsSave] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsRecurMasterGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsRecurMasterGet] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsGet] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsGetByRange]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsGetByRange] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[SplitIDs]') and xtype in (N'FN', N'IF', N'TF')) drop function dbo.[SplitIDs] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsCleanupExpired]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsCleanupExpired] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsNotificationSave]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsNotificationSave] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsNotificationGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsNotificationGet] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[EventsNotificationsToSend]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.[EventsNotificationsToSend] System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsSignupsGetEventRecurMaster ***/ CREATE PROCEDURE dbo.EventsSignupsGetEventRecurMaster ( @RecurMasterID int, @ModuleID int ) AS SET DATEFORMAT mdy Select Distinct s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as UserName, u.Email, c.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, c.TimeZoneOffset, NoEnrolees FROM dbo.EventsRecurMaster AS r INNER JOIN dbo.Events AS c ON r.RecurMasterID = c.RecurMasterID RIGHT OUTER JOIN dbo.EventsSignups AS s LEFT OUTER JOIN dbo.Users AS u ON s.UserID = u.UserID ON c.EventID = s.EventID LEFT OUTER JOIN dbo.EventsMaster AS m ON s.ModuleID = m.SubEventID Where r.RecurMasterID = @RecurMasterID And (s.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) ORDER BY c.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsSignupsGetUser ***/ CREATE PROCEDURE dbo.EventsSignupsGetUser ( @EventID int, @UserID int, @ModuleID int ) AS SET DATEFORMAT mdy Select Distinct s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, -- u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as USerName, u.Email, c.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, c.TimeZoneOffset, NoEnrolees from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Left Outer Join dbo.EventsMaster m ON s.ModuleID = m.SubEventID Where s.EventID = @EventID And s.Userid = @UserID And (s.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsSignupsGet ***/ CREATE PROCEDURE dbo.EventsSignupsGet ( @SignupID int, @ModuleID int, @PPIPN bit ) AS SET DATEFORMAT mdy Select Distinct s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, --u.FirstName + ' ' + u.LastName as UserName,# u.DisplayName as UserName, u.Email, c.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, c.TimeZoneOffset, NoEnrolees from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Left Outer Join dbo.EventsMaster m ON s.ModuleID = m.SubEventID Where s.SignupID = @SignupID And (s.ModuleID = @ModuleID Or m.ModuleID = @ModuleID Or @PPIPN <> 0) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsSignupsGetEvent ***/ CREATE PROCEDURE dbo.EventsSignupsGetEvent ( @EventID int, @ModuleID int ) AS SET DATEFORMAT mdy Select Distinct s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as UserName, u.Email, c.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, c.TimeZoneOffset, NoEnrolees from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Left Outer Join dbo.EventsMaster m ON s.ModuleID = m.SubEventID Where s.EventID = @EventID And (s.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) ORDER BY c.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsSignupsSave ***/ CREATE PROCEDURE dbo.[EventsSignupsSave] ( @EventID int, @SignupID int, @ModuleID int, @UserID int, @Approved int, @PayPalStatus nvarchar(50), @PayPalReason nvarchar(100), @PayPalTransID nvarchar(50), @PayPalPayerID nvarchar(50), @PayPalPayerStatus nvarchar(50), @PayPalRecieverEmail nvarchar(100), @PayPalUserEmail nvarchar(100), @PayPalPayerEmail nvarchar(100), @PayPalFirstName nvarchar(50), @PayPalLastName nvarchar(50), @PayPalAddress nvarchar(100), @PayPalCity nvarchar(25), @PayPalState nvarchar(25), @PayPalZip nvarchar(25), @PayPalCountry nvarchar(25), @PayPalCurrency nvarchar(25), @PayPalPaymentDate datetime , @PayPalAmount money, @PayPalFee money, @NoEnrolees int ) AS SET DATEFORMAT mdy IF @SignupID = 0 OR @SignupID IS NULL INSERT dbo.[EventsSignups] ( EventID, ModuleID, UserID, Approved, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, NoEnrolees ) VALUES ( @EventID, @ModuleID, @UserID, @Approved, @PayPalStatus, @PayPalReason, @PayPalTransID, @PayPalPayerID, @PayPalPayerStatus, @PayPalRecieverEmail, @PayPalUserEmail, @PayPalPayerEmail, @PayPalFirstName, @PayPalLastName, @PayPalAddress, @PayPalCity, @PayPalState, @PayPalZip, @PayPalCountry, @PayPalCurrency, @PayPalPaymentDate, @PayPalAmount, @PayPalFee, @NoEnrolees ) ELSE UPDATE dbo.[EventsSignups] SET EventID = @EventID, UserID = @UserID, Approved = @Approved, PayPalStatus = @PayPalStatus, PayPalReason = @PayPalReason, PayPalTransID = @PayPalTransID, PayPalPayerID = @PayPalPayerID, PayPalPayerStatus = @PayPalPayerStatus, PayPalRecieverEmail = @PayPalRecieverEmail, PayPalUserEmail = @PayPalUserEmail, PayPalPayerEmail = @PayPalPayerEmail, PayPalFirstName = @PayPalFirstName, PayPalLastName = @PayPalLastName, PayPalAddress = @PayPalAddress, PayPalCity = @PayPalCity, PayPalState = @PayPalState, PayPalZip = @PayPalZip, PayPalCountry = @PayPalCountry, PayPalCurrency = @PayPalCurrency, PayPalPaymentDate = @PayPalPaymentDate, PayPalAmount = @PayPalAmount, PayPalFee = @PayPalFee, NoEnrolees = @NoEnrolees WHERE SignupID = @SignupID and ModuleID = @ModuleID Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, u.DisplayName as UserName, u.Email, c.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.[EventsSignups] WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, c.TimeZoneOffset, NoEnrolees from dbo.[EventsSignups] s Left Join dbo.[Users] u ON s.UserID = u.UserID Left Join dbo.[Events] c ON s.EventID = c.EventID Where s.SignupID = scope_identity() ORDER BY c.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** EventsSignupsMyEnrollments **/ CREATE PROCEDURE dbo.EventsSignupsMyEnrollments ( @ModuleID int, @UserID int ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, u.displayName as UserName, u.Email, c.EventTimeBegin, DATEADD(mi, c.Duration, c.EventTimeBegin) as EventTimeEnd ,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, c.TimeZoneOffset, NoEnrolees from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Left Outer Join dbo.EventsMaster e ON s.ModuleID = e.SubEventID Where s.Userid = @UserID AND (s.ModuleID = @ModuleID Or e.ModuleID = @ModuleID) ORDER BY c.EventTimeBegin desc System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /**** EventsGet ****/ CREATE PROCEDURE dbo.[EventsGet] ( @EventID int, @ModuleID int ) AS SET DATEFORMAT mdy CREATE Table #RealModuleID (EventID Int, ModuleID Int) Insert into #RealModuleID (EventID, ModuleID) Select distinct e.EventID, e.ModuleID From dbo.[Events] e left outer join dbo.[EventsMaster] m ON e.ModuleID = m.SubEventID WHERE EventID = @EventID And (e.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, E.Importance, E.CreatedDate, CreatedBy = u.DisplayName, E.CreatedByID, E.Every, E.Period, E.RepeatType, E.Notify, E.Approved, E.Signups, E.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.[EventsSignups] WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, (Select count(*) from dbo.[Events] as E2 WHERE E2.RecurMasterID = E.RecurMasterID and E2.Cancelled = 0 and E2.Approved = 1) as NoOfRecurrences, (Select max(EventDateBegin) from dbo.[Events] as E2 WHERE E2.RecurMasterID = E.RecurMasterID and E2.Cancelled = 0 and E2.Approved = 1) as LastRecurrence, E.EnrollRoleID, E.EnrollFee, E.EnrollType, E.PayPalAccount, E.Cancelled, E.DetailPage, E.DetailNewWin, E.DetailURL, E.ImageURL, E.ImageType, E.ImageWidth, E.ImageHeight, E.ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, E.Reminder, E.TimezoneOffset, E.SendReminder, E.ReminderTime, E.ReminderTimeMeasurement, E.ReminderFrom, E.SearchSubmitted, E.CustomField1, E.CustomField2, E.EnrollListView, E.DisplayEndDate, E.AllDayEvent, E.OwnerID, OwnerName = O.DisplayName, E.LastUpdatedAt, LastUpdatedBy = L.DisplayName, E.LastUpdatedID, r.RRULE, RMOwnerID = r.OwnerID, E.OriginalDateBegin, E.NewEventEmailSent FROM dbo.[Events] E inner join dbo.[EventsRecurMaster] AS r on E.RecurMasterID = r.RecurMasterID left outer join dbo.[Users] U on E.CreatedByID = U.UserID left outer join dbo.[Users] O on E.OwnerID = O.UserID left outer join dbo.[Users] L on E.LastUpdatedID = L.UserID left join dbo.[EventsCategory] b on E.Category = b.Category left join dbo.[EventsLocation] c on E.Location = c.Location WHERE EventID = @EventID And e.ModuleID = (Select ModuleID from #RealModuleID where EventID = @EventID) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /**** EventsGetByRange ****/ CREATE PROCEDURE dbo.[EventsGetByRange] ( @ModuleIDs nvarchar(1024), @BeginDate datetime, @EndDate datetime, @CategoryName nVarchar(50) ) AS SET DATEFORMAT mdy CREATE Table #EventIDs (EventID Int, NoOfRecurrences Int, LastRecurrence DateTime) INSERT INTO #EventIDs (EventID, NoOfRecurrences, LastRecurrence) SELECT DISTINCT e.EventID, Count(E2.EventID) as NoOfRecurrences, Max(E2.EventDateBegin) as LastRecurrence FROM dbo.[Events] E LEFT OUTER JOIN dbo.[EventsMaster] M ON E.ModuleID = M.SubEventID LEFT JOIN dbo.[Events] as E2 ON E.RecurMasterID = E2.RecurMasterID WHERE ((E.EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,E.Duration,E.EventTimeBegin) >= @BeginDate) OR (E.EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1, @EndDate))) AND E.Approved = 1 AND E.Cancelled = 0 AND (E.ModuleID in (SELECT * FROM dbo.[SplitIDs](@ModuleIDs))) GROUP By E.EventID SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, E.Importance, E.CreatedDate, CreatedBy = U.DisplayName, E.CreatedByID, E.Every, E.Period, E.RepeatType, E.Notify, E.approved, E.Signups, E.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.[EventsSignups] WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, ET.NoOfRecurrences, ET.LastRecurrence, E.EnrollRoleID, E.EnrollFee, E.EnrollType, E.PayPalAccount, E.Cancelled, E.DetailPage, E.DetailNewWin, E.DetailURL, E.ImageURL, E.ImageType, E.ImageWidth, E.ImageHeight, E.ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, E.Reminder, E.TimezoneOffset, E.SendReminder, E.ReminderTime, E.ReminderTimeMeasurement, E.ReminderFrom, E.SearchSubmitted, E.CustomField1, E.CustomField2, E.EnrollListView, E.DisplayEndDate, E.AllDayEvent, E.OwnerID, OwnerName = O.DisplayName, E.LastUpdatedAt, LastUpdatedBy = L.DisplayName, E.LastUpdatedID, RMOwnerID = r.OwnerID, r.RRULE, E.OriginalDateBegin, E.NewEventEmailSent FROM dbo.[Events] E inner join dbo.[EventsRecurMaster] AS r on E.RecurMasterID = r.RecurMasterID left outer join dbo.[Users] U on E.CreatedByID = U.UserID left outer join dbo.[Users] O on E.OwnerID = O.UserID left outer join dbo.[Users] L on E.LastUpdatedID = L.UserID left join dbo.[EventsCategory] b on E.Category = b.Category left join dbo.[EventsLocation] c on E.Location = c.Location left join #EventIDs ET on E.EventID = ET.EventID WHERE E.EventID in (Select EventID from #EventIDs) AND (b.CategoryName = @CategoryName or @CategoryName = N'') System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* EventsRecurMasterGet */ CREATE PROCEDURE dbo.[EventsRecurMasterGet] ( @RecurMasterID int, @ModuleID int ) AS SELECT RecurMasterID, ModuleID, PortalID, RRULE, DTSTART, Duration, Until, EventName, EventDesc, Importance, Notify, Approved, Signups, MaxEnrollment, (SELECT Sum(NoEnrolees) FROM dbo.[Events] AS E INNER JOIN dbo.[EventsSignups] AS S ON E.EventID = S.EventID WHERE E.RecurMasterID = R.RecurMasterID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, DetailPage, DetailNewWin, DetailURL, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, CustomField1, CustomField2, EnrollListView, DisplayEndDate, AllDayEvent, CultureName, OwnerID, CreatedByID, CreatedDate, UpdatedByID, UpdatedDate FROM dbo.[EventsRecurMaster] R WHERE RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** SplitIDs Function **/ CREATE FUNCTION dbo.[SplitIDs] ( @RecordIDList varchar(1024) ) RETURNS @ParsedList table ( RecordID int ) AS BEGIN DECLARE @RecordID varchar(10), @Pos int SET @RecordIDList = LTRIM(RTRIM(@RecordIDList))+ ',' SET @Pos = CHARINDEX(',', @RecordIDList, 1) IF REPLACE(@RecordIDList, ',', '') <> '' BEGIN WHILE @Pos > 0 BEGIN SET @RecordID = LTRIM(RTRIM(LEFT(@RecordIDList, @Pos - 1))) IF @RecordID <> '' BEGIN INSERT INTO @ParsedList (RecordID) VALUES (CAST(@RecordID AS int)) --Use Appropriate conversion END SET @RecordIDList = RIGHT(@RecordIDList, LEN(@RecordIDList) - @Pos) SET @Pos = CHARINDEX(',', @RecordIDList, 1) END END RETURN END System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsCleanupExpired ***/ CREATE PROCEDURE dbo.EventsCleanupExpired ( @PortalID int, @ModuleID int, @ExpireTime DateTime ) AS UPDATE dbo.Events SET Cancelled = -1, LastUpdatedAt = GetUTCDate() WHERE PortalID = @PortalID AND ModuleID = @ModuleID AND DATEADD(minute,Duration,EventTimeBegin) < DATEADD(minute, TimezoneOffset, @ExpireTime) DELETE dbo.EventsRecurMaster WHERE PortalID = @PortalID AND ModuleID = @ModuleID AND 0 = (SELECT count(EventID) FROM dbo.Events WHERE dbo.Events.RecurMasterID = dbo.EventsRecurMaster.RecurMasterID AND dbo.Events.Cancelled = 0) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsNotificationSave ***/ CREATE PROCEDURE dbo.EventsNotificationSave ( @NotificationID int, @EventID int, @PortalAliasID int, @UserEmail nvarchar(50), @NotificationSent bit, @NotifyByDateTime DateTime, @EventTimeBegin DateTime, @NotifyLanguage nvarchar(10), @ModuleID int, @TabID int ) AS SET DATEFORMAT mdy IF @NotificationID = -1 OR @NotificationID IS NULL INSERT dbo.EventsNotification ( EventID, PortalAliasID, UserEmail, NotificationSent, NotifyByDateTime, EventTimeBegin, NotifyLanguage, ModuleID, TabID ) VALUES ( @EventID, @PortalAliasID, @UserEmail, @NotificationSent, @NotifyByDateTime, @EventTimeBegin, @NotifyLanguage, @ModuleID, @TabID ) ELSE UPDATE dbo.EventsNotification SET EventID = @EventID, PortalAliasID = @PortalAliasID, UserEmail = @UserEmail, NotificationSent = @NotificationSent, NotifyByDateTime = @NotifyByDateTime, EventTimeBegin = @EventTimeBegin, NotifyLanguage = @NotifyLanguage, TabID = @TabID WHERE NotificationID = @NotificationID and ModuleID = @ModuleID SELECT * FROM dbo.EventsNotification WHERE NotificationID = scope_identity() System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsNotificationGet ***/ CREATE PROCEDURE dbo.EventsNotificationGet ( @EventID int, @UserEmail nvarchar(50), @ModuleID int ) AS SELECT Distinct NotificationID, EventID, PortalAliasID, UserEmail, NotificationSent, NotifyByDateTime, EventTimeBegin, NotifyLanguage, n.ModuleID, n.TabID FROM dbo.EventsNotification n Left Outer Join dbo.EventsMaster m ON n.ModuleID = m.SubEventID WHERE EventID = @EventID And UserEmail = @UserEmail And (n.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** EventsNotificationToSend ***/ CREATE PROCEDURE dbo.EventsNotificationsToSend ( @NotifyTime DateTime ) AS SELECT n.NotificationID, n.EventID, n.PortalAliasID, n.UserEmail, n.NotificationSent, n.NotifyByDateTime, n.EventTimeBegin, n.NotifyLanguage, e.TimezoneOffset, n.ModuleID, n.TabID FROM dbo.[EventsNotification] as n INNER JOIN dbo.[Events] as e ON n.EventID = e.EventID AND n.NotifyByDateTime <= DATEADD(minute, e.TimezoneOffset, @NotifyTime) WHERE (n.NotificationSent = 0) ORDER BY n.NotifyByDateTime System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) if exists (select * from dbo.sysusers where name='redlorry') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on [' + @name + '] to [redlorry]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole) if exists (select * from dbo.sysusers where name='redlorry') begin declare @exec nvarchar(2000) declare @name varchar(150) declare @isscalarfunction int declare @istablefunction int declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as IsScalarFunction from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name, @isscalarfunction while @@fetch_status >= 0 begin if @IsScalarFunction = 1 begin select @exec = 'grant EXECUTE on [' + @name + '] to [redlorry]' execute (@exec) fetch sp_cursor into @name, @isscalarfunction end else begin select @exec = 'grant SELECT on [' + @name + '] to [redlorry]' execute (@exec) fetch sp_cursor into @name, @isscalarfunction end end deallocate sp_cursor end |
| Info |
End Sql execution: 05.01.00.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - DNN_Events |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
|
|
|
Regards
|
| |
|
|