Description:
Opening connection in server explorer and choosing to alter existing routine requires
another authentication at server.
How to repeat:
VS2008Pro, c/NET 6.0.3GA, Win2K8x64.
- Created DataConnection to remote box, database test, via it's IP (then 192.168.1.2).
192.168.1.2(test)
- Created new DataConnection to remote box by it's name (OpenSol), database test, while
it's IP was still 192.168.1.2. opensol(test).
- Changed OpenSol IP to 192.168.1.12
- Open VS2008, dbl-click on opensol(test) connection, show SP's, all is fine
- Right-click any SP, choose "Alter Routine"
- Change stuff
- When trying to apply the changes, VS2008 pops-up MySQL server login where server is
represented by old IP, 192.168.1.2 and fails as there is no such box any more.
Question is, if this is a bug in c/NET and not VS, why am I asked for credentials (and
wrong ones) while still connected to remote MySQL server in server explorer.
Suggested fix:
-
