Category: Code or Hosting
-
Find the Default File Paths for a Given SQL Instance
Method 1 of 1? — Check if temp database exists — Tempdatabase is used for determining the default database path –if the zztempDefaultPath db exists drop IF EXISTS(SELECT 1 FROM [master].[sys].[databases] WHERE [name] = ‘zzTempDBForDefaultPath’) BEGIN DROP DATABASE zzTempDBForDefaultPath END; — Create temp database. Because no options are given, the default data and — log…
-
Create the alias with cliconfg.exe
Option 2: Create the alias with cliconfg.exe Log into the Application and/or front-end Web servers Got to Start > cliconfg.exe (Note: it’s c-l-i-c-o-n-f-g-dot-e-x-e) Then click on “Alias”: If you already have an alias set up, it will show up there. Otherwise… Click “Add” Specify the port number and give it a name. That’s it! Test…
-
Solved dotDefender An error occured. Action: get_update_best_practice_rules_configuration Exception: Invalid Response
Solved the following dotDefender error: Error text: An error occured. Action: get_update_best_practice_rules_configuration Exception: Invalid Response Internet Information Services 7.5 Error Summary HTTP Error 403.18 – Forbidden The specified request cannot be processed in the application pool that is configured for this resource on the Web server. Detailed Error Information Module IIS Web Core Notification BeginRequest…
-
Solved: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
I ran into this error on a RHEL machine that recently patched. To correct the issue, I recreated the symlink in /tmp : ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock service mysqld restart I found the solve and associated troubleshooting steps here: http://forums.cpanel.net/f354/cant-connect-local-mysql-server-through-socket-var-lib-mysql-mysql-sock-111-a-78444.html
-
iMIS Requirements for 15.1 15.2 and 20
iMIS: Version 15.1.3 requires SQL Server 2008 (R1, as R2 will not work even in compatibility mode). By version 15.2 is when SQL Server 2008 R2 can be used. Requirements for iMis 15.2.15 *Microsoft SQL Server and Express Edition 2012 *Microsoft SQL Server and Express Edition 2008 SP3 and 2008 R2 SP1 (32-bit and 64-bit)…
-
Updating Local Host Entries and Web Server Caching
If you edit a hosts entry on your server, you win, and if windows, you need not restart IIS as ASP.NET does not cache this resolution, PHP run as an apache module DOES require a restart of apache. Idk about other languages just yet, nor services tied to them.
-
SQL Server FAQ
I wanted a place to throw a lot of the high level SQL FAQ and answers for issues I come to. v=sql.70 7 v=sql.80 2000 v=sql.90 2005 v=sql.100 2008 v=sql.105 2008R2 v=sql.110 2012 v=sql.120 2014 v=sql.130 2016 This site lists build versions, this is really useful for matching version to version by running the updates…
-
Solved: Java method security exception.A security exception occurred while invoking Java method on a “”java.lang.Class”” object. MethodName is getName. Possible cause: Either the createobject function and cfobject tag are disabled in the security sandbox or you are trying to create a class in the ColdFusion package and that is disabled.
I was getting this error in the exception log: “Error”,”ajp-bio-8012-exec-37″,”04/12/13″,”11:51:15″,”mgtemplate”,”Java method security exception.A security exception occurred while invoking Java method on a “”java.lang.Class”” object. MethodName is getName. Possible cause: Either the createobject function and cfobject tag are disabled in the security sandbox or you are trying to create a class in the ColdFusion package and…
-
Easily test connectivity to MSSQL Server
I have run into a number of cases where I want to test a connection to a SQL (MSSQL) Server without having to resort to code. To do so is rather straight forward: Create a new file, a simple txt file is fine, and rename the document to “TestDBConnection.udl” sans quotes and spaces. Be sure…