Today, the following command saved my day. EXEC xp_readerrorlog My SharePoint 2010 installation cant find the DB server. I was able to ping , tracert to the db server from my windows (SharePoint). The SQL server were running perfectly fine. My first suspect was the firewall. I disabled the servers firewall in both servers. This is fine to do because these are testing systems. But , my sharepoint installation still cant find the SQL server. After googling for few hours, i tried the above command to check which port was being used by the SQL service. The SQL service was using port 56033 ( i guess this because the dynamic port was set as 0 ). After i configure the TCP Port to 1433 and removed the dynamic port value, the SQL server start listening in 1433 and my SharePoint was able to find the SQL server now. Hope this helps someone out there. Happy troubleshooting!
8 Principles of Document Writing : 1.Cohesive The statements have to be well-integrated and unified. 2.Complete The document has to be complete. 3.Consistent The statements should have consistent presence through out. 4.Correct The information must be correct. 5.Feasible The document should be readable by the Users. 6.Modifiable Contents are grouped so the changes doesn't need to modify. 7.Testable A document must be reviewable 8.Unambiguous Statements should be not give more than one interpretation.
Monte Carlo Method It is a mathematical way of approximate the probability by generating the random variables. Monte Carlo simulation is the computerized method for applying the Monte Carlo method. Monte Carlo Simulation simplified STEP 1. Find the Three point estimate - Best case , Normal case, Worst case estimate ( Min , Max , Average ) STEP 2. Find the Mean,StDev and Number of Iterations required - No. of iterations are important for reducing the total error percentage. STEP 3.Use the Excel rand() function with the low and high points to generate a normal distribution. - Formula for generating random probability is =rand()* (Max estimate - Min Estimate) + Min Estimate STEP 4.Propagate the random generation for number of iterations. - Use the Excel's data table to propagate the random generation. Please check the example file attached. STEP 5.Use Excel's Countif() function to calculate the number of ...
Comments
Post a Comment