Jump to content


  • Posts

  • Joined

  • Last visited

Computer Information

  • OS
    Windows 10
  • CPU
  • RAM
  • Storage Type
    Hard Disk
  • Storage Size
    500GB – 1TB
  • Graphics Card

Recent Profile Visitors

406 profile views

ksanjeevp's Achievements


Newbie (1/14)



  1. Steps:- To upgrade on same server- If you want to upgrade on another server you also can do. To upgrade on same server, OS win server 2012 R2. Check for Windows updates, Installed required updates. Cmd to stop, TFS services(cd C:\Program Files\Microsoft Team Foundation Server 14.0\Tools>Tfsserviceconntrol.exe quiesce Check URL should not be working. 3. SQL 2016 upgrade with SP1 upgrade your sql with Higher Version or if you want to be on same SQL 2014 then you require to install SP, upgrade will be required. You should have backup for Databases if you are going for Production upgrade. Install using ISO, TFS 2017.2 Run tfsserver2017.2_enu After installing Ensure to take Backup, for required DB Here Define services Account and all including Public URL, If you require to upgrade only in intranet then you should have CNAME entry in DNS, so that host can be resolved, If you have users who access it publicly then you should have necessary settings in your Firewall what you are using. After readiness check, process will be start. Checked the Version after complete. If you require to use your Team Foundation server publicly then you have to purchase a SSL cert and install that certificate on your server for security. Its all Done. Now you have upgraded your Team foundation server. Complete post - https://ksanjeevpandey.blogspot.com/2017/11/steps-to-upgrade-on-same-server-if-you.html Thanks, Sanjeev
  2. You can check First. sc \\servername query If it gives you error (Access denied) means you need to set the required permission for user. Also You should allow WMI (Windows Management Instrumentation) Port -135 in Firewall exception of Remote computer, for which you want to manage services. Also, you can do via cmd (run as admin) - sc \\servername start ServiceName (start or stop) Hope it will help.. Thanks,
  3. Better you should write with all the Details, which OS are you using etc ..However assuming you will have another account with admin privilege You can restore the backup from restorepoint or from backup..as suggested above. or go to Windows +R (run) - secpol.msc or gpedit.msc and make the required changes one by one. Thanks,
  4. How to Take backup of All of the Databases available on instance ? Sometimes Its required to take all of the Databases to be backed up periodically for more reliable backup process. If You require to get backup of any critical server's Database then You shouldn't do manually always, It will be better to automate the Process.SQL Query to take backup for All the Databases:- DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name-- specify database backup directorySET @path = 'D:\BKP\' -- specify filename formatSELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR READ_ONLY FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude these databasesOPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @path + @name + '_' + @fileDate + '.BAK' BACKUP DATABASE @name TO DISK = @fileName FETCH NEXT FROM db_cursor INTO @name END CLOSE db_cursor DEALLOCATE db_cursor copy the above query and save it with file name i.e- sqlbackupquery. The above query will give the Database backed up file (.bak) on the location You will set.You can run it over SQL server Management Studio (SSMS) or on sqlcmd.Query will give you the database backup in the described format below.DBName_YYYMMDD.BAKYou can run it from SQL CMD, with the required parameters. for Example see below.sqlcmd -S .\InstanceName -i C:\SQLBackup\SQLBackupQuery.sql (backup query file location and file name) If you require it to schedule the Process for backup of all SQL databases on the path where you want You can schedule it from Task Scheduler.To create a task go to Run (windows +R) - taskschd.msc and create a task. schedule it as per the requirement. Here define the action. Note- User should have the Admin right,Logon as batch Job Right. You also can automate on SQL Server Express from above query and Process.Enjoy, Now You will be able to take the databases backup in one go and schedule it as per your requirement for convenience and saving the time.Thanks,SanjeevPS- Please write to me or comment if you have any question/Feedback.
  5. Here I am sharing about UCC SSL certificate Installation. Prior to start its required to understand what is an SSL certificate. and why we require it, I have tried an easy way to understand and sharing easy steps of Installation.UCC SSL certificate- also called multidomain SSL certificate. UCC- Unified Communication Certificate is an SSL certificate that secures multiple domains(SAN- subject alternative names), Host names(FQDN) within a Domain.UCC lets you secure your Primary Domain and after SANs or any hostname which you use Publically for any hosted services. It can support upto 99, and Ideal for MS exchange, Communication servers or any application hosted on IIS which you require publically. It will be compatible with shared hosting as well. Understand why SSL certificates required- SSL certificates give you secured and encrypted communication between websites and your Browser, SSL( secure Socket layer) which provides encryption, SSL certificate required to installed on the Pages where user required to fill/send sensitive and Personal/confidential Information. such as payment pages, Login page, Online forms etc. data transfered in Plain-text or in non-encrypted can be easily intercepted,compromise or stolen. Here I will share how we may use same SSL certificate for both, also on shared hosting with a differen platform/Application hosting.First you require to purchage UCC SSL certificate as per your requirement.You may get from service providers for example- in.godaddy.com, instassl.com symantec globalsign..etc.on shared hosting we had got an SSL from service provider but they didnt able to support us and want us to charge for installation, So we have done it on our own. It will be very helpful follow the steps and you will be able to do it easily.. Purchage a UCC SSL certificate from Service provider for your xyz.com Domain. Now you want to use the certificate on xyz.com +abc.xyz.com + India.xyz.com+ Delhi.xyz.com for different different services for different purposes on different platform, so to use this you should have Certificates with same serialnumber should install on required Hosts/Servers/SANs. Example:- https://yourdomainname.com https://www.yourdomainname.com https://abc.yourdomainname.com https://delhi.yourdomainname.com:443 (orother port) it should all working. even if application are hosted on different platform or shared hosting.XYZ.com is domain and abc.xyz.com or other prefixes will be SANs. In our scenario we have got SSL from godaddy and we were using it only on IIS(microsoft) but we want to use for other services as suggested by the support Team, we have rekey and certificate has stopped working for previous but as we purchased and we have Certs available it should work, but support was not able to give us required steps then they said it will be on chargeable basis if we required, then we have done from our own.If you have installed Cert on IIS hosted application and you want same cert with same serial number to use on Linux apache hosted application/website.Here is an outline of the process that may used to generate and install the UCC certificate for use in multiple places at xyz.com Using IIS Manager on our server, create a certificate request. Then take the certificate request blob to the GoDaddy site and enter it as my Certificate Signing Request (CSR) to get them to issues me a UCC certificate to specification (SAN’s etc.) Once they issue UCC certificate, take that certificate back to the IIS Manager on server to complete the certificate request by installing the certificate on the server where the original certificate request was made. Then, I export the certificate from the server(IIS manager), which creates a .pfx file that we then use to install the UCC certificate on all the other sites that are named in the certificate.Export the certificate from IIS: Go to IIS manager on your windows server.Select your server in the left pane, then double click the Server Certificates icon in the middle pane: Select the certificate that you want to export in the middle pane, then click the Export… link in the right pane: enter the file name and pass to export. Your file will be exported as you want on location UCC cert.pfx created on desired location.[/caption] Now use the file to install on the services or application where you want. Remember when creating CSR(certificate signing request), You need to add the SANs for which you have to use the SSLcerts with same serial.You will be able to do on IIS easily but if you use shared host or if its on another OS or application as Linux apache, then you required to extract Pvt key again and paste pvt key separately. then you may use it perfectly.Use your credntial to login on shared host, If its on Linux apache go to Cpanel and click on SSL/TLS option. after clicking on SSL/TLS go to manage SSL If you want to unintsall a certificate which is not working or required a new cert to upload. to install first you need to upload. or you may choose to install an uploaded cert. If you face issues with Private key, after uploading certs pvt key not getting uploaded then you need to extract Pvtkey from the certificate(.pfx or .crt file)You need to use Open ssl (http://gnuwin32.sourceforge.net/packages/openssl.htm) (Open SSL Tool) to extract the pvt key and use on the above tab with certificate. Now you will get above screen, you have installed successfully.after finishing browse your URL which will be working after few hours and match the both certs it will have same serialnumber and validity.To check go to Internet explorer- click on view certificate. Click on Details You will find same as on your IIS host and on your shared host or Except IIS different Application.Enjoy.. You have done now. Hi Guys please let me know if you have questions, and I welcome your comments.Thanks,Sanjeev complete Post - https://ksanjeevpandey.blogspot.com/2017/12/ucc-ssl-certificate-installation-on.html
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy