Outlook and saving attachments with the Save button

It's really annoying that every time someone calls saying they've opened a Word document from Outlook and they spent half a day working on it just to press Save and then closed I have to say sorry but it's gone. Shouldn't be Office smarter than this? Clients are often unaware of this problem and it often ends up in tears. I think office applications should be aware when a document gets opened from Outlook and than rather save it in Temps so then it vanishes when not selecting Save As after the document closes and keep such a file either in some special location or do whatever to prevent it from dispersing permanently. Some patch for older versions of Office would be most welcome?

yaro

Reply:

You can use code and rules to automatic save incoming attachments.

Use this script into VBA Outlook Developer:

Sub Save_AttMail_on_drive(Item As MailItem)  'OShon from VBATools.pl 
 If Item.Class = olMail Then   If Item.Attachments.Count > 0 Then   Dim objAtt As Outlook.Attachments   Set objAtt = Item.Attachments   For Each objAttach In objAtt   objAttach.SaveAsFile "c:\temp\" & _   Format(Now, "YYYY-MM-DD") & "_" & objAttach.FileName '<- change for your path   Next   Set objAtt = Nothing   End If   End If  End Sub

Oskar Shon, Office System MVP

Press if Helpful

Edited by VBAToolsMVP Friday, December 9, 2011 4:24 PM

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

Applying this script on a small scale would be fine but applying it to over a 100 of clients (small to medium companies) would prove somewhat problematic if not close to impossible but definitely it's an idea.

yaro

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

test

Edited by Florin Ciuca Monday, December 12, 2011 2:57 PM edit

Repalcing blank value to Null using SSIS package

Hi,

ID Name Sales
1 a 12
2 b 23
3 c 44
4 d
5 e 66

I have a table like above from the table sales column having some of empty values, My requirement is to replace the empty value to Null. with in the derived column transformation I mention the condition like

[Sales ]==" "? Null : [Sales ]

But it shows an error,can any one help me to slove the problem.

Regards,

Praveen C

Reply:

have you tried

isNull( [Sales ] ) || RTRIM( [Sales ] ) ==""? Null : [Sales ]

data warehouse | data migration | ETL/ELT | UK | http://www.brainpowered.net/cms

Edited by Nicolas D Friday, December 9, 2011 11:44 AM

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

try this

