Tuesday, January 25, 2022

Event ID 55: The file system structure on the disk is corrupt and unusable. ...

Event ID 55: The file system structure on the disk is corrupt and unusable. ...

In my Hyper-V server I get an error message in the event log:

Event ID 55

The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume \\?\Volume{d8cfcca8-c935-11e1-acc4-d94f72d41a21}.

I think that the volume is an ID of a Virtual hard disk, but how do I find which one?

Things I already tried:

mountvol.exe does not list the volume;

vssadmin list writers does not show the volume.

We suspect this happens when Backup Exec makes a shadow copy of a volume as it occurs as the backups are going. But how do we see which volume on which virtual machine is corrupt?

(We have a 5-cluster Hyper-V host, cluster shared volumes based on iSCSI, runing Server 2008R2 Datacentre edition).


  • Edited by richard_artes Thursday, July 19, 2012 10:30 AM
  • Changed type Vincent Hu Thursday, August 9, 2012 9:16 AM

Reply:

If the event is generated on your Hyper-V server you should run the chkdsk utility on that server not on a virtual machine. I recommend you back up the virtual machines on the volume before you run the utility.

How to perform disk error checking in Windows XP

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


Adrian Costea - MCP, MCTS, MCSA 2003, MCITP: Windows 7

My Blog: www.vkernel.ro/blog


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

I discovered this error is generated at the same time a virtual machine of Windows 8 (consumer preview) is backed up, I think it may be related... will move this virtual machine to a different host and see if I get the same error on the new host...

To be continued.

Richard.


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

Hi,

Any updates about the issue?

 


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

I'm seeing the same error in a 3 node Hyper V cluster (2008 R2) fully patched during VM backup using DPM 2010 SP1.  Also using Iscsi CSV's. Doing a serialized backup per CSV LUN.

Hyper V nodes are monitored using SCOM that pickes up this event.

hope to do some research this week and find the root cause.

@ Richard_artes: Did you manage to figure out the root cause of this event?


Pascal Lokin


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

I have the same issue with my Hyper-V Clusters on Server 2012 R2 and CommVault. I only get the error on one of my CSVs. 

Did anyone figure out the root cause? 


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

Check for Multiple Null Registry entries with VBScript

Hey Scripting Guy,

I know questions have been asked about reading Registry keys and Values and if they exist but... My question is "How can you check for multiple keys that may or may not exist."  The basis of my question is checking if "Remote Desktop" is enabled on a computer.  There are 3 registry keys involved.  I have a script but if two keys are missing, the script only reports the 1st entry that is missing.  I even tried breaking it into different Subs to see if that would help but it has not.  I only included the 3 subs, I did not include the beginning of the script with the Declarations, Objects and Constants.

  • "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\WinStationsDisabled"
  • "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\fDenyTSConnections"
  • "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\TSUserEnabled"

Thank you.

<START CODE>

wCheckIfExists1

Sub wCheckIfExists1
strPolicyWS = ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT" _ 
& "\CurrentVersion\Winlogon\WinStationsDisabled")

On Error Resume Next
reg_value = objshell.RegRead (strPolicyWS)
Err_Number = err.number
On Error Goto 0

If err_number <> 0 Then
MsgBox "Win Stations Disabled" & VbCrLf _ 
& "Has Not Been Set",48,"Click OK To Exit"
WScript.Quit
End If
End Sub

wCheckIfExists2

Sub wCheckIfExists2
strPolicyDC = ("HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet" _ 
& "\Control\Terminal Server\fDenyTSConnections")

On Error Resume Next
reg_value = objshell.RegRead (strPolicyDC)
Err_Number = err.number
On Error Goto 0

If err_number <> 0 Then
MsgBox "fDenyTSConnections Has Not Been Set",48,"Click OK To Exit"
WScript.Quit
End If
End Sub

wCheckIfExists3

Sub wCheckIfExists3
strPolicyTS = ("HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet" _ 
& "\Control\Terminal Server\TSUserEnabled")

On Error Resume Next
reg_value = objshell.RegRead (strPolicyTS)
Err_Number = err.number
On Error Goto 0

If err_number <> 0 Then
MsgBox "TSUserEnabled Has Not Been Set",48,"Click OK To Exit"
WScript.Quit
End If
End Sub

<END CODE>


Helpful nice guy

  • Changed type Bill_Stewart Friday, March 10, 2017 10:02 PM
  • Moved by Bill_Stewart Friday, March 10, 2017 10:02 PM This is not "scripts on demand"

Reply:

Use PowerShell and things will be a lot simpler.


-- Bill Stewart [Bill_Stewart]


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

Example:

$values = @(  	@{Key = 'hklm:\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon'; PropertyName = 'WinStationsDisabled'},  	@{Key = 'hklm:\SYSTEM\CurrentControlSet\Control\Terminal Server';PropertyName='fDenyTSConnections'},  	@{Key = 'hklm:\SYSTEM\CurrentControlSet\Control\Terminal Server'; PropertyName='TSUserEnabled'}  )  foreach($pair in $values){  	if(Test-Path $pair.Key){  		$pvalue = (Get-ItemProperty $pair.Key -Name $pair.Property).$($pair.Property)  		Write-Host "KEY: $($pair.Key) Property: $($pair.Property) has value $pvalue"   }else{  		Write-Host "$($pair.Key) not found"   }  }


\_(ツ)_/


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

Exchange 2016 DLP U.S. Financial Scan missing U.S account #'s

Our DLP implementation is catching SSN , Credit Cards but not Account #'s.

We have tested with "Account number xxxxxxxx" and "Checking Account XXXXXXXX" . DLP keep's missing them.

They rules look like they should as they were default templates provided by MS.

Thoughts?

Use values from two colums in a list as a unique index

