Kbase P55890: Progress DB to MS SQL Server utility (ProtoMSS) does not pull any table definitions from the SQL Ser
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/10/2008 |
|
Status: Verified
SYMPTOM(s):
Progress DB to MS SQL Server utility (ProtoMSS) does not pull any table definitions from the SQL Server 2000 Database when used other than sa user
Received informational message "There are no objects in the MSS database that satisfy the selected criteria. (Remember: some data sources are case sensitive.) Reenter preselection criteria?"
Clicking yes redisplays the informational message above.
clicking no shows following message:
Run pro -p c<Schema holder name>.p to connect to new MSS Database
Clicking ok on the above message returns to the Data Admin window.
FACT(s) (Environment):
The user performing the ProToMSS has System Administrator server role in SQL Server.
Progress DB to MS SQL Server utility pushes all the tables to SQL Server Database with "dbo" as owner.
There are no user tables in the schema holder
MS SQL DataServer
Windows
MS SQL SERVER 2000
CAUSE:
When the user who performs the ProToMSS had System Administrator Server role or has been defined as database owner, SQL Server creates the objects with an owner of "dbo". When the ProToMSS utility searches for objects to pull into the schema holder, it uses the userid of the user running the utility in it's search criteria. Since the object are owned by"dbo" no objects can be found to pull.
FIX:
Revoke the System Administrators role or database owner designation.
Follow the steps below:
1. Go to the SQL Server Enterprise Manager.
2. Console Root > Microsoft SQL Servers > SQL Server Group> Machine Name (Windows NT) > security > Logins
3. Right mouse click on the user to select properties > Click on Server roles tab
4. Uncheck the System Administrators server role.
5. Click on the Database Access tab
6. Uncheck the db_owner box.
7. Click on OK to save changes