1. After starting the AS service the following errors are seen in the ASLOG:
07:52:28.763 (06) Error: SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Possible cause: Your database migration script gave an SQL error.
Try the following: Contact your account manager with this error information......
16:49:29.220 (05) Error: Unable to start server: Database server not available or database migration script error. Attix5.StoragePlatform.Common.Exceptions.StartupException: Database server not available or database migration script error
at Attix5.StoragePlatform.Common.SPService.OnStart(String args)
16:52:26.817 (0a) Error: Error while processing XML-RPC call from BUDView@18.104.22.168: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.....
2. The SP Console is not able to connect to the AS or no Group/User info and activity is displayed.
The amount of connections made to the SQL server (AS Database) exceeds the default pool size. As there are no connections available the database cannot be queried to populate the SP Console.
Add ‘;Max Pool Size=xxx’ into the ConnectionStrings.config to both the BackupServer and ReportServer string.
<add name="BackupServer" connectionString=";Integrated Security=SSPI;Persist Security Info=True;Data Source=(local)\SQLEXPRESS;Initial Catalog=StoragePlatform;MultipleActiveResultSets=True;Connect Timeout=30;Max Pool Size=200 " />
<add name="ReportServer" connectionString=";Integrated Security=SSPI;Persist Security Info=True;Data Source=(local)\SQLEXPRESS;Initial Catalog=StoragePlatformReports;MultipleActiveResultSets=True;Connect Timeout=30;Max Pool Size=200 " />
Keep the following in mind