Hello,
I'm wondering how to enforce any combination of values from two list's columns to act as a unique index, maybe you guys can help?
Please get familiar with image I'm linking below. Values from columns "Urzadzenie" and "Port" are those that I want to use as a indexes. I want to avoid situation in which two rows ("3" and "9") have the same values: 'war_lx4' in Urządzenie column and 'ae0' in Port column.

Actually this list was created after exporting my Access database to SharePoint. In Access I have no problem to use values from many columns to act as a unique index but unfortunatelly after exporting to SP this functionality is gone ;/ 
I'm also wondering if there is a way to fix it in Access or I have to modify some SP settings.
https://postimg.org/image/c3g4596in/

Thank you so much in advance!

Reply:

The image is not loading for some reason.

There is no OOB option to apply unique constraint on multiple columns. You could try using JavaScript and override PreSaveAction to prevent the save if the combination exists. Refer to the following posts for more information

http://sharepoint.stackexchange.com/questions/91854/what-is-the-difference-between-presaveaction-and-presaveitem-on-sharepoint-l


Cheers,
My Blog


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

Snapshot Master - View all checkpoints, schedule checkpoints, run reports...

Hey guys, just wanted to share an applications that I've come across called Snapshot Master - lets you view all your checkpoints in one screen, and delete any you don't need. It also lets you schedule checkpoints across multiple VMs and even lets you set a date to auto delete them! Has a bunch of different reports you can run too. Plus a load of other options.

If you need to do any of these things, maybe take a look as it's saved me a few headaches.

http://www.smikar.com/snapshotmaster/



  • Edited by amary96 Sunday, February 5, 2017 10:34 AM

special character question/help

I am working on a script where it is accepting parameters from our internal erp system which is not a windows based o/s system.

All of the parameters are formatted like this: "<<MODE=SELECT>>"

My script, in theory, is to take the incoming parameters and writing them to a text file in a format like this <<MODE=SELECT>>

My issue is how to strip off the double quotes and not have the << or >> cause errors

I have found may ways to remove them but each time I remove them and run the script I get this error

<< was unexpected at this time

My script is as follows:

Update - I used a function to replace the " with a space and received the same error

echo %1 %2 %3 %4 %5 %6 %7 %8

echo %8
set p1=%~8

set dirname=C:\temp\%p1%
if not exist %dirname% mkdir %dirname%

cd C:\temp\%p1%


 
REM CREATE VARIABLE %TIMESTAMP%

for /f "tokens=1-8 delims=.:/-, " %%i in ('echo exit^|cmd /q /k"prompt $D $T"') do (
   for /f "tokens=2-4 delims=/-,() skip=1" %%a in ('echo.^|date') do (
set dow=%%i
set mm=%%j
set dd=%%k
set yy=%%l
set hh=%%m
set min=%%n
set sec=%%o
set hsec=%%p
)
)

REM ensure that hour is always 2 digits

if %hh%==0 set hh=00
if %hh%==1 set hh=01
if %hh%==2 set hh=02
if %hh%==3 set hh=03
if %hh%==4 set hh=04
if %hh%==5 set hh=05
if %hh%==6 set hh=06
if %hh%==7 set hh=07
if %hh%==8 set hh=08
if %hh%==9 set hh=09

set timeStamp=%yy%%mm%%dd%_%hh%%min%%sec%

set TextfileName = VC%timestamp%.txt

set p=%~1
@echo %p%> vcab.txt

set p=%~2
@echo %p%>> vcab.txt

set p=%~3
@echo %p%>> vcab.txt

set p=%~4
@echo %p%>> vcab.txt

set p=%~5
@echo %p%>> vcab.txt

set p=%~6
@echo %p%>> vcab.txt

set p=%~7
@echo %p%>> vcab.txt

Is there a way to do this


  • Edited by C.lyde Friday, February 3, 2017 11:16 PM
  • Changed type Bill_Stewart Friday, March 10, 2017 10:00 PM
  • Moved by Bill_Stewart Friday, March 10, 2017 10:00 PM Unan

Reply:
Please describe the problem rather than your attempted solution.

-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:
I need to remove the double quotes from the parameters and write the resultant value to a text file

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

One line'

Get-Content <yourfile> |%{ $_ -replace '"' } | Out-file newfile.txt


\_(ツ)_/


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

If you are new to scripting, you are much, much better off starting with PowerShell than with cmd.exe shell script (batch).


-- Bill Stewart [Bill_Stewart]


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

Powershell and PDF using itextsharp

I am working with success in reading PDF files using the itextsharp.dll.

Below the code fragment, which does this little miracle:

Add-Type -Path $ItextSharp     $reader = New-Object iTextSharp.text.pdf.pdfreader -ArgumentList $TestPDF    for ($page = 1; $page -le $reader.NumberOfPages; $page++) {   $lines = [char[]]$reader.GetPageContent($page) -join "" -split "`n"   foreach ($line in $lines) {   $line   }   }  

I want to do nicer things however, and here come my question:

In order to understand better the dll at hand I try the following:

$asm = [Reflection.Assembly]::LoadFile($ItextSharp)   $asm.GetTypes() | select Name, Namespace | sort Namespace | ft -groupby Namespace


but how do I arrive the the methods and object defined in the dll without desecting the C# code ? unfortunately the dll does not come with a lot of documentation, so I would like to use Powershell board tools to explore what I have in the dll file.

Question I have are: how do I know from the dll that the object I want to create is:iTextSharp.text.pdf.pdfreader ?

Thank you very much for any hint

Yours

Erich

 



  • Edited by LinuxFan999 Friday, February 3, 2017 9:59 PM
  • Changed type Bill_Stewart Friday, March 10, 2017 9:59 PM
  • Moved by Bill_Stewart Friday, March 10, 2017 9:59 PM This is not a support forum for third-party components

Reply:

Please post your code correctly.  It is a completely unreadable mess.  YOU posted html from some web page.

For iTextSharp help post in the iTextSharp forum.


