Just a quick note that in the meantime we could overcome this issue. The reason was similar than that is outlined in KB article KB 51455. Only a different .DLL had to be set rights upon (DynamicPageDB.DLL).
I am assuming that you are using default port 1433 on SQL server and that you can connect to that port from the Virtual machine.
Ensure that the Username or the password specified doesn't have any special characters. A known issue is that, MQM 6.0 doesn't accept special characters while connecting to the SQL Server. This is being addressed in an upcoming Patch.
We'll need to install Microsoft SQL Server Native Client on the MQM server. This can be installed from the Microsoft SQL Server 2005 CD or can be downloaded from the following link.
Also verify the username and the password being specified is the Database Owner's username and password.
Verify if there are any connectivity issues with SQL or any of the parameters that is being used in connectivity. Best way to check if there are any issues with connectivity is to create a DSN and pass the parameters you are passing from MQM. Please follow the steps below.
a) After installing SQL Server Native Client, Data Sources ( ODBC) in the Administrative Tools from Control Panel
b) Create a DSN, and fill the Name, Description, Server fields respectively. ( Just specify the IP address, Do not enter the port number along with the Server IP)
c) click "Next" and choose "With SQL Server Authentication usin a Login ID and Password" and check "connect to SQL server to obtain settings...."
d) Enter the Database owner's username and Password and click "Next"
If the test fails, then this may indicate that we may need to tweak few settings on the SQL server.
Hope this helps.
thank you for your exthaustive response. I got the previous information from a third party making the actual troubleshooting.
they might or might not fulfill al the steps in your description on the first run, though, thus resulting in the issue.
Thank you again.