Friday, February 25, 2022

SQL Server 2008 R2 SP2 Is Now Available!

SQL Server 2008 R2 SP2 Is Now Available!

Microsoft SQL Server 2008 R2 SP2 also addresses a few key customer requests:

  • Reporting Services Charts Maybe Zoomed & Cropped 
    Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped. To work around the issue some customers set ImageConsolidation to false.
  • Batch Containing Alter Table not Cached 
    In certain situations with batch files containing the alter table command, the entire batch file is not cached.
  • Collapsing Cells or Rows, If Hidden Render Incorrectly 
    Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed. When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.

Please go through this link :

http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/07/26/sql-server-2008-r2-sp2-is-now-available.aspx

Submitting change to set timed out

I'm trying to edit the filter for the "Password Reset Users" set. I'm using the gui wizard and all I want to do is change the "User with any of the conditions below" to "user with all of the conditions below".

Some details: the current filter has all my user objects in it (28.000+). I'm not sure whether this amount impacts setting the change. In the SQL tracer I can see that this specific query took 57999 ms (57 seconds).

The Portal UI shows "summary: edit set", "status: Timed Out".

The event log on the portal server:

The Portal cannot connect to the middle tier using the web service interface.  This failure prevents all portal scenarios from functioning correctly.
The cause may be due to a missing or invalid server url, a downed server, or an invalid server firewall configuration.
Ensure the portal configuration is present and points to the resource management service.

Requestor: urn:uuid:7fb2b853-24f0-4498-9534-4e10589723c4
Microsoft.ResourceManagement.Service: System.NullReferenceException: Object reference not set to an instance of an object.

P.S changing settings to other sets works okilidokely. Also doing a view members on the "password reset users" works ok. Backups run regulary and DB maintance has been performed (rebuild index, update statistics).

Any thoughts?


http://setspn.blogspot.com

Reply:

I have seen this before. you need to increase your timeouts for this operation. Afterwards you will want to change it back, unless this is an admin partition

http://technet.microsoft.com/en-us/library/ff800821(WS.10).aspx

/configuration/ resourceManagementService/ @dataReadTimeoutInSeconds

[0,inf)

58

The timeout used in all SQL select commands.

/configuration/ resourceManagementService/ @dataWriteTimeoutInSeconds

[0,inf)

58

The timeout used in all SQL update, insert, and delete commands.

 

If it still timeoust you might also need to modify

/configuration/ resourceManagementClient/ @timeoutInMilliseconds

[0,360000]

90,000

The timeout of the client side of communication.


David Lundell, Get your copy of FIM Best Practices Volume 1 http://blog.ilmbestpractices.com/2010/08/book-is-here-fim-best-practices-volume.html

------------------------------------
Reply:

Seemed like a good tip.

I tried them one by one (starting with the read and gradually adding the others) so my config now looks like:

...
    </services>
  </system.serviceModel>
  <resourceManagementClient resourceManagementServiceBaseAddress="fimsvc.domain.tld" timeoutInMilliseconds="120000"/>
  <resourceManagementService externalHostName="fimsvc.domain.tld" dataReadTimeoutInSeconds="120" dataWriteTimeoutInSeconds="120" />
  <system.diagnostics>
    <sources>
...

If I stopwatch between "submitting" and gettting "timed out", I have exactly 60 seconds. No matter what the above parameters are.

I'm now having this behavior on two sets. So i created a new dynamic set: succeeded. I altered the dynamic membershop to a different filtered: worked. Back to my bad sets: timed out again...

So I haven't got any further now. Any further tips are appreciated.


http://setspn.blogspot.com

------------------------------------
Reply:

After googling a bit (using the parameters you provided) I came upon: http://technet.microsoft.com/en-us/library/ff608271(WS.10).aspx

So the resourceManagementClient section was overruled by my web.config section which had 60.000 specified. Changed that to 120.000, and now it takes two minutes before timeout.

So no real solution there...


http://setspn.blogspot.com

------------------------------------
Reply:

I wouldn’t say I solved the problem, but I’ve definitely got my set configured as I want it…

 

I followed: http://blogs.msdn.com/b/darrylru/archive/2010/02/02/extending-fim-timeouts.aspx

Which is in fact also described at: http://technet.microsoft.com/en-us/library/ff608271(WS.10).aspx

 