\_(ツ)_/


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

Sorry for the big mess, no idea what happend. I try again:

I am working with success in reading PDF files using the itextsharp.dll.

Below the code fragment, which does this little miracle:

$reader = New-Object iTextSharp.text.pdf.pdfreader -ArgumentList $TestPDF

for ($page = 1; $page -le $reader.NumberOfPages; $page++) {  

    $lines = [char[]]$reader.GetPageContent($page) -join "" -split "`n"   

     foreach ($line in $lines) {  

        write $line  # or do something with the line  

    }

}

I want to do nicer things however, and here come my question:

In order to understand better the dll at hand I try the following:

$asm = [Reflection.Assembly]::LoadFile($ItextSharp)

$asm.GetTypes() | select Name, Namespace | sort Namespace | ft -groupby Namespace

but how do I arrive the the methods and object defined in the dll without desecting the C# code ? unfortunately the dll does not come with a lot of documentation, so I would like to use Powershell board tools to explore what I have in the dll file.

Question I have are: how do I know from the dll that the object I want to create is:   iTextSharp.text.pdf.pdfreader ?

Thank you very much for any hint

Yours

Erich





  • Edited by LinuxFan999 Friday, February 3, 2017 9:44 PM

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

Please fix your first post and use the code posting tool to post code.

"Autocomplete" will show you the properties and methods of any Net object.


\_(ツ)_/


  • Edited by jrv Friday, February 3, 2017 9:44 PM

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

Never used the psoting tool. will learn it, I promise ....

Problem was with firefox, now I use IE.

Anyway the question is how do I arrive from:

$ItextSharp = $PathToItextSharp + "\itextsharp.dll"

Add-Type -Path $ItextSharp

$reader = New-Object iTextSharp.text.pdf.pdfreader -ArgumentList $TestPDF

I.e. after Add-Type I do not have any object yet to inspect. How do I know that I must create an object using "iTextSharp.text.pdf.pdfreader".

something like: $asm = [Reflection.Assembly]::LoadFile($ItextSharp) ???

thx a lot


  • Edited by LinuxFan999 Friday, February 3, 2017 9:54 PM missing a variable

------------------------------------
Reply:
It is on the edit toolbar and looks like this <>

\_(ツ)_/


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

$reader = New-Object iTextSharp.text.pdf.pdfreader -ArgumentList $TestPDF
$reader | Get-Member

or

$reader | gm


\_(ツ)_/


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

That is clear, but , once I called New-Object I need gm. But my question is how do I know the parameter of New-Object, i.e. how do I know that the name is "iTextSharp.text.pdf.pdfreader" and not only "iTextSharp.text.pdf" ?

$ItextSharp = $PathToItextSharp + "\itextsharp.dll"  Add-Type -Path $ItextSharp    # which Object can I create ?  # I have read that one: iTextSharp.text.pdf.pdfreader  # are there any others ?  # or other dll, for example:  # which ones do I need for itextsharp-dll-xmlworker.ddl     $reader = New-Object ?????? -ArgumentList $TestPDF  $reader | Get-Member

One possible approach is:

$asm = [Reflection.Assembly]::LoadFile($ItextSharp)  $asm.GetTypes() | select Name, Namespace | sort Namespace | ft -groupby Namespace    # this works fine, however I do not get methods  # and elements or classes 

thx a bunch

as you see I learned how to insert code .... great tool ...


  • Edited by LinuxFan999 Friday, February 3, 2017 10:19 PM

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

Ahh. That looks better and is readable.

The answer is "Autocomplete.  Type iTextSharp then a dot and hit <tab> and cycle through all embedded type and so on.

Get the enume this way:

PS C:\scripts> [iTextSharp.text.pdf.CMYKColor]::ORANGE     R G B   - - -  255 200 0      PS C:\scripts>  

After the :: tab through the enum names.


\_(ツ)_/


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

There must be something I am missing. Let me reassume what I do

$ItextSharp = $PathToItextSharp + "\itextsharp.dll"  Add-Type -Path $ItextSharp

then I enter:

ItextSharp.

and tab to expand, nothing happens.

 [iTextSharp.text.pdf.CMYKColor]::ORANGE however works fine.

another try:

$asm = [Reflection.Assembly]::LoadFile($ItextSharp)

then I enter

$asm.

and tab to enter, then the object gets expanded, but it seems to me, that are all methods inherited from type object, indeed I do not find "iTextSharp.text.pdf.pdfreader". Below the output of $asm | gm

Clone            Method           System.Object Clone()

CompareTo  Method           int CompareTo(System.Object value), int CompareTo(string strB)

Contains       Method           bool Contains(string value)  

               

 
  • Edited by LinuxFan999 Saturday, February 4, 2017 10:45 AM added output of asm|gm

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

I did a different try now, which I found on a forum, JFY i attach it, but it was not of much help for me.

$Results=@()  Get-ChildItem -recurse "$PathToItextSharp"|  Where-Object { ($_.Extension -EQ ".dll") -or ($_.Extension -eq ".exe")} |   ForEach-Object {   $AssemblyName= $_.FullName; try {$Assembly = [Reflection.Assembly]::LoadFile($AssemblyName);} catch{ "***ERROR*** Error when loading assembly: " + $AssemblyName} $Assembly | Format-Table; $Assembly.GetTypes() |   %{   $Type=$_;$_.GetMembers() | Where-Object {$_.MemberType -eq "Constructor"-or $_.MemberType -EQ "Method" } |    %{   $ObjectProperties = @{ 'Assembly' = $AssemblyName;   'ClassName' = $Type.Name;   'ClassPublic' = $Type.IsPublic;   'ClassStatic' = $Type.IsAbstract -and $Type.IsSealed;   'MemberType' = $_.MemberType;   'Member' = $_.ToString();   'Changed' = $Changed;   'MemberPublic' = $_.IsPublic;   'MemberStatic' =$_.IsStatic;   }   $ResultsObject = New-Object -TypeName PSObject -Property $ObjectProperties   $Results+=$ResultsObject   }   }  }  $Results | Select-Object Assembly,ClassPublic,ClassStatic,ClassName,MemberType,Member,MemberPublic,MemberStatic | Sort-Object Assembly,ClassName,MemberType,Member| Out-GridView -Title "Reflection"      
 again, I do not find what I am searching for, the object I can create from the dll.

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

