Q: If I failed to open the datasource and database workspace from SQL Server 2000 remotely and I got the error: [Microsoft][ODBC SQL Server Driver] dialog failure. You failed to connect to datasource. How can I solve this issue if the database on the server works well and there is no problem creating or saving a database?

A: If the default port of the SQL Server database has been changed from 1433 to some other number, then the service name must be written as: [computer name]:[new port number] or [IP]:[new port number] for normal access to the datasource and database workspace.