isNull( [Sales ] ) || RTRIM( [Sales ] ) ==""? Null(DT_NUMERIC): [Sales

http://msdn.microsoft.com/en-us/library/ms141758.aspx

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

Cannot rename "file.ext" to ".file"

I think it is wrong that if I have a file called "file.ext" and i cannot give it a name with a single dot at the beginning. It tells me "You must type a file name." So the only easy way to do this is cmd shell.
Also, on WinXP there was a full screen console feature. When working with console window (like cmd.exe) one could open the console in full screen by pressing Alt+Enter. This feature didn't work in Vista, but it seems to work in Win7. However, when I press Alt+Enter in console window, I get black screen and no response, so I need to reset.

Reply:

Hi,

Thank you for your feedback.

Regarding the rename file issue, I can re-produce the issue easily. I will report it as a potential bug to our internal team.

Regarding the CMD windows fullscreen issue, hope the following Microsoft Knowledge Base article can help you.

Some 16-bit DOS-based Programs and the Command Prompt will not run in full-screen mode in Windows Vista

Thanks.

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

Hmm, interesting. I noticed the fullscreen issue when i was running Lua 5.1 interpreter, which is commandline, but not 16-bit. I can swear I had black screen after pressing Alt+Enter. But now I do the same, and I get "This system does not support fullscreen mode" messagebox. So it seems like some random (or, possibly, already fixed) issue.

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

Although I can't understand WHY you would want to do so, you CAN name a file ".file" in Notepad and save it.

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

I CAN open cmd.exe, then enter "cd c:\directory & rename file.ext .file". I can also open this file in IE and save it to ".file". Or, I can write a program which uses MoveFileEx function of WinAPI. There're many ways.

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

> I CAN do it with my ass in many ways

May be you do not need the hands at all?

> Although I can't understand WHY you would want to do so, you CAN name a file ".file" in Notepad and save it.

Wrong recommendation. We, supermasters, know that if Windows Explorer bugs are specifications of ideal behavior. Therefore, if you need something that Windows Explorer prohibits, you must revise your decision. Definitely, you have a bad design. The ".files" must be banned completely.

> Regarding the rename file issue, I can re-produce the issue easily. I will report it as a potential bug to our internal team.

Thank you. As of Dec 2011, your internal team made no advance.

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

source record deleted - data flow

Hi,

We are currently moving data from source to staging. And SCD2 type from staging to DWH.

We planned to archive the data prior to 2 months in staging. There are situation where some record will get deleted in source. Now these records should be identified in DWH and make the record inactive. Please find the data flow

Source
=======

acct | name
100 | a1
200 | a2

Staging
=======

Acct | name | Stageloaddate
100 | a1 | 01/12/2011
200 | a2 | 02/12/2011

DWH
=======

Staging will have increamental load.
DWH will pull data from staging to DWH where stage.stageloaddate>max(dwh.dwstartdate)

Now acct 100 got deleted in source. how to make 100 in dwh inactive as we pull only incremental load to dwh from staging.

Do we need to compare entire table of staging to implement this...is there any alternative.

Thanks for your help..

Reply:

If staging tables are cleared down every day after DWH table refreshed then you must use Source table to update the DWH tables with left outer join on Acct column.

Some thing like this schould be scheduled -

Update B set status ='Inactive'

From DWH B Left join Source A

on A.Acct = B.Acct

Where A.acct is null

http://uk.linkedin.com/in/ramjaddu

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

Add dates in Calendar 2010

I would like to create a batch file to import special dates for our company into Outlook 2010. How do I create such a file. Where can I find more info on how to create such a file?

Reply:

The simplest is to create .ics file. There is a Wikirock - Read it

If You want to create VBA appoitment I got form and discr. et this article: Dodanie wydarzenia kalendarzowego do wiadomości e-mail

Use translator for Your self, course i did not prepare in english yet.

Regards

Oskar Shon, Office System MVP

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

windows 7

recently my windows 7 takes forever to shut down. just started doing this. whats up?

Reply:

Restart the computer and enter into Safe Mode, what's the result?

Also test in Clean Boot.

Update your BIOS as well.

Regards,

Miya

Miya Yao

TechNet Community Support

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

deployment of Lists/ web parts / wsp from English MOSS server to Japense MOSS server

Hi,

I have lists and web parts created in english moss server.. I want to deploy those things to Japanese moss server.. How to do that? when i deployed wsp web part populated but giving some error. not able to add it to page.

we have two web application on english webapp and one japanese.

for list.. i look save as template..got stp file.. renamed to cab and then changed manifest.xml lanauge code from 1033 to 1048 .. then generated cab and renamed to stp.. uploaded and created the list.. but everything comes in english.. so changed display name to japanese language..

is there any easy way?? its very urgent.. please help? the web part works fine in enlgish site.. but not in japanese site..

how to deploy wsp? please guidance is needed from MVPs

Server- moss 2007.(sharepoint 2007)

Regards

Guru

Guruprasad Marathe

Edited by Guruprasad Marathe Friday, December 9, 2011 8:23 AM h

Reply:

Changing the language of a site is not really fully supported. please refer this link

http://vspug.com/mirjam/2008/04/29/changing-the-language-of-an-existing-sharepoint-site/

Satyam MCITP, MCPD

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

Just want to share my findings concerning corrupted user profiles on Terminal Server with you

We all aware of "corrupted profile" problem. We all face it from time to time. It is not a big pain when you can restart your terminal server, delete corrupted profile and log in again to recreate the profile. But sometime you just can't restart the server - think about corporate environment with 1000 users who use it 24/7. You might be more lucky than others if you have two or more terminal server for fail over, but not all as lucky as you.

So here is the answer. If you have user's profile corrupted and you can't restart the server, you might want to do "regedit" and go to "HK Local Machine\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\the sid of the user"

(You locate the user's hive by "ProfileImagePath" key: it shows user's profile folder's location)

You can create a new folder for the user's profile and change "ProfileImagePath" to point to that

newly created folder or you can just delete sid hive from registry - in this case system will recreate

profile at next log on.

Reply:

Hi,

Thank you for sharing the experience. :)

Technology changes life……

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

deployment of Lists/ web parts / wsp from English MOSS server to Japense MOSS server

Hi,

is there any easy way?? its very urgent.. please help? the web part works fine in enlgish site.. but not in japanese site..

how to deploy wsp? please guidance is needed from MVPs

Server- moss 2007.(sharepoint 2007)

Regards

Guru

Guruprasad Marathe

what changes required in web.config and app.config files to make work multiple WCF services in windows azure

i have a 14 WCF Services in my website and all working fine without azure and i create a virtual directory name SFDE.WebServices and my URL of Webservices is "http://localhost/SFDE.WebServices/Servicename.svc" but when i implement in windows azure locally by creating one WebRole and only one WCF Service working fine and all other shows error that "No protocol binding matches the given address 'http://localhost:2001/Servicename'. Protocol bindings are configured at the Site level in IIS or WAS configuration".................i tried port no 2000 and 80 in WCF WebRole properties..........may i need to change WCF Services URL from http://localhost/SFDE.WebServies/Servicename.svc to http://localhost:2000/SFDE.WebServies/Servicename.svc in case of port no 2000.............when i run locally azure deployment wcf Services it run at URL = http://127.0.0.1:2001/Servicesname.svc and it shows Directory list at URL = http://127.0.0.1:2000/ ..............i don't know what i have to change and what steps to follow...........what problems with WCF Services and may i run WCF Services at Different Different port no.......................here is my web.config

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.web>
  <authentication mode="None" />
  <authorization>
   <allow users="*" />
  </authorization>
  <compilation batchTimeout="7200" debug="true" targetFramework="4.0" />
  <sessionState timeout="2880" />
</system.web>
<connectionStrings>

   </service>
   <service name="SFDE.ESS.Services.EmployeeService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/EmployeeService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IEmployeeService" />
   </service>
   <service name="SFDE.ESS.Services.ExpenditureService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/ExpenditureService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IExpenditureService" />
   </service>
   <service name="SFDE.ESS.Services.FareService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/FareService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IFareService" />
   </service>
   <service name="SFDE.ESS.Services.BoardingLodging" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/BoardingLodgingService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IBoardingLodgingProcess" />
   </service>
   <service name="SFDE.ESS.Services.FamilyService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/FamilyService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IFamilyService" />
   </service>
   <service name="SFDE.ESS.Services.OtherExpenseService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/OtherExpenseService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IOtherExpenseService" />
   </service>
   <service name="SFDE.ESS.Services.DepartmentService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/DepartmentService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.IDepartmentService" />
   </service>
   <service name="SFDE.ESS.Services.LeaveRequestService" behaviorConfiguration="serviceBehavior">
    <endpoint address="http://localhost/SFDE.WebServices/LeaveRequestService.svc" binding="basicHttpBinding" contract="SFDE.ESS.Services.Contracts.ILeaveRequestService" />
   </service>

  </services>
  <behaviors>
   <serviceBehaviors>
    <behavior name="serviceBehavior">
     <serviceMetadata httpGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="true" />
     <dataContractSerializer maxItemsInObjectGraph="2147483647" />
    </behavior>
    <behavior name="">
     <serviceMetadata httpGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="false" />
    </behavior>
   </serviceBehaviors>
  </behaviors>
</system.serviceModel>
    <system.webServer>
        <directoryBrowse enabled="true" />
    </system.webServer>
</configuration>

Manish K. Bhalodi

Windows Server is unable to ping the other DC Windows 2008 Server.

I just transferred my windows VM files to another drive and trying to run but again, no connection.

DC Zayan can ping DB Server DANIYAL but not the other way around, both are windows server 2008.

Help !!!!!!!!

Also, DANIYAL show the following statement when ping to ZAYAN.

Pinging zayan [169.254.9.36] with 32 bytes of data:

Reply from 192.168.0.10: Destination host unreachable.

What is "169.254.9.36" IP Address, and what does it means ?

MSH

Changed type Tiger LiMicrosoft employee Friday, December 2, 2011 8:12 AM

Reply:

These Computers are unable to connect.

Zayan can ping Daniyal but not Daniyal cannot ping.

Pls help.

MSH

Merged by Tiger LiMicrosoft employee Wednesday, November 30, 2011 12:56 AM

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

I would suspect for that Windows Firewall on 2008 server. FW is disabled on 2003 by default but on 2008/2008R2 it is enabled. You need to allow icmp traffic on 2008 server's advanced firewall or disable it.

Remember that 2008/2008R2 has advanced firewall which containes 3 profiles. You need to modify or disable apporpriate one (public, private, domain)

Regards, Krzysztof ---- Visit my blog at http://kpytko.wordpress.com

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

Hi Salman,

Thanks for posting here.

Yes, Please first ensure that the ICMP Echo Request expectation has been enabled on both VMs.

Since you are using Virtual Box, could also verify the virtual network settings to ensure they are all been properly configured ?

Nobody Can Ping My Computer

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

Thanks.

Tiger Li

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.

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

Looking at the Network icon in the lower right corner of Daniyal, it shows a little yellow triangle, indicating that you have an issue with your connection.

The config looks the same on both, but I see the primary DNS server on Zayan is IPv6, so you may want to verify/compare the settings on those two machines.

_________________________________________________________________________________________

Please vote my post as helpful if you think it was, and mark it as an answer if it answered
your question. That will help others with the same problem finding the answer. Thanks.

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

Hi Ole Drews Jensen,

Thanks for posting here.

According to the ipconfig results, the icon might indicate that hosts were unable to connect to internet(http://www.msftncsi.com) , you can find out the explications about how Windows detects internet connectivity form the links below and that should nothing to do with this issue so far:

Appendix K: Network Connectivity Status Indicator and Resulting Internet Communication in Windows Vista

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

http://blog.superuser.com/2011/05/16/windows-7-network-awareness/

Thanks.

Tiger Li

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

Hi Tiger

It is having the same issue.

Actually I am unable to connect Daniyal to Zayan via Active Directory.

MSH

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

Is there an antivirus app on the machines? In some cases, the newer AVs have some sort of "protect network traffic" feature that may be causing this issue. I would suggest disabling the antivirus to test it, as well as disable the WIndows Firewall, as others have suggested, to test this, too.

Ace

Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, 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 posting is provided AS-IS with no warranties or guarantees and confers no rights.

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

My two servers both AD enabled are unable to ping each other.

I bridge them using Internal and Bridge Option in VM of Oracle, no firewall is enabled.

Any helpful idea from guys....pls...

MSH

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

Now, from your sceeen-shots we can see that "Daniyal" server has no IP address assigned. It uses APIPA (default configuration when DHCP server was not found for DHCP enabled clients). Comparing it to the first attached screen-shot (which shows that you have used fixed IP addresses for these servers), now it is changed. Please set up once again static IP address with appropriate network mask on "Daniyal" DC.

Please also run in command line on both servers ping for DNS domain name

ping softwarelogicscorporation.com

and see if this name is resolved. Sometimes in VirtualBox I had a situation where no AD specific DNS records were created and I couldn't access DNS domain name.

Another question from my side is, did they connect each other earlier? Did it work for you for some time? You didn't mentioned anything about that and we can see that both servers (DCs) are in softwarelogisticscorporation.com domain. So, two cases are possible, the first - it worked for you and you was able to promote additional DC for above domain, the second - you inproperly configured two DCs as they are root domain controllers for that domain (in virtual environment it's possible) ?

You ca try to follow articles on my blog (they were created in VirtualBox environment :) ) for how to create forest root domain and then how to add additional DC to that domain at

