The installers for PeoplePassword and PeopleEnroll ask for a database when installing the solutions. Sometimes the list of servers is empty, though, when you browse for a database. This is typically caused because the SQL Server hosts in your environment do not have the SQL Server Browser service running. You have two options to work around this solution. It’s important to make sure the PeoplePassword web server can communicate with the SQL Server since the installer runs the scripts to create and populate the initial PeoplePassword database.
- Turn on the SQL Server Browser service on the database server that will host the PeoplePassword database. You can turn this service off again once the installer finishes. The References section includes links to more information about the service.
- If you know the database and catalog name, you can manually type in the SQL Server host name and catalog name instead of browsing. You can use (local) for a local SQL Server installation and include the parentheses in the name.
- SQL Server Browser Service: http://msdn.microsoft.com/en-us/library/ms181087(v=sql.105).aspx
- Overview of the SQL Server Browser service: http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/
- How to configure SQL Server 2005 to allow remote connections: http://support.microsoft.com/kb/914277
- How to: Start and Stop the SQL Server Browser Service (SQL Server Express): http://msdn.microsoft.com/en-us/library/ms165734(v=sql.90).aspx