Quick CPE Search |
Newly Certified MembersWithin the last 30 days, the following FICPA members have successfully met all requirements to practice as a certified public accountant in Florida. Becoming a CPA is an accomplishment and we would like to congratulate Florida's newest certified public accountants. Click the top of the table to sort the columns. 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:72c0e48f-1f7d-48ab-a229-7709896fee7b
Error Number:4060,State:1,Class:11
SELECT DATEADD(Month, -1, getdate()) as ThirtyDaySpan , CONVERT(datetime, CURRENT_TIMESTAMP, 121) AS TodaysDate, CONVERT(VARCHAR(10),indate,101) AS CertificationDate,
names.indexname AS Member,
'FirmWebsite' = CASE
WHEN ltrim(rtrim(Firms.fname1)) ='' Then rtrim(ltrim(names.name))+', CPA'
WHEN ltrim(rtrim(Firms.fname1)) ='Unknown Inactive, Retired or Other' Then rtrim(ltrim(names.name))+', CPA'
WHEN Firms.ud2 ='' THEN (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2))
Else '' + (rtrim(Firms.fname1) + ' ' + ltrim(Firms.fname2)) + ''
END,
--'Member_Phone' = CASE
--WHEN firms.FPhone='' AND names.dphone='' THEN ''
--WHEN firms.FPhone='' THEN '(' + LEFT(rtrim(ltrim(names.dphone)), 3) + ') ' + SUBSTRING(rtrim(ltrim(names.dphone)), 5,3) + '-' + RIGHT(rtrim(ltrim(names.dphone)),4)
--WHEN names.dphone ='' THEN '(' + LEFT(rtrim(ltrim(firms.FPhone)), 3) + ') ' + SUBSTRING(rtrim(ltrim(firms.FPhone)), 5,3) + '-' + RIGHT(rtrim(ltrim(firms.FPhone)),4)
--Else '(' + LEFT(rtrim(ltrim(firms.FPhone)), 3) + ') ' + SUBSTRING(rtrim(ltrim(firms.FPhone)), 5,3) + '-' + RIGHT(rtrim(ltrim(firms.FPhone)),4)
--END,
'City' = CASE
WHEN firms.fcity='' THEN names.city
WHEN names.city ='' THEN firms.fcity
Else REPLACE(rtrim(firms.fcity),'Ft', 'Fort')
END
FROM
Names
INNER JOIN
Firms ON (Names.firm=Firms.firm)
WHERE me='m' AND indate > DATEADD(Month, -1, getdate()) ORDER BY lname, fname
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
|