January 2, 2003 at 4:54 pm
All of my SQL Server 2000 instances are running in Windows authentication mode. ERwin can't connect to SQL Server using Windows authentication. Besides the obvious (change to Mixed mode), is there a workaround to this incompatibility? I would like to be able to:
1. Use ERwin to make changes to a data model.
2. In ERwin, compare the SQL Server database to the data model.
3. In ERwin, generate a script containing the changes which would synch up the database with the model.
I have the latest version of ERwin (4.1).
January 2, 2003 at 5:10 pm
Unfortunately, you have to create a standard login in SQL Server to connect to ERwin, There is no way around as far as I know. A user name with read-only rights (DataReader) would be enough.
January 3, 2003 at 10:30 am
Thanks, but that would mean that I'd have to change to mixed mode. For security reasons, our company standards require that we use Windows authentication.
What other data modeling tools allow Windows authentication? ER/Studio from Embarcadero?
January 3, 2003 at 12:38 pm
ER/Studio does, I believe.
alternative, setup a local server, make the changes to that and then script them. run the script using Windows Auth.Kludgy, but secure.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 3, 2003 at 12:46 pm
Thanks, Steve! Your suggestion is less kludgy than what I'm doing now. I'm scripting the database, re-engineering it in ERwin, comparing to the data model in ERwin, generating a difference script, then running the script against the SQL Server database.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply