Gregory Varghese
  • About Me
  • Labs
  • GitHub
  • My Work Setup
  • My Photography Blog
  • About Me
  • Labs
  • GitHub
  • My Work Setup
  • My Photography Blog
  • Categories
  • All
  • Solutions
  • Administration
  • Troubleshooting
  • Tips and Tricks
  • Development
28th October 2007
Uncategorized

Secrets, oh my

It amazes me sometimes the lengths that companies go to “protect” their products but then make so simple to work around.

I am trying to get a program called NeatReceipts to work on my machine and am running into serious issues with it because of a crappy installer. It keeps failing when installing the database. Of course it tries to be slick and install in a password protected instance with a hidden password.

Naturally as a tech, I’m inclined to fix problems on my own PC. So I’m poking around to figure out exactly what’s happening and why it is failing. There’s no real information as to why it fails. It doesn’t even notify me that there’s been a failure, it actually tells me it’s successful.

So I’m tracing all the steps backwards and trying to figure out how to get the SQL instance setup. Of course there’s no information on this anywhere. So I do further sleuthing and stumble across log files created by the installer in another folder with this in plaintext:

Executing sqlexpr32.exe -q INSTANCENAME=NR2007 SECURITYMODE=SQL SAPWD=nr-2006-s@pwd-t6r5y7n9y7t6y7 ADDLOCAL=SQL_Engine,SQL_Data_Files SQLAUTOSTART=0 REBOOT=ReallySuppress /qn

Now it just makes me wonder, if you’re going to be all paranoid and choose a password that is really that complex and unguessable, why store it in a plain text where anyone with brains could see it?

It reminds me of the time when Quickbooks wouldn’t help my company unlock the SQL database when we were looking to integrate another product. The actual response we got back from them regarding the password was “Guess.”

Not very smart when you have a team of intelligent geeks who’s primary job is figuring out how stuff works. We didn’t waste time figuring out the password though. Instead we used a backdoor solution of backing up the database and restoring it which gave us full access to the entire DB.

  • Continue Reading
  • 0
  • 12
No More Articles
Newer Posts
  • 1
  • …
  • 8
  • 9

Tags


.NET (4) Administration (20) Applications (12) ASP.NET (8) ASP.NET MVC (2) C# (6) Caution (4) Debug (6) Development (17) Errors (9) ESET (3) Excel (2) Firefox (2) Fix (18) High CPU Usage (2) IIS (3) Javascript (5) jQuery (4) laravel (4) linux (6) Mac (13) Memory (2) Microsoft (5) NTFS (2) Open Source (3) Outlook (2) Outlook 2011 (4) Photography (2) php (3) Programming (8) review (2) Reviews (2) Sitecore (2) Software (8) Solutions (35) SQL (4) SSL (2) Tips (26) Tools (6) Troubleshooting (23) Useful (17) Utilties (9) Windows (11) Windows 7 (4) Windows Server (2)

