Page 1 of 1
How do I change SQL Complete DB connection details?
Posted: Fri 21 Oct 2011 13:49
by EricLeBouffon
I changed the password of my SQL Authentication login and SQL Complete keeps showing an error box about "Login for ... failed"
How can I instruct SqlComplete about the new password to use?

Posted: Fri 21 Oct 2011 14:01
by EricLeBouffon
I guess I won't know the answer since SSMS crashed on me... but I realised (just before it crashed) that my connection within the object list still had the old password.
So, maybe this is the connection that SQL Complete used?

no more problem...
Posted: Sat 22 Oct 2011 12:52
by EricLeBouffon
EricLeBouffon wrote:I guess I won't know the answer since SSMS crashed on me... but I realised (just before it crashed) that my connection within the object list still had the old password.
So, maybe this is the connection that SQL Complete used?

Just for the record, I am not having any more problem so I guess a workaround is to restart SSMS

Posted: Tue 25 Oct 2011 09:35
by .jp
Hi there!
SQL Complete has nothing to do with connection details specified by a user in the 'Connect to Server' dialog box since this functionality belongs to Microsoft SQL Server Management Studio 2008 but not to SQL Complete. We can suggest you to make sure the login details you specify are correct or contact your database administrator for regaining new ones.
where???
Posted: Tue 25 Oct 2011 13:16
by EricLeBouffon
I am very happy to supply SQL Complete the right connection details... but this is precisely the question: where does one do that?
I don't remember giving SQL Complete specifically logins and/or passwords...
Posted: Wed 26 Oct 2011 15:36
by alexa
Hello,
You can not supply SQL Complete with connection details directly as it uses the connection details which are entered to the 'Connect to Server' dialog box of Microsoft SQL Server Management Studio.
You can always change the entered login details by invoking the context menu in a new document and selecting Connection -> Change Connection.
Posted: Fri 28 Oct 2011 08:19
by EricLeBouffon
OK, makes sense.
Thanks
