Re: Connection to SQL Server Failed?
Date: January 31, 2012 12:04AM

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
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 ??

Options: ReplyQuote

Written By
December 06, 2011 09:52AM
Re: Connection to SQL Server Failed?
January 31, 2012 12:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.