| Author |
Message |
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
 [9.0.151 BETA] Error after modification Snippets Options |
 |
Hi Team,
Some times after option modifications, I am getting this error:
---------------------------
SQL Assistant - Error
---------------------------
Context: Connect
Message: Login failed for user 'xxxxxx'.
server='172.18.60.41';uid='xxxxxx';Application Name='Microsoft SQL Server Management Studio';Pooling=false;Packet Size=4096;multipleactiveresultsets=false;Database="xxxx"
---------------------------
Aceptar
---------------------------
|
|
| Wed Sep 28, 2016 6:16 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Could you please let us know version of SQL Server Management Studio you are running?
|
|
| Wed Sep 28, 2016 6:32 pm |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
Microsoft SQL Server 2008 R2 Express
Microsoft SQL Server Management Studio 10.50.4042.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.17843
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601
|
|
| Wed Sep 28, 2016 6:48 pm |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
I am testing the [9.0.152 BETA] version, but I am getting the same error.
|
|
| Wed Sep 28, 2016 7:40 pm |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
When the error happens, my connections are lost and I need to reconnect again.
|
|
| Wed Sep 28, 2016 8:55 pm |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
Additional to reconnect, I need to enter again to options because all the assistant functionality is lost even if I try to use SQL Assistant -> Connect
|
|
| Wed Sep 28, 2016 10:03 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I'm afraid this is caused by the SQL Assistant add-on not being loaded correctly. Please try the following:
Open SQL Assistant Options dialog.
Select MS Management Studio target on the Targets tab
Expand Advanced options on the right.
Set Register SQL Assistant Add-on option to No and click the Apply button.
Set Register SQL Assistant Add-on option back to Yes and click the Apply button again.
Please verify this solves the issue with connections. Connections are supposed to be shared when working with SQL Server Management Studio, you should not get separate login prompts or errors in SQL Assistant.
|
|
| Thu Sep 29, 2016 12:21 am |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
:(
I am trying with your suggestion but I am getting the same error. I tried with MSSQL Management Studio 2014 in other machine but I still getting the same error.
|
|
| Thu Sep 29, 2016 1:06 am |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
The workaround that I use is select the option Refresh Cache, (This last works like a Disconnect) and then I use Connect option.
|
|
| Thu Sep 29, 2016 9:56 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Something is incorrect there. If the add-on is loaded by SSMS correctly, then it shares all connections with SSMS, so there should be no separate connections and separate logins, and by virtue no login errors if connections are already open in SSMS.
However, if you open a file from disk that opens a new editor tab, the connection is not yet established for that editor in SSMS, and SQL Assistant attempts to restore last know connection associated with the file, that's when a login error can potentially occur if using SQL authentication by user/password or if the target server is not reachable.
|
|
| Fri Sep 30, 2016 12:08 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I've got further instructions from my team.
Please change target settings for MS Management Studio.
In Advanced settings change Auto Connection option to None, and also verify that Default Connection Type option is set to ADO.NET.
|
|
| Fri Sep 30, 2016 11:36 am |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
At the end I had that uninstall completely the software and I had to delete the %appdata% folder and install again. It seems all is OK until now :)
|
|
| Tue Oct 04, 2016 7:26 pm |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
Hi Team,
Finally I could find the error with this:
---------------------------
SQL Assistant - Error
---------------------------
Context: Connect
Message: Login failed for user 'xxxxxx'.
server='X.X.X.X';uid='xxxxxx';Application Name='Microsoft SQL Server Management Studio';Pooling=false;Packet Size=4096;multipleactiveresultsets=false;Database="xxxx"
---------------------------
Aceptar
---------------------------
This error always occurs when I haven't executed the SQL Assistant (SysTray Icon) before to open MSSQL Management Studio.
This behavior is new in this version, because in the previous one, I have always closed the SysTray Icon, without experimenting problems.
|
|
| Tue Oct 04, 2016 7:57 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I believe this issue has been fixed in the latest build 9.0.157. It's related to login errors after opening files and restoring tabs. Please give it a try.
|
|
| Wed Oct 05, 2016 12:29 am |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
With the last beta all indicate that the error is gone :)
|
|
| Thu Oct 06, 2016 6:14 pm |
|
|
|
