string measure
i have a string column (named status) in a fact table and i want to add it as a measure in the cube.
when i choose Usage="No aggregations" , i got the following error:
Errors in the metadata manager. The data type of the 'Status' measure is not valid because the data type of the measure is a string type.
am i choosing the wrong Usage ? how should i treat string measures or columns in cubes ?
- Changed type Butmah Wednesday, October 17, 2012 5:47 AM because it converted to a discussion
Reply:
------------------------------------
Reply:
because it's a "status" on the combination of the ids in the fact table. the fact table is about timesheet; so the "status" indicates whether the timesheet for a certain employee under a certain supervisor in a specific date is accepted, rejected, or pending ....etc.
i though about degenerated dimension, but, first i'm not sure if this is the best solution for such case, second i don't know how to create a degenerated dimension in visual studio 2008 :P
------------------------------------
Reply:
i would not create a degenerated dimension for this. Instead create a static dimension say Status and have the data populated it through initial script. Most likely the chances of adding new status is less. If added, i would store it as unknown first and then update it.
Then in ETL, i would get the id using lookup and then store the Statusid in fact.
degenerated dimension is not a good idea as it will try to do a distinct of all fact values to create this one dimension with single attribute
you cannot create a measure on data type = string
vinu
------------------------------------
Reply:
I have encountered a similar problem where I needed to display textual statuses.
I handled it this way:
- I used numerical values for my measure, because as you discovered, SSAS doesn't like textual measures very much. You'll need to decide for your own situation how you want the status to be aggregated, but it's a lot easier to do aggregations with numbers, anyway.
- I then wrote a calculation to "translate" that into text, because SSAS doesn't seem to mind as much when you have textual calculation results.
If you had measures [AcceptedCount], [RejectedCount], and [PendingCount] and you want to display a status message based on whether there are any rejected/pending items, you could create a textual status calculation like this:
[Measures].[StatusText] = CASE WHEN [Measures].[PendingCount] > 0 or [Measures].[RejectedCount] > 0 THEN "Pending/Rejected" ELSE WHEN [Measures].[AcceptedCount] > 0
THEN "All Accepted"
ELSE "None submitted"
END
END
- Edited by Gregg_ Tuesday, October 16, 2012 5:07 PM
------------------------------------
Reply:
thanks all for your replies,
Vinuthan, would you please explain more why you suggested to have a physical dimension table instead of a degenerated one? . i've chose degenerated because the dimension has no columns except the status, so this dimension would be empty without the "transactional key" .
Gregg, thanks, but i didn't like having it hardcoded
------------------------------------
Reply:
In this case u would not prefer degenerated because status values are static and repetitive in nature...additionally since the degenerated dimension is built of your fact table, it would do a SELECT distinct status from Fact_Table. This is costly even if you put a index on the status column to make distinct work faster.
Hence i would suggest a physical or regular dimension.
vinu
------------------------------------
Reply:
Candidates for degenerate dimensions should have a cardinality reasonably close to the number of rows in the fact table. These dimensions take awhile to process because as Vinuthan stated above, the processing of that dimension involves issuing a SELECT DISTINCT Status FROM fact against the source. Ideally, fields such as Status that have important analytic usefulness belong in a Junk dimension. This junk dimension should consolidate several low cardinality attributes into a single dimension to reduce the dimensional explosion that will occur when a single business process has several different status that codes that may be useful.
HTH, Martin
------------------------------------
cannot create response groups are create workflows
we had a serious Lync issue where the Lync server broke its trust and computer account to the domain. It is not known why this happened.
The Lync server domain trust was restored - by rejoining the domain however various things were broken. The Short story is Lync is working fine - however we cannot create a workflow/response group using either the powershell or the web Gui.
The feeling is that something has changed in our ADUC but we are not sure what?
What is interesting is via the powershell we get cannot bind parameter "parent to the target Exception setting "Parent": the pool "rtc.servername" does not exist.
I have re published the the Topology along with a few other things however nothing has fixed this last issue
Any ideas?
John Rice
Outlook 2010 "check spelling as you type" bug
Repeatable:
- Install Outlook 2010 without the other major pieces of Office 2010 on a newly built machine.
- Open Outlook (and establish and account) and go to File -> Options -> Mail -> Spelling and Autocorrect... and note that the "Check spelling as you type" option is both checked and available (not greyed out).
- Close the options and *immediately* open it again and note that the preference is still checked but the whole section "When correcting spelling in Outlook" is greyed out.
- Close the options, create a new message, and notice that there is no spellchecking occurring while you type.
- Close Outlook.
- Go to %programfiles%\Microsoft Office\Office14.
- Create a new, empty (0 kb) file and name it "winword.exe".
- Open Outlook, create a new email and notice that spellchecking is active again. The option is now repeatedly available.
This is a bug because the spellchecking ability is not dependent on Word, only dependant on a file with the same name existing. You can delete the "winword.exe" file and spellchecking-while-you-type again doesn't function.
It's shameful that MVPs are claiming that Outlook needs Word to do spellchecking.
Reply:
I think most of the MVPs have known for some time that features that depend on word only need the winword file in the same directory as outlook and most of us are not shy about sharing proven hacks. BTW, this hack (at least the real winword method) restores most of the missing features in standalone outlook, not just spell check.
I've known about the 0 byte file trick for a long time too, but I have not been able to make it work and because large numbers of the people I help are not into tech (they just want outlook to work), I recommend using a real winword.exe. It's quick, easy, and works - and doesn't generate a "this didn't work" follow-up. :) Because a large # of the people affected have the student version of Office, they have the real winword handy.
Is it a bug that outlook is tricked by a fake file? Not necessarily - removing the call that looks for winword could insert a lot more bugs. But that hasn't stopped me from publically calling them out over the stupidity of this.
Diane Poremsky [MVP - Outlook]
Outlook Daily Tips | Outlook & Exchange Solutions Center
Subscribe to Exchange Messaging Outlook weekly newsletter
------------------------------------
Windows Server 2012 Networking documentation location, just FYI
Hi there -
This is just FYI that all Networking documentation for Windows Server 2012 is located in the Technical Library at http://technet.microsoft.com/en-us/library/hh831357.aspx.
Thanks -
James McIllece
Automate testing for SharePoint 2010 site
Hi Guys,
How can i do automate testing for SharePoint 2010 site.
Any one can guide ? Any automation tool for SharePoint 2010?
abbijohn
- Edited by abbijohn Thursday, October 18, 2012 2:22 PM
Reply:
Microsoft has a Load Testing Kit that will let you simulate a test load against your 2010 farm. It requires VS but that is where I would start...
------------------------------------
Guidelines when posting JDBC related questions
In order to better assist troubleshooting JDBC and JDBC related connectivity issues, the more specific the problem you describe, the faster we can help you out. Please take a few minutes to answer the following questions and post the answers as much as possible along with your specific repro steps.
http://blogs.msdn.com/jdbcteam/ or http://blogs.msdn.com/sql_protocols/ may already have your question answered. Check them out.
[1] Client side:
- Which OS platform are you running on? (please specify)
- Which JVM are you running on? (please specify)
- What is the connection URL in you app? (please specify)
- If client fails to connect, what is the client error messages? (please specify)
- Is the client remote or local to the SQL server machine? [Remote | Local]
- Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
[2] Server side:
- What is the MS SQL version? [ SQL Server 2000 | SQL Sever 2005]
- Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
- If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
- What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
- Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable]
- Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance.[YES | NO | not applicable ]
Tips:
- If you are executing a complex statement query or stored procedure, please use execute() instead of executeQuery().
- If you are using JDBC transactions, do not mix them with T-SQL transactions.
Last but not least:
There is a wealth of information already available to help you answer your questions.
(1) Online Documentation - http://msdn.microsoft.com/en-us/library/ms378749(v=sql.110).aspx
(2) MSDN JDBC site: http://msdn.microsoft.com/data/jdbc
(3) MSN Search: http://www.bing.com or use your favorite search engine.
- Edited by Microsoft JDBC Driver Product Team Thursday, March 15, 2012 10:34 PM update
Reply:
Hi Jimmy - We recently downloaded JDBC 4.0 driver for testing. Is there a case study on how to configure Windows Integrated Authentication on LINUX(SUSE) server our backend is SQL 2008 R2.
regards
Fahad
------------------------------------
Reply:
I'm having a problem with connecting to Sql server from a Java application.
I'm using Windows 7
I'm using jdk 7
And NetBeans as IDE
I'm using the url below read from the text file: "Successfully"
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc: sqlserver :/ / 192.168.1.106:1434;
databaseName = eUniProFaculdade;
IntegratedSecurity = true
I'm having the following error message after get some connections
requesting FACULDADE connection
returning FACULDADE connection # 0 at count # 13
requesting FACULDADE connection
returning FACULDADE connection # 0 at count # 14
requesting FACULDADE connection
returning FACULDADE connection # 0 at count # 15
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:243)
at mz.ac.eup.cp.ConnectionPool.createConnection(ConnectionPool.java:82)
at mz.ac.eup.cp.ConnectionPool.getConnection(ConnectionPool.java:63)
at mz.ac.eup.cp.DataFactory.getConnection(DataFactory.java:73)
at mz.ac.eup.main.Main$Requestor.run(Main.java:43)
I'm Using SQLServer 2008
The database are in other computer but we are connected by the same network
My firewall is off, and I'm using Windows authentication Mode
I have tryed enable the tcp configuration alredy, and I still getting the error.
please someone help me, I'm stuck and my boss is pressing me.
public ConnectionWrapper getConnection(String databaseId, String databaseUrl, String password, String userName, String drive) throws IOException, SQLException, FileNotFoundException, ClassNotFoundException {
if (fullCache.size() == MAX_POOL_SIZE) {
System.out.println(databaseId + " cache is full");
return null;
} else {
//check if there is an using connection
if (wrapper != null) {
//check if there is space for one more request in this wrapper
if (wrapper.getLoadCount() == MAX_LOAD_SIZE - 1) {
fullCache.offer(wrapper);//add to full and remove from using
//create a new wrpper
wrapper = new ConnectionWrapper();
wrapper.setId(databaseId);
wrapper.setConnection(createConnection(databaseId, databaseUrl, password, userName, drive));
} else {
wrapper.setLoadCount(wrapper.getLoadCount() + 1);
}
} else {
wrapper = new ConnectionWrapper();
wrapper.setId(databaseId);
connection = createConnection(databaseId, databaseUrl, password, userName, drive);
wrapper.setConnection(connection);
}
return wrapper;
}
}
private Connection createConnection(String databaseId, String databaseUrl, String password, String userName, String drive) throws SQLException, FileNotFoundException, ClassNotFoundException, IOException {
if (databaseId.toString().toUpperCase().equals(loadConnectionInfo().get(0).toString().toUpperCase())) {
Class.forName(drive);
connection = DriverManager.getConnection(databaseUrl, userName, password);
return connection;
} else if (databaseId.toString().toUpperCase().equals(loadConnectionInfo().get(5).toString().toUpperCase())) {
System.setProperty("java.net.preferIPv4Stack" , "true");
Class.forName(drive);
connection = DriverManager.getConnection(databaseUrl + userName + password);
return connection;
}
return connection;
the lines in bold are the ones that show the error message class ConnectionPool.
I'm trying to make a web application, and so I'm doing coonectionPool, this provides some connections and then give me the error
------------------------------------
Reply:
Thanks :) just getting back on board after some well deserved time off.... will give it a go :)
xo PK79
PK79 VB C++ HTML PASCALL UNIX LINux Opensource Guru and modest all round lovable gal X
------------------------------------
TROUBLESHOOTING: FIM Synchronization Service loses connection with backend database
TROUBLESHOOTING: FIM Synchronization Service loses connection with backend database
Tim Macaulay Security Identity Support Team Support Escalation Engineer
Can not access files on SBS 2011 server while connected through VPN
Scenario: 2003 STd server running as Terminal Server and Remota access VPN server, it is a domain member in small d0main where SBS2011 Essentials is functioning as domain controller. Users are loging in usin domain credantials.
I don't know if this can be relevat but 3389 is open on the firewall and redirected to TS.
Problem: I can acces files on TS and RDP to it using local address (10.0.0.254) but I can not do it to SBS (10.0.0.253) i am getting message that "file and prin service resource (10.0.0.253) is on line but isn' responding to connection attempts."
If i RDP to TS I can than RDP to SBS with no problem. I can't do it from my win 7 desktop.
What am I doing wrong?
- Edited by mariusz.marek Thursday, October 18, 2012 2:52 PM
- Changed type Sean Zhu - Wednesday, October 24, 2012 7:52 AM
Reply:
------------------------------------
SharePoint "Open with explorer" publication with TMG
Hi,
I'm having troubles for SharePoint "Open with explorer" feature. It work's perfectly inside my LAN (After a few configuration on IE and on the reg of my Windows 7 computer). Then, I published my SharePoint site with TMG 2010 with SP1: Everything works except one thing, I'm prompted (But only the first time) when i'm using the "Open with explorer" feature. My client doesn't want to be prompted when he use this feature.
I checked the credential manager,
I checked the reg
I checked the security settings and connection settings of IE 9 x86
I tried to switch to basic authentication for my SharePoint Site and TMG.
All my modifications did not change anything on the situation... I'm asking social technet because i'm running out of ideas :( ...
Charles Borcke MCTS SharePoint for Exakis
Windows Live Mail unable to work with Gmail
I was using windows live mail 2012 (on Windows 7) for my Gmail account (IMAP).Recently my computer rebooted and on when restarted there was no Gmail (IMAP) account in live mail. When I created the account it refused to login. While I can login on the web using same credentials. I tried repairing my Win7, I have reinstalled windows essential 2012. without any result. I tried using using POP for the same Gmail account and even that does not work. I tried my Hotmail (POP) account and that works. I tried it on other Gmail acccount and it does not work.
Can you help please
- Moved by Simon_WuMicrosoft contingent staff Friday, October 19, 2012 8:57 AM (From:Exchange Server 2010)
- Changed type Jeremy_Wu Saturday, October 20, 2012 12:50 PM
Reply:
I was using windows live mail 2012 (on Windows 7) for my Gmail account (IMAP).Recently my computer rebooted and on when restarted there was no Gmail (IMAP) account in live mail. When I created the account it refused to login. While I can login on the web using same credentials. I tried repairing my Win7, I have reinstalled windows essential 2012. without any result. I tried using using POP for the same Gmail account and even that does not work. I tried my Hotmail (POP) account and that works. I tried it on other Gmail acccount and it does not work.
Can you help please
- Merged by Fiona_Liao Friday, October 19, 2012 1:05 AM duplicated
------------------------------------
Reply:
This is the Exchange Forum
You may want to ask this in a Windows 7 Forum or contact Live Mail Support directly.
------------------------------------
Reply:
------------------------------------
Clients Cannot Access Internet through SBS
Some recent Microsoft Updates were installed and required a reboot of Windows Server.
After the reboot, clients in the domain cannot access the Internet. I've rebooted many times since then and tried many things, but the clients no longer can connect to the Internet.
SBS is running DNS, AD, RAS, DHCP etc with one NIC on the LAN and another NIC on the WAN. Everything seems to be set up correctly, just as it was before the reboot.
Here is the current status.
- The clients can see each other inside the Active Directory domain.
- The Windows Server can connect to the Internet
- When the command "NSlookup [name of any domain computer] [server ip address]" is run from a client computer, the ip address of the domain computer is returned.
- Event view shows now errors logged for DNS Server
- "Ping [server ip address]" works fine from the client.
- "Ping microsoft.com" from the client returns "request timed out"
There must be one simple setting that is not correct. I cannot find it in any of the documentation on Technet.
Please help!
- Changed type Sean Zhu - Thursday, June 21, 2012 8:27 AM
Reply:
Actually, "NSlookup [any internet domain name]" returns a valid IP address. So perhaps the problem is not with DNS, but rather, that clients are getting blocked?
On the client side, the Network Connection Status shows "IPV4 Connectivity: Internet". So, the client doesn't see any connection problem.
Something on Windows Server is either not working, or is blocking client traffic to the Internet (again, the server is fine--I'm using it now to connect here)
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Yes, when I do an nslookup from client for "microsoft.com" it returns IP addresses for Microsoft.com.
If I ping Microsoft.com, ping reports the IP address, but then the 4 pings time out.
------------------------------------
Reply:
I'm running SBS11 (Server 2K8 R2 SP1) with 2 NICs.
I do not believe ISA is running. I was looking for it in the Admin panel and didn't find it.
I disabled IPV6 using the FixIT tool. (DHCP is still serving IPV6 addresses).
I am not using Network Access Protection, nor other network access policies. Unless something changed in the last Windows update, I didn't have any group policy restricting network access.
Clients are able to get IP addresses from DHCP and operate normally within in the domain on the LAN. Only when they try to get to the Internet, are they somehow getting blocked.
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Ok, I guess I'll have to go back to the drawing board, because I don't understand how SBS would work in a one-server config without 2 NICs.
Could you refer me to a KB or How-To that describes the intended network topology?
------------------------------------
Reply:
------------------------------------
Reply:
Depending on the mechanism you receive the MSDN subscription through you may indeed have some associated 'support incidents', BUT I'm not encouraging you to burn them for items that may be answered in the forums.
'home' works fine, vs seemingly identifying yourself as MS. (unless you really are an MS employee, which causes me some despair that 'MS expect consumers to be aware of product features and limitations while we have here an example of an MS employee that can't read same')
Changes to Windows Server caused SBS Dev to drop '2 NIC deployment' on versions later than SBS03R2. There are various reasons why this happened but the major items concerned 'multi-homed DCs' and changes to RRAS.(AFAIK)
I want to make sure that statement is as fully understood as possible. Changes to Windows Server (non-SBS) were the 'motivation' for the change. This was, to at least some extent, SBS Dev following Windows Server 'guidelines', making SBS _more_ 'Standard Server-like'.
Versions of SBS >03 _only_ support a single network interface.
------------------------------------
Reply:
The 2-NIC configuration had been working since installation. Maybe there is confusion about the version of O/S I'm running, which includes Server 2008 R2 SP1.
I now have it working, again.
I disabled RRAS and re-enabled it. Then, everything was back to normal.
------------------------------------
Reply:
There must be some confusion about the product I'm running.
It has always been running with 2 NICs. And after I disabled and re-enabled RRAS, it is running fine, again!
Regarding your despair, MS provides pre-sales support to inform customers of product features and limitations through 600,000+ certified partner personnel and through 1000's of MS Technical Specialist Professionals. ...I don't understand why it's bad for people to learn about products outside of their normal job function and area of expertise.
In any case, my SBS11/WS2K8R2 installation is running fine, again.
Thanks for your help.
------------------------------------
Reply:
Just to avoid confusion, any configuration for SBS 2008 and SBS 2011 that users more than one network adapter (nic) will not work properly, will "break" the wizards, and is not supported. It is not possible to confirm that Leigh Huang is actually managing his SBS with the wizards, nor that he has proper functionality, but I give him the benefit of the doubt... perhaps he is.
Anyone else reading this thead should not take that a a green light to utilize more than ONE nic in their SBS 2008 or SBS 2011. It is not supported.
Since Leigh has expressed bewilderment as to how it works with one nic... it works exactly the same as any other Windows Server, with the edge device doing the firewalling and port forwarding.
Larry Struckmeyer[SBS-MVP]
------------------------------------
Reply:
There must be some confusion about the product I'm running.
It has always been running with 2 NICs. And after I disabled and re-enabled RRAS, it is running fine, again!
Regarding your despair, MS provides pre-sales support to inform customers of product features and limitations through 600,000+ certified partner personnel and through 1000's of MS Technical Specialist Professionals. ...I don't understand why it's bad for people to learn about products outside of their normal job function and area of expertise.
In any case, my SBS11/WS2K8R2 installation is running fine, again.
Thanks for your help.
However, your SBS (configured with 2NICs) and the whole content of this thread, is formally 'outside MS support parameters'.
It is _very disappointing_ that an MS employee should wish to do this.
------------------------------------
Reply:
The 2-NIC configuration had been working since installation. Maybe there is confusion about the version of O/S I'm running, which includes Server 2008 R2 SP1.
I now have it working, again.
I disabled RRAS and re-enabled it. Then, everything was back to normal.
Please 'unmark' this as 'answer'. It is a configuration in _direct conflict_ with SBS configuration parameters.
------------------------------------
Reply:
Leigh
As a moderator of this forum I have unmarked your response as an Answer. The reason behind my action is that your proposed answer would lead one to believe that Small Business Server can be run satisfactorily with two active NICs, running RRAS. Since SBS 2008, two nics have not been support over security issues regarding using a Domain Controller (The SBS Server) as an "Edge" device connected directly to the internet. Following is a link to the a Blog from the SBS Product Team on supported Network Topologies http://blogs.technet.com/b/sbs/archive/2008/09/16/sbs-2008-supported-networking-topology.aspx While this blog is targeted for SBS 2008, it applies to SBS 2011 as well. The SBS MVPs and other community contributors have also created a WIKI/Build document for SBS 2011 on Technet which you can find here http://social.technet.microsoft.com/wiki/contents/articles/1709.sbs-2011-standard-build-info-en-us.aspx
Since you are trying to learn the product, it's important that you follow best practices.
I hope this information helps
Cris Hanna, Microsoft SBS MVP, Owner-CPU Services, Belleville, IL
------------------------------------
Reply:
and sorry Leigh, but this may give you a 'feel' for how much concern we (not just MVP but 'community' in general) have that this be adressed properly:
The additonal network interface is known to interfere with SBS 'wizards'. _most_ experienced SBS admins will promote the use of the wizards. People who perform such 'outside the box' actions and ignore the use of the wizards often cause undue problem discussion and a perception that 'SBS is broken' when the simple fact is that _their implementation_ is wrong, and _causing_ such error.
I (personally) am concerned that your 2 NIC config has existed for _some time_, suggesting you are either ignoring or 'working around' problems that would be experienced in such situation.
_particularly_ in the case of an MS employee testing SBS, wanting to get familiar with the product, it is important that such be done properly.
OTOH: If you want to 1st do SBS 'the SBS way' then explore how SBS functionality may be expanded, I would ask that you preface your questions with 'an SBS experiment' (or similar).
------------------------------------
Reply:
Hi All,
I am having same problems... Just after server updates... DHCP behaving strangely.... not internet access to clients... BAD ADDRESS or IP conflicts... MS exchnage firewall rules gone.....
No error in event manager.
Please can someone guide...
Many Thanks
------------------------------------
Reply:
HI Sharpwaves:
Please start a new thread with your question and explain the symptoms and what update you installed before the problems began. Old threads get very little viewing, and most are not inclined to read an entire thread of old posts to see what "same problems" you refer to.
Larry Struckmeyer[SBS-MVP]
------------------------------------
Get last 24 months data till given quarter
Hi,
I have a cube with Measures and Time Dimension. I need to write a syntax which will give me last 24 months (24 rows) till given quarter (say Q2 2012). I used Last periods but its giving me incorrect outputs whenever i change quarter. pl help me
Thanks,
Paddy
- Edited by Paddy Paddy Thursday, October 18, 2012 12:22 PM
Integrate Application Catalog with Sharepoint and SCSM 2012
HI All,
I have a requirement from Client related to Application Catalog in CM2012. Client wants to achieve the below:
| 1. Integration with SharePoint 2010. |
| 2. Integration with System Center Service Manager (AWA). |
How can I achieve this? Need some imp links or thoughts.
Thanks & Regards, Kedar
Reply:
AWA? Are you talking about AAW (Application Approval Workflow solution accelerator): http://www.microsoft.com/en-us/download/details.aspx?id=29687? Just download and read the docs; there are a lot of steps involved and it cannot be explained in a forums thread. There's no out-of-the-box solution for Sharepoint integration available if I am not mistaken.
Torsten Meringer | http://www.mssccmfaq.de
------------------------------------
Reply:
Hi Kedar,
To answer your first question, the Application Catalog can be added to the Microsoft SharePoint website.
See the following documentation article, "Application Catalog and Software Center" section for more details:
http://technet.microsoft.com/en-us/library/gg682125.aspx
------------------------------------
Printing headers of received and sent emails
- Changed type Aaron.ParkerModerator Thursday, October 18, 2012 10:39 AM
Reply:
Twitter: @stealthpuppy | Blog: stealthpuppy.com
This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
Please remember to click "Mark as Answer" or "Vote as Helpful" on the post that answers your question (or 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.
------------------------------------
autodiscovery configuration for exchange 2010 to 2010 resource forest maigration
Hi,
I'm doing an exchange 2010 migration to new forest as resource forest with 7000 mailboxes. I have already configured SMTP and availability coexistence. My problem is with outlook autodiscovery.
Source and target forest use outlook 2010 and exchange 2010. Primary SMTP name space is xyz.com and external and internal autodiscover.xyz.com is pointed to source exchange CAS load balancer. I hope it will two months to move users to new forest.
How do I configure autodiscovery for migrated users?
If I point autodiscovery DNS to source CAS Load Balancer, migrated users will try to connect source server and fail. If configured to new CAS server, existing users in source forest may break the Availability and OOF in outlook.
What the best practice for this?
Reply:
Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
------------------------------------
Reply:
Hi Chama,
the same discussion on this link: http://social.technet.microsoft.com/Forums/en-US/exchangesvrmigration/thread/6e78e84d-6123-4880-8065-a56cfb0aeff3
Perhabs it is helpful.
Thanks,
Lync-Federation: dominik.hoefling@newcotec.com
------------------------------------
How to handle passwords
Hi,
I would just like to ask how do I securely handle passwords in opalis. Currently what I do is just store them as Global variables or text files. But this method is not actually a secure way of doing it.
Regards,
Herwin
Reply:
Hello Herwin,
Ochestrator is the new name for Opalis in System Center 2012. In System Center 2012 you can store encrypted Varables out of teh box.
Regards,
Stefan
German Orchestrator Portal , My blog in English
- Edited by Stefan HorzMVP Thursday, October 11, 2012 12:25 PM
------------------------------------
Reply:
Hi Stefan,
That's good to hear. Can the variables me masked as well?
Regards,
Herwin
------------------------------------
Script that clear documents and pictures
I am looking for a script
that if I shut down the computer and restart
that all what the previous useris created (documents and pictures)
is removed
can anyone help me here???
- Changed type Jeremy_Wu Thursday, October 18, 2012 9:34 AM
Reply:
Hi,
As the question is related to Script, it is recommended to post the thread in Scripting forums for better assistance.
Thanks for your understanding.
Best Regards.
Jeremy Wu
TechNet Community Support
------------------------------------
Far-east letters appear as squares
Strangely they work fine in a browser (IE or Chrome) but nowhere else on the system, including notepad or file names in the normal file explorer. On 2008 R2 this has never been a problem, what happened?
Edit: Finally managed to fix it, but not sure how. Added japanese keyboard layout, did not help. Removed japanese layout. Rebooted. Japanese letters appeared in file names.
- Edited by Gabest Sunday, October 14, 2012 7:17 PM
- Changed type Arthur_LiMicrosoft contingent staff Thursday, October 18, 2012 9:13 AM
Reply:
Hi,
Thanks for sharing your experience. I think it will help others who encounter the similar issue.
Regards,
Arthur Li
Arthur Li
TechNet Community Support
------------------------------------
Lync certificate
Hi,
I have recently deployed a Lync 2010 FE server and Lync edge server placed on DMZ. I have used 3 Public IP's for edge server public domains(sip.abc.com, meet.abc.com, dialin.abc.com) and used NAT to Edge server's 3 DMZ ip's.
Internally all the client's are working good with connected to Lync FE server by local root CA.
Also I have installed Public SAN for External access in lync edge server. My san fields are sip.abc.com, meet.abc.com, dialin.abc.com, lynfe.abc.com, webconf.abc.com.
When i try to connect Lync server externally from web it's not connecting and shows error there was a problem with verifying your certificate****..
Actullay where i have to put my Public san SSL ( edge server or Lync FE)? Is my san fields are correct?
Need your quick help. Thanks.
Reply:
Hi,
Have you installed reverseproxy server role ? You should point meet, dialin records to reverse proxy server not to edge server. I have mentioend certificate SN and SAN for your reference.
Edge server certificate :
SN : sip.abc.com
SAN:sip.abc.com;web.abc.com and addition sip domain if any.
Reverse proxy certificate :
SN : webext.abc.com
SAN : webext.abc.com;meet.abc.com;dialin.abc.com;autodiscover.abc.com etc.
You can also consolidate both records on a single certificate if needed.
Thanks
Saleesh
If answer is helpful, please hit the green arrow on the left, or mark as answer.
------------------------------------
Reply:
Could pl. tell me in brief..
I've created a public record for sip.abc.com, meet.abc.com & dialin.abc.com. and all havin it's own public IP's. Do i need to point those IP's to the TMG server? not in edge server?
I have only one 3rd party public san cert. and i created san values with sip.abc.com, meet.abc.com, dialin.abc.com, lynfe.abc.com, webconf.abc.com. Is this is ok? or i need to change any of the san value?
Thanks,
Jackson.
------------------------------------
Reply:
sip.abc.com and webconf.abc.com records should point to edge server (AE and WC edge respectively). Meet and dialin should point to TMG.
If you are using consolidated certificate , you can use the same certificate on edge and TMG. SN should be access edge FQDN , I hope sip.abc.com would be your access edge FQDN.
SAN should include edge and TMG records which are ; sip.abc.com ;webconf.abc.com;meet.abc.com;dialin.abc.com; lyncdiscover.abc.com (mobility if needed); Lynfe.abc.com (I hope this is your external web URL , otherwise add the external URL)
Thanks
Saleesh
If answer is helpful, please hit the green arrow on the left, or mark as answer.
------------------------------------
Reply:
Sorry for much questions.
I can use only 5 values in SAN ssl.
sip.abc.com ;
webconf.abc.com;
meet.abc.com;
dialin.abc.com;
Lynfe.abc.com - this is my local lync FE server Fqdn. What about you are pointing about external URL?
Also i have used local root CA in lync FE. is it correct?
Thanks.
------------------------------------
Reply:
Frontend server FQDN isn't required on the external certificate. I would suggest you to mask the external base URL. On topology builder , you can mask the external web services URL with some other FQDN and same can be added as a certificate SAN.
Yes , you can use internal CA on FE pool.
Thanks
Saleesh
If answer is helpful, please hit the green arrow on the left, or mark as answer.
------------------------------------
Reply:
I suggest reading through this blog article as it explains in detail the requirements and best practices for Edge Server certificate configuration.
http://blog.schertz.name/2012/07/lync-edge-server-best-practices
Jeff Schertz | Microsoft Solutions Architect - Polycom | Lync MVP
------------------------------------
Reply:
Many thanks Saleesh. Finally i will create two public SAN ssl. It would be
SSL cert1 on Lync edge
SN: sip.abc.com
San Values: Sip.abc.com, Webconf.abc.com
SSL cert2 on TMG reverse proxy
SN: lyncweb.abc.com
SAN values: Lyncweb.abc.com, dialin.abc.com, meet. abc.com, lyncdiscover.abc.com
Is that the values are correct?
I have 3 public IP's , I should create a public dns record for sip,webconf,lyncweb
My TMG is behind h/w firewall and I have to create a NAT.
Apart from this is there any records needs to be created for dialin, meet, lyncdiscover on public dns side?
Can lyncweb.abc.com will resolve names for the dialin, meet, lyncdiscover?
Thanks.
Jackson
------------------------------------
Reply:
Hi,
Certificate request looks good.
You need four public IPs now . 3 IP addresses for edge ( sip.abc.com; webconf.abc.com and av.abc.com ; we don't need av.abc.com on the certificate SAN list. However topology does required 3 IP addresses ). 1 IP address for reverse proxy ie lyncweb.abc.com.
Externally , meet.abc.com; dialin.abc.com , lyncweb.abc.com and lyncdicover.abc.com 'A' records should point to reverse proxy public IP (TMG NAT IP). You need individual 'A' records for each one.
Thanks
Saleesh
If answer is helpful, please hit the green arrow on the left, or mark as answer.
------------------------------------
Reply:
Can't able to find mark as answer
------------------------------------
Data Collector Set - Subdirectory format bug
There's a bug in the formatting of the sub directory name when creating a new data collector. If you specify the format name to contain 'tt' which is the AM/PM designation, it will write the opposite or possibly always AM. This bug exists in 2008 r2 sp1 as well.
I've attached a screen shot from both 2008 r2 sp1, and 2012 RTM.
I've tried to submit the bug using connect or some other applicable bug tracking system, but i've given up after 25 mins of searching the MS Site, Partner Sites, Technet, and MSDN.
I'll throw it out here in hopes that somehow it finds it way over the wall to people who care about these bugs.
- Changed type Boo_MonstersInc Tuesday, October 23, 2012 7:45 AM
Reply:
Thank you very much for your time and effort.
Zhang
TechNet Subscriber Support
If you are TechNet Subscriptionuser and have any feedback, please send your feedback here.
------------------------------------
No comments:
Post a Comment