The big issue here is that you do not know PowerShell. 

Add a type does not get you anything useful with this DLL because of how it is designed.

Start dimple until you understand how PowerShell works.  Don't write scripts.  Just do this at a command prompt.

Where you see <tab> means that we tab until the item we want is displayed.

PS C:\scripts> add-type -Path .\iTe<tabs>xtSharp\it<tabs>extsharp.dll  PS C:\scripts> $doc = New-Object iTextSharp.<tabs>text.D<tabs>ocument  PS C:\scripts> $$doc.<tabs>HtmlStyleClass  PS C:\scripts> $doc | gm    TypeName: iTextSharp.text.Document    Name MemberType Definition  ---- ---------- ----------  Add Method bool Add(iTextSharp.text.IElement element), bool IElementListener.Add(iTextSharp.text.IElem  	AddAuthor Method bool AddAuthor(string author)  	AddCreationDate Method bool AddCreationDate()  	AddCreator Method bool AddCreator(string creator)  	AddDocListener Method void AddDocListener(iTextSharp.text.IDocListener listener)  	AddHeader Method bool AddHeader(string name, string content)

Typing the first couple of letters will start the tabbing at that string and proceed ahead.

Takes some time to review the documentation on how to use PowerShell autocomplete.


\_(ツ)_/




  • Edited by jrv Saturday, February 4, 2017 1:19 PM

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

.

In ISE this is what happens:

To make this work in ISE you have to first execute the add-type line   After that the Intellisence and AutoComplete systems will work.


\_(ツ)_/


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

In PS5 we can use new semantics to create a type instance:

Note that we can use the type [itextsharp.<tabs> ... to complete the object reference and add the "new()" constructor to create an object. If the constructor takes arguments we can find them lby leaving off the () and it willlist all method overload:

D:\scripts> [System.Data.SqlClient.SqlConnection]::new    OverloadDefinitions  -------------------  System.Data.SqlClient.SqlConnection new(string connectionString)  System.Data.SqlClient.SqlConnection new(string connectionString, System.Data.SqlClient.SqlCredential credential)  System.Data.SqlClient.SqlConnection new()  

Reflection can find anything on an object.  If you take time to learn how to use PowerShell and the editor you will find you can inspect and use almost any type library with ease even with limited documentation.


\_(ツ)_/


  • Edited by jrv Saturday, February 4, 2017 1:39 PM

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

Thank you very much, btw I have powershell V2

I tried it out:

PS C:\scripts> add-type -Path .\iTe<tabs>xtSharp\it<tabs>extsharp.dll  # Tabs worked here  PS C:\scripts> $doc = New-Object iTextSharp.<tabs>text.D<tabs>ocument  # Tabs does not work 

"New-Object iTextSharp.<tabs>"  I tried already at beginning of my work, however no success.

I cannot believe it is only a Problem of V2 , I think all these features above are already present in the 2nd version, or aren't they ?


------------------------------------
Reply:
No; the tab completion features of which you speak do not exist in PowerShell v2. You will have to rely on the documentation in that case. Also, this is not a support forum for the iTextSharp component.

-- Bill Stewart [Bill_Stewart]


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

OK, thx a lot. Therefore better to upgrade as I understand. At least to have a development machine, will look for one and retry.

Again, thank you very much for your help on this.


BTW, which minimum version do you reccomend ? Since I must keep version 2 it would be good not to have a too different one on the enviroment, where I try out things. 
  • Edited by LinuxFan999 Saturday, February 4, 2017 4:50 PM

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

You really want to upgrade to WMF 5.  You will find support for V2 is getting very slim.  It also cannot do most things.


\_(ツ)_/


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

Steps to troubleshoot SQL connectivity issues

Please follow this blog to troubleshoot SQL connectivity issue and post question here.

Steps to troubleshoot SQL connectivity issues

Lot of blogs related to SQL connectivity issue are available sql_protocols blog.

http://blogs.msdn.com/sql_protocols


(Update: Please search your error message in this forum before you post your question, there are probably already answers in previous posts. If your scenario is different, please start a new thread rather than appending to old ones. Please reply this thread if this searching step solves your issue. We would like to hear from you. Thanks).

 


Reply:

Thanks for your good information.

I followed your step to step2, the log file showed "error :9003, severity: 20, state:1".

Could you teach me how to solve this problem or could you provide the URL for how to uninstall SQL Server 2008 and reinstall"

 

thank you very much


I have uninstall and reinstall the SQL Server 2008 already.

Thanks for your read.


------------------------------------
Reply:
The SQL Server connection tool pointed me at the problem- my connection string user and password were being ignored in favor of the windows login I happened to be using.

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

In lieu of TELNET, one can check port connectivity with the PowerShell command below.  Specify the desired port number instead of the default instance port 1433 as needed.

1433 | % { echo ((new-object Net.Sockets.TcpClient).Connect("YourServerName",$_)) "server listening on TCP port $_" }


Dan Guzman, SQL Server MVP, http://www.dbdelta.com


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

Xinwei Hong

I have done the tests recommended in you post by going through the steps in "Steps to troubleshoot SQL connectivity issues" Turning off the Firewall solved the problem, but naturally, I don't want to leave it turned off.

Here are the settings I have changed and the results:

Firewall off: Instant connection.

Domain Profile: Inbound connections changed from Block to Allow. (No results) Time Out at 15 seconds

Private Profile: Inbound connections changed from Block to Allow. (No results) Time Out at 15 seconds

Public Profile: Inbound connections changed from Block to Allow. (No results) Time Out at 15 seconds

All three of the above set to Allow (No Results) Time Out at 15 seconds

IPSec Settings: All computers on the domain added to Only Allow Exceptions. (No results) Time Out at 15 seconds

IPSec Settings: Added Domain Admins to Only Allow Authorized list.

Are there any other firewall settings I can try resetting?



Tom Childers, Radio Amateur N5GE, Licensed since 1976, QCWA Member 35102, ARRL Life Member


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

You can now use the following troubleshooter to solve majority of connectivity issues when working with SQL Server.

Solving connectivity issues to SQL Server

Please check and share any additional feedback for improvements using the Feedback button at the bottom of the troubleshooter or through comments section in the following blog post on PSSSQL

Guided walkthrough just got published..

Thanks.
Ramu.


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

This is great, Ramu!  I'll be sharing like this in answers for those that missed your post.


Dan Guzman, Data Platform MVP, http://www.dbdelta.com



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

Thank you Dan. Truly appreciate your help in extending the reach of this doc. If you can think of any additional scenarios or improvements that can be added to this, please do let me know and I can work on the same.

Regards.

Ramu.


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

Insider Preview Build 15025 ISO file available to download now

This is the OFFICIAL Microsoft download link. 100% safe.

Windows Insider Preview Downloads

https://www.microsoft.com/en-us/software-download/windowsinsiderpreviewiso?wa=wsignin1.0

Click the Select Edition > select 15025 > Confirm

Click Language > select > Confirm

Click Bit version

Click Save As > select download destination > click Save.




  • Edited by david hk129 Saturday, February 4, 2017 1:09 AM

Reply:

I am one of those Insiders with a 32-bit computer. As such WU will not offer the new build 15025.

With the 32-bit ISO file downloaded from the link above, 15025 has been installed successfully.

1. As usual, System Protection has to be re-enabled.
2. Display mixed content option has to be re-enabled.
3. My google.ca search provider was removed and replaced by the freaking Bing. I had to "Add" google.ca back on > set it as Default > then remove Bing.

Other than that, 15025 is up and running.

Next to check is whether system restore is still broken or not.
https://social.technet.microsoft.com/Forums/windows/en-US/ae9578f7-4d24-4a06-9f13-c513bd1e81e6/to-insider-preview-users-did-your-preview-build-break-your-system-restore-?forum=WindowsInsiderPreview#9a4b8bab-cfd0-435a-a31a-824ded1f2f1a


------------------------------------
Reply:
As a Hyper-V guest the ISO does not boot with secure boot for me, anyone else notice that? Tried on 2016 Hyper-V Server Nano and a Windows 10 Hyper-V host neither boot that ISO with secure boot on. Turn off secure boot it boots the DVD fine and you can turn back on secure boot when Windows has installed.

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

I am one of those Insiders with a 32-bit computer. As such WU will not offer the new build 15025.

With the 32-bit ISO file downloaded from the link above, 15025 has been installed successfully.

1. As usual, System Protection has to be re-enabled.
2. Display mixed content option has to be re-enabled.
3. My google.ca search provider was removed and replaced by the freaking Bing. I had to "Add" google.ca back on > set it as Default > then remove Bing.

Other than that, 15025 is up and running.

Next to check is whether system restore is still broken or not.
https://social.technet.microsoft.com/Forums/windows/en-US/ae9578f7-4d24-4a06-9f13-c513bd1e81e6/to-insider-preview-users-did-your-preview-build-break-your-system-restore-?forum=WindowsInsiderPreview#9a4b8bab-cfd0-435a-a31a-824ded1f2f1a

System Restore still fails to complete.


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

Good news to Insiders running 32-bit versions and unable to receive build 15025

Good news..............provided this website is trustworthy.

excerpt:    Source

Microsoft pushed out Windows 10 Insider Build 15025 to the Fast Ring channel yesterday evening featuring mostly bug fixes.

Some devices, all running 32-bit versions of Windows 10, are excluded from receiving the update though the company notes in a blog post announcing the new release.

Microsoft plans to make ISO images available at the end of the week which will work on 32-bit PCs as well so that the update may be installed on those devices.

.................. end of excerpt.

I, for one, am unable to receive the new build.

I am running a 32-bit Windows 10 Pro Insider Preview 15019.


  • Edited by david hk129 Friday, February 3, 2017 1:20 AM
  • Changed type david hk129 Friday, February 3, 2017 2:57 AM

Reply:

From another website :

excerpt : Source
Take Note: If you're an Insider using Windows 10 on a 32-bit machine, you won't be receiving this build today. There is a bug causing 32-bit installs to fail, therefore this build is not rolling out on that architecture. 64-bit users can proceed as normal.

.....................................................................................

Well, I feel better now knowing that the problem is not in my end.

......................................................................................

From yet another site :

excerpt :   Source
 "We have discovered a bug that impacts our ability to release this build to PCs running 32-bit (x86) versions of Windows 10 Insider Preview builds. Because the majority of Insiders in the Fast ring have PCs running 64-bit (x64), we decided to go ahead and release this build with 32-bit PCs blocked until our next flight. We plan to release ISOs for this build by the end of the week and Insiders on 32-bit PCs will be able to update from the ISOs.


  • Edited by david hk129 Friday, February 3, 2017 1:59 AM

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

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

SCCM 2012 Error Code = 2152205056 when Importing Computer

I am importing a computer into SCCM 2012 and it is giving me the following error:

The SMS Provider reported an error.ConfigMgr Error Object:instance of SMS_ExtendedStatus{ Description = "Unable to save changes"; ErrorCode = 2152205056; File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\sspsite.cpp"; Line = 1296; Operation = "ExecMethod"; ParameterInfo = "SMS_Site"; ProviderName = "WinMgmt"; StatusCode = 2147749889;

I have looked up unknown systems and tried to delete them but the delete button is grayed out. I can image other pc's just fine. Any ideas? 

Reply:

how are you trying to do the import, for one pc or using a csv file?

if a csv file, please show us your syntax


------------------------------------
Reply:
i'm having the same problem if you already know the answer... please mail me at "luan.augusto.sa@gmail.com"

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

Community template with approved replies only in SharePoint 2013

HI,

I have a community site template enabled, in which i need to acheive the following things as follows,

1. I need to have custom Join this community link, by default it have on byut I couldn't see that web part, might be email is not configured in it not sure due to that?

2. I need to have only the approved reply and discussion to be showed in the page how to acheive that

3. in the count of the reply it will have all the count which includes, but i need only the approved counts.

Thanks,

-Sendil


Reply:

1. with network capture from IE developer tools, i can see that Join Community model dialogue show the page /_layouts/15/CommunityJoinPage.aspx ;

After you click send request, administrator can find a pending request in site settings->Access Request and invitations.

The Join Community process just request and assign site permissions, user needs more then Contribute permission to create post or reply in the community, which means 'join' the community.

2. In site settings->versioning settings, you can set the require content approval to yes. And Only user who can approve items can see draft items


  • Edited by GuYuming Monday, May 20, 2013 4:55 AM

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

GuYuming, 

Is there any way to have just the discussion require approval and then the replies not require approval? That's the way it worked in our staging environment but in Production it seems to want the approval for all items. 


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

Unable to run automated tasks with reboot due to bitlocker

Hi,

I run several VBScripts and windows batch files. I cannot find a command to run for either as an administrator on the local computer that will reboot the machine and not prompt the user for a bitlocker pin when it starts back up. This is needed as i have a job that runs that needs a reboot to continue with several tasks post reboot. Does anyone know if this is achievable as an admin using wither VBScript or a windows batch file? If so, how?

Regards,

Vishay

  • Changed type Bill_Stewart Monday, March 6, 2017 7:33 PM
  • Moved by Bill_Stewart Monday, March 6, 2017 7:33 PM This is not "research solutions for me" forum

Reply:

BitLocker can be configured not to require a PIN when booting.

This is not a scripting question, however.


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:
Hi Bill, that is not the aim, i do not want to change the current confirguration of our estate. The aim is to suspend bitlocker using a command prompt batch file or a VBscript to run several other scripts as an administrator locally on the machine.

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

I don't have a machine I can test with, but if you make a call PowerShell:

get-bitlockervolume | suspend-bitlocker -rebootcount 1

That might keep BitLocker at bay without having to turn it off entirely. I don't know if this will suspend the PIN requirement, however. 


  • Edited by SYN_ACK_87 Thursday, February 2, 2017 3:59 PM Code correction

------------------------------------
Reply:
thanks for this but the estate is windows 7, so the machines do not have powershell as part of their builds. thiscommand would work if we had windows 8 or above deployed  generally.

------------------------------------
Reply:
Windows 7 has PowerShell out of the box.  It was the first version of Windows to include PowerShell

\_(ツ)_/


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

Enabling Forest Discovery

Hi,

I have manually created the boundary based on site and IP subnet, If i enable forest discovery does it repopulate all the site and convert that as a boundary irrespective of one which i have already created it manually or it will create the delta(one which is newly created in AD )

Any help would be much appreciated.


Reply:
Just enable it and see what happens. Just creating boudaries does not affect anything. You can delete those that were imported by forestdisc any time.

Torsten Meringer | http://www.mssccmfaq.de


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

For AD sites, yes.

Forest discovery does not create IP Subnet Boundaries though, it creates IP Address Range boundaries which are much preferred.

If you've already created your boundaries, there's no need to have forest discovery create them again though so you can disable that. Alternatively, as Torsten pointed out, boundaries have no functionality until they are added to a boundary group so there's no harm in having them enabled either.


Jason | http://blog.configmgrftw.com | @jasonsandys


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

BranchCache: How many HostedServer can you deploy with an one content (main branch) server?

Hello guys,

i hope you guys can help me with that quesiton. 

Q: How many HostedServer can you deploy with one content server? 

For example: i have my content server in USA. So can i deploy a hosted server in Vietnam and a hosted server in China? It´s that possible or support BranchCache only one HostedCache Server for each content server? 

Thank you :)

Megas_Ioan



Reply:

hi,

your configuration is not a problem. You can have many content servers and many HostedCache servers.

The HostedCache servers don't need to know about content servers - in fact the clients could be pulling content from multiple content servers - and you can have multiple HostedCache servers in large locations with many clients for redundancy.

thanks

Phil


Phil Wilcock http://2pintsoftware.com @2pintsoftware


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

Issue while adding article to existing subscription(Transactional Replication)

We are haing issues while adding article on existing subscription.

The replication is setup with Initialize from backup=true.

Below is the command I tired to use aftet transfering the rows thru export import wizard but the table on the subscriber isnt refreshing.

exec sp_addarticle @publication = N'marcus8rpl' , @article = N'appnames' , @source_owner = N'dbo' , @source_object = N'appnames' , @type = N'logbased' , @description = null , @creation_script = null , @pre_creation_cmd = N'NONE' , @identityrangemanagementoption = N'manual' , @destination_table = N'appnames' , @destination_owner = N'dbo' , @vertical_partition = N'false' , @ins_cmd = N'CALL sp_MSins_dboappnames' , @del_cmd = N'CALL sp_MSdel_dboappnames' , @upd_cmd = N'CALL sp_MSupd_dboappnames'


Reply:

1. Stop the log reader agent

2. Stop making changes to the new article in the Publisher (Note that table should be quiesced to all changes while the data is being copied out from the publisher and until the table is added to the publication with sp_addarticle)

3. Generate a script to create the table on the subscriber and copy the data out of the article from Publisher to Subscriber.

A. For new or small tables you can use INSERT INTO… SELECT * FROM

B. For tables with a lot of existing data, create a SSIS package that creates and then load the table on the remote server

4. Add the article to the publication using sp_addarticle

5. Start Log Reader Agent

6. Now you can start to make changes as the log reader will start tracking changes for the article at this point.

Please note that if the backup already had the article and if it is still present in the subscriber and provided there is no schema change is done to that table, you don’t need to create it again in the subscriber.

Also compare the row count of the table being added between publisher and subscriber before starting log reader agent to make sure that both publisher and subscriber have the same amount of data.


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

There is an issue with adding new articles to publications where the subcription is initialized from a backup.

New articles won't replicate the changes. I can't find a reference to this, but I first read about it here.

You may want to open a support incident with Microsoft on this.


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:

Is there any reason why new article will not be replicated properly if we intialize subsription from a backup?

Thx


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

So you mean to say  with the Intialize from the backup setup no new artcles can be added?

 


------------------------------------
Reply:
I can actually add new article and it does replicate provided I run the sp_refreshsubscriptions command. Intially it was working ok. But eventually it started taking more resource and became diffcul to run on the publisher.

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

There was something posted here recently on this. Unfortunately I can't find it right now.


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:

Hi,

Add article in replication

Adding new article without generating a complete snapshot

1)      Make sure that your publication has IMMEDIATE_SYNC and ALLOW_ANONYMOUS properties set to FALSE or 0.

Use yourDB
select immediate_sync , allow_anonymous from syspublications

If either of them is TRUE then modify that to FALSE by using the following
command

EXEC sp_changepublication @publication = 'yourpublication', @property =
N'allow_anonymous', @value='False' 
Go
EXEC sp_changepublication @publication = 'yourpublication', @property =
N'immediate_sync', @value='false'
Go

2)      Now add the article to the publication

