Hotfix 1.1.1501.203
Hello,
Can some one explain me Hotfix 1.1.1501.203 with respect to SQL Server 2000 SP4.what's importance of this hot fix and can it be applied on SQL 2005 SP3?
Reply:
Hello,
It is a fix that applies only to the JDBC driver used to get connected to a SQL Server 2000 instance. Please see the following article for a detailed explanation:
http://support.microsoft.com/kb/928616
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
------------------------------------
Passing values in select statement as a parameter
Hello,
Iam trying tobuild a report inwhich the user can select what he want to see and group by. My SQL statement is somethign like this:
select @groupA
,@groupB
,COUNT(*)
from vw_Fact
group by @groupA,@groupB order by COUNT(*) desc
I would like theuser to decide how he wants togroup it.
Now when i paste tjis query in query builder, it first asks for the values of those parameters. If i leave them NULL, then i get a group by error.
If i cancel it and go ahead, doesnt show me any available columns.
I am very new to SSRS so it would be great if you could explain in baby steps.. How can i get this functionality.
Thanks,
CK
Reply:
First thing you will have to understand, the output of alll the queries shpould be the same. Reason is, if you have your first out selected for group - G1 and G2, then your output column names would be G1 and G2. You would be using this name for creating your report items. Next time, when you select G3, the report would be expecting G2 in the report items and would give an error.
A work around would be to alias the columns as say, col1 and col2 (if you know that the column numbers are fixed, else you need a different thought process).
You can write a sample query without parameters like
select G1 as col1, ,G2 as col2 ,COUNT(*) as Cnt from vw_Fact
Once you press on OK, you can see that the fields are there in the dataset. Now go and edit your sqlquery like shown below
="select "+Parameters!groupA.Value+" as Col1,"+Parameters!groupB.Value+" as Col2,COUNT(*) as Cnt from vw_Fact group by "+Parameters!groupA.Value+" ,"+Parameters!groupB.Value+" order by COUNT(*) desc"
Make sure that the entire code is in one line in the expression editor, else you might need to add the start quotes and end quotes as required at each line.
You can see that basically we are creating a dynamic sql but the column output is always same. So it should work, I have done this type of reports before.
Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
------------------------------------
Lotus Notes to SharePoint Migration
Hello,
Currently I am working on a project where we need to migrate various Lotus Notes databases to SharePoint 2010 environment. We have planned to do this with Quest. The problem that we are facing is, many of the LN applications/ databases have size more than 20GB. It's very hard to migrate 20GB application on a single site collection. What is the limit for a single site collection? Can we upload 20-50GB data on a single site collection?
And again the requried time for migrating 20GB data is worrying factor. How much time will require to migrate 20-40GB data? It may take several days to complete the migration job. What does happen if migration throws any error in between executing the job? If it throws any error do we need to run the jobs again for all the records?
Can I have any suggestions about managing site collections and dividing migration jobs??
Thakns,
Pratima
Reply:
Hi there,
first, on a functional level:
- do you really have to migrate all that data? Perhaps you only need the data from the last 3-5 years instead of everything ?
A site collection can be as large as the content db (200GB). (via http://technet.microsoft.com/en-us/library/cc262787.aspx#ContentDB)
Your question of the required time is heavily influenced by the hardware / network you have.
Ask the people of Quest, they can probably give your some rough estimations. Ofcourse you are going to do a test run, so you can check the time there ;)
http://marijnsomers.blogspot.com || @marijnsomers
------------------------------------
Reply:
Not wanting to split hairs about the size of the Site Collection:
CORRECT:
A site collection can be as large as the content database size limit for the applicable usage scenario. For more information about the different content database size limits for specific usage scenarios, see the Content database limits table in this article.
HOWEVER:
In general, we strongly recommend limiting the size of site collections to 100 GB for the following reasons:
- Certain site collection actions, such as site collection backup/restore or the Windows PowerShell cmdlet Move-SPSite, cause large Microsoft SQL Server operations which can affect performance or fail if other site collections are active in the same database. For more information, see Move-SPSite.
- SharePoint site collection backup and restore is only supported for a maximum site collection size of 100 GB. For larger site collections, the entire content database must be backed up. If multiple site collections larger than 100 GB are contained in a single content database, backup and restore operations can take a long time and are at risk of failure.
Reference: http://technet.microsoft.com/en-us/library/cc262787.aspx#SiteCollection
blog: http://sharepointingitout.blogspot.com
------------------------------------
[Info Sharing]: You may get "Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi" error message when you repair an instance SQL Server 2008
Title: You may get "Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi" error message when you repair an instance SQL Server 2008
| Intended Audience :
|
Applies to Products: Microsoft SQL Server 2008 Workgroup, Microsoft SQL Server 2008 Web, Microsoft SQL Server 2008 Standard Edition for Small Business, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft Visual Studio 2008 Team Suite Service Pack 1, Microsoft Visual Studio 2008 Team Edition for Database Professionals Service Pack 1, Microsoft Visual Studio 2008 Team Edition for Software Architects Service Pack 1, Microsoft Visual Studio 2008 Team Edition for Software Developers Service Pack 1, Microsoft Visual Studio 2008 Team Edition for Software Testers Service Pack 1, Microsoft Visual Studio 2008 Standard Edition Service Pack 1, Microsoft Visual Studio 2008 Professional Edition Service Pack 1, Microsoft Visual Basic 2008 Express Edition Service Pack 1, Microsoft Visual C# 2008 Express Edition Service Pack 1
Source SR/Case Number: Click here to enter text.
FAST PUBLISHING
Symptom
Consider the following scenario:
· You install Microsoft Visual Studio 2008 Service Pack 1.
· You install Microsoft SQL Server 2008 side by side with Visual Studio 2008 Service Pack 1.
· You try to repair the SQL Server 2008 instance, using Add or Remove Programs feature in Control Panel
In this scenario, the repair action will fail with the following error message
Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401
Note: The issue will also happen with the release version of Visual Studio, but as noted in the release notes, SQL Server 2008 requires Service Pack 1 for Visual Studio 2008 if you need to use Management tools, Integration services and Business Intelligence Development studio features.
Cause
Visual Studio 2008 SP1 and SQL Server 2008 shipped the same MSI package for SSCE runtime but with different file names. SQL Server shipped it as SSCERuntime.msi while Visual Studio 2008 SP1 shipped it as SSCERuntime-enu.msi. During the repair operation, Windows installer tries to change the name of the MSI shipped with Visual Studio.net to the one that is shipped with SQL. Since this is not allowed by Windows installer, the repair operation fails with the error mentioned in the symptom section.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
To resolve this problem, follow these steps:
1. Remove Microsoft SQL Server Compact 3.5 SP1 <Language> using Add or Remove Programs feature in control panel.
2. Rerun the repair operation for SQL Server 2008. After the repair operation, SQL Server Compact 3.5 SP1 <Language>is reinstalled on the system.
Note <Language> is a placeholder for the language of SQL Server Compact 3.5. For example, ENU is for English, and JPN is for Japanese.
If you experience any problems reinstalling the compact edition through the repair option, you can install the compact edition using the setup files that are available in the Servers\Setup folder on the SQL Server 2008 installation media. You can also download SQL Server Compact 3.5 SP1 from the following Microsoft Download Center Web site:
More Information
· 955396 How to troubleshoot SQL Server 2008 Setup issues
· SQL Server Troubleshooting and Support
· 955965 Description of SQL Server Compact 3.5 Service Pack 1
------------------------------------------------------------
Microsoft's Role: Microsoft does not offer formal support for the communities you'll find here. Instead, our role is to provide a platform for people who want to take advantage of the global community of Microsoft customers and product experts. Microsoft may monitor content to ensure the accuracy of the information you'll find, but any information provided by Microsoft staff is offered "AS IS" with no warranties, and no rights are conferred. You assume all risk for your use.
Microsoft Online Community Support
Reply:
Error 1316 is an installation error. It pops up when a software is being installed, uninstalled or repaired on your computer.You may get the following description while seeing this error:
Error 1316:"A network error occurred while attempting to read from the file: :\Install.msi"
Follow the following guidelines to fix this error:
1. Use Windows Installer Clean Up
2. Use a Registry Fixing Utility
3. Change Windows Installer Registry Information
4. Check the Security Details of the Concerning File
you can also get some help from this article to fix error 1316 win 7
------------------------------------
I have a query regarding the display name of the Active directory user. Can anyone provide their feedback that how we can empty/remove the display name of a Active directory user?
for your information i have followed up below mentioned steps for removing the Display name from AD.
I have removed the Display name attributes from the AD user properties.
Reply:
You can do the same thing from Adsiedit.msc
Just curious, why would you want to do it? How many user's are their?
Gulab Prasad,
MCITP: Exchange Server 2010 | MCITP: Exchange Server 2007
MCITP: Lync Server 2010 | MCITP: Windows Server 2008
My Blog | Z-Hire Employee Provisioning App
------------------------------------
Reply:
Hi Gulab,
Thanks for lookintg into the issue.
we have large no. of users in the active directory can not count. Can you please provide me the steps. Will be helpful.
- Gurmeet
- Edited by Gurmeet Singh Sehgal Wednesday, February 22, 2012 10:24 AM
------------------------------------
Reply:
Configuration...Default Naming Context...Look for the Container where user is...Right click and go to properties...Look for attribute..displayname
if you don't want DisplayName, make sure it's notset
Cheers,
Gulab Prasad,
MCITP: Exchange Server 2010 | MCITP: Exchange Server 2007
MCITP: Lync Server 2010 | MCITP: Windows Server 2008
My Blog | Z-Hire Employee Provisioning App
------------------------------------
Adding website to trust site from Internet Explorer can be synchronized to GPO?
Hi all,
I add the website to trust site from Internet Options with administrator account, but i do not know whether it can be deployed to all domain or users in the whole domain.
I check the trust site list from GPO, yes, the website is there.
Thanks!
Br,
Fiona
Reply:
Hi,
For obvious reasons the Administrator's settings are separate from the Computer's User's GPO settings.
Logon with a user account and then see if the new site has been added to the User's account IE Trusted Sites list...but you may have GPO settings that prevent users accessing the Security tab of Internet Options.
In IE9 and earlier you can find out which Ie security zone a site is mapped to from the File>Properties menu.
Ie8 and earlier display an icon in the Status bar (if enabled).
Regards.
Rob^_^
------------------------------------
Reply:
Hi,
Due to the site was not in the trust site, i wanted to add the site to the trust site from GPO.
I got the message box "This site is already in the Trust sites zone".
But i cannot see the site into the list actually...
So what i can do was only add the site from IE directly.
I found the site was already added into the registry.
I tried to delete the key in HKCU. Like
HKCU\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\EscDomains\<company.com>\<*.rc9.netact>
But i still cannot add the site into trust site.
Then i deleted the key in HKLM.
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\EscDomains\<company.com>\<*.rc9.netact>
It's ok i can add the site to the trust site.
I tried to reproduce this issue by removing the site from GPO setting, then manually adding the key into both HKCU and HKLM, then rebooted the server.
After that, i tried to add the site into the trust site from GPO, no error...that means i cannot reproduce the issue...I don't know why...
------------------------------------
Reply:
Hi,
do not try to hack the IE Secrity zone keys manually.... use gpedit.msc to administer your Trusted Sites list....
gpedit.msc uses different registry keys than the ones you manually tried to update.... it is too complex to try to explain it here....
just use gpedit.msc
don't hack the registry unless you have great confidence in that you know what you are doing...
Regards.
Rob^_^
------------------------------------
The full path to current folder in document library page breadcrumb
EventID 20050 on Site-to-Site VPN
Recently this error has popped up on my site-to-site VPN. I was not the last person who reconfigured it, although I was the first person who configured it, so I'm trying to track down what has changed between then and now.
The server-in-question is both a site-to-site VPN provider, and a client VPN provider.
Client VPN works fine. Client VPN works fine from the site where the site-to-site VPN is not working. Client VPN from this site works fine to the remote site.
I've tried deleting the local user accounts on both ends for the remote sites, recreating them, and recreating the site-to-site VPNs in ISA 2006 SP1, and that does not work or fix/alter the problem.
When I try and initiate the connection from the remote end, I get this on the local server:
Event Type: Error
Event Source: RemoteAccess
Event Category: None
Event ID: 20050
Date: 21/02/2012
Time: 12:03:44 PM
User: N/A
Computer: LEAHYISA1
Description:
The user LEAHYISA1\BaragerHome connected to port VPN3-106 has been disconnected because no network protocols were successfully negotiated.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
If I setup a VPN connection on my workstation, to connect to the ISA server with the same username/password, I get the same error (i.e. the error is not related to the remote server, it is related to the local ISA).
I've tried deleting everything and recreating it using L2TP/IPSec instead of PPTP, the problem persists.
EDIT: Checking the event log (historically) this EventID only started appearing after I changed the WAN adapter's IP address on Friday the 17th, because my ISP changed my assigned IP.
EDIT: Restarting RRAS (by itself) and Microsoft Firewall (which restarts the RRAS service) has no effect.
- Edited by Spike15 Tuesday, February 21, 2012 8:52 PM
- Changed type Nick Gu - MSFTModerator Saturday, February 25, 2012 3:50 PM
Reply:
Hi,
Thank you for the post.
Before going any further, I'd like to confirm the following question:
- is the RRAS Server's network card configured as a DHCP client?
- Is the RRAS Server is conifigure to obtain addresses from DHCP for VPN and dial up clients?
- Do you receive any error message when running ISA BPA in the server?
Regards,
Nick Gu - MSFT
------------------------------------
open media file in windows media player
Hi.
I have created Content Query Web Part which displays list of video urls.
But when I click on them it is not opening in windows media player.
It is opening some silverlight player on browser and gives error that "media failed to load"
How to open that links in windows media player ?
Reply:
Hi,
Do you want to force all users to use windows media player on their client machine? are the users part of your company so you can insure they have windows media player?
Regards
MCITP & MCPD Sharepoint 2010 ¦ MCITP Server 2008 Administrator ¦ MCP
------------------------------------
Reply:
@Spyderco
Yes, I want them to use media player only.
And If u can tell why silverlight is giving the error. ?
------------------------------------
Reply:
Hi,
The only way i know of that may work, but is not advisable, is to manually edit the DOCICON.xml file, which specifiys how sharpeoint should handle file types.
If you have sharepoint installed in the default location, you can find the file here: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\DOCICON.xml
Inside this file you will find entrys for the various file types like this:
<Mapping Key="doc" Value="icdoc.png" EditText="Microsoft Word" OpenControl="SharePoint.OpenDocuments" />
The OpenControl attribute is what you will want to change. it may be enough to simply leave it blank, as that tells sharepoint to let your browser decide what to do with the file.
You will need to do this manually on every server in your farm, and also remember to check it after any upgrades/service packs, as they will likely write over your changes, hence why i say it is not advisable, although sometimes it is the only option.
As for your silverlight error, have you got any error messages, other than "Media failed to load"? have you checked in the logs to see if their is a stack trace?
Regards
MCITP & MCPD Sharepoint 2010 ¦ MCITP Server 2008 Administrator ¦ MCP
------------------------------------
Reply:
Hi Spyderco,
Thank You for the reply.
My Silverlight is giving one more error.
When I try to create content It throws me a error called "An Unhandeled Exception Occured"
See, if you can help.
------------------------------------
Reply:
Hi.
Im sorry but that silverlight error could be almost anything, without more info its going to be impossible to diagnose.
Regards
MCITP & MCPD Sharepoint 2010 ¦ MCITP Server 2008 Administrator ¦ MCP
------------------------------------
default my docs folder
Hi all
I did a search but couldnt find something thats related to my query.
I have windows server 2008 r2 with windows 7 64bit client
I have configured my doc folder redirection. under user names the home drive is set to H: with \\severname\home\%username% followed by group policy folder redirection and create folder under \\servername\home\
But when a user logs in all they see is the local documents. When user goes to word then save as it defaults to local drive not one on server/ or h mapped drive?
how can i make it so h drive is default?
Reply:
Hello sundeep1984,
first of all, your folder redirection is not working?
Which permissions did you set to the share and folder?
http://technet.microsoft.com/en-us/library/cc775853%28v=ws.10%29.aspx
MVP Group Policy - Mythen, Insiderinfos und Troubleshooting zum Thema GPOs: http://matthiaswolf.blogspot.com/
------------------------------------
Reply:
Kindly check how to Configuring Folder Redirection in Windows Server 2008
http://technet.microsoft.com/en-us/library/cc782799(v=ws.10).aspx
http://www.itechtalk.com/thread1958.html
Mohamed Abd Elhamid Abd Elaziz Microsoft System Administrator My blog: http://Mabdelhamid.wordpress.com/
------------------------------------
Reply:
Hi,
I'd like to confirm the advanced security setting configured correctly.
For details:
1. Right click the folder which you had configured home folder connect to.
2. Point Properties, on the Sharing Tab, click Share, make sure the specified users have Read/Write Permission.
3. on the Security Tab, click Advanced.
4. On the Permission Tab, Make sure the specified users have Full control Permission and Apply to This folder, subfolders and files.
5. On the Owner Tab, Make sure the Current owner is Domain Admin.
Please make sure the user can access and create a new folder with the specified folder successfully.
Please make sure the Folder Redirection configured correct.
For details:
Folder Redirection: Group Policy
http://technet.microsoft.com/en-us/library/cc781907(WS.10).aspx
Please make sure Always wait for the network at computer startup and logon policy is set to Enable. (Computer Configuration\Administrative Templates\System\Logon\ Always wait for the network at computer startup and logon)
In addition, there is a related article for your reference:
When you redirect the Documents folder on a Windows Vista-based or Windows 7-based computer to a network share, the folder name unexpectedly changes back to Documents
http://support.microsoft.com/kb/947222
Hope this helps!
Best Regards
Elytis Cheng
Elytis Cheng
TechNet Community Support
------------------------------------
How to get TCP chimney offload settings using WMI class or equivalent
By using netsh command "netsh int tcp show global" we can see tcp chimney settings on Windows OS like Win2k3/win2k8 systems.
But I am looking for WMI class or equivalent class to check the status from my application.
Any clue or idea?
- Moved by Paul E Long Monday, February 13, 2012 4:19 PM Not a Network Monitor question (From:Network Monitor)
- Changed type Arthur Xie Wednesday, February 29, 2012 9:47 AM
Reply:
Hi,
I suggest you post a new thread in the correct forum in MSDN.
------------------------------------
Reply:
------------------------------------
Download file via BITS to workstation, which isn't in domain
Hi guys!
I have 1 fileshara (server in domain) and I need to download file to workstation (not in domain) via BITS
What I did:
C:\Documents and Settings\Admin>bitsadmin /create testjob
BITSADMIN version 2.0 [ 6.6.2600.2180 ]
BITS administration utility.
(C) Copyright 2000-2004 Microsoft Corp.
Created job {DAC5D798-91D1-415C-A42F-8BEA732CA2AD}.
C:\Documents and Settings\Admin>bitsadmin /setcredentials testjob server basic fileserver\c
lient 123456
BITSADMIN version 2.0 [ 6.6.2600.2180 ]
BITS administration utility.
(C) Copyright 2000-2004 Microsoft Corp.
OK.
C:\Documents and Settings\admin>bitsadmin /addfile testjob /CCM_Client/i386/client.msi">http://<ip-fileserver>/CCM_Client/i386/client.msi -> c:\1\client.msi to job.
C:\Documents and Settings\admin>bitsadmin /list /allusers /verbose
BITSADMIN version 2.0 [ 6.6.2600.2180 ]
BITS administration utility.
(C) Copyright 2000-2004 Microsoft Corp.
GUID: {DAC5D798-91D1-415C-A42F-8BEA732CA2AD} DISPLAY: testjob
TYPE: DOWNLOAD STATE: SUSPENDED OWNER: workstation\administrator
PRIORITY: NORMAL FILES: 0 / 1 BYTES: 0 / UNKNOWN
CREATION TIME: 21.02.2012 14:11:06 MODIFICATION TIME: 21.02.2012 14:11:32
COMPLETION TIME: UNKNOWN ACL FLAGS:
NOTIFY INTERFACE: UNREGISTERED NOTIFICATION FLAGS: 3
RETRY DELAY: 600 NO PROGRESS TIMEOUT: 1209600 ERROR COUNT: 0
PROXY USAGE: PRECONFIG PROXY LIST: NULL PROXY BYPASS LIST: NULL
DESCRIPTION:
JOB FILES:
0 / UNKNOWN WORKING /CCM_Client/i386/">\\<ip-fileserver>/CCM_Client/i386/ - can open using fileserver\client without any problem
Жизнь стоит того, чтобы не быть сволочью.
Reply:
Hi Donec,
Thanks for sharing your experience with using BITS with us. I think many people will get help from your sharing.
In addition, I also would like to add some more information regarding BITS in this thread:
Bitsadmin Overview
http://technet.microsoft.com/en-us/library/cc779476(v=WS.10).aspx
Arthur Li
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.
Arthur Li
TechNet Community Support
------------------------------------
Registy Entry for Office version and service Pack
I am interested in office 2003 and sp3 registry path?
Reply:
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
------------------------------------
TMG Publish SharePoint 2010 with Anonymous and Authenticated access
Hi,
I would like the option to have users hit the site anonymously but if they click sign in, they will be redirected back to TMG FBA to authenticate.
What would be the best approach to do this?
Thanks,
Troy
troy
Reply:
Hi,
Please check this link,
http://msdn.microsoft.com/en-us/library/gg430121(v=office.12).aspx
I hope this will help you.
Thanks,
Best Regards, ----Naresh Man Maharjan,Nepal---- www.msserverpro.com
------------------------------------
Reply:
Thanks Naresh. Unless I missed something that was more on how to publish a sharepoint via TMG 101?. But didnt explain the best approach on how to publish sharepoint for anonymous access and when a user clicks sign in, they can authenticate via HTTPS etc..
Perhaps the only way this can be done is via 2 rules and 2 different URL's? Unless I'm mistaken? one http and one https?
Any thoughts please?
Thanks,
troy
------------------------------------
Reply:
Dave Barker
------------------------------------
Reply:
Hi Dave,
Unfortunately the only way I have found to do this, is to use TMG as a proxy with anonymous access and change the authentication tab to 'no authentication, but the client may authenticate directly' and enable SP2010 FBA and let sharepoint handle the authentication.
Kind of sucks that this seems to be the only way to do this.
Cheers,
Troy
troy
------------------------------------
Custom Task list for Office 365
Hi
Since MS says that the Tier 1 & Tier 2 Support would be retained by the Customer and only the Tier 3 issues would be escalated to MS.
Would someone share with me the Tier1 & tier 2 task list that has to be managed by the customer, because I am unable to locate it anywhere.
Regards.
Reply:
http://community.office365.com/en-us/f/default.aspx
+Say thanks and observe basic forum courtesy:
+If this post answered your question, Mark As Answer
+If this post was helpful, Vote as Helpful
windowspbx blog: my thots/howtos
see/submit Lync suggestions here: simple and public
------------------------------------
Lync/Exchange Integration woes
When I first setup our system I had the Lync/Exchange integration working. I followed this guide http://blog.schertz.name/2010/11/lync-and-exchange-im-integration/. I made some topolgy changes to add an Edge Server which failed, so I reverted back to the working topology. Now the intergration doesn't work. I have deleted the exchange application pool and went back over the steps in the blog post above. On the exchange server I can see. Event 112, MSExchange OWA "Instant Messaging Endpoint Manager was initialized successfully." On the Lync server after I do the Enable-CsTopology. I get this http://funkybassplayer.com/enable-cstopolgy.jpg. What has me suspicous is the fact it is skipping the creation of the SCP. Any ideas how to get this working again?
Reply:
hi,
You description does not point to the actual problem.It seems that you have issue deploying the Edge server and in the process not Owa integration is not working.
------------------------------------
Reply:
- Edited by The_Techguy Wednesday, February 15, 2012 6:15 PM
------------------------------------
Reply:
hi,
For IM -OWA integraton you should look for following
1) Trusted application server in Lync Topology( FQDN of CAS or external OWA Url ex .,mail.contoso.com)
2) Certificate assigned to the Trusted Application server with subject name matching FQDN of Trusted Application server.
3) Check following registry value (HKLM\System\CurrentControlSet\Services\MsExchangeOWA\InstantMessaging)
Check OWA virtual directory settings (Get-OwaVirtualDirectory | fl)
4) Check events on Exchange server Client Access .
If you are able to see the presence of contacts ,but there is probem with IM using OWA .
Enable lync Logging tool and trace the IM conversation.
------------------------------------
Reply:
1) Application server is in the topology , exchange.domain.com, without replication.
2) The certificate assigned to the Trusted Application server is a godaddy/starfield SAN cert, with the FQDN of the server as the primary name. this goes for the Lync FE server also.
3) The key exists on the exchange server with ImplementationDLLPath
C:\Program Files\Microsoft\Exchange Server\V14\ClientAccess\OWA\bin\Microsoft.Rtc.UCWeb.dll
On the second point of 3,
[PS] C:\Windows\system32>Get-OwaVirtualDirectory | fl *instant*
InstantMessagingCertificateThumbprint : 3729BD93485F1F56968141ACA555F7C06D5E1B87
InstantMessagingServerName : lync.domain.com
InstantMessagingEnabled : True
InstantMessagingType : Ocs
I have verified it's the correct thummbprint
[PS] C:\Windows\system32>Get-ExchangeCertificate|fl Services,Thumbprint
Services : IMAP, POP, IIS, SMTP
Thumbprint : 3729BD93485F1F56968141ACA555F7C06D5E1B87
4) I see no obvious error events in the event viewer. I am not able to see the presence of contacts at all, let alone the "chiclets". I have used the Lync Logging tool, and selects SIPStack and all flags. I see no error events there either.
I am open to any ideas.
------------------------------------
Reply:
I fixed it.
Set-OWAMailboxPolicy -Identity [Your Policy's Identity] -InstantMessagingType 1
That did the trick.
------------------------------------
My exchange users no longer receive alerts from sharepoint 2010
I have sharepoint 2010 and exchange 2010.
2 weeks ago my exchange users stopped of receiving alerts. The alerts only works when I create and alert in the site. After that, the users no longer receive more alerts everytime that a file is updated.
I haven't made changes in the infraestructure.
I've been looking in diferent forums, and I've tried diferent solutions, like restart the service owstimer.exe, Use STSADM to reset properties, Use STSADM to re-register the alert templates.
I have used instructions like this
like this stsadm -o updatealerttemplates -url http://YourSiteURL -f "c:\Program Files\CommonFiles\Microsoft Shared\web server extensions\12\TEMPLATE\XML\alerttemplates.xml"
-LCID 1033
But it didn't solve the problem
Any help will be welcome
Reply:
Hi,
So you are aware of no changes in the exchange and SharePoint environment that can remotely cause this issue? Possibly, this will need a good amount of troubleshooting. When a scenario occurs as a result of which the users should get an alert (for example, someone modifying a document), do you see any errors in the event logs? How about ULS logs?
Can you create another site collection (for testing purposes only) and subscribe to some alerts there and see if this Site Collection is any different?
Thanks, Soumya | MCITP, SharePoint 2010
------------------------------------
Change Retention Period in Transactional Replication (T-SQL)
Hi,
How can we change the retention period ( in Trasanactional Peer-To-Peer Replication)through T-SQL. I know how to do that through GUI. If increase the Retention period do i need to restart the Replication?
Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
Reply:
Hi Found the answer.
USE <Database> GO sys.sp_changedistributiondb @database='distribution',--Default name @Property='max_distretention', @value=288; GO
The property parameter value must be 'min_distretention', 'max_distretention' or 'history_retention'.
Minvalue will be 0 default in Hr's.
Maxvalue in Hr's.
History_retention will be replication performance data .
Value in hr's.
Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
------------------------------------
SSRS report parameter dates format
Hi,
I need my report date parameters to display non-american format dd/mm/yy.
I could only get the report manager to do this (by changing the culture of report.aspx page) but I can't get the report viewer to display the format properly. So when users set a parameter date such as 15/02/2011 the report cannot run.
I've already tried:
1) In web.config added <globalization culture="en-AU" uiCulture="en-AU" />
2) Culture of Report.aspx & ReportViewer.aspx Culture="en-AU"-helps only report manager parameter date format
3) Client PC regional setting (which I wouldn't want to change anyway)
4)IIS-->Properties-->AsP.NET(taB)-->Application(Tab)-->Globalettings(Culture)
5) server regional settings
None of the above helped for the report viewer. Since the link from email subscriptions points the user to the report viewer and not the report manager, I must have the format correctly there.
The only solution I found is to change the clients IE language settings but I would prefer not to do that.
Any idea as to how to define the correct parameter format in the report viewer?
Or at least alternatively, how to set the subscription email link to point to the proper report in report manager? (I've tried some culture and path changes on rsreportserver.config but no luck).
Thanks
Namnami
- Edited by namnami Wednesday, February 15, 2012 11:39 AM spelling
Reply:
Hello Namnami-
Have you considered tweaking the parameters in the report data set itself?
I.e. if users are entering data in format dd/mm/yy the query could say:
SELECT * FROM TABLE1 WHERE DATE1 BETWEEN (SUBSTRING('DD/MM/YY',4,3) + SUBSTRING('DD/MM/YY',1,3) + SUBSTRING('DD/MM/YY',7,2)) AND (SUBSTRING('DD/MM/YY',4,3) + SUBSTRING('DD/MM/YY',1,3) + SUBSTRING('DD/MM/YY',7,2)) Bonediggler
------------------------------------
Dell OEM upgrade question
Reply:
Noel Paton | Nil Carborundum Illegitemi | CrashFixPC | The Three-toed Sloth
------------------------------------
No comments:
Post a Comment