I think you must look at this attached file.
_______________________________________________________________
Do You Yahoo!?
Consiga gratis su direcci�n @yahoo.es en http://correo.yahoo.es
Subject: Re: (ROSE) Reverse Engineer MS SQL 7
Date: Tue, 5 Sep 2000 10:48:11 -0700
From: "Patrick Kennedy" <[EMAIL PROTECTED]>
To: "Christopher Vun" <[EMAIL PROTECTED]>,
"Rose Forum (E-mail)" <[EMAIL PROTECTED]>
Take a look at the following technical note.
If this fails to get you going, send a description of
the problem along with the information requested in
III. IF PROBLEM PERSISTS
to [EMAIL PROTECTED]
TN ID: 12926
PRODUCT: Rose 2000e
OS: Windows
DEFECT #:
PATCH #:
REFERENCES:
CREATED: 08/22/2000
REVISED:
SUMMARY: Troubleshooting Data Modeler:Reverse Engineer - SQL Server
TROUBLESHOOTING TIPS:
Troubleshooting Data Modeler:Reverse Engineer - SQL Server
I. COMMON PROBLEMS
II. USER EXAMPLES
III. IF PROBLEM PERSISTS
-------------------------------------------------------------------
I. COMMON PROBLEMS
-------------------------------------------------------------------
Test connection fails with following error:
"Unable to connect to the database with the information supplied.
Please verify the connection information."
1)
You must connect using, SQL Server authentication.
Windows NT authentication is not supported at this time.
Open enhancment request:
DefectID: 11790 : DM support for "Windows NT Authentication"
See II. USER EXAMPLES below.
2)
Incorrect server name
Specify the name of the server running Microsoft SQL Server to
connect to. If server name is local machine you can leave this
blank or type in local machine name.
Server 7.0 database: Data Modeler use the OLE DB driver for SQL
Server (SQLOLEDB) , which is provided by Microsoft. The correct
Server Name to use should be identical to the one that your ODBC
Datasource points to, although we do not use ODBC to connect to SQL
Server.
To check ODBC name, goto control panel, click on
Data Sources (ODBC), User DSN tab, Double click on
Name for SQL Server, name should be same as
"Which SQL Server do you want to connect to? Server: ..."
3)
Incorrect username or password.
User doesn't exist or you may not have the property security to
connect. Check username and password.
Test connection using SQL Server Query Analyzer:
EXAMPLE:
SQL Server: JSMITH_NT
Connect Information:
x Use SQL Server authentication
Login Name: jsmith
Password: ********
Use same connection information in Rose.
Tools:Data Modeler:Reverse Engineer...
Reverse Engineering Wizard
Target: Microsoft SQL Server 7.x
User Name: jsmith
password: ********
Server: JSMITH_NT
Database: Northwind (sample db that ships with SQL Server)
[Test Connection]
OK
[Next >]
Choose Schema
x Northwind
-------------------------------------------------------------------
Test connection succeeds, but no databases listed to choose from.
Reverse Engineering Wizard
Target: Microsoft SQL Server 7.x
User Name: jsmith
Password: ******
[Test Connection]
Connection succeeded, OK
However Database listbox is empty
[Next>] button just displays a empty list under Schemas.
SOLUTION: You need to assign master database as your default.
The only privilege that is required to be able to browse in RE
Wizard is assign the user "READ" privilege to "master" database.
This will work with the current version as well as future versions
of Rose. This limitation will be corrected in the next release of
Rose. See II. USER EXAMPLES below.
-------------------------------------------------------------------
II. USER EXAMPLES
-------------------------------------------------------------------
Examples showing creating a user, checking user, to access
SQLServer sample database, Northwind.
1) Example to create a user to access sample database Northwind.
Start SQL Server Enterprise Manager
Start:Programs:MicroSoft SQL Server 7.0:Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
hightlight Server
Select "Administer SQL Server" in window
Select "create a login"
Create Login Wizard - SERVERNAME
select
x SQL Server login information that was assigned to me by
the system administrator. (SQL Server authentication)
[Next >]
Login ID: jsmith
Password: ********
Confirm password: ********
[Next >]
Grant Access to Security Roles:
[optional]
System Administrators
Security Administrators
Server Administrators
Setup Administrators
Process Administrators
Disk Administrators
Database Creators
[Next >]
Grant Access to Databases
x master
model
msdb
x Northwind (optional, as long as master is selected than
this database should show up in Reverse Engineering
wizard)
tempdb
[Next >]
Authentication: SQL Server
Granted to: jsmith
User 'jsmith' granted access to the following databases:
master
Northwind
[Finish]
Wizard Complete!
! The login was successfully created.
[OK]
2) To check user (server):
Start SQL Server Enterprise Manager
Start:Programs:MicroSoft SQL Server 7.0:Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Expand Security
Double click on Logins
Double click on user name
General Tab
Authentication
x SQL Server authentication
must be selected.
Defaults
Specify the default language and database for this login
Database: master
(master must be the default)
Language: English
Database Access tab
Specifiy which databaes can be accessed by this login
x permit Northwind
x permit master
Database roles for [database name]
x pubic
(others are optional)
Server Roles tab,
these settings are optional, i.e. no need to select any.
3) To check user (database):
Start SQL Server Enterprise Manager
Start:Programs:MicroSoft SQL Server 7.0:Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Expand [Server Name]
Expand [Database Name]
click on Users
User name must exists under database you
are trying to access.
Double click on username
Permit in database role:
x public
(others are optional)
-------------------------------------------------------------------
III. IF PROBLEM PERSISTS
-------------------------------------------------------------------
Can you connect with SQL Server Query Analyzer?
What server connection information are you using in Rose? Is it
the same as you use outside of Rose?
Is SQL Server 7.0 a local installation, or out on a network?
If test connection succeeds, and you can select your database,
Reverse engineering starts and then stops or hangs:
1) Reboot your machine and retest.
2) If problems persists, can you reverse engineer from a DDL file?
To create a DDL file in SQL Server,
Start, Server Enterprise Manager
Right click on database,
All tasks:Generate SQL Scripts...
If this script fails, could you please email this to technical
support so we can test it here?
Patrick Kennedy
Rational Support
On Aug 14, 14:19, Christopher Vun wrote:
> Subject: (ROSE) Reverse Engineer MS SQL 7
>
> Hi all,
>
> Currently I am doing a reverse engineering process from a MS SQL 7 server on
> local LAN to a Rose2000e model. The problem is that I cannot select the
> database I want to reverse. I got to the point where in the database
> wizard, I choose SQL 7 as the target and set the login and server
> parameters. Press the test connection and Rose2000e reported that the
> connection was alright. But there is nothing for me to select from the
> database.
>
> Can anyone offer any suggestions?
>
> The only way I have got around this problem is importing the data tables
> from the server to my own PC which is running Win98 using the MS SQL client
> desktop and then run the database on my own PC. I run the wizard again and
> was able to select which database I wanted.
>
> Is this a Rose bug?
>
> Thanks
>