Creating forest root domain
http://kpytko.wordpress.com/2011/09/02/configuring-a-forest-root-domain-on-windows-server-2008-r2/

Adding additional DC
http://kpytko.wordpress.com/2011/09/05/adding-additional-domain-controller/

and if it's possible to you I would recommend using DNS domain name in non-public TLD (Top Level Domain) instead of .com use .private, .local or something like that. It may causes some configuration issues in the future when you want to use hosted (external) domain in .com domain with a lot of administrative effort for you.

Regards, Krzysztof ---- Visit my blog at http://kpytko.wordpress.com

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

To add, a DC must be set to a static IP config. Maybe that was an oversight when the machine was setup?

I would also believe that bridging connections will cause problems, because you don't want to bridge them, rather you want the two DCs to communicate with each other, and believing I understand the setup, they need to communicate to the outside world.

After following Krzysztof's instructions using virtualBox, configuring the DC with a static IP, you should also run:

ipconfig /registerdns
net stop netlogon
net start netlogon

After following Krzysztof's instructions and running the above, I would also recommend to delete any 169.254.x.x IP address in DNS from:

The GC records under gc._msdcs.softwarelogicscorporation.com
The 'same as parent" record under the softwarelogicscorporation.com zone
In the Nameservers tab

Ace

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

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