Use yourDB
EXEC sp_addarticle @publication = 'yourpublication', @article ='test',
@source_object='dbo.test', @force_invalidate_snapshot=1

If you do not use the @force_invalidate_snapshot option then you will receive the
following error
Msg 20607, Level 16, State 1, Procedure sp_MSreinit_article, Line 99
Cannot make the change because a snapshot is already generated. Set
@force_invalidate_snapshot to 1 to force the change and invalidate the existing snapshot.

3)      Verify if you are using CONCURRENT or NATIVE method for synchronization by running the following command.

Use yourdb
select sync_method from syspublications

If the value is 3 or 4 then it is CONCURRENT and if it is 0 then it is NATIVE.
For more information check
http://msdn.microsoft.com/en-us/library/ms189805.aspx

4)      Then add the subscription for this new article using the following command

             EXEC sp_addsubscription @publication = 'yourpublication', @article = 'test', 
             @subscriber ='subs_servername', @destination_db = 'subs_DBNAME', 
             @reserved='Internal'

If you are using the NATIVE  method for synchronization then the parameter
@reserved='Internal' is optional but there is no harm in using it anyways. But if it is CONCURRENT then you have to use that 

parameter. Else the next time you run the snapshot agent it is going to generate a snapshot for all the articles.

Lastly start the SNAPSHOT AGENT job from the job activity monitor. To find
the job name follow these steps.