By coincidence I also had to reboot some servers in the FIM topology (some non-fim-related hotfixes had to be installed). After a reboot I was able to do a change just once, but then the issue resurfaced. So changing the timeouts didn’t really help. The Test I was trying to make currently had a 28.000 users in it scope, and had to get a new filter which consisted of “User with all of the following: not accountType = bla; not Language = a; not language = b; not language =c”. Each time I was getting either request failed or request timed out.

 

Creating a new set with the exact same filter posed no problem. Performing changes to that set also posed no problems… And then I started gradually creating the filter. I added “not accountType = ble”, clicked submit. Watched my SQL CPU spike a bit and it got through. And so I added the clauses one by one…

 

So I’m guessing our virtual SQL (lab environment) is being to slow somewhere. What I don’t get that all other portal interactions are fairly responsive. The preview for that exact set worked as expected. And creating/editing other sets went just fine….

 

I though Id write this for future reference…

This seems related too: http://social.technet.microsoft.com/Forums/en-US/ilm2/thread/e7611d18-8988-4e77-bf15-762be36244da


Regards,
Thomas

 


http://setspn.blogspot.com

------------------------------------
Reply:

Increasing the SQL read and write timeouts fixed this problem for me. I haven't bothered increasing the web timeout, so I still get the Set popup timing out after 60 seconds, but in the background the update completes, so I'm fine with that.

I modified the file C:\Program Files\Microsoft Forefront Identity Manager\2010\Service\Microsoft.ResourceManagement.Service.exe.config

<

 

resourceManagementService externalHostName="fimserver.mydomain.local" dataReadTimeoutInSeconds="360" dataWriteTimeoutInSeconds="360" />


http://www.wapshere.com/missmiis

------------------------------------
Reply:

Quick question on this one,

If the FIM Service is installed on a separate server to the FIM Portal, is the externalHostName value in the config file the Service server or the Portal Server??

Cheers

Rob


------------------------------------
Reply:
that would be the FIM Service Server.

http://setspn.blogspot.com


------------------------------------

Split for format

Hi Nina,

I'd like to confirm if you have installed all the latest updates for the Lync client?


Max Meng

TechNet Community Support

  • Split by Max Meng Friday, July 27, 2012 6:51 AM Split for format

change preexist button caption in sharepoint designer 2010

hi

 

i want to change the default text on the button in the newpost.aspx page but i couldn't find the button on the page . when i select the button the whole webpart is highlighted. please help me on .


Reply:

------------------------------------

Split for format

I couldn't register the account with Google Blogger/blogspot blog, even in Word 2010. But the other blog provider would work.

For now, the workaround might be use the other blog provider, or copy and paste the content to your bloger...


Max Meng

TechNet Community Support

  • Split by Max Meng Friday, July 27, 2012 5:55 AM Split for format

SQL 2008 Cluster adding a node to an existing sql cluster!

Hey there,

I have SQL 2008R2 enterprise active passive 2 node failover cluster. The active node is a high-end intel server and the passive node is low-end, so i wanna replace the low-end passive server to a new high-end server. So, for that purpose should i have to remove the existing passive node first from the cluster , or i have to add the new server to that failover cluster and then remove the passive one ?

 

Many Many thanks,


  • Changed type Ishuv Monday, November 14, 2011 6:12 AM
  • Edited by Ishuv Monday, November 14, 2011 6:18 AM

Reply:

Hello,

You can remove the passive node first, then add the new node.

http://msdn.microsoft.com/en-us/library/ms191545(v=SQL.100).aspx

Hope this helps.


Regards,

Alberto Morillo
SQLCoffee.com


------------------------------------
Reply:

Hi Alberto,

Thanks for your reply.

 

Regards,

Ishuv Baidhya


------------------------------------
Reply:

Hi Alberto,

For the windows 2008 cluster first of all i should configure a windows cluster, so within an existing cluster how can i remove the old machine and add a new one on 2 node cluster. My query is if i remove a node from a 2 node windows cluster will the cluster be stable or will it work from 1 node?

Thanks, Ishuv


Many Many Thanks, Ishuv


------------------------------------
Reply:

Hello,

When you create a cluster on Windows Server 2008 you start creating the cluster with one node (if you want), then you add nodes to the cluster. You can
remove nodes without any issues and leave the cluster cluster with one node, then add new nodes again.

http://blogs.technet.com/b/mdegre/archive/2009/12/28/installation-of-sql-server-2008-clusters-on-windows-2008-step-3-installation-of-the-first-node.aspx?us

