Are we able to build a interface link between 2 SQL database in order to have data replicated?
Dear all Experts,
We are looking for a way to have sales data to flow from 1 database to another database on same SQL server. Can we build or have a link between 2 database? If yes, how to and how much effort will that be?
Thank you.
DatabaseDummy
Reply:
There are two ways off the top of my head.
1. Trigger on the Sales Data table or tables on insert/update/delete that does the same to the other database.
2. Replication - fairly overkill but more transparent as you will notice failures in data transfer. Although replication is most complex of the two.
This is not the exact solution but I am sure you can do a bit if reading, Concentrate on 1 and 2 if you are interested.
Kind Regards Nick Kemp.
- Edited by Freedomofmovement Monday, April 2, 2012 4:14 AM
------------------------------------
Reply:
Hi Nick,
Thanks for the reply. Would a SQL developer knows how to do a link replication? Export data from DB1 and Insert into DB2??
------------------------------------
Good Ole ALL CP Items
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
- Edited by Drew1903 Monday, March 26, 2012 11:05 PM
Reply:
------------------------------------
Reply:
Sorry, if, missing the humour.
Regards,
Drew
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Append two tables on column names in ssis
Hi,
Could you please assist me on this issue.
Issue: I have two tables on same column names. I need to append these tables on column names.
my tables are
customer table:
code type name
c1 customer chaitu
c2 customer mahesh
c3 customer rajesh
vendor table:
code type name
v1 vendor raju
v2 vendor suresh
v3 vendor ganesh
required output is like:
code type name
c1 customer chaitu
c2 customer mahesh
c3 customer rajaesh
v1 vendor raju
v2 vendor suresh
v3 vendor ganesh
For this which transformation i need to use or how to solve this issue?
Thanks in advance
Chaitanya.B
Reply:
You could use Union All: http://msdn.microsoft.com/en-us/library/ms141020.aspx
PS change the thread type to question... as this isn't a discussion.
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Edited by SSISJoostMVP Tuesday, April 3, 2012 1:31 PM
------------------------------------
Windows 7 Blue Screen Problem
Hey all,
First post for me so I'll try to get it right. I've had my new laptop since August this year and in the last 6 weeks have been having problems with bluescreens. I have taken the laptop into where I purchased it (Best Buy) twice to get it serviced and it still blue screens. They replaced the motherboard the first time through and the second I'm not sure they did anything.
I was doing non-intensive tasks each of the times my laptop bluescreened (browsing the internet, playing solitaire, updating games in Steam).
The following error message popped up after the blue screen:
roblem signature:
Problem Event Name: BlueScreen
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 4105
Additional information about the problem:
BCCode: 3b
BCP1: 00000000C0000005
BCP2: FFFFF880010D7756
BCP3: FFFFF8800EA4EAA0
BCP4: 0000000000000000
OS Version: 6_1_7601
Service Pack: 1_0
Product: 768_1
Files that help describe the problem:
C:\Windows\Minidump\121111-25630-01.dmp
C:\Users\Steven\AppData\Local\Temp\WER-59327-0.sysdata.xml
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
A link to the first file it talks about is:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!177&parid=4C8F5B05CE8A796!175&authkey=!AFcwwoA-5xegjmM
Skydrive won't let me upload the second file for some reason. Hopefully you guys can get a little farther than those fools at Best Buy Geek Squad did.
Thanks in advance :)
Reply:
fltmgr.sys file information
The process Microsoft Filesystem Filter Manager or FltMgr belongs to the software Microsoft Windows Operating System or FltMgr or Microsoft(R) Windows (R)(version 2000 Operating System) by Microsoft Corporation (www.microsoft.com).
Description: File fltmgr.sys is located in the folder C:\Windows\System32\drivers.
Please Update Your Drivers to the Latest Version , and Uninsall the Software DAEMON Tools Lite (DTLite.exe) Or install the latest version of DAEMON Tools Lite (DTLite.exe).
Regards,
MCP ✦ MCTS ✦ MCITP
------------------------------------
Reply:
------------------------------------
Reply:
Great :)
Regards,
MCP ✦ MCTS ✦ MCITP
------------------------------------
Reply:
So I've had a number of bluescreens since. Three were close together and involved Skyrim. I took my laptop to bestbuy and they updated my graphics driver which seemed to fix the problem. The most recent occurred right after start windows.
Problems Signature:
Problem signature:
Problem Event Name: BlueScreen
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 4105
Additional information about the problem:
BCCode: 1a
BCP1: 0000000000001238
BCP2: FFFFFA8006828150
BCP3: 0000000000000802
BCP4: 0000000000000000
OS Version: 6_1_7601
Service Pack: 1_0
Product: 768_1
Files that help describe the problem:
C:\Windows\Minidump\123111-36270-01.dmp
C:\Users\Steven\AppData\Local\Temp\WER-60044-0.sysdata.xml
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
Skydrive Links:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!178&parid=4C8F5B05CE8A796!175&authkey=!AKyaO-ODDTwmrBQ
Give it a shot, hopefully it can stop being so ridiculous. If not the laptop is going back to the store, if so it is still likely to go back to the store. Don't buy from bestbuy. Don't get their protection plan either.
Thanks :S
------------------------------------
Reply:
-- Mike Burr
Technology
------------------------------------
Reply:
Hey people,
So I've gotten a few more bluescreens in the last little while. The first was on February 2nd:
Problem signature:
Problem Event Name: BlueScreen
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 4105
Additional information about the problem:
BCCode: 1a
BCP1: 0000000000001238
BCP2: FFFFFA8006828150
BCP3: 0000000000000802
BCP4: 0000000000000000
OS Version: 6_1_7601
Service Pack: 1_0
Product: 768_1
Files that help describe the problem:
C:\Windows\Minidump\123111-36270-01.dmp
C:\Users\Steven\AppData\Local\Temp\WER-60044-0.sysdata.xml
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
A link to the dump file:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!179&parid=4C8F5B05CE8A796!175&authkey=!APSXBqkr_4wGeKU
Another today:
Problem signature:
Problem Event Name: BlueScreen
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 4105
Additional information about the problem:
BCCode: 1e
BCP1: 0000000000000000
BCP2: 0000000000000000
BCP3: 0000000000000000
BCP4: 0000000000000000
OS Version: 6_1_7601
Service Pack: 1_0
Product: 768_1
Files that help describe the problem:
C:\Windows\Minidump\021012-28735-01.dmp
C:\Users\Steven\AppData\Local\Temp\WER-72010-0.sysdata.xml
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
Link to the dump:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!180&parid=4C8F5B05CE8A796!175&authkey=!AAlY-g0hm9rMxKk
Here's another file windows pointed me to for information:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!181&parid=4C8F5B05CE8A796!175&authkey=!AFawQeW7-QPjfMY
I also had a second bluescreen today (about 15 minutes after the first):
Dump file:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!182&parid=4C8F5B05CE8A796!175&authkey=!AGI4OLZ9e3uKbS8
The other file that windows pointed me too:
https://skydrive.live.com/redir.aspx?cid=04c8f5b05ce8a796&resid=4C8F5B05CE8A796!183&parid=4C8F5B05CE8A796!175&authkey=!APjir92ouGU5nX4
In both the bluescreens on the 10th I was surfing the internet with Steams built in browser using my phone as a access point (via bluetooth). The one on the 2nd my laptop was in sleep mode in my backpack and had the error message when I opened it for my next class.
Thanks for your previous help guys, hopefully this narrows it down a bit more.
Cheers
------------------------------------
Reply:
------------------------------------
Integrate FIM 2010 with SSO client
I need to integrate FIM 2010 with PassLogix to provision application credentials into the SSO store (Active Directory), the list of enterprise applications that FIM provision (AD, HR, etc...) are different from the applications' definitions in the SSO client (most of them are business applications).
I understand that I need to use custom workflow activity or XMA connector to call web service methods of the SSO client,
the integration should be at first FIM with the original application (to create the credential), then next step provision the credential into the SSO app store ? I cannot have different list of applications that FIM provision to, and SSO has another list of apps that store their credentials ...
PassLogix dropped OOB integration with FIM, is there any SSO client has direct integration with FIM (using XMA Management Agent) ?
It's never too late in life ... to start living
- Changed type Markus VilcinskasMicrosoft employee Wednesday, May 22, 2013 1:05 PM
Reply:
FIM could be integrated with Exchange using out of box Management Agents ? or do we need to install/crate custom MA for this purpose?
Thanks & Regards, Ankit Yadav
------------------------------------
Created a Integration services project under asia\abc windows loginaccount. other user account, throws errors.
Reply:
Hello,
Can you please provide more details on thsi may some error or a screen shot will help
------------------------------------
Reply:
------------------------------------
Reply:
The protectionlevel of the package is probably EncryptSensitiveWithUserKey. Change this to DontSaveSensitive.
http://msdn.microsoft.com/en-us/library/ms141747(v=sql.105).aspx
ps: next time, try to include at least the errors in your question
MCTS, MCITP - Please mark posts as answered where appropriate.
- Edited by Koen VerbeeckMVP Monday, April 2, 2012 5:54 AM
------------------------------------
Born to Learn Training and Certification Resources
The following additional training and certification resources are available on the Born to Learn site:
- Blogs
- Forums (non-MSDN)
- Events
- MCT Community Portal (This portal is a replacement for, and upgrade to, the MCT private newsgroups which retired on September 1, 2010. The MCT Community Portal provides discussion forums, blogs, wikis and media libraries and is available only to MCTs).
- Training Spotlight
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript
- Changed type Mr. Wharty Saturday, June 2, 2012 9:30 AM
SQL Server 2008 Microsoft Certified Master (MCM) Accelerated Exam Preparation Program
The popular live accelerated training program for SQL Server MCM returns with another session starting May 8, 2012. Whether you're preparing for SQL Server 2008 MCM exams, or just looking to take your SQL Server skills to the next level, don't miss out on this unique training opportunity.
Accelerate your path to SQL Server MCM
This series of live online sessions with a SQL MCM presenter offers a low-cost and convenient solution for MCM exam preparation, or for those looking for advanced training around MCM topic areas. In seven weeks, with two weekly sessions of two hours each, the focus each week will be on one of the exam topic areas. There will be time for Q&A after each session. You can benefit from the input of other participants -- even form online study groups to enhance the learning experience. Plus, we offer practice lab subscriptions with twenty labs and two months of lab access, providing an easy to use, anytime access lab environment in which you can practice the required skills associated with the weekly session. The sessions start May 8, so Enroll Now, as places are limited in the weekly sessions.
BONUS: All paid program enrollments by April 25 will receive a $1000 Discount for the SQL MCM Lab Exam!
Available today: Hands-on Practice Labs for Microsoft Certified Master: SQL Server 2008
The hands-on labs used in the Accelerated Prep training series are also available any time in one week or one month increments. The labs cover advanced SQL Server topics geared to helping you prepare for the pursuit of advanced certification. This is a great alternative for those who may not need the time commitment of two months of lab access. Here's what one of our new MCMs in SQL Server 2008 had to say about the practice labs:
The MCM Practice Labs were instrumental in my passing the MCM lab test. Not only were the lab documents and demos useful, but they are very easy to build onto. I highly recommend the MCM practice labs for anyone looking to take the MCM Lab test.
Eric Strom
Digineer
www.digineer.com
Minnesota, USA
Register here for the hand-on practice labs.
Learn more about the Microsoft Certified Master Program.
Follow the Master Blog for future announcements on SQL Server MCM programs.
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript
- Changed type Mr. Wharty Monday, April 2, 2012 5:11 AM
Problems with my External Hard Drive using Windows Server 8 Beta
Good Morning,
Happy Aprils Fools Day To You all! Believe me this is no joke. OK, So I am at the Server Pool set up from my Server Deployment. I have a 256 GB Segate External Hard Drive. Now according to the Server Manager, and the Device Manager, I can see this Hard Drive, I can Update it's Driver but When I go to get the volume, I get an error that tells me that the my sytem does not see it.
This is what the Server Manager \ Server Pool tells me:
| = Healthy | segate | Storage Pool | BlodgettHomeServer | 297 GB | 147 GB | 50.5% Used |
Followed By this Error:
Blodgett Home Server:
Error occurred during enumeration of iSCSI virtual disks: HRESULT = 0x80070015iSCSI virtual disks enumeration failed.
| . |
Please advise! I would greatly appreciate any help at all.
- Changed type Vincent Hu Wednesday, April 4, 2012 6:29 AM
Reply:
>> Did you put iSCSI virtual disks on the Segate External Hard Drive? Please provide details.
Vincent Hu
TechNet Community Support
------------------------------------
Free Event - Planning and Designing a Microsoft Lync Server 2010 Solution
The demand for information technology (IT) professionals experienced enough to effectively architect Microsoft unified communications solutions with Lync Server 2010 technologies continues to increase. For those of you who have the Lync Technical Specialist certification (see below) or have equivalent knowledge and experience, this accelerated Jump Start may be for you—so keep reading! If you don't have the experience with Lync required for this course, we encourage you to check out the prerequisite course, "Deploying Lync Server 2010 Jump Start" scheduled for April 17-19, 2012, first.
Microsoft Learning and the Microsoft Lync team have partnered to bring you an exciting opportunity to learn what you need to know to plan and design Microsoft Lync Server 2010 solution. Leveraging the popular "Jump Start" virtual classroom approach, two of the industry's most gifted experts will leverage an accelerated, engaging and demo-rich learning experience to help attendees gain the knowledge and confidence to help prepare for Exam 70-665: PRO: Microsoft Lync Server 2010, Administrator, a required exam for the Microsoft Certified IT Professional (MCITP): Microsoft Lync Server 2010 Administrator.
Here are the details:
- Course: "Planning and Designing a Microsoft Lync Server 2010 Solution"
- Date/Time: April 24-26, 2012 from 9:00am – 4:00pm PST
- Where: Live virtual classroom (online from wherever you are)
- Cost: FREE!
- Target audience: IT Professionals and telecommunications professionals. This is an accelerated course. Attendees are expected to have experience in hands-on deployment and day-to-day management of Unified Communications technologies for enterprise organizations and the Microsoft Certified Technology Specialist (MCTS): Microsoft Lync Server 2010, Configuring or equivalent knowledge.
- Registration: http://mctreadiness.com/MicrosoftCareerConferenceRegistration.aspx?pid=315
COURSE OUTLINE
Day 1: Lync Server 2010 Topology Design
Module 1: Overview of the Lync Server 2010 Design Process
Module 2a: Designing a Lync Server 2010 Topology – Part 1
Module 2ab: Designing a Lync Server 2010 Topology – Part 2
Module 3a: Designing for Conferencing and External Scenarios – Part 1
Module 3b: Designing for Conferencing and External Scenarios – Part 1
Module 4: Planning and Designing Load Balancing
Day 2: Lync Server 2010 Infrastructure & Network Design
Module 5: Designing a Mediation Server Topology
Module 6a: Designing Voice Infrastructure – Part 1
Module 6b: Designing Voice Infrastructure – Part 2
Module 7: Designing Exchange Server Unified Messaging Integration with Lync Server 2010
Module 8a: Creating a Network Design for Lync Server 2010 – Part 1
Module 8b: Creating a Network Design for Lync Server 2010 – Part 2
Day 3: Lync Server 2010 Services & Maintenance Design
Module 9: Designing Location Services in Lync Server 2010
Module 10: Designing Response Group Services
Module 11: Designing Resiliency
Module 12: Designing for Backup and Disaster Recovery
Module 13: Designing Monitoring and Archiving Server
Module 14: Planning a Migration to Lync Server 2010
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript
- Changed type Mr. Wharty Saturday, June 2, 2012 9:07 AM
Free Event - Deploying, Configuring, and Administering Microsoft Lync Server 2010
Literally hundreds of organizations are recognizing the cost savings and efficiency that results from empowering people with improved collaboration and cross-team communications. Once you learn about what Microsoft Lync can do for your office, as well as your resume, you'll never look back.
Microsoft Learning and the Microsoft Lync team have partnered to bring you an exciting opportunity to learn how to deploy, configure and administer Microsoft's unified communications solution. Leveraging the popular "Jump Start" virtual classroom approach, two of the industry's most gifted experts will leverage an accelerated, engaging and demo-rich learning experience to help attendees gain the knowledge and confidence required to prepare for taking Exam 70-664: TS: Microsoft Lync Server 2010, Configuring.
Here are the details:
- Course: "Deploying, Configuring, and Administering Microsoft Lync Server 2010 Jump Start"
- Date/Time: April 17-19, 2012 from 9:00am – 4:00pm PST
- Where: Live virtual classroom (online from wherever you are)
- Cost: FREE!
- Target audience: IT Professionals and telecommunications professionals. This is an accelerated course. Attendees should have at least three (3) years' experience working with unified communications software, including knowledge of and experience with Microsoft Office Communications Server 2007 R2.
- Registration: http://mctreadiness.com/MicrosoftCareerConferenceRegistration.aspx?pid=313
COURSE OUTLINE
Day 1: Lync Server 2010 Deployment & Configuration
Module 1: Features and Architecture of Microsoft Lync Server 2010
Module 2a: Deploying Microsoft Lync Server 2010 Part 1
Module 2b: Deploying Microsoft Lync Server 2010 Part 2
Module 3: Configuring Users & Rights and Client/Device Deployment in Lync Server 2010
Module 4a: External User Access
Module 4b: External Media Relays and Connectivity
Day 2: Enterprise Voice with Lync Server 2010
Module 5a: Configuring Basic Enterprise Voice Functionality
Module 5b: Phone Normalization, Dial Plans and Policies
Module 6a: Extending Enterprise Voice Functionality
Module 6b: Microsoft Exchange Server 2010 SP1 Unified Messaging Integration
Module 7a: Understanding Response Groups and Call Flows
Module 7b: Dissecting a Real-world IVR Scenario
Day 3: Extending Lync Server 2010 Enterprise Features
Module 8: Conferencing in Lync Server 2010
Module 9: Monitoring
Module 10: Compliance and Archiving
Module 11: High Availability, Voice Resiliency Features and Disaster Recovery in Lync Server 2010
Module 12: Call Admission Control
Module 13: Deploying & Configuring Enhanced 9-1-1
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript
- Changed type Mr. Wharty Saturday, June 2, 2012 9:07 AM
A bug in populating mdm.tblTransaction by MDS?
Hi, I discover a bug (I think) on the process that populates the mdm.tblTransaction table. If you have a date attribute in your leaf member, change the value, and check the values in columns OldValueand NewValue, you would notice that the date format used to store the date as strings are different.
For example, I have athe following values being stored (as strings) in a record in the table mdm.tblTransaction, after I changed the date attribute value from 27/02/2013 to 27/2/2014 :
Old Value: '2013-02-27 00:00:00.000'
New Value: '02/27/2014 00:00:00'
Is this a set up /configuration issue, or is this a bug?
- Changed type Ed Price - MSFTMicrosoft employee Tuesday, December 23, 2014 1:08 AM
Reply:
Hi, I discover a bug (I think) on the process that populates the mdm.tblTransaction table. If you have a date attribute in your leaf member, change the value, and check the values in columns OldValueand NewValue, you would notice that the date format used to store the date as strings are different.
For example, I have athe following values being stored (as strings) in a record in the table mdm.tblTransaction, after I changed the date attribute value from 27/02/2013 to 27/2/2014 :
Old Value: '2013-02-27 00:00:00.000'
New Value: '02/27/2014 00:00:00'
Is this a set up /configuration issue, or is this a bug?
- Merged by Challen Fu Tuesday, April 3, 2012 7:38 AM duplicated thread
------------------------------------
Need help straightening out EXTENSIONS settings for root CA
I have set up a two tier CA with the following server names:
rootCA.domain.com
EnterpriseCA.domain.com
I did the install without creating a CAPolicy.inf file. The default settings of my EXTENSIONS tab of the rootCA properties are:
CRL Distribution Point settings:
C:\Windows\system32\CertSrv\CertEnroll\<CaName><CRLNameSuffix><DeltaCRLAllowed>.crl
Checked: Publish CRLs to this location and Publish Delta CRLs to this location
ldap:///CN=<CATruncatedName><CRLNameSuffix>,CN=<ServerShortName>,CN=CDP,CN=Public Key Services,CN=Services,<ConfigurationContainer><CDPObjectClass>
Checked: All except for bottom "Include in the IDP extension of issued CRLs"
http://<ServerDNSName>/CertEnroll/<CaName><CRLNameSuffix><DeltaCRLAllowed>.crl
Check: Nothing checked
file://<ServerDNSName>/CertEnroll/<CaName><CRLNameSuffix><DeltaCRLAllowed>.crl
Check: Nothing checked
=======================================
Authority Information Access settings:
C:\Windows\system32\CertSrv\CertEnroll\<ServerDNSName>_<CaName><CertificateName>.crt
Check: Nothing Checked - greyed out
ldap:///CN=<CATruncatedName>,CN=AIA,CN=Public Key Services,CN=Services,<ConfigurationContainer><CAObjectClass>
Checked: "Include in the AIA extension of issued certificates
http://<ServerDNSName>/CertEnroll/<ServerDNSName>_<CaName><CertificateName>.crt
Check: Nothing Checked
file://<ServerDNSName>/CertEnroll/<ServerDNSName>_<CaName><CertificateName>.crt
Check: Nothing Checked
My CDP and OCSP are on the EnterpriseCA.domain.com server.
What changes should I make to the above entries?
- Changed type Bruce-Liu Friday, April 6, 2012 5:44 AM
Reply:
There are still more questions about your setup to be able to set the desired config. Please answer the following questions:
Is your Root CA offline or online?
Does the Root CA CRL needs to be published in AD using LDAP?
Are you planning to publish the Root CA CRL using HTTP URL(s)?
Are you going to use OCSP for your Root CA?
/Hasain
------------------------------------
MPIO error in windows 2008 r2 edition.
Hi,
We have to confiugure 2 servers (IBM) with 2008 r2 ent edition and need to configure failover cluster for SQL DB, while validating the failover cluster after adding the node, we getting MPIO error. We have tried with and without teaming of Broadcam of IBM.
Could you please help someone on this and kindly provide step by step document for confgiuring cluster with gui mode.
Gangadhar
- Changed type Vincent Hu Tuesday, April 3, 2012 7:21 AM
Reply:
Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP
------------------------------------
Reply:
Hi,
Could you please forward the error message recieved?
Martin
If you find my information useful, please rate it. :-)
------------------------------------
0856250882
- Moved by Allen_MSDN Monday, April 2, 2012 5:57 AM (From:LINQ Project General)
Reply:
60000good question!
Best Regards,
If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".
------------------------------------
Beloved (old) start menu things
You know, whilst some ppl are on about loss of start menu... just, having Desktop Toolbar on the Taskbar can be an appealing 'must have' :D Actually gives some good stuff very handy, no matter what
(Check it out & see what it gives you or could)
Cheers,
Drew
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
Reply:
I'm, also, vegetarian :)
I have been running Windows8 darn near 100% since Feb. 29. I honestly find the (Metro) Start very little of a concern. I 'organized' the tiles, very quickly, right @ the onset...there's not much on it, now & as more 'appear' there, it's easy to remove them, if desired. But, I work @ & from Desktop...need Start very rarely... access things @ or from Desktop. I will go to Start sometimes to type something I want to find or search...of course there about 29 (other) ways to 'search', lol
There is a learning curve, 8, certainly, has some (new) & different features & methods; but, it need not take long to figure it out and it's all explained in HELP (if ppl would only look there (sigh)). Once you do figure it out, it is easy, quick & almost fun to run around in Windows8
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Reply:
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Reply:
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Reply:
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Reply:
Excellent suggestion, Drew, though it really less to do with the Start menu and more to do with the Taskbar - it's a Taskbar feature that thankfully has not been removed in Windows 8.
Ever since Vista I have always enabled the Desktop toolbar myself. It's very handy, especially if your desktop icons happen to be covered and you'd rather not minimize everything to go looking for them. It doesn't take up much space on the Taskbar and it's just nice to have when you need it.
More ways to do things on the Desktop makes for a richer UI experience, which is generally a Good Thing.
It's interesting that you regard this as a positive feature while not regarding removal of the Start menu as negative. Most folks don't make that distinction. Perhaps this can help you to see others' points of view more clearly.
-Noel
| Detailed how-to in my eBook: | Configure The Windows 7 "To Work" Options |
------------------------------------
First Try - Discussion Board in Share Point
Hello Everyone,
It's nice to meet you all.
I'm totally new to Share Point and this is my first time in using it. I would like to create a new discussion board so my company users can create new threads and reply/Share to existing threads as well. I have looked it up and found some nice and easy going videos in you tube that I like to share.
How To: Create Discussion Boards in SharePoint 2010
http://www.youtube.com/watch?v=HPqL1K4dD7E
Video Tutorial - Create a Discussion Board (SharePoint) <//span>
http://www.youtube.com/watch?v=LRMvlmcKWp4&feature=related
Contributing to a discussion board thread<//span>
http://www.youtube.com/watch?v=hD7MG4-OujE&feature=related
Furthermore, I have few questions please and I would really appreciate your advice.
1- When I create a new discussion board following the steps in the video, would the users be able to start their own new threads?
2- Where would the link of the discussion board be? I don't have a test environment so trying it means changing the live SP server.
3- In terms of security, how to secure the discussion board so users cannot delete threads and to limit it to authorized people only?
It will be great if you can share with me some good source on how to create the discussion board and how to set it up the proper way.
I thank you in advance and I appreciate your help.
Reply:
Hi
1. Yes, if they will have write rights on DB
2.I propose you to not work on prod env. If you don;t have possibility to have a test env, on the prod serv, create a separate testing web app, a new site collection , and there create your own new testing DB
3. Yes, you can cusomize permissions for your needs
After you connect to you site using an admin account
goto ribbon, and select
Site Actions
Site permissions
Pernissions level - from the ribbon
Add a permission level
There you name it and check needed rights
After that, you go to the Discussion Board, and assign this new level to a specific group/user(s)
Romeo Donca, Orange Romania (MCSE, MCTS, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.
------------------------------------
DAG and Cluster Name pointing..
Hello,
We've got a two node DAG setup (MBX, CAS, HUB on each of em').
I noticed recently when I RDP to (or telnet on port 25 to)
RDP: SRV-EMAIL01 (CAS array/cluster virtual name)-> it takes me to E2K10-N1 (it's the active node in the DAG, clients are connecting via 'SRV-EMAIL01' as server name)
RDP: SRV-DAG01 (DAG name) -> it takes me to E2K10-N2 (the passive node in the DAG).
Why not both DAG name and cluster name points to same server i.e active node???? Is it how the DAG is? (I tried with each one's IP and it's the same)
Appreciate some tips!
PS: I've a scheduled email backup issue which requires an answer for the above.
- Edited by Insaf Muhammed Saturday, March 24, 2012 9:39 PM
Reply:
Hello,
Why no one answers? :(
------------------------------------
Reply:
Hi Insaf,
First of all please don't confuse DAG clustering with Load balancing RDP or SMTP sessions.
How did you configure load balancing of your CAS connections? By a hardware load balancer or someway else?
The name you connect to (fa SRV-EMAIL01), how is this name configured in DNS?
What you normally would do is create a logical name like SRV-EMAIL01 and point it in DNS to a VIP (Virtual IP address) of a load balancer. The load balancer has then both CAS servers as session hosts with a service to handle MAPI and HTTP(S) sessions.
The CAS role can only be load balanced by one of the following methods:
- Hardware or Virtual Loadbalancer (recommended)
- WNLB (not recommended because the lack of service awareness and cannot be used in combination with a multi-role configuration)
- DNS Round robin (not recommended)
Cor
Technical Consultant Exchange | MCP, MCSA, MCSE, MCTS, MCITP | Blog: http://www.reinhard-online.nl | Follow me on twitter: correinhard | Please, feel free to nominate me for MVP @ https://mvp.support.microsoft.com/gp/mvpnominate
------------------------------------
Reply:
Insaf,
Please update us on this question. Is your question answered?
Also give credits to the people who answer the questions by selecting "Mark as answer". Appreciate it.
Cor
Technical Consultant Exchange | MCP, MCSA, MCSE, MCTS, MCITP | Blog: http://www.reinhard-online.nl | Follow me on twitter: correinhard | Please, feel free to nominate me for MVP @ https://mvp.support.microsoft.com/gp/mvpnominate
------------------------------------
Reply:
Hi Insaf,
First of all please don't confuse DAG clustering with Load balancing RDP or SMTP sessions.
How did you configure load balancing of your CAS connections? By a hardware load balancer or someway else?
The name you connect to (fa SRV-EMAIL01), how is this name configured in DNS?
What you normally would do is create a logical name like SRV-EMAIL01 and point it in DNS to a VIP (Virtual IP address) of a load balancer. The load balancer has then both CAS servers as session hosts with a service to handle MAPI and HTTP(S) sessions.
The CAS role can only be load balanced by one of the following methods:
- Hardware or Virtual Loadbalancer (recommended)
- WNLB (not recommended because the lack of service awareness and cannot be used in combination with a multi-role configuration)
- DNS Round robin (not recommended)
Cor
Technical Consultant Exchange | MCP, MCSA, MCSE, MCTS, MCITP | Blog: http://www.reinhard-online.nl | Follow me on twitter: correinhard | Please, feel free to nominate me for MVP @ https://mvp.support.microsoft.com/gp/mvpnominate
HI Cor,
I'm terrible sorry to not respond because I was OOF for a week! Thanks for your concern and tips and let's share what I know,
- We have 2 nodes with all 3 roles (CAS, HUB, MBX) in the DAG.
- Having MBX role in place on both nodes, we have not used MS NLB services for CAS load balancing. Neither we have hardware load balancer.
- We configured a MS Cluster service for : SRV-EMAIL01, adding both nodes as a member in the cluster group. SRV-EMAIL01 has an IP in DNS (192.168.0.25) , so when the user connects to SRV-EMAIL01 for CAS it takes him to 192.168.0.25 and to the active DAG node. (may be not a recommended setup but it just works fine for us)
This is how I know how to explain you :) However, my backup issues are solved as it was due to some other reasons and the above query was my knowledge concern.
Thanks a lot :)
------------------------------------
DSAccess woes
G'day all -
I'm an Active Directory guy trying to tackle an Exchange issue, so please forgive if my terminology is not right.
I work for a relatively large organisation, and in some countries we have repeating incidents whereas Exchange becomes unavailable - users can't logon and so forth. The postmasters have to stop MS Exchange store service and reboot Exchange systems for rapid resolution. there's one site where the problem is the most acute and two Exchange servers have it regularly. The setup is rather standard - Exchange 2003 on Windows 2003 with less than 1000 mailboxes per server (40GB RAM, iSCSI with NetApp storage for the stores, NetApp Snapdrive, Antigen, ~25% of mailboxes are BlackBerry-enabled).
The best I got for the logs footprint is this:
Event 2103 MSExchangeDSAccess
Process EMSMTA.EXE (PID=9999). All Global Catalog Servers in use are not responding
<long list of domain controllers follows>
There are some other events that are occuring as those exchange servers have a problem:
Event 2085 MSExchangeDSAccess
Process EMSMTA.EXE (PID=9999). No Global Catalog server is up in the local site 'USERSITE'.
Event 9098 MSExchangeSA
The MAD Monitoring thread was unable to read its configuration from the DS, error '0x80004005'.
And few more - anything that can complain will complain about my AD not being available. If we point Exchange servers to certain local DCs (in the same rack), the issue doesn't go away. It still happens although appears to recover faster that discovery is enabled, so user impact is reduced but not avoided - sometimes users are disconnected during busy hours.
Here's my predicament: I'm certain that Active Directory works just fine. We have completed all checks possible against the DS and I'm pretty sure that conectivity is not a problem - nothing stands out in the captures of traffic b/w Exchange and AD. Site topology could use some optimisation but generally not a problem and is eliminated by pointing to local DCs anyway.
I'd like to identify the root cause of this. What else can I check? Could those problems be related to WMI? Once as all users were disconnected I tried to restart WMI and the service wouldn't stop - hung stopping. Could this be related to storage?
This is really very interesting issue (although involving 9-year old technology). Please help. All reasonable ideas appreciated.
-= F1 is the Key =-
Reply:
--- Rich Matheisen MCSE+I, Exchange MVP
------------------------------------
Reply:
Thank you for the suggestions! You are correct, that's 4GB of RAM. I couldn't see any symptoms of memory leak into system areas. There are no 2019/2020s warnings from Srv service, I can logon with domain credentials, and traffic captures show uninterrupted communication with the domain controllers. We have eliminated Symantec AV software that is notorious for gobbling up the pools - the issue persisted.
Active Directory is healthy and communications appear to be okay, even though Microsoft CTS on the case were adamant that the problem is in that space.
I have found something that looks like a root cause indicator and a workaround. As the issues occur, some of the errors logged by MSExchangeDSAccess mention wmiprvse.exe process:
Event Type: Error
Event Source: MSExchangeDSAccess
Event Category: Topology
Event ID: 2104
Description: Process WMIPRVSE.EXE -EMBEDDING (PID=9999). All the DS Servers in domain are not responding.
Event Type: Warning
Event Source: MSExchangeDSAccess
Event Category: Topology
Event ID: 2121
Description: Process WMIPRVSE.EXE -EMBEDDING (PID=6088). DSAccess is unable to connect to any domain controller in domain emea.example.net although DNS was successfully queried for the service location (SRV) resource record used to locate a domain controller for that domain.
As that happens, I cannot query DSAccess via WMI (as per KB 313711), receiving WBEM_E_PROVIDER_LOAD_FAILURE error:
WINMGMTS:{authenticationLevel=pkt,impersonationLevel=impersonate}!
\\EXCHANGESRVR\ROOT\MicrosoftExchangeV2:Exchange_DSAccessDC
C:\tmp\ex\queryDSAccess.vbs(12, 1) (null): 0x80041013
When I kill the wmiprvse.exe process, DSAccess is reinitialised:
Event Type: Information
Event Source: MSExchangeDSAccess
Event Category: General
Event ID: 2068
Description: Process WMIPRVSE.EXE -EMBEDDING (PID=99999). DSAccess initialized successfully.
From that point on, all errors from MSExchangeDSAccess and some more disappear from the logs, and I can query DSAccess via WMI. So I think the issue is with WMI but still cannot quite pinpoint the underlying cause.
-= F1 is the Key =-
------------------------------------
Reply:
Sukh
------------------------------------
Reply:
--- Rich Matheisen MCSE+I, Exchange MVP
------------------------------------
Reply:
Tis but a scratch! It's just a flesh wound!Good luck with WMI spelunking. Whenever presented with WMI problems Ilike King Authur's advice in Monty Python and the Holy Grail: Runaway! Run away! :-D---Rich MatheisenMCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
------------------------------------
Reply:
(http://support.microsoft.com/kb/947485). Not exactly my symptoms but newer code may help.
-= F1 is the Key =-
------------------------------------
Reply:
In case anyone's interested: the above hotfix did dot resolve the issue in my environment. So I have a workaround (terminating the wmiprvse.exe process that is DSAccess) but no cause or the fix.I wonder if current versions of Exchange also rely on that process
-= F1 is the Key =-
------------------------------------
add iscsii target virtual disk. feature is installed but server is not listed
just wondering what could be causing this.
i installed iscsi target feature from and features. i can see that the service is running. but the iscsi virtual disk wizard dose not see the machine.
I allready disabled the firewall to see if that was the case.
Edit: reinstalling server and domain contoler seemed to have fixed this.
- Edited by dw5304 Thursday, March 15, 2012 5:30 PM
- Changed type Vincent Hu Monday, March 19, 2012 10:49 AM
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Hi,
here's a walkthrough (maybe it might help?):
http://blogs.technet.com/b/meamcs/archive/2012/03/30/installing-and-configuring-target-iscsi-server-on-windows-server-8-beta.aspx
Don
------------------------------------