·        select * from msdb..sysjobs where name like '%yourpublication%'
·        Right click on each of those jobs and find which one contains the step    
      'Snapshot Agent startup message'. This is the job that you want to      
                         start from the first step.

Verify that the snapshot was generated for only one article.


Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!


------------------------------------
Reply:
First time on here but have to say Brilliant Mark.  I had done alot of research on this and there is a myriad of schemes to get this going.  Yours worked a treat.  Still a bit odd after initializing from a backup you cant add articles using the snapshot agent automatically but yours worked a treat.

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

Hi, I have an oracle to sql transactional replication setup.  How can I add new articles without bringing in the other tables?  I can't run Step 1 above because the publication database is an oracle database.  How can I update the 'immediate_sync' and 'allow_anonymous' to false then?  I can't seem to find the table on the oracle database to make the update?  Please help...

Ted


tae yang


------------------------------------
Reply:
Hi,

It's possible to add article(s) after inialization from backup but you need to change some options on publication and update one system table for subscribtion :

http://www.concatskills.com/2016/02/01/replication-initialisation-par-sauvegarde/

1) Disable initialization from backup on publication

2) Use async mode on publication

3) Update system table for subscribtion


------------------------------------
Reply:
First time on here but have to say Brilliant Mark.  I had done alot of research on this and there is a myriad of schemes to get this going.  Yours worked a treat.  Still a bit odd after initializing from a backup you cant add articles using the snapshot agent automatically but yours worked a treat.
Who is Mark? Don't see a post from him. Is it different/less convoluted than SiaKumar's?

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

