LL – Laxmi Lal Menaria Blog!

Category: Remote

  • How to update the Max Memory at SQL Server?

    From the command prompt start sqlCmd using the Dedicated Administrator Connection (DAC). : net start MSSQLServer /mSQLCMD /f C:>sqlcmd -S ServerName -U sa -P –A Once you are connected, execute the following to set the memory to 4 GB, it should be enough to allow you to reconnect using the Management Studio tool. sp_configure ‘show…

  • How to Backup MYSQL Databases

    REM Export all databases names to file mysql -h your-server-ip -u user-name -ppassword information_schema –skip-column-names –execute=”SHOW DATABASES;” > databases.tmp echo “Start!” REM Look over database names REM Outter loop to get table names for /F %%A in (databases.tmp) do ( echo “Exporting table Names for %%A” mysql -h your-server-ip -u user-name -ppassword %%A –skip-column-names –execute=”SHOW…

  • How to fix CLSID {00024500-0000-0000-C000-000000000046} error when using excel component in background code?

    We have  a windows Service application which uses Excel Application Object. It used to work on some machines but not all, the error which I am getting is: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. After some struggling I found a solution and it works,…

  • Only Office Error: Server connection lost. The document cannot be edited right now

    After hosting of Only Office some time users can get the error “Server connection lost. The document cannot be edited right now“.? To resolve this error we can remove 2 values from the web.config key of the Document Server setup. By default values: <add key=”editor.settings.coauthoring.url” value=”/coauthoring” /> <add key=”editor.settings.spellchecker.url” value=”/spellchecker” /> Remove values like that:…

  • How to access your machine in browser using VNC?

    Steps to access windows machine remotely using browser: Download and install TightVNC , while installation provide password for access. all other info must be default. Install Cygwin with Python? to C:\CYGBIN Download Kanaka noVNC and extract it. Copy Kanaka Folder to C:\CYGBIN\Kanaka Now run the Cygwin.bat using “Run as Admisistrator” Go to root using “cd…