This project has moved. For the latest updates, please go here.

Previous SQL Server Installation Problems DBA Password Store Next

SQL Configuration Problems

This page gives details on how to troubleshoot problems that may occurr during configuration of SQL Server after the main install has completed.

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 5CFA.

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 section Moving System Databases in Books Online (BOL)

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 http://blogs.technet.com/b/roplatforms/archive/2010/05/03/creating-a-custom-data-collector-set-with-sql-x86-counters-on-an-x64-os.aspx.

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 © 2012 - 2014 Edward Vassie. License and Acknowledgements
Previous SQL Server Installation Problems Top DBA Password Store Next

Last edited Dec 22, 2014 at 3:48 PM by EdVassie, version 5