Netstumbler on Win7 64-bit

I can't seem to get Netstumbler to work on Windows 7 64-bit Release Candidate. Does anyone know if this works on the 32-bit version of Windows 7? Perhaps it's a problem with my network card? I'm running an Intel 5100 AGN network card.

Trevor Sullivan
Systems Engineer
OfficeMax Corporation


Trevor Sullivan Systems Engineer OfficeMax Corporation

Reply:
bump
Trevor Sullivan Systems Engineer OfficeMax Corporation

------------------------------------
Reply:
Might be a problem with the card/drivers (does NS report the card as an "unsupported device?"), might (more likely) be a problem with NS itself.
FWIW, NS doesn't work on my Vista (x86) laptop, either.  NS, useful as it may be, also hasn't been updated in quite some time, and still to this day lacks even Vista support.
There's a sticky (still posted) in the NS forums on this.

My thinking is that your issue will be fixed when mine is - that is, when a version newer than 0.4.0 (one that has proper Vista support) is released.

Edit:  your question got me to looking for a something that works.  Vistumbler works under Vista x86, and should work on x64.  It's also actively developed.

HTH,
Chris
[If this post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of this message. By marking a post as Answered, or Helpful you help others find the answer faster.]
  • Edited by Chris Cupler Monday, May 11, 2009 4:06 AM add info & link

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