I bridge them using Internal and Bridge Option in VM of Oracle, no firewall is enabled.

Hi,

Thanks for update.

To add, based on my knowledge about VirtualBox, I’d suggest to first add a new “Host-only Adapter” virtual interface and set to use it as the only connected interface for all VMs.

I think this issue in more like about misconfiguration on virtual network instead on OS side.

For more information about the virtual network settings in VirtualBox please refer to the manual below, epically the session “6.2. Introduction to networking modes”

http://download.virtualbox.org/virtualbox/UserManual.pdf

Perhaps we may also try to build the test environment by using Microsoft virtual machine software like Virtual PC or Hyper-V.

Thanks.

Tiger Li

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

Tiger,

I think testing this with a HyperV build would be a good idea. I'm not sure if Windows 2008 R2 can be installed in a VirtualPC or Virtual Server environment, since they can't support 64bit OS, based on the command prompt in the original post (Windows [Version 6.1.7601]) this is 2008 R2.

In addition, I would like to offer another avenue of support to explore for Salman if our suggestions or the UserManual are not helpful - the Virtual Box forums:
http://forums.virtualbox.org/

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

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

Was the problems in your other thread resolved, or is this thread related?

FYI for anyone reading this thread, the following is related to this thread:

Servers are not connected - Windows 2008
http://social.technet.microsoft.com/Forums/en-US/winserverNIS/thread/7d43cd66-abe1-4641-9003-58e960a9674d

