This guide will help you to set up MS SQL Server (express and standard editions) with remote connection enabled via TCP port 1433 or any other port of your choice. By default, when you install MS SQL Server Express edition, the remote connection feature is disabled. You can connect to the DB locally via SQL Server Management Studio but you won’t be able to connect…
Along with the Windows Server 2012 R2 official release this month, there is another member of the Windows Server family that deserves attention, which is Windows Server 2012 R2 Essentials. I ve written here previously about Windows Server 2012 Essentials, and can report that Microsoft continues to invest in the Essentials product. While optimized for a hybrid…
Also experienced the same issue here, blank page. Created for future implementations for a web server? Well, to be honest, i hoped to see a web fronted where i can login (with defined users) to remote access my content and view it on: Laptop / Android or iPad. But then again i guess this isn t the purpose why this software exists or Will it evolve? Not to bash…
Learn about the various panes available in the Server app, how to enable remote access to the Server app, and how to move the location your server uses to store much of its service data. Once you’ve completed your initial installation and configuration of OS X Server and you click Finish at the Congratulations pane, the Server app opens its main configuration…
This topic describes how to start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using SQL Server Configuration Manager, SQL Server Management Studio, net commands from a command prompt, Transact-SQL, or PowerShell. Before you begin: Instructions using: What is the SQL Server Database…
This documentation is archived and is not being maintained. Applies To: Windows Server 2008 R2 Server Manager in Windows Server® 2008 R2 replaces older management consoles such as Configure Your Server and Manage Your Server. With Server Manager, you prepare the server for deployment by installing logical software packages known as roles, role services, and features…
For more than 10 years Videoguys.com, one of the world’s leading resellers of video editing and production solutions, has been publishing DIY articles as a service to their customers. These guides have been recommended by video editing, post production, gaming and general computer blogs, web sites, and user forums all over the world—including Streaming Media…
First, make a backup of your sshd_config file by copying it to your home directory, or by making a read-only copy in /etc/ssh by doing: sudo cp /etc/ssh/sshd_config /etc/ssh/sshd_config.factory-defaults sudo chmod a-w /etc/ssh/sshd_config.factory-defaults Creating a read-only backup in /etc/ssh means you ll always be able to find a known-good configuration when…
SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse Returns the name of the local server that is running SQL Server. Transact-SQL Syntax Conventions Syntax @@SERVERNAME Return Types nvarchar Remarks SQL Server Setup sets the server name to the computer name during installation. To change the name of the server, use…
I’m sure you’ve heard of the Internet… right? Duh. Well, simply put, it’s a big huge network that’s changing humanity. Does that Jog your memory? Now the real question is this: do you know the difference between the Internet and your WiFi network? If you don’t, stay calm and I’ll explain. I’ll do my best to put this into laymen s terms. There will be a few concepts…
When you run ipython notebook on a remote server using the following command jupyter notebook –no-browser –port=9 You will see: The Jupyter Notebook is running at: In this case, you cann’t use the link: public_IP_address:9 or domain_name:9 to get access to the Ipython Notebook Server. You can do some config to allow the Ipython notebook server to run on the public…
In AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs, I outlined how there are, effectively, two ways to tackle the need to run batch jobs (or SQL Server Agent jobs that target a database that’s part of an AlwaysOn Availability Group). Either your SQL Server Agent jobs can target (or detect) whether…
I wish everyone a very happy and prosperous new year. Here comes the first blog post for the year 2015, on ColdFusion Buider 3. A user came across our Mobile Application Development Contest blog and was trying to develop his application using ColdFusion Builder 3, but he wasn’t able to setup a connection between ColdFusion 11 and ColdFusion Builder 3. He was…
The UCLA Library s online subscriptions are all set up to provide automatic access to any computer or device with a UCLA IP address, the unique address associated with every computer on the internet. IP addresses are assigned automatically by your internet service provider when you connect to them. Your computer can obtain a UCLA IP address in a few ways. On-campus:…
When you change the name of the computer that is running SQL Server, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name. Instead, use the following steps to update system metadata that is stored in sys.servers and reported by the system function @@SERVERNAME. Update system metadata to reflect computer…
In the Open box, type mmc -a to open the Microsoft Management Console in author mode. On the File menu, click Add/Remove Snap-in. In the Add/Remove Snap-in window, click Add. In the Add Standalone Snap-in window, click Computer Management and then click Add. In the Computer Management window, click Another computer, type the name of the remote computer you wish…
: Intranet websites, private sites for users within a home or office, can be useful for lots of things. And if your home or office PCs can all access the Internet, chances are good that you have an Internet connection sharing router or gateway device, like the SMC Barricade, or the Linksys BEFSR81 (just two examples out of many). But what does an Internet…
I m not sure what you were exactly asking. As you are writing this procedure for an Auditing need I guess you re asking how do you get the current database name when the Stored Procedure exists in another database. e.g. USE DATABASE1 GO CREATE PROC spGetContext AS SELECT DB_NAME GO USE DATABASE2 GO EXEC DATABASE1..spGetContext /* RETURNS DATABASE1 not DATABASE2…
Netgear’s new Nighthawk X10 AD7200 router is supposed to be the world’s fastest,at least according to Netgear. The company also claims that its new router is the first designed for media streaming and instant backup,which is not very true and makes me wonder if I can trust Netgear about any of its claims. Let’s get into it. The X10 comes with a 1.7GHz Quad…
This SQL Server tutorial explains how to use the NOT condition in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) NOT condition, also called the NOT Operator, is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement. Syntax The syntax for the NOT condition in SQL Server (Transact-SQL) is: NOT…
This documentation is archived and is not being maintained. In this topic, you will learn how to start and stop the SQL Server Browser service. By default, Microsoft SQL Server 2005 Express Edition (SQL Server Express) does not set the SQL Server Browser service to start automatically. On the Start menu, right-click My Computer, and then click Manage. In Computer…
Sure, you could just connect a PC to your TV, but these provide convenient interfaces across all your devices. That means apps for TV streaming boxes, smartphones, tablets, and web-based interfaces for everything else. They even work over the Internet. Bring Your Own Media There are some good free software packages for this, but you’ll need to bring your own…
As an engineer, my favorite answer in the world is, it depends. I can certainly recommend some great Simple Network Management Protocol (SNMP) performance monitoring tool sets based on the email you sent. If you just want to monitor management information base (MIB) that provide statistics based on hardware, software services, and interface data, then go with…
ESHA software uses SQL Server to host the ESHA Database. When the database resides on a separate machine (often a Server computer), there is need to allow SQL Server as an exception if Windows Firewall is enabled. To allow this exception, get into Windows Firewall (found in the Control Panel). Depending on your operating system, your Firewall display may vary…