This works for wireless adapters, download, install and run inSSIDer, simply select your wireless adapter from the drop down menu and click Start Scanning.

http://www.metageek.net/products/inssider

------------------------------------
Reply:
Those are both great suggestions guys, thanks! I didn't even know either of those existed, and thought that we were all doomed to be stuck with an outdated version of Netstumbler! :) I'll give both of those a shot on my 64-bit Win7 build and see how they work.

Trevor Sullivan
Systems Engineer
OfficeMax Corporation
Trevor Sullivan Systems Engineer OfficeMax Corporation

------------------------------------
Reply:
There is also this netsh command sequence. Go to Start > Run and type cmd /k netsh wlan show networks mode=bssid in the command window.

MS-MVP Windows Desktop Experience, "When all else fails, read the instructions"

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

Thank you! Very cool command.


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

There is a piece of software that uses the netsh command as its root and it much easier than a command line called vistumber.  It is written to work on vista and 7 but uses the netsh command to gather its information. The link is below.  I like it, but my quest to find a piece of software that reports SNR like netstumbler and works on Vista and 7 continues.......

 

 http://www.vistumbler.net/


------------------------------------
Reply:
Well for those who still try to use Netstumbler 0.4.0 to work on windows 7, there is a workaround tested to work only with some USB devices with wmware player. My favorite usb device are those based on RTL8187(b) chip. Install vmware player, then the desired xp version. After successfully installed the xp virtually go to http://www.realtek.com/downloads/downloadsView.aspx?Langid=1&PNid=24&PFid=1&Level=6&Conn=5&DownTypeID=3&GetDown=false&Downloads=true and download the realtek driver for xp (the driver for windos 7 is no needed). Copy those driver files into your newly installed virtual xp (regular copy paste works just fine only after you install vmware tools in your virtual xp). Install the xp driver then connect your rtl8187 to your laptop/desktop through the usb port. Your vmware software will detect the usb device, then on right click "connect (disconnect from host)" located in the right-bottom side of your visualization console while xp is running (small usb icon). At that point your virtual xp will pickup the already installed drivers and auto-configure your plug-and-play usb device. Test it if it works then install your netstumbler 0.4.0 the same way as you did previously the drivers. For me worked fine, and the only reason that i'm still using is for the distance that show up through the GPS. Other then that inSSIDer is pretty good app.

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

@ boghy:
All due respect, but, I have to ask:  why bother?  That's a lot to go thru, when there's a working (and still actively developed) replacement - vistumbler.

Just saying.....

-Chris


[If this post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of this message. By marking a post as Answered, or Helpful you help others find the answer faster.]

------------------------------------
Reply:
http://rsload.net/soft/traffic/13199-vistumbler.html

------------------------------------
Reply:
How can you tell which AP you are connected too?

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

Insider Preview Mobil users, build 15025 is now available.

Why Partition Switching works faster ? I want to know the underlying mechanism that takes place.

Why Partition Switching  works faster ? I want to know the underlying mechanism that takes place.

Reply:
The actual switch takes place almost immediately, because it is simply a metadata operation

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence


------------------------------------
Reply:
Uri is correct. Basically pages in the database will belong to a table. The partition switch changes the page pointers to switch ownership from one table to another.

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

This is a good explanation.

https://technet.microsoft.com/en-us/library/ms191174(v=sql.105).aspx


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

how to convert a vmware machine to hyperv using Microsoft Virtual Manager Converter

Good Day,

please assist, i am using vmware workstation 9 and trying to convert the virtual machines to hyperv using the mvmc tool. the problem comes after i choose the source or host of my vmware workstation. it proceeds but say they are o virtual machines on the source. what am i doing wrong/?

  • Moved by BrianEhMVP Thursday, January 12, 2017 4:19 PM

Reply:

https://technet.microsoft.com/en-us/library/dn873998%28v=ws.11%29.aspx?f=255&MSPPError=-2147217396

Note that this article does not say that it supports moving from VMware workstation.

You could try using a third party product.  I have used Starwind's converter (no cost) successfully.  Ensure that you remove the VMware tools from the VM before you convert the disk.  Starwind's converter doesn't really convert the VM; it converts the virtual hard drive.  Then you create a VM on Hyper-V and point it to the converted VHD, so you need to note the configuration of the VM on the VMware side to use to create the Hyper-V VM.

Of course, the typical caveat ... it is always recommended to build the VM from scratch rather than convert.  Then you never have to wander if it was the conversion process if something goes wrong with the VM in the future.  One less thing to debug.


. : | : . : | : . tim


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

Hello,

Tim, thanks for mentioning us. 

Tim is right you can use our V2V converter to convert your Virtual hard drives to format you need. You can download it here: 

https://www.starwindsoftware.com/converter


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

Hello,

If you are try to convert vm from vmware to hyperv you can read the following article that i wrote and i have use it lot of times for your scenarion

How to Convert Vmware Virtual Machine to HYPER-V

Reply if you have any problem with the conversion to help you


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

In a slightly off-topic question...

Is it possible to go from an ESXi VM to a Generation 2 Hyper-V VM?

I can go to Generation 1 fine but I can't find much on going directly to Generation 2.

thanks


------------------------------------
Reply:
It depends upon the VM.  Most of the conversion tools I have seen work with non-UEFI configurations.  If you have a VM on ESX that is a legacy (BIOS) system, you cannot convert it to a UEFI system.  Boot and disk partitions are different.

. : | : . : | : . tim


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

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