http://blogs.technet.com/b/mdegre/archive/2009/12/29/installation-of-sql-server-2008-clusters-on-windows-2008-step-4-add-a-new-node.aspx?us  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com


------------------------------------
Reply:
thanks i will try it.

Many Many Thanks, Ishuv


------------------------------------

Split for format

Hi Aussie, 

For the "read only", there are two common cause:

  • Office 2010 has introduced the Protected View, which is a read-only mode and most editing functions have been disabled.
    Read more about the Protected View:
     
    http://office.microsoft.com/en-us/excel-help/what-is-protected-view-HA010355931.aspx
  • There seems to be a known issue, when the Preview Pane is enabled in Windows 7, some documents created by the earlier version of Word would become Read-Only. The workaround is to disable the Preview Pane in Windows.

     

For your situation, I'd suggest to download and install the trial of Office 2010, try to open your documents with it. You can make a copy of your documents if you worry about unexpected problem. And if you have any compatibility issue when using Word 2010, feel free to reply on this post so we can follow up with you.

Download the trial from: http://office.microsoft.com/en-us/products/

 

Also, for end-user specific topic, the Answers community is even more suitable:

http://answers.microsoft.com/en-us/


Max Meng

TechNet Community Support

  • Edited by Max Meng Friday, July 27, 2012 4:50 AM
  • Split by Max Meng Friday, July 27, 2012 4:53 AM Split for format

IE9

My computer says I already have a newer version when I try to down load IE9. I can't find it anywhere on my computer. The closest I get is in "all programs" I type in Internet explorer, but all I see is IE with add ons disabled. My default browser is firefox and I don't want to change, but I want to have IE available by way of a shortcut on my toolbar. As it is, I have no way to open IE.

Reply:

Uninstall ie9,<o:p></o:p>

http://support.microsoft.com/kb/2579295/en-us<o:p></o:p>



------------------------------------
Reply:

Hi,


Please press Windows Key + R to open Run command prompt.


In the box, please input iexplore.exe and see if you can open Internet Explorer.


Also, you can navigate to C:\Programe Files\Internet Explorer and run iexplore.exe.


Hope this helps.


Jeremy Wu

TechNet Community Support


------------------------------------

Links list - best practice

I would like to create a links list where the links are opening in a new window, what is the best practice?

I found different solutions:

- edit the list in Sharepoint Designer
- add javascript on the page
- create a new list template

or do you have a  better solution?


Reply:
We had a same requirement and for this I created a list using Link List template and added a new boolean type column to it for e.g. "Open in New Window". If user would like to open a link in new window then they have to select this check box. Then I applied custom XSLT to this list to open links in new window if this users have selected this checkbox.

-Prashant


------------------------------------
Reply:

Does it have to be a list?

A quick solution may be a content editor web part just select 'open in new tab' in link  options when creating the links.


ceren


------------------------------------
Reply:

Hi,

Edit the page and add a hyperlink:

<a href="javascript:var options = {url: 'url page', title: 'Your page title'}; void(SP.UI.ModalDialog.showModalDialog(options))"> Your link </a>  

Regards.

Tomás González. Twitter://@tgmourino


------------------------------------
Reply:

@cernn

Yes, because the list contains sometimes more then 100 links so it's easy that you can order the list.

At the moment I created a new list template and edited the xslt, but don't know if that's the best solution.


------------------------------------
Reply:

there is an easier way suggested here:

http://blog.animesh.co.in/2009/06/open-sharepoint-link-list-item-in-new.html

