Comments
Sort by recent activity
I'm running version 2.6.1.47.
I did check the save password option. If I open the saved project and then click the Add Objects to Project button (which is the only way I know of to see the DB selected) it lists my SQL Server Instance twice (which could be part of the problem as I only opened the instance once) and both with the correct saved user and password. I can then expand that and see the correct DB and select or deselect items. Clicking Add Selection to Project generates errors though.
When I open the project in Notepad and I scroll all the way to the bottom I can see the XML you mentioned, but it looks like some of it is missing as it ends like this "<projectDatabase instanc". The integratedSecurity option is set to false.
I'll download and try the latest patch. / comments
I'm running version 2.6.1.47.
I did check the save password option. If I open the saved project and then click the Add Objects to Project button (which is the only way I know of to see the DB sele...
After installing the latest patch the problem does not appear to happen. I was able to open my saved project and do a Update From Schema and it worked with no login failures. Everything updated.
Thanks! / comments
After installing the latest patch the problem does not appear to happen. I was able to open my saved project and do a Update From Schema and it worked with no login failures. Everything updated.
...
Thanks for the reply.
Unfortunately the link in your post for permissions takes me to a page that has another link which is supposed to describe the permissions needed (the same as SQL Compare) and that link is broken.
I doubled checked the user I am using and that user has SysAdmin rights to the instance and it's a 2005 DB so the additional GRANT VIEW SERVER TO <user> should not be needed.
I also ran SQL Compare against the DB just to make sure it would work and that ran fine too.
I checked the SQL Server Logs and did see logon failures for when I was trying to logon with the original project.
If I open Dependency Tracker and create a new project and login to the server with the same login everything works fine. If I then save that new project, close down and then reopen that new project and attempt to refresh I get the same error.
After trying that I noticed that the SQL Server Logs are reporting that it was attempting to login with both my SQL auth user and my Windows auth user.
After doing a bit of Googling (http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx) I've determined that it's either not passing in the SQL Auth password or it's passing in the wrong value as that entry has a State of 8 which indicates invalid password. For the entry for my Windows account (which it should not pass since this DB is connected via SQL Auth) it generates a State of 11 which indicates that it's a valid login but there's a server access failure. / comments
Thanks for the reply.
Unfortunately the link in your post for permissions takes me to a page that has another link which is supposed to describe the permissions needed (the same as SQL Compare) and...