SQL Configuration Problems - SQL-FineBuild/Common GitHub Wiki
| Previous SQL Server Installation Problems | DBA Password Store Next |
|---|
This page gives details on how to troubleshoot problems that may occurr during configuration of SQL Server after the main install has completed.
The following items are covered:
- Report Services Configuration
- SQL System Database Configuration
- Database Container shows no Databases
- No SQL Performance Counters for SQL 2005
Report Services Configuration
Reporting services can sometimes take a long time before it will accept the web service requests used to configure the Reporting Services Administration Accounts in Process Id 4RAJ.
If FineBuild fails at this point, restart FineBuild and it will automatically continue.
SQL System Database Configuration
This relates to Process 5D, where FineBuild moves msdb and tempdb to new locations. The process of moving database files is supported by Microsoft, and first step in any troubleshooting should be to look at the Microsoft advice at https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases?view=sql-server-2017.
Database Container shows no Databases
If this occurs when SQL Server is started with the T3608 flag set, it may be due to a database file not being moved to its correct location.
Check that all files are in their correct location, and then try restarting SQL Server without the T3608 flag. If this cures the problem, restart SQL Server with the T3608 flag, then restart FineBuild and it will automatically continue.
No SQL Performance Counters for SQL 2005
If you install a 32-bit version of SQL Server 2005 on to a 64-bit OS, you may find there are no SQL Server performance counters.
This problem can be solved from copying a file from a 64 bit version of SQL Server to the server running the 32-bit version of SQL Server. You must copy the file for the same SQL 2005 64-bit Service Pack and preferably the same Cumulative Update that you used for the SQL 2005 32-bit install. This problem and solution is described at https://blogs.technet.microsoft.com/roplatforms/2010/05/03/creating-a-custom-data-collector-set-with-sql-x86-counters-on-an-x64-os.
You should copy the sqlctr90.dll file from the C:\Windows\System32 folder from the server running the 64-bit version of SQL Server 2005 to the C:\Windows\System32 folder of the server running the 32-bit version of SQL Server 2005.
Copyright FineBuild Team © 2012 - 2018. License and Acknowledgements
| Previous SQL Server Installation Problems | Top | DBA Password Store Next |
|---|