(Scroll down to 'If any of the above metho doesn't suit your taste, and in case you are a JavaScript fan, there is an easy process to acheive this:...')


ceren


  • Edited by ova c Friday, May 18, 2012 9:13 AM

------------------------------------
Reply:

The problem for this is that the summery name must be the same for every list, or i have to change the code for every table.

with changing code i mean this line:

...  if(tbl[i].getAttribute("Summary") == "Links")  ...

So isn't it better to use the list template?


------------------------------------
Reply:

If you have Publishing Features activated in your site you could you a Content Query Web Part.

First, you need to create a custom Item Style in ItemStyle.xsl in the Style Library at the Site Collection Level.

In the page where you want to display the List just add a Content Query Web Part and configure it to display items from your link list, and in Presentations select your custom style.


Denis Stadler MCT | MCTS | MCITP | MCDBA www.denisstadler.pro | www.stadler.pro


------------------------------------
Reply:

I'm new for xslt and styles, but when i create a content query web part by default there is no view to see all the links and open them. I have a list and when you click on it it opens the item...

I saw the option "Field to display", but i can't get the url link and the url description. Can't find the correct name to use for url link and url description...

Could someone give me a small example of the xslt for a links list? Just a default view as a normal list without the content query webpart. Once i have that i can start i think.

tnx in advance


------------------------------------
Reply:

<td>
    <a href="{@URL}">
     <xsl:value-of select="@URL.desc"/>
    </a>
</td>

The field name is "URL" and the type is "Hyperlink or Picture". The point is give an anchor tag <a>  with href attribute as the link and let its body/inner text contain the xsl:value-of select which can have the description from the field.

#N.B. : A field (e.g. fieldName)  Hyperlink or Picture  has fieldName.desc which can be used in XSLT.


------------------------------------

Issues with second DPM server

HI

I am testing replicating some of my pg's to a second site with dpm 2010. On a whole its going well but on a couple of member in the pg's I have to run a consistency check every morning on the secondary backup dpm server. It is always the c: of machine within the pg's and once I run a consistency check manually there then fine? I have 7 pg's on the secondary dpm and 5 are fine but it happens to the same 2 every time? The error I always get is below?

Affected area:    C:\(server.blah.com)
Occurred since:    26/07/2012 04:04:09
Description:    Recovery point creation jobs for Volume C:\(server.blah.com) on server.blah.comk have been failing. The number of failed recovery point creation jobs = 1.
 If the datasource protected is SharePoint, then click on the Error Details to view the list of databases for which recovery point creation failed. (ID 3114)
Date inactivated:    26/07/2012 09:52:11
Recommended action:    No action is required because this alert is inactive.


Reply:

Hi,

Please include the delails of the failed jobs.


Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.


------------------------------------

I Need To Know All Of The Win Phone 8 Functions That Anybody Knows! Please Read Microsoft!

I Am A Windows Developer And I Need To Know As Much About The Win phone 8 Functions As You Know!

I Am Getting A Windows 8 Phone When It Comes Out So I Can Develop Apps; I need to know all the new functions anybody ever knows So I Can Make Great Apps!


Reply:
CEM1272 --
 
You have erroneously posted your question in a public forum dedicated to Microsoft Project, a project management tool.  Please repost your question in a more relevant forum, such as one of the forums shown at the following site:
 
 
Hope this helps.
 

Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


------------------------------------
Reply:

What Is The forum Name?


I Don't Know Which One To Post In!!
  • Edited by CEM1272 Thursday, July 26, 2012 5:05 PM

------------------------------------
Reply:
CEM1272 --
 
Well, how would I know which forum is right for you?  Why don�??t you just click on the link for each of the forums listed and study the questions asked by users in each forum?  Perhaps you can find the correct forum that way.  Or, why don�??t you post your question in one of those Windows 8 forums and let the users direct you to the right forum?  Hope this helps.

Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


------------------------------------

TROUBLESHOOTING: Event ID: 1000: Faulting application name: miiserver.exe, version: 4.0.2592.0, time stamp: 0x4b6790ea

TROUBLESHOOTING: Event ID: 1000: Faulting application name: miiserver.exe, version: 4.0.2592.0, time stamp: 0x4b6790ea

http://social.technet.microsoft.com/wiki/contents/articles/12632.troubleshooting-event-id-1000-faulting-application-name-miiserver-exe-version-4-0-2592-0-time-stamp-0x4b6790ea.aspx


Tim Macaulay Security Identity Support Team Support Escalation Engineer

Move DNS (AD)

Long story short, the DNS service isn't working correctly.

What I want to do is set up another DNS Service (DNS Only, no AD Service) that will run all the zones currently being handled on the Active Directory Server. The Active Directory Server currently handles everything.

This is what the network services currently looks like.

SERVER 1

AD DS, AD FS 2.0, DHCP, DNS, IIS (Running Web Services for management).

---

This is how I want it to look

SERVER 1

AD DS, AD FS 2.0, DHCP, IIS

SERVER 2

DNS

---

I've always managed networks where DNS was being served from the same server as AD DS. I've never seperated them before. I'm assuming it's possible. I'm also assuming that all I need to do is bring up a Win2008 R2 server, attach it as a Member Server to the domain, and add it as a secondary DNS to do a domain transfer. Then I need to upgrade it to be a primary DNS, move all the clients to use the new DNS then uninstall DNS from SERVER 1. Am I correct?


Owner, Quilnet Solutions


Reply:

Sure, you can do that, and I would rather see the new DC also have DNS installed and replicate the zone. But the question is, why do you believe that DNS is not working correctly? DNS simply just works, and works fine, on a DC, and is especially designed to do so, taking advantage of the security (Secure updates, not stored in a text file, and replicates to other DCs for fault tolerance), and robustness of AD integrated zones.

There are a number of things that can cause DNS to have problems on a DC. One of the most popular reasons is a multihomed DC (more than one IP, more than one unteamed NIC, RRAS installed, IP routing enabled, WINS Proxy enabled, iSCSI adapater on it, etc). There can be other issues, and if DNS is not running properly, it *will* affect AD functionality. SInce your DC is up and running and clients are able to log on and access resources, it may be a simpler issue.

.

Let's see an ipconfig /all from the current DC and any event log errors, so we can assist to fix whatever is ailing the DC.


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:

We are not interested in further trouble-shooting. We have been on this for 3 weeks. This isn't a multihomed server, it's not a RRAS server, We don't use WINS or WINS proxy and I've never heard of iSCSI. We have been thru everything. This includes resetting the entire DNS database file and re-populating it. After we pulled this DNS server from rotation everything went back to normal. We know it's the DNS service. What we are going to do is pull in a new DNS service to run with this server's AD DS system. Once we know the new DNS server is working correctly we will uninstall this DNS Server. At a later time we will either attempt to reinstall the DNS Service on the AD DS system or we will remove this AD DS system completely and flatten the machine for a rebulk.

I just need to be sure we can seperate the DNS service from the AD DS system.


Owner, Quilnet Solutions


------------------------------------
Reply:

Yes, you can.

I/we are offering to assist to troubleshoot it, but I understand if you don't want to take it further.

Another option is to simply just zone transfer it over to the other server as you're doing, but taking it further, since you believe DNS on the DC is corrupted, then uninstall DNS off the DC, restart, then reinstall it, zone transfer it back, then change the zone to AD integrated.

Please let us know how things work out afterwards, whichever method you use.


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:
That is the plan. We already transfered the zone to the newly created DNS server and already uninstalled the DNS service from the AD server. We are going to hold for a few days to be sure everything else continues to work before we reinstall DNS. If reinstalling DNS doesn't work, I've been authorized to flatten the machine. I'll let you know what the results are next week.

Owner, Quilnet Solutions


------------------------------------
Reply:
Looking forward to your results.

Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:
We re-installed DNS services on the AD server and have been running it for 2 days now. The issue isn't resolved BUT it's not as bad as it was. I'm probably restarting DNS about once a day instead of 4 times an hour. We will probably rebulk this system next month.

Owner, Quilnet Solutions


------------------------------------
Reply:

Thank you for the update. Interesting this is still occuring. Apparently there must be a corrupted or modified system DLL.

If interested in pursuing this possibility, you can run the System File Checker.

How to use the System File Checker tool to troubleshoot missing or corrupted system files on Windows Vista or on Windows 7
http://support.microsoft.com/kb/929833

Description of Windows XP and Windows Server 2003 System File Checker (Sfc.exe)
http://support.microsoft.com/kb/310747


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:

Yeah, we thought of that over the weekend and ran a SFC. It didn't come up with anything though. We think the problem lies in a registry setting.

I got word earlier today that before this system was given to me for AD DS, it was used in another department for RRAS. RRAS was removed from the system prior to my department receiving it but the OS wasn't wiped. I'm wondering if MAYBE there is a registry setting that got set when RRAS was on it that wasn't reverted when RRAS was removed.

The only problem with my theory however is that this system has been running AD DS without problems for 9 months. The issue only recently surfaced.

Now that I have a backup DNS that I can use in the event of a problem, we can probably do more TS if you have more for me.


Owner, Quilnet Solutions


------------------------------------
Reply:

Maybe a TCP reset? Have you done that?

Basically, it's:
netsh int ip reset logfile.txt
Then restart.

How to reset "Internet Protocol (TCP/IP)" in Windows Server 2003
http://support.microsoft.com/kb/317518

Or use the Mr.FixIt script in the following KB:

How to reset Internet Protocol (TCP/IP)

http://support.microsoft.com/kb/299357

.

.

One more thing, if RRAS was installed, and there was a RRAS filter in conjunction with a corrupted reg key, that could cause it, too. If the above doesn't help, then take a look at resetting the Winsock, since it's a DC:
netsh winsock reset

And this article gives you all the TCP registry keys to delete and reset. It's pretty comprehensive.

How to remove and reinstall TCP/IP on a Windows Server 2003 domain controller
http://support.microsoft.com/kb/325356

More info on the above:

Technet thread: RRAS doesn't start. Error 8007042a. EventID 20103
http://social.technet.microsoft.com/Forums/en/winserverNIS/thread/14c70bd9-3db8-4cae-b63f-361df4b7b939

.


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:
No, we haven't tried that yet. I'm going to wait until the issue occurs again as I don't want to "stir the pot" until we really need to. I'll let you know what the results are when we run it.

Owner, Quilnet Solutions


------------------------------------
Reply:
Sounds good.

Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:
We are trying to TCP/IP reset. I'll let you know the results. I didn't reset Winsock just yet. I'm gonna wait and see if the TCP/IP reset does anything first.

Owner, Quilnet Solutions


------------------------------------
Reply:
And the plot thickens...

Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:

Ok so, we did the Winsock reset when the TCP/IP failed. Restarting the server after running the netsh winsock reset how has the DNS service stopped. When attempting to manually restart the DNS service I get "An address incompatible with the requested protocol was used." I also receive this error when looking at DHCP. What's interesting is that the server still has an internet connection even when it's using itself as the only DNS source.

I'm not familar with this error message so hopefully you have something. I thought maybe I needed to reset the interfaces in DNS but without having the service running I cannot access the Interfaces page on the DNS settings.


Owner, Quilnet Solutions


------------------------------------
Reply:

That's under an Event ID 7023, right? Let's re-run netsh winsock reset, then reboot.

Ref:

Scroll down or search for the string to "an address "
http://eventid.net/display-eventid-7023-source-Service%20Control%20Manager-eventno-345-phase-1.htm

Could not start the windows firewall/internet
http://www.techspot.com/community/topics/could-not-start-the-windows-firewall-internet.16323/


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:

To confirm, netsh winsock reset is what caused the "An address incompatible with the requested protocol was used." error. Are you saying you want me to run it a second time?


Owner, Quilnet Solutions


------------------------------------
Reply:
So, we ran the netsh winsock reset command a second time and rebooting and we are getting the same result. One of other IT guys said "Hey, lets uninstall and reinstall DNS" so we tried that. Uninstalled ok, restarted, but when we attempted to reinstall DNS we got the following failure code: 0x80070643.

Owner, Quilnet Solutions


------------------------------------
Reply:

I saw your other post before it was deleted. I was suggesting to retry it. I see you did. At least now with this error, we are getting closer to whatever is going on. See if this helps - applies to 2003, too.

.

Error code when you try to install the DNS server role if all network adapters are disabled or unplugged on a computer that is running Windows Server 2008: "0x80070643"
http://support.microsoft.com/kb/975654

.

Thread: "Attempt to install DNS Server failed with error code 0x80070643. Fatal error during installation"
http://social.technet.microsoft.com/Forums/en/winservergen/thread/17198d26-7ffb-4214-9d9f-f8e1e2818e14

.


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------
Reply:
I was already ahead of you but when I ran the pkgmgr I got error code 0x80070643.

Owner, Quilnet Solutions


------------------------------------
Reply:
I'm being told we are not pursuing this issue further. They don't want to spend any more resources on this since we've hit the 4 week mark. They are reverting the server state back two days and are going to install a temporary server to host what this server hosts, then wipe and reload.

Owner, Quilnet Solutions


------------------------------------
Reply:

Sorry to hear that. But since this is a DC, you don't want to do a revert., assuming you're referring to the virtualization revert feature and not a true System State restore, or you will introduce another complexity.

Check out this thread that a guy did just that and is now beleaguered with a USN rollback and an unusable DC.
http://social.technet.microsoft.com/Forums/en-US/winserverNIS/thread/209bc176-2213-4db0-a561-28c8c9d9a6bf/

.


Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This post is provided AS-IS with no warranties or guarantees and confers no rights.

FaceBook Twitter LinkedIn


------------------------------------

How to create an FTP with multiple users having own private content?

I want to host an FTP site in my local network at my workplace.

There are multiple users with each having its personal data. I want to authenticate every user with unique username and password, so that a particular user will have access to his own folder and the public folders only.

I have made a working FTP site for anonymous authentication.

how shall I make it for particular users?


Reply:

Hi Tanay N,

not sure what Windows version you have. In Windows 2008 R2 the users can just log on to ftp using there AD credentials. In the FTP root create a folder for each user and set the proper permissions.

Regards,

Lutz


------------------------------------

access denied windows7

overcommin access denied message on windows7


Reply:

Hi CAC2234,

do you have more information, otherwise it is impossible to give you a advice at all.

Regards,

Lutz


------------------------------------

Cannot Change Agent Profile through Replication Monitor

I have a PULL merge subscription set up and a stand alone publisher and stand alone distributor, so 3 servers in all and I was able to create a user defined agent profile just fine but when I try to assign my merge subscription to it I get the following using replication monitor.  Google and Bing have not turned anything up as to why this may be happening.  Wondering if this is a bug or by design or any links to more information on this topic



Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz


Reply:

May you elaborate more information about :

  • Version & edition of publisher

  • Version & edition of subscribers

Did you try push subscription which might  help in compromising conflicts might take place between distributor and Subscriber


Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities


------------------------------------
Reply:
Would this be SQL Express clients? Perhaps a default profile would work for you?

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941


------------------------------------
Reply:
No these are SQL 2012 Developer Edition Subscribers, I have just never seen this error and not sure what is causing it


Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz


------------------------------------
Reply:
Is this on Windows 8?

Brandon Williams (blog | linkedin)


------------------------------------
Reply:
Hi Brandon, this is Server 2008 R2 running SQL 2012 RTM Developer.  I think the issue is these are PULL subscribers as I can change the profile fine on PUSH subscribers


Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz


------------------------------------
Reply:
Anyone have any more ideas, I am going to open a connect item for this


Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz


------------------------------------

Access 2007 - Export to PDF/XPS Broken

Hi there,
Very recently (over the past DAY!) something has changed and affected Access 2007 Export to PDF. All the computer in my office now produce this, however I'm unsure which update caused it, or if there's a way to fix it.

I am able to run my reports no problem, view them locally inside Access using Print Preview and they look fine, however once exported to PDF the charts look as if they were half rendered. The "Pie" chart isn't a circle, it's a bunch of colored squares all over the place and some point graphs don't show up.

I ran Windows Update to see if maybe there was another update missing, but nothing. Says I'm up-to-date. Ran Adobe updater, thinking maybe it's an Adobe rendering issue. Found 1 update, updated and still no change.

Has anyone run into this problem? Maybe this is a midigation thing for future versions, but it's quite unfortunate to happen at this moment cause my office almost lives off these reports. Anyone able to suggest any kind of quick-fix? Anyone run into this yet? Can't change the graphs because the only options for charts are these Office 97 looking things.


Regards, Chad Garrett

Reply:

Just in case anyone else runs into this issue, I fixed the problem but Uninstalling the following updates for Office XP

  KB974556 and KB976380

Works perfect again!


Regards, Chad Garrett

------------------------------------
Reply:

@Chad,

I'm using Windows 7 and I don't have those updates on my computer, but I'm having the same problem described above. Any ideas on how to fix this issue?


------------------------------------

How to track/change access provided through SID History?

Hello there,

My question is completely summarized into the title but here are the details:

Currently, Access Reviews are made in the following manner;

- Servers have the DUMPs of what group and access is applied to every resource;

- Membership of every group is tracked and controlled through databases;

This kind of tracking is automated and every owner has a pretty good report through a GUI of the resources they own and who's applied there (e.g. Directory -> Local Group -> Global Group -> User IDs), they can choose to add/remove accounts on these groups and consequently change access to the resources.

After I move an account from domain A to domain B usind ADMT. If the accesses previously granted through Global Groups are kept through SID History, how can we keep track of that during Access Reviews and how can I change the SID History later if the attribute is protected? (i.e. remove one of the retained accesses).

AutoRefreshInterval does not work on a 2010 Foundation Hosted Anonymous Site - Only when you log in

I am working on a SharePoint Foundation 2010 hosted site with anonymous access.  I created a webpart in Designer using Display Item Form and selected 15 as the Refresh Interval and confirmed that the parameter is in the code.

When I access the page in a browser anonymously, the refresh does not work.  However, when I log into the site as a site collection administrator, the refresh works as expected every 15 seconds.  I have not yet experimented with different permission levels...

I've searched these forums as well as the WWW for any documentation on the AutoRefreshInterval parameter with respect to permissions and have had no luck.  Has anyone else experienced this issue and perhaps knows of a fix?  Thanks,

-Richard.

<more information added>

Here's an interesting test result.

I went into the Web Part Properties and Under the Ajax Controls, I enabled the Enable Asynchronous Load option.  Now, when I access the page anonymously, I am prompted for an ID and password.  I uncheck that option, I can load the webpart anonymously.

When I am logged in as a SCA and try to access the page with the Enable Asynchronous Load option checked, I do not get a prompt but instead get the green loading animated icon and the web part does not load.  If I uncheck that option and refresh the page, the web part comes right up.

Could the functions running the Enable Asynchronous Update option be the same as the Enable Asynchronous Load option?  If so, then of course the webpart is not going to refresh when you accessing the page anonymously. 

Does anyone know of a way to allow the anonymous user to access the Asynchronous Load function?  Thanks,

-Richard.

<Update>

It was my own fault!  I forgot I had security trimmed some items (like the quick launch) and when I reverted the masterpage back to the default, the Auto Refresh works as it is supposed to.

Now I need to go back and find out exactly what piece I need to expose to get this to work...






Reply:

Hi

check this doc

http://support.microsoft.com/kb/979632


Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.


------------------------------------
Reply:

Wow!  Thanks for the very quick response!!!

But that configuration is exactly what I have right now.  I unchecked it just in case, but that didn't change anything when i was logged on anonymously, so I changed it back and still no luck.

I think it is a permissions issue, not a JS issue, unless the JS is permissions controlled?

-Richard.

--

This problem occurs because the JScript code for the automatic refresh is not processed.

To work around this problem, configure the Web Part or the regular list in Microsoft SharePoint Designer 2010. To do this, follow these steps:
  1. Open the page that contains the virtual List Web Part in Microsoft SharePoint Designer 2010.
  2. Click Edit file.
  3. Click the Web part.
  4. On the Options tab, click to select the Asynchronous Update check box.
  5. Click the Refresh Interval drop-down list, select an interval, and then save the settings.


  • Edited by _Richard_D_ Wednesday, July 25, 2012 3:03 PM

------------------------------------
Reply:

Here's an interesting test result.

I went into the Web Part Properties and Under the Ajax Controls, I enabled the Enable Asynchronous Load option.  Now, when I access the page anonymously, I am prompted for an ID and password.  I uncheck that option, I can load the webpart anonymously.

When I am logged in as a SCA and try to access the page with the Enable Asynchronous Load option checked, I do not get a prompt but instead get the green loading animated icon and the web part does not load.  If I uncheck that option and refresh the page, the web part comes right up.

Could the functions running the Enable Asynchronous Update option be the same as the Enable Asynchronous Load option?  If so, then of course the webpart is not going to refresh when you accessing the page anonymously. 

Does anyone know of a way to allow the anonymous user to access the Asynchronous Load function?  Thanks,

-Richard.


  • Edited by _Richard_D_ Thursday, July 26, 2012 8:58 PM

------------------------------------

New Version Released

A new Version 3.21.1767 (http://www.piriform.com/ccleaner/download) of the free CCleaner system cleaning utility has been released. The changes in this version include improved Startup tool, Drive wiper and System Restore discovery, added support for Universal Extractor and Internet Download Manager, along with various minor improvements and bug fixes.


Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com


Reply:

Warning: Don't use  a registry cleaner.  You never know what it does and may cause much problems. Since Windowx XP: Only Registry Hives are loaded, wich are used by an application. There is no performance improvement at all.

Some of such tools are simply vapoware. You should know that.


------------------------------------
Reply:
No offense drew but I totally agree with Zahni. They cause way more problems and never fix anything.



------------------------------------
Reply:

I do not advocate or recommend Reg cleaners, even discourage most people from messing w/ the Reg, @ all.  But, though, one sees 'debate' regarding CCleaner... it is not usually seen in the same sphere as 'those nasty Reg cleaners'.  Personally, I have never seen any problem caused by it, not in my machines or those of clients or other people's.  It does get used or recommended occasionally to help 'fix' a 'problem'... for many years, personally, I treat CCleaner just as 1 part of keeping 'junk' cleared out, along w/ Internet Options & Disc Clean-up.  I do, always, suggest unchecking the Jump List item so, those stay intact.

No offense taken :) 


Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com


------------------------------------

No comments:

Post a Comment

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...