System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT COUNT (me) AS TotalCountInDateRange, left(datename(month, dateadd(mm, -1, getdate())), 10) AS Previous_Month FROM Names WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT(DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101)AND me='M' at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'AT' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'BE' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'BO' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'CF' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'EM' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'KY' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'GU' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'JX' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'DA' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'MD' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'MF' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'MS' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'NC' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'GO' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'NS' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'PB' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'PC' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'SF' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'SA' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'SD' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'SW' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'SJ' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'SU' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'TA' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'VC' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'WC' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'WF' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = '' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'FL' THEN '' WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'FL' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'XX' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else REPLACE(rtrim(names.city),'Bch', 'Beach') END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

System.Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAM4SQL" requested by the login. The login failed. Login failed for user 'CMSQueryList'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 266 ClientConnectionId:5a3bd293-8a01-4ff8-a33b-23b5774fea4a Error Number:4060,State:1,Class:11 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @ChapterName varchar(5) -- CHAPTER ABBREVIATION GOES HERE SET @ChapterName = 'zz' SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) --Member Year Starts April 1 SET @EndDate = DATEADD(SS,-1,DATEADD(mm,12,@StartDate)) --Member Year Ends March 31 SELECT names.UD2, CONVERT(VARCHAR(2), DATEPART(mm,names.udate), 101)as Month_Updated, ltrim(ID) AS MemberID, 'Firm' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' ELSE (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) END, 'Name' = CASE WHEN Names.NName='' THEN (rtrim(Names.FName) + ' ' + rtrim(ltrim(Names.LName))) Else (rtrim(Names.NName) + ' ' + rtrim(ltrim(Names.LName))) END, 'FirmWebsite' = CASE WHEN Firms.fname1 = 'Unknown Inactive, Retired or Other' THEN '' WHEN Firms.fname1 = 'Unknown Industry/Commerce Company' THEN '' WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + '' END, 'City' = CASE WHEN firms.fcity='' THEN rtrim(names.city) WHEN names.city ='' THEN rtrim(firms.fcity) Else rtrim(names.city) END, 'State' = CASE WHEN ltrim(rtrim(firms.fst)) = 'ZZ' THEN '' WHEN ltrim(rtrim(names.st)) = 'ZZ' THEN '' WHEN firms.fst = '' THEN ', ' + LTRIM(RTRIM(names.st)) WHEN names.st = '' THEN ', ' + LTRIM(RTRIM(firms.fst)) Else ', ' + LTRIM(RTRIM(names.st)) END, 'Country' = CASE WHEN ltrim(rtrim(names.fc)) = 'ZZ' THEN '' Else '' END FROM Names INNER JOIN Firms ON Names.firm=Firms.firm WHERE (names.UD2 =(LTRIM(RTRIM(RIGHT( DATEPART(yy,@StartDate), 2))) + LTRIM(RTRIM(RIGHT( DATEPART(yy,@EndDate), 2))))) AND DATEPART(mm,names.jdate) = CONVERT(VARCHAR(2), DATEADD(month, -1, GETDATE()), 101) and ch = @ChapterName AND me='M' ORDER BY names.lname, names.city at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 280 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210