SQL server connection details and database name are required when running Open Project Wizard and providing information about Exchange portion of QMM (Quest Migration Manager) project. The following error is normally received when insufficient or incorrect information about SQL server is provided:
Open Project Wizard: Login failed for user "UserName". Please check whether the server is available, and username and password are correct.
Is it possible to specify port number if SQL server instance is configured to connect over TCP/IP and listen on the port other than default 1433?
The behavior is by design.
QMM application is relying on standard OLE DB client libraries in order to connect to SQL server instance where Exchange project database is stored. There are well known Microsoft best practices on how to configure server or client side applications for the connection to SQL server.
1. In SQL Server 2005 "SQL Server Browser Service" can be configured to provide this information to the client applications: <http://msdn2.microsoft.com/en-us/library/ms181087.aspx>
2. SQL server instance can be configured for the dynamic port allocation: <http://support.microsoft.com/kb/287932/>
3. Configure port number on the client side using SQL Server client configuration tools, for example SQL Server Configuration Manager (part of SQL 2005 server installation) or creating alias. Steps can be found here: http://support.microsoft.com/kb/265808/en-us
4. While 1 through 3 are preferred also the following syntax can be attempted: SQLSERVER\INSTANCE\,<port number> or without "\". For example: SQL\DB1\,1501 or SQL\DB1,1501where 1501 is TCP/IP port number. Also it is possible to type just the servername followed by a comma and then the port name, syntax would be: SERVERNAME,1450 (where 1450 is just an example)