Sorry, but I'm a little confused. If you can provide some details, that would be helpful, such as:

Did you refer to the VirtualBox documentation as was provided in the other thread?
Or did you contact VirtualBox as was discussed? If so, what did VirtualBox support suggest?
Or did are you now using HyperV?
Did you manually set the IP on Denayli?

Also, if you are now using HyperV, and if you converted it from a VirtualBox virtual harddrive to a Microsoft HyperV VHD drive, then imported the VHD into HyperV, more than likely the Network Name that it is assigned to is a different name, therefore Windows thinks it's a new interface, where it will create a new interface and set it as DHCP. That's why the 169.254.x.x address showed up.

I don't know if the above is 100% accurate, because I'm not sure if you converted it, imported it, or if this is the same problem from your other thread.

As for the 169.254.x.x IP, that address is called the Automatic IP Address also referred to as the APIPA. That is the number that gets automatically created on a DHCP set interface but no DHCP server is available to give it an IP.

The APIPA is why you can't ping because it is an IP on a different subnet than the other machine. Therefoe you will have to manually set the IP address, whatever the IP address needs to be.

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

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

Hi Ace

Really frustrated after applying all the tricks and no use.

Daniyal Server can ping to softwarelogicscorporation.com but not to Zayan...pls check..

Any idea ?

MSH

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

MSH,

I don't know what you mean by "tricks?" We were offering configuration recommendations.

I see you still have an APIPA address (169.254.x.x) on the machine in the left picture (Zayan). Why haven't you set a static IP yet to match your other server's subnet?

To better help, please provide the following from each server, then open the text file the command creates, then paste it to your reply.

ipconfig /all > c:\ipconfig-Zayan.txt

ipconfig /all > c:\ipconfigDamyan.txt

Also provide any Event log errors from any of the logs. Post the EventID# and the Source Name in the event.

Thank you,
Ace

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

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

Hi Ace

Haha, just kidding about tricks things, means I tried a lot.

Here are files as you instructed.

For Zayan

Windows IP Configuration

Host Name . . . . . . . . . . . . : ZAYAN

Primary Dns Suffix . . . . . . . : softwarelogicscorporation.com

Node Type . . . . . . . . . . . . : Hybrid

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : softwarelogicscorporation.com

Ethernet adapter Local Area Connection 2:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter #2

Physical Address. . . . . . . . . : 08-00-27-8F-80-44

DHCP Enabled. . . . . . . . . . . : Yes

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::b99e:1eb8:a9a0:227a%14(Preferred)

