There is also an issue where you must be a named user and cannot use NT
Authentification. This is fixed in the upcoming release.
Eric Naiburg
Rational Software Corp.
425-497-6124
[EMAIL PROTECTED]
-----Original Message-----
From: Eric Manley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 10:32 AM
To: Butler, Frances H. (FHB)
Cc: 'Rose_Forum
Subject: RE: (ROSE) Connecting to Microsoft SQL Server 7.0
Frances,
You might want to try setting up an ODBC reference to your SQL Server
Database. In setting up the security portion, select the option that has
"Trusted?" (I believe). It is easier to deal with for security. That
option passes the logon/password of the person currently logged onto the
machine, to the DB environment. Am not sure if ODBC will allow you to set
up an alias to a database, while not being connected to the network.
Eric
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Butler, Frances H.
(FHB)
Sent: Wednesday, December 06, 2000 9:56 AM
To: '[EMAIL PROTECTED]'
Subject: (ROSE) Connecting to Microsoft SQL Server 7.0
I am attempting to use Rose 2000e to reverse engineer a SQL Server 7.0
database schema, and I'm having some trouble connecting to the database.
Within Rose, I go to Tools->Data Modeler->Reverse Engineering Wizard.
Next, I have a "Choose a Database" window with the following text boxes:
Target (pull-down menu, where I select Sql Server 7.x)
User Name (where I enter my Windows 3-character uid)
Password (where I enter my Windows password)
Server (where I enter the server name, which is the same as the machine name
in Windows' network neighborhood)
Database (there should be a pull-down menu here if connected properly, but
my problem seems to be with the Windows networking issues, and since I'm not
connected, I get nothing here)
A Windows NT system administrator suggested that I enter 2 backslashes
followed by the machine name (in this case, "morpheus"). That did not work.
We are using TCPIP for connectivity.
Any help would be greatly appreciated.
Thanks in advance,
Frances
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Frances H. Butler
| Computing Specialist
| BWXT Y-12 L.L.C.
| Oak Ridge, TN
| Phone: (865) 574-3694
| Internet: [EMAIL PROTECTED]
|
| Results! Why, man, I have gotten a lot of results.
| I know several thousand things that won't work.
| Thomas Edison
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
