How do I change SQL Complete DB connection details?

How do I change SQL Complete DB connection details?

Postby 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

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

Postby 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 :)
EricLeBouffon
 
Posts: 5
Joined: Fri 21 Oct 2011 13:43

Postby .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.
.jp
Devart Team
 
Posts: 200
Joined: Wed 09 Sep 2009 06:55
Location: devart

where???

Postby 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...
EricLeBouffon
 
Posts: 5
Joined: Fri 21 Oct 2011 13:43

Postby 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.
alexa
Devart Team
 
Posts: 481
Joined: Fri 24 Jun 2011 14:17

Postby EricLeBouffon » Fri 28 Oct 2011 08:19

OK, makes sense.

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


Return to dbForge for SQL Server