Enable tcp\ip remote connections to sql server express already installed database with code or script(query)

I tested below code with SQL Server 2008 R2 Express and I believe we should have solution for all 6 steps you outlined. Let’s take on them one-by-one: 1 – Enable TCP/IP We can enable TCP/IP protocol with WMI: set wmiComputer = GetObject( _ “winmgmts:” _ & “\\.\root\Microsoft\SqlServer\ComputerManagement10”) set tcpProtocols = wmiComputer.ExecQuery( _ “select * … Read more

Configure log4net to send errors to different appenders based on level

This can be done using the threshold or filter elements within the appender. Note that the threshold can be directly under the appender, where it acts as an inclusive filter, or under a evaluator e.g. <evaluator type=”log4net.Core.LevelEvaluator”> <threshold value=”ERROR”/> </evaluator> where it acts as an inclusive filter for skipping buffering (immediate output), where applicable. Full … Read more

Getting an Environment Variable in Terraform configuration?

I would try something more like this, which seems closer to the documentation. variable “UN” { type = string } variable “PW” { type = string } resource “google_container_cluster” “primary” { name = “marcellus-wallace” zone = “us-central1-a” initial_node_count = 3 master_auth { username = var.UN password = var.PW } node_config { oauth_scopes = [ “https://www.googleapis.com/auth/compute”, … Read more

Gitlab with non-standard SSH port (on VM with Iptable forwarding)

In Omnibus-packaged versions you can modify that property in the /etc/gitlab/gitlab.rb file: gitlab_rails[‘gitlab_shell_ssh_port’] = 766 Then, you’ll need to reconfigure GitLab: # gitlab-ctl reconfigure Your URIs will then be correctly displayed as ssh://git@git.domain.com:766/group/project.git in the web interface.

How to modularize an emacs configuration?

My .emacs file loads ~/.emacs.d/init.el, which defines the following functions, written first for XEmacs, but working well enough for Emacs these days: (defconst user-init-dir (cond ((boundp ‘user-emacs-directory) user-emacs-directory) ((boundp ‘user-init-directory) user-init-directory) (t “~/.emacs.d/”))) (defun load-user-file (file) (interactive “f”) “Load a file in current user’s configuration directory” (load-file (expand-file-name file user-init-dir))) Then the rest of the … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)