Comments
Sort by recent activity
Many thanks for your post Grant.
For some unknown reason, SQL Server Management Studio installations have been unravelling and deleting the interface that Prompt and Refactor need to get access to the query window.
Running this from a Command Prompt should fix it:
Code: regsvr32 "%commonprogramfiles%\microsoft shared\msenv\textmgrp.dll"
Kindly let us know if this fixed the problem. / comments
Many thanks for your post Grant.
For some unknown reason, SQL Server Management Studio installations have been unravelling and deleting the interface that Prompt and Refactor need to get access to ...
Many thanks for your post.
We have logged a suport call for you: F0034866. / comments
Many thanks for your post.
We have logged a suport call for you: F0034866.
Thanks for your post David.
You can do the following to ensure that SQL Prompt will not re-appear in the menu for VS upon startup:
1) Open up VS and go to Tools > Add In Manager
2) Uncheck SQL Prompt both as an available add in and startup, click ok
3) Go to Tools > Customize
4) Drag the SQL Prompt menu icon away from the menu bar, and it should disappear.
5) Restart VS, and SQL Prompt should be gone from there, but not SSMS
Kindly let me know if this fixes the issue. / comments
Thanks for your post David.
You can do the following to ensure that SQL Prompt will not re-appear in the menu for VS upon startup:
1) Open up VS and go to Tools > Add In Manager
2) Uncheck SQL Prom...
Open up your "Network and Sharing Center."
Click "Change Adapter Settings" in right-hand pane.
This should bring you to Control Panel\Network and Internet\Network Connections. You can also get there by running "ncpa.cpl".
Hit "ALT" to make the menu bar visible, and pick "Advanced" (Alt-N will bring you directly to that menu), and pick "Advanced Settings".
That will open the Advance Settings window, and you can adjust your binding order there. / comments
Open up your "Network and Sharing Center."
Click "Change Adapter Settings" in right-hand pane.
This should bring you to Control Panel\Network and Internet\Network Connections. You can also get ther...
Apologies for delay in replying you.
Can you take a look in the Advanced Network Settings, specifically the binding order? Can you make sure that the correct NIC is the first binding? / comments
Apologies for delay in replying you.
Can you take a look in the Advanced Network Settings, specifically the binding order? Can you make sure that the correct NIC is the first binding?
Can we assumed correctly that SQL Response was working correctly prior to this error occurring? Or you have never been able ever to connect to the Alert Repository Machine?
Can you please ensure that the SQL Response Alert Repository Service is in a started condition on the Alert Repository machine?
From the screen shot, I see that you are attempting to connection on the default port 7398, is this the port configured when the Alert Repository was first created?
Are there any firewall type devices between the SQL Response Client and the Alert Repository machine? If the answer is yes, is the firewall configured to allow data through port 7398?
Can you telnet from the SQL Response Client Machine to the Alert Repository machine on port 7398 or the port number configured, if different from the default port number? / comments
Can we assumed correctly that SQL Response was working correctly prior to this error occurring? Or you have never been able ever to connect to the Alert Repository Machine?
Can you please ensure ...
Thanks for the update.
Your Alert Repository service is not running.
Can you kindly use a windows account and not a sql server account to run the service?
Kindly let me know how it goes. / comments
Thanks for the update.
Your Alert Repository service is not running.
Can you kindly use a windows account and not a sql server account to run the service?
Kindly let me know how it goes.
Many thanks for your post.
Can you kindly confrim that you have changed the setting for Secure remoting to <SecureRemoting>False</SecureRemoting>? For both Client and server config file?
Are you running Alert Repository on Virtual machine? / comments
Many thanks for your post.
Can you kindly confrim that you have changed the setting for Secure remoting to <SecureRemoting>False</SecureRemoting>? For both Client and server config file?
Are you ru...
Many thanks for your post.
It sounds like you may be encountering a known issue when the server you are monitoring is on a different domain. Plese see the following knowledgebase article: http://www.red-gate.com/supportcenter/C ... 000378.htm
If this is not the case, please check your login credentials as per: http://www.red-gate.com/supportcenter/C ... c55308.htm
and http://www.red-gate.com/supportcenter/C ... 000307.htm
If you still have problems, please send across the Alert Repository logs . You can get these as per: http://www.red-gate.com/supportcenter/C ... _files.htm / comments
Many thanks for your post.
It sounds like you may be encountering a known issue when the server you are monitoring is on a different domain. Plese see the following knowledgebase article:http://www...
Have you deslected this option?
In SSMS 2008 Tools --> Options --> Text Editor --> Transact-SQL --> make sure to deselect option 'Auto list members'
If you deselect this option it should not show up native intellisense? / comments
Have you deslected this option?
In SSMS 2008 Tools --> Options --> Text Editor --> Transact-SQL --> make sure to deselect option 'Auto list members'
If you deselect this option it should not show u...