A duplicate definition was found for the user 'horakle'

bzimmer

Hello,

I also just stubmled over this error. I have a fresh installation of sSMS Version 18.11.1 with SQL Source Control installed. We do have a couple dozen of different Databases. And I tried to connect several of them with the same error.

I also already tried to link SourceControl to a freshly cloned Repository and also tried to change the case sensitivity options under Setup->Comparison options with no success and could use a little help here.

Error:
"A duplicate definition was found for the user 'horakle'.

Ensure that case sensitivity options are set correctly and all object creation scripts are valid.If the problem persists, contact Redgate support."

Jon_Kirkwood

Hi @bzimmer

Thanks for reaching out on the Redgate forums and sorry that you're having trouble with SQL Source Control. 

To troubleshoot the issue, can you please try the following:

• Unlink the database from source control

• Clear the content in the caches folder located in %localappdata%\Red Gate\SQL Source Control<version>\Caches. 

Using Notepad++ or similar tool, can you please search the repository for the create script for the user 'horakle' and delete any duplicates before relinking the database to source control

For reference, the instructions are also outlined in the help article below:

https://productsupport.red-gate.com/hc/en-us/articles/4407476864401-Duplicate-definition-troubleshooting-in-SQL-Source-Control