How do I change SQL Complete DB connection details?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
EricLeBouffon
Posts: 5
Joined: Fri 21 Oct 2011 13:43

How do I change SQL Complete DB connection details?

Post by EricLeBouffon » Fri 21 Oct 2011 13:49

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? :(

EricLeBouffon
Posts: 5
Joined: Fri 21 Oct 2011 13:43

Post by EricLeBouffon » Fri 21 Oct 2011 14:01

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? :?:

EricLeBouffon
Posts: 5
Joined: Fri 21 Oct 2011 13:43

no more problem...

Post by EricLeBouffon » Sat 22 Oct 2011 12:52

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 :)

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 25 Oct 2011 09:35

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.

EricLeBouffon
Posts: 5
Joined: Fri 21 Oct 2011 13:43

where???

Post by EricLeBouffon » Tue 25 Oct 2011 13:16

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...

alexa

Post by alexa » Wed 26 Oct 2011 15:36

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.

EricLeBouffon
Posts: 5
Joined: Fri 21 Oct 2011 13:43

Post by EricLeBouffon » Fri 28 Oct 2011 08:19

OK, makes sense.

Thanks :wink:

Post Reply