Comments
Sort by recent activity
Hi Brian,
This did not solve the problem. I ended up taking my source DB offline, copied th MDF/LDF to the target server, brout the source back online and attached the DB on the target server. [image]
Even when I commented out the sp_grantdbaccess I still got errors when it tried to grant permissions. Too much editing makes it a PITA to use. I even tried turning off all User/Group matching and it still tried to grant permissions. Maybe I'm missing something... / comments
Hi Brian,
This did not solve the problem. I ended up taking my source DB offline, copied th MDF/LDF to the target server, brout the source back online and attached the DB on the target server.
E...
This is fast becoming a bone of contention.
Scenario 1: described above.
Scenario 2: I develop on an XP box with IIS 5. I have 2 accounts in the Database. [ASPNET] for the web app and [KBARROWS] for myself to work in SQL. I do not login as [SA], I login using trusted. Now, go to the Dev/QA/Prod servers and they all run on Win2003 and IIS6. There is 1 account there. [NETWORK SERVICE]. I try to script *anything* over and it rollsback because it could not find the [ASPNET] and [KBARROWS] accounts. It is taking me over 30 minutes per script to find and chop out all the GRANTS that cause the script to fail. Even when I turn off account scynch it still tries to create the accounts and use them. :x / comments
This is fast becoming a bone of contention.
Scenario 1: described above.
Scenario 2: I develop on an XP box with IIS 5. I have 2 accounts in the Database. [ASPNET] for the web app and [KBARROWS]...
I have been 100% unsuccessful in logging into any of our Azure hosted MySql databases! It just gives me a generic authentication failure error. (Authentication failed) I connect via EntityFramework (C#), MySql Workbench and TablePlus with no issues.
I have no idea why your product will not connect. There is no way for me to evaluate this other than to tell my company it is a broken product, don't buy it.
MySql Compare 1.0.1.4
/ comments
I have been 100% unsuccessful in logging into any of our Azure hosted MySql databases! It just gives me a generic authentication failure error. (Authentication failed) I connect via EntityFramewor...