IPv4 Address. . . . . . . . . . . : 10.0.3.15(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Lease Obtained. . . . . . . . . . : Thursday, December 08, 2011 6:07:24 PM

Lease Expires . . . . . . . . . . : Friday, December 09, 2011 6:07:23 PM

Default Gateway . . . . . . . . . : 10.0.3.2

DHCP Server . . . . . . . . . . . : 10.0.3.2

DHCPv6 IAID . . . . . . . . . . . : 319291431

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-41-A7-0D-08-00-27-85-CC-CB

DNS Servers . . . . . . . . . . . : 192.168.1.1

NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter

Physical Address. . . . . . . . . : 08-00-27-DB-D1-62

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::55f4:3581:2e42:526b%12(Preferred)

IPv4 Address. . . . . . . . . . . : 192.168.0.1(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 252182567

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-41-A7-0D-08-00-27-85-CC-CB

DNS Servers . . . . . . . . . . . : ::1

192.168.0.1

NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter isatap.{93684B6C-EDFC-4AA5-A1B1-C2DCFE928DE0}:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft ISATAP Adapter

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Tunnel adapter Local Area Connection* 11:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Teredo Tunneling Adapter

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{E2880DFC-D6C2-449B-BAFD-66C03D535E4E}:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft ISATAP Adapter #2

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

For Daniyal :

Windows IP Configuration

Host Name . . . . . . . . . . . . : DANIYAL

Primary Dns Suffix . . . . . . . : softwarelogicscorporation.com

Node Type . . . . . . . . . . . . : Hybrid

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : softwarelogicscorporation.com

Ethernet adapter Network Bridge:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : MAC Bridge Miniport

Physical Address. . . . . . . . . : 0A-00-27-89-08-5C

DHCP Enabled. . . . . . . . . . . : Yes

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::b8bb:b51a:4e8b:8fae%17(Preferred)

IPv4 Address. . . . . . . . . . . : 10.0.3.15(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Lease Obtained. . . . . . . . . . : Thursday, December 08, 2011 6:06:57 PM

Lease Expires . . . . . . . . . . : Friday, December 09, 2011 6:06:57 PM

Default Gateway . . . . . . . . . : 10.0.3.2

DHCP Server . . . . . . . . . . . : 10.0.3.2

DHCPv6 IAID . . . . . . . . . . . : 285868071

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-43-B5-C2-08-00-27-A0-A3-BF

DNS Servers . . . . . . . . . . . : 192.168.1.1

NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter

Physical Address. . . . . . . . . : 08-00-27-7D-61-4D

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::b464:9b42:1415:6d1a%12(Preferred)

IPv4 Address. . . . . . . . . . . : 192.168.0.10(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 201850919

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-43-B5-C2-08-00-27-A0-A3-BF

DNS Servers . . . . . . . . . . . : 192.168.0.1

NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter Reusable ISATAP Interface {16AADFC2-5E15-4E51-9BAC-8F47BD543AD6}:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft ISATAP Adapter

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Tunnel adapter Local Area Connection* 11:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Teredo Tunneling Adapter

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{CE11728D-1463-42B3-A484-7C60D1BFABFB}:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft ISATAP Adapter #2

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{C97BDB78-46E7-42EC-B240-46FFCE2DC659}:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft ISATAP Adapter #3

Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Thanks.

MSH

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

Ace

One thing to mentioned...

I have put my own IP settings and still I am getting apipa thing.

Also I have two network connections in Network Panel.

Do I need to get rid of one of them ? If yes then how, cause it done let me delete that and grayed the option.

Pls advice.

MSH

Edited by Salman Haleem Friday, December 9, 2011 4:36 AM

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

The 169.254.x.x is probably coming from a DNS entry that was registered by one of these machines while configured for DHCP but it didn't get a DHCP address.

These are both domain controllers? If so, they can't be DHCP clients.

Also, can you elaborate on why each server has two interfaces? DCs do not work well with multiple NICs and IPs.

For Daniyal :

Windows IP Configuration

Host Name . . . . . . . . . . . . : DANIYAL
Primary Dns Suffix . . . . . . . : softwarelogicscorporation.com
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : softwarelogicscorporation.com

Ethernet adapter Network Bridge:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : MAC Bridge Miniport
Physical Address. . . . . . . . . : 0A-00-27-89-08-5C
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::b8bb:b51a:4e8b:8fae%17(Preferred)
IPv4 Address. . . . . . . . . . . : 10.0.3.15(Preferred)     <- DUPLICATE IP AS THE OTHER SERVER
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Thursday, December 08, 2011 6:06:57 PM
Lease Expires . . . . . . . . . . : Friday, December 09, 2011 6:06:57 PM
Default Gateway . . . . . . . . . : 10.0.3.2
DHCP Server . . . . . . . . . . . : 10.0.3.2
DHCPv6 IAID . . . . . . . . . . . : 285868071
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-43-B5-C2-08-00-27-A0-A3-BF
DNS Servers . . . . . . . . . . . : 192.168.1.1
NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter
Physical Address. . . . . . . . . : 08-00-27-7D-61-4D
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::b464:9b42:1415:6d1a%12(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.0.10(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DHCPv6 IAID . . . . . . . . . . . : 201850919
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-43-B5-C2-08-00-27-A0-A3-BF
DNS Servers . . . . . . . . . . . : 192.168.0.1
NetBIOS over Tcpip. . . . . . . . : Enabled

=============================================================================

Zayan

Windows IP Configuration

Host Name . . . . . . . . . . . . : ZAYAN
Primary Dns Suffix . . . . . . . : softwarelogicscorporation.com
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : softwarelogicscorporation.com

Ethernet adapter Local Area Connection 2:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter #2
Physical Address. . . . . . . . . : 08-00-27-8F-80-44
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::b99e:1eb8:a9a0:227a%14(Preferred)
IPv4 Address. . . . . . . . . . . : 10.0.3.15(Preferred)    <- DUPLICATE IP AS THE OTHER SERVER
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Thursday, December 08, 2011 6:07:24 PM
Lease Expires . . . . . . . . . . : Friday, December 09, 2011 6:07:23 PM
Default Gateway . . . . . . . . . : 10.0.3.2
DHCP Server . . . . . . . . . . . : 10.0.3.2
DHCPv6 IAID . . . . . . . . . . . : 319291431
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-41-A7-0D-08-00-27-85-CC-CB
DNS Servers . . . . . . . . . . . : 192.168.1.1
NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter
Physical Address. . . . . . . . . : 08-00-27-DB-D1-62
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::55f4:3581:2e42:526b%12(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.0.1(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DHCPv6 IAID . . . . . . . . . . . : 252182567
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-41-A7-0D-08-00-27-85-CC-CB
DNS Servers . . . . . . . . . . . : ::1
                                                192.168.0.1
NetBIOS over Tcpip. . . . . . . . : Enabled

From the above results, I can see why you are having numerous problems. The networking configurations were never properly setup.

Based on the above, there are two different DNS addresses being specified. They show:

192.168.0.1
192.168.1.1

Is that a typo when you entered them?

Also, both servers have the same IP address on one of the interfaces!!!!!!???

Zayan: IPv4 Address. . . . . . . . . . . : 10.0.3.15(Preferred)

Daniyal: IPv4 Address. . . . . . . . . . . : 10.0.3.15(Preferred)

What IP range should these machines be on???

Do you know of an IT admin that is familiar with networking that can assist you with properly setting them up and can provide on going support afterwards?

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

Edited by Ace Fekay [MCT] Friday, December 9, 2011 5:12 AM

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

Support

SQL Server 2008 R2 / Management Studio is not connecting to my server instance? How can I trouble shoot this problem?

James Cooper

Changed type Niki Han Wednesday, December 21, 2011 9:15 AM

Reply:

Hi,

I think the issue is related to SQL Server 2008 R2, please post there to get more accurate assistances.

http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/

Best Regards,

Niki

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

It just took a little determination and patience. Thanks for looking out. Now I have to get used to joins, and subquerying my Queries. Any tips?

James Cooper

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

Biztalk 2010 publish Stored Procedueres as WCF Service, but some methods don't work

Hi All, This is Jessie,

I published SQL stored procedures as wcf services. Before published them, I have tested every stored procedure, they all worked.

After the service been published, I have tested every single method in the WCF service in SoapUI, all worked.

Then I add the wcf service as reference into the Visual Studio project (C# Code). One of the method -- 'GetClient' is based on ClientID and ClientName those 2 parameters to get ClientID, ClientName,ClientPhone, ClientEmail, ClientAddress.

When starting to debug the project, code calls "GetClient", it always has an error says the stored procedure or function 'GetClient' expects @ClientID, which was not supplied. the code looks pass the ClientID and ClientName in, for some reason which I dont know, the biztalk doesn't recognize or doesn't take ClientID as a parameter.

Is there anything wrong in the orchestration design? or any places? please give me a clue..

Appreciate your all help!! Thank you!!

Changed type Steef-Jan WiggersMVP Thursday, December 29, 2011 2:04 PM No reply

Reply:

Your question is a little confusing. Did you generate a schema for the SQL stored procedure and then published the schema as a WCF service?

What part of your solution includes the orchestration? Could you describe the orchestration?

Thanks,

If this answers your question, please use the "Answer" button to say so | Ben Cline

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

Cannot make Lync Call from exteral to internal Client

Hi,

When trying to start a Lync Call from an external Lync Client I get "Call failed due to network issues", same problem when making Lync Call from internal to external Client.

Checking Lync logs I find the same message on both external client and FE-server:

ms-client-diagnostics: 23; reason="Call failed to establish due to a media connectivity failure when one endpoint is internal and the other is remote";CallerMediaDebug="audio:ICEWarn=0x2b,LocalSite=90.233.185.167:15790,LocalMR=94.127.32.24:3478,RemoteSite=172.30.127.23:7732,PortRange=1025:65000,LocalLocation=1,RemoteLocation=2,FederationType=0"

There are other threads suggesting that the resolution is to add the edge av address so that it can be resolved in internal DNS, this doesn't help. http://social.technet.microsoft.com/Forums/en-US/ocsedge/thread/522e7f53-d0d4-4b08-9917-45b80a292963

This a a screenshot of NMON from The external Lync client

The external client can resolve the ip-adress of the external av edge FQDN

There's one consolidated edge with 3 IP-adresses and one internal pool consistingf of one FE and a BE SQL DB.

The IPs assigned to the public EGDE interfaces are private so there's a firewall in front doing NAT.

Any suggestions?

Best regards, Daniel

www.twitter.com/danielullmark

Reply:

I think this could be related to the firewall configuration of traffic to/from the edge A/V interface.
Anyone that has done this config on a watchguarf firewall, send me a message. Thanks.

www.twitter.com/danielullmark

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

Updated routing info on edge and did some firewall config

www.twitter.com/danielullmark

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

HowTo: Installing Linux Integration Components on Ubuntu and Debian

All,

The past few days I have been nose down with determination to not rest until I have completely documented how to get the integration components for Hyper-V working under Ubuntu Linux and Debian Linux... This can be evidenced by my bloodshot eyes and moderately angry wife. Well I am glad to say I am finished and I will be sleeping like a baby tonight.

Anyways this guide is a step-by-step howto for the Integration Components (v1) for Ubuntu Linux 8.04-2, 8.10, and 9.04 and Debian 5. I did all of my testing and documentation on the x64 platform however all commands will be the same (with the exception of architecture names) for x86.

So if this howto is of interest to you please visit my blog and check it out.

http://blog.allanglesit.net/Blog/tabid/66/EntryId/22/Hyper-V-Guests-Linux-Integration-Components-Ubuntu-and-Debian.aspx

-matt

If this post is helpful, please mark it as such.

Edited by Matthew Mattoon Tuesday, May 26, 2009 11:25 PM updated link to reflect new blog engine.

Reply:

Sweet ! Thanks .

-- ChetanG -- This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all.

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

awesome!!! finally someone has actually done this

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

I am having trouble with this, and noticed your blog was down.... please tell me you have a backup copy of this available.

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

Critical situation in cube development

most critical situation you faced in cube development and processing give me some examples Thank U

Vijay Kolisetty

Changed type Challen Fu Thursday, December 8, 2011 7:23 AM sharing

Reply:

Hi,

Your statement is more relevant to disscussion about sharing and open question, so I change its type to discussion to involve more communities to join.

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

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

Thanks Challen

Vijay Kolisetty

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

office attachments in outlook take too long to open

Hi,

I'm using windows 7 x64 and ms office 2010 32bit. It takes about 20 seconds to open an office attachment such as a word or excel attachment from within microsoft outlook. I launched outlook in safe mode and had the same results. I even tested by disabling my anti-virus software and encountered the same problem. I also cleaned out the OutlookSecureTempFolder but that didn't help either. Lastly, I uninstalled and reinstalled office 2010, which didn't help. I am connected to an ms exchange 2007 server through outlook.

Any suggestions?

thanks!

-sul.

Reply:

Hi,

please refer below articles... this may help you...

http://answers.microsoft.com/en-us/office/forum/office_2010-office_install/word-and-outlook-2010-slow-to-open/83df6e31-43e7-4e85-8d4f-ddb957cc1e8c

http://blog.krisgielen.be/archives/55

Thanks & Regards, Kottees *** Please mark it as an answer if it really helps you.

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

process incremental for cube

Hello,

I have a cube which consists of 150gb, if we make Process Incremental. How much time will it take. If any make this, would be appreciable Thank U

Vijay Kolisetty

Changed type Munna Kollu Thursday, December 8, 2011 6:36 PM

Reply:

Hello Vijay,

During a "incremental process" only new data are pushed into the cube. A temporary partition is created, filled with the new data and the the temp partition is merged with the productive one.

So the time for processing depends on the amount of new data.

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

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

Hello, Thanks for ur reply. In this scenario the updates r made thats k. But i want approximate time for Process incremental for 150gb sized Cube Thanking U

Vijay Kolisetty

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

Hello Vijay,

It depends on many factor like your server & storage performance and the amount of new data; test it then you know it.

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

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

hello olaf,

Thanks for ur reply, tell the approximate time according to ur sys specifications ...This is an interview question that my friend faced. So i also wanna about that one. I have my sys here, thats not part of the server.

Thanking U

Vijay Kolisetty

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

Hi Vijay,

Just as Olaf mentioned the time for processing depends on the amount of new data, it is not recommend to ask this kind of interview question, you can create a disscussion type thread involving more communities to join in. Next time, if you encounter question, please supply detail information. Please also pay attention to "how to ask a question" guideline to our forums http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/54e60911-f2fd-4f7f-8eca-a0f2b92abc65

Thanks,
Challen Fu

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

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

Hello Challen,

Thanks for ur suggestion, I'm taking this as a +ve. I did this for my friend k any way i 'll inform to my friend also. Once again thanks for ur reply..:)

Vijay Kolisetty

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

"Date modified" incorrect on scans saved to server

We have a SBS2011 SP1 x64, all updates applied. We also have a networked Cannon document scanner.

Starting last week out of the blue (no changes made that week to anything that IT knows) all of a suddent any document scanned to the server is showing it's file "Date modified" as -7hrs. Example; we scan a document at 8AM it says we scanned it at 1AM.

The timer & zone on the server is correct, time on the document scanner is correct, the time on the clients viewing the scan folder looking at the timestamps are set correct, even the time in the Cisco switch is correct (not that it would matter but whatever). I'm out of things to check. Maybe the BIOS on the server? I don't want to shut it down to check though.

Any ideas?

Thanks! Alex

Reply:

Bump...still have the issue

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

Ms Support forum

Thursday, March 3, 2022