Activity overview
Latest activity by aseniuk
We found out what was the issue, our IPS was blocking the traffic going through via WMI. So just remember even when you allow the traffic on your firewalls that something else may think it is not a good idea. / comments
We found out what was the issue, our IPS was blocking the traffic going through via WMI. So just remember even when you allow the traffic on your firewalls that something else may think it is not a...
Just to note we have tried IP, full URL and short NetBIOS naming.
Chris Spencer wrote:
Hi Adam
Apologies for this. I've looked into this error and the vast majority of online advice suggests that it's either a firewall or DNS issue.
It doesn't look like you've missed any ports on your firewall so it might be worth trying with ip addresses rather than the server names if you haven't already. I realise that with 90 servers this would only be a short-term solution but I believe it would confirm a DNS issue if there is one.
Also the page where I found this suggestion is full of useful WMI information - http://technet.microsoft.com/en-us/libr ... 92772.aspx
Please let us know if this helps.
Regards
Chris
/ comments
Just to note we have tried IP, full URL and short NetBIOS naming.
Chris Spencer wrote:
Hi Adam
Apologies for this. I've looked into this error and the vast majority of online advice suggests that ...
We are currently opening a support case with microsoft as our network is a bit more complicated then most. I will post any relevent information as to a fix just incase someone else gets the same issue when using WMI (RPC) over subnets within the same network with firewalls protecting the environments.
RPC Error 0x800706BA / comments
We are currently opening a support case with microsoft as our network is a bit more complicated then most. I will post any relevent information as to a fix just incase someone else gets the same is...
WMI & RPC Not working across subnets
Hi All,
We are trying to setup the red gate SQL monitoring tool to monitor 90 SQL servers but after running through http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Testing_dat...
Multiple Base Monitors
Hi All,
I have a secure environment where we have multiple areas where I need to collect data from the base monitors. Is there any way to pull the data from multiple base monitors?
Second option co...
SQL 2008 R2 CTP Not Supported
Hi all,
I just installed SQL Search beta on my system and now the add-in crashes my server management studio. I think they must have changed how they configure add-ins as it no longer works.
Thanks...
You will need to make a hot fix for the application to include this text
<HostApplication>
<Name>Microsoft Visual Studio Macros</Name>
<Version>10.0</Version>
</HostApplication>
<HostApplication>
<Name>Microsoft Visual Studio</Name>
<Version>10.0</Version>
</HostApplication>
in the file VSUI.AddIn
Thanks. / comments
You will need to make a hot fix for the application to include this text
<HostApplication>
<Name>Microsoft Visual Studio Macros</Name>
<Version>10.0</Version>
</HostApplication>
<HostApplication>
<...
Unfortunately that didn't work. I ran the commands and reset visual studio.
Just to note, %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 4\RedGate.SQLPrompt.VSUI.dll" should be %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles(x86)%\Red Gate\SQL Prompt 4\RedGate.SQLPrompt.VSUI.dll"
Is there something else I need to do during the install? / comments
Unfortunately that didn't work. I ran the commands and reset visual studio.
Just to note, %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 4\RedGate.SQLPro...
Got a new box and tryed this again (Winodws 7), I installed SQL Server 2008, Visual Studio 2010 (Beta 2) and then installed SQL Prompt, I get SQL prompt in SQL server management studio but I still do not see the SQL Prompt 4 menu in Visual Studiio 2010.
2 things to note are, I am running a 64 bit edition of Windows 7 Enterprise and I am running the client for SQL 2008 R2 CTP.
If any one has any ideas or command line suggestions to get SQL prompt into Visual studio I would be happy.
Note: It seems that SQL 2008 R2 CTP doesn't like SQL Refactor. Just FYI. / comments
Got a new box and tryed this again (Winodws 7), I installed SQL Server 2008, Visual Studio 2010 (Beta 2) and then installed SQL Prompt, I get SQL prompt in SQL server management studio but I still ...
Column Data Referenced / Selected by Another Columns Data
Hi All,
I was wondering how I would do something like this. Lets say we want to get the gender of the person or rather select the gender first then fill in an appropriate name based on the gender.
...