Red Gate forums :: View topic - Domain Authentication
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Domain Authentication

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kgabrys



Joined: 26 Jul 2013
Posts: 2

PostPosted: Fri Jul 26, 2013 10:48 pm    Post subject: Domain Authentication Reply with quote

Our databases use SSPI for windows authentication. I had an issue with my domain account used for dba access and eventually it was solved by issuing a new account name. For instance: was kentg and now is kent

Even though our permissions are set and everything is good, the Data Compare Tool is still trying to access the database using my old user name. This is not the authentication directly created by windows, but a piece written for SQL Server that uses the Microsoft authentication passed. There is a database server trigger app that we created, used for security to insure the user is authorized. Since we changed the my logon name (by one character) I have not been able to authenticate on this trigger because Data Compare 10 is not using my currently logged in user name, but my old one.

Is there a way to flush any cached values so that it sends the current value?
_________________
Thanks in advance,
Kent - Becket & Lee LLP
Back to top
View user's profile Send private message
kgabrys



Joined: 26 Jul 2013
Posts: 2

PostPosted: Fri Jul 26, 2013 11:03 pm    Post subject: Reply with quote

We have found the solution, the error message I am receiving about a bad logon name is not correct due to an issue with the resources of the component. This issue turns out to be configuration on our server. Embarassed
_________________
Thanks in advance,
Kent - Becket & Lee LLP
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group