Re: Connection to SQL Server Failed?

[ANIRBAN MODAK]

I am facing almost the same issue for my domain login (domain1\anirban.modak).

But I notice, Migration Toolkit can retrieve the system databases (master, model, msdb and Tempdb) but can not retrieve the other (user) databases. Even if I provide the database name (say, ICD) in the textbox (in Source Database screen), the error comes as following:

-------------------------------------------------------------------------
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
Connection jdbc:jtds:sqlserver://2043-CH-HEALTHC:1433/ICD;user=anirban.modak;password=hello;charset=utf-8;domain=domain1
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :Cannot open database "ICD" requested by the login. The login failed.
---------------------------------------------------------------------------

Server Level:
-------------
Login domain1\anirban.modak having Server Roles: public, sysadmin.

Database Level: For ICD
-----------------------
User:
CREATE USER [dbo] FOR LOGIN [domain1\anirban.modak] WITH DEFAULT_SCHEMA=[dbo]

Database Role:
[dbo] is authorized to all the existing Database Roles.
Example: CREATE ROLE [db_accessadmin] AUTHORIZATION [dbo]

I am using SQL Server 2005 Express Edition.

Can you please help me resolve this ??