Categories


  • Administration 58
    • Caution 3
    • Cloud 7
      • Cloudflare 1
      • Digital Ocean 5
        • Droplet 5
      • Namecheap 1
    • Hardware 4
      • Drobo 3
    • IIS 2
    • Linux 8
      • Apache 1
      • SSH 7
        • Terminal 4
      • Ubuntu 16.04 1
    • Mac 8
      • Software 3
        • Alfred 1
        • MAMP 2
        • PHPStorm 1
      • Terminal 4
    • Review 1
    • Security 6
      • ESET 4
      • Firewall 1
    • SQL 3
      • 2008 1
      • DTSX 1
      • mySQL 1
    • Stupid Tales 2
    • Windows 42
      • Applications 16
      • Malware 2
      • NTFS 2
      • PowerShell 1
      • Reviews 1
      • Software 20
        • Excel 2
        • Outlook 1
        • Peerblock 1
        • Remote Desktop 1
          • RDC 1
        • SourceTree 1
        • Steam 1
        • Synergy 1
        • Visio 1
        • Visual Studio 2013 1
        • Word 1
        • Wordpress 2
          • Hack 2
      • Tips and Tricks 30
      • Tools 20
      • Utilities 18
      • Windows 10 1
      • Windows 7 8
      • Windows 8 3
      • Windows Server 3
        • Windows Server 2008 2
        • Windows Server 2012 2
  • Body Hacking 1
    • Diet 1
    • Soylent 1
  • Development 28
    • Bitbucket 3
      • Pipelines 3
    • c# 2
    • CouchDB 1
    • Github 3
    • Gitlab 2
    • Open Source 4
    • ORM 1
      • Dapper 1
    • PHP 6
      • Laravel 6
        • Jigsaw 1
    • PHPStorm 1
    • Sitecore 2
    • SourceTree 1
    • Syncfusion 1
  • Mac 10
    • iCloud 1
    • Outlook 2011 2
    • Safari 1
  • Photography 3
    • Food 1
    • Rockstars 1
    • Uproar Festival 2012 1
    • Wolves 1
  • Products 3
    • Backblaze B2 1
    • Reviews 2
  • Programming 29
    • ASP.NET 7
      • MVC 1
    • AWS 1
      • Rekognition 1
    • C# 3
    • Javascript 2
    • jQuery 3
      • Fancybox 1
    • MonoTouch 1
    • PHP 5
      • Laravel 5
        • Tinker 1
    • Regex 1
    • Sitecore 2
    • SQL 1
    • SSL 2
    • VBA 2
      • Microsoft Word 1
    • Web Development 9
      • JavaScript 2
    • WinForms 2
  • Raspberry Pi 1
  • Recipe 1
  • Self Experimentation 1
  • Troubleshooting 43
    • Solutions 42
  • Uncategorized 9

Archives


  • October 2021 (1)
  • January 2021 (1)
  • July 2020 (1)
  • May 2020 (1)
  • April 2020 (1)
  • February 2020 (1)
  • September 2019 (1)
  • August 2019 (3)
  • July 2019 (1)
  • June 2019 (1)
  • May 2019 (4)
  • October 2018 (1)
  • July 2018 (1)
  • May 2018 (1)
  • April 2018 (2)
  • November 2017 (1)
  • October 2017 (1)
  • June 2017 (1)
  • May 2017 (1)
  • November 2016 (1)
  • October 2016 (2)
  • September 2016 (1)
  • June 2016 (2)
  • May 2016 (4)
  • February 2016 (1)
  • January 2016 (1)
  • October 2015 (1)
  • September 2015 (1)
  • July 2015 (1)
  • June 2015 (1)
  • May 2015 (3)
  • April 2015 (1)
  • March 2015 (1)
  • February 2015 (1)
  • July 2014 (1)
  • June 2014 (1)
  • May 2014 (1)
  • December 2013 (2)
  • September 2013 (1)
  • July 2013 (1)
  • May 2013 (2)
  • March 2013 (2)
  • February 2013 (1)
  • September 2012 (1)
  • August 2012 (4)
  • July 2012 (1)
  • March 2012 (1)
  • November 2011 (1)
  • September 2011 (4)
  • July 2011 (3)
  • June 2011 (3)
  • February 2011 (1)
  • August 2010 (1)
  • May 2010 (1)
  • October 2007 (1)

Continue Reading
Gregory Varghese

Top Posts & Pages


  • ReportCrash High CPU & How to Disable reportcrash in Mac OSX
  • How to Setup a CI/CD Pipeline for Storybook.js using Gitlab
  • How to Automate Sending Emails through Outlook interop using C#
  • How to Import Multiple VCF contacts into iCloud
  • How to execute SSH command with Bitbucket Pipelines
  • Why I'm switching from Namecheap to Cloudflare
  • SourceTree Crashes on Load
  • How to Get Browser Name and Version via JavaScript
  • How to use Backblaze B2 with Laravel
  • Copy File Context to Clipboard via Command Line, Git Bash (Mingw64), or Terminal

Recent Posts


  • How to deploy a React app to Amazon S3 using Gitlab CI/CD
  • How to Setup CI/CD of Jigsaw Site to Digital Ocean Droplet Using Bitbucket Pipelines
  • How to use Backblaze B2 with Laravel
  • How to Setup a CI/CD Pipeline for Storybook.js using Gitlab
  • How to Clear Archive & Read-only flags on Files in Windows in Bulk

Copyright © Gregory Varghese. 2022 • All rights reserved.

Onyx WordPress Theme by EckoThemes. Published with WordPress.