A duplicate definition was found for the user 'horakle'
bzimmer
Posts: 1 New member
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'.
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."
Tagged:
Best Answer
-
Jon_Kirkwood Posts: 395 Silver 5
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.
For reference, the instructions are also outlined in the help article below:Jon Kirkwood | Technical Support Engineer | Redgate Software