Kbase 21450: Getting Preselection Criteria message while running Progress to SQL Server migration using NT authen
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/10/2008 |
|
Status: Verified
SYMPTOM(s):
Getting Preselection Criteria message while running Progress to SQL Server migration
Error is received when running "Progress to SQL Server" schema migration tool
There are no objects in the MSS database that satisfy the selected criteria. (Remember: some data sources are case sensitive.) Re-enter preselection criteria?
ODBC DSN is using Windows NT authentication model
Schema definitions are present within the SQL Server database
No tables are defined within the new schema holder
No data is present within tables within SQL Server
Defining no user and password within the migration screen
Entering in Windows user (with or without DOMAIN information) and password within the migration screen (DOMAIN\user & password or user & password) does not change behavior
Using user 'sa' within the migration screen does not change behavior
FACT(s) (Environment):
MS SQL DataServer
Windows
Progress 9.x
CAUSE:
User 'dbo' is the user that owns all the system and user tables within the database. When using NT authentication, you need to reference the user that owns the tables so that the tables can be pulled back into the Schema holder/schema image.
FIX:
Within the migration screen, Progress to SQL Server migration, define user 'dbo' with no password.