Connecting to a another SQL Server instance on the same network/LAN

If you need to connect to another SQL Server instance on the same network you need to ensure the following settings are in place-

1. Your login should be added to the SQL Server instance you are trying to connect to.

2. The SQL Server instance should have Allow Remote Connections as checked.
a. Goto Instance Properties
b. Connections
c. Check "Allow remote connections to this server".

3. SQL Server Browser Service should be running in the machine you are trying to access.

4. TCP/IP Protocol should be enabled for the SQL Server
Steps
a. Run SQL Server Configuration Manager
b. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS
c. Make sure TCP/IP is enabled.

Hope this helps!!
Hitesh

Comments

Alex on DAX (Alex Kwitny): How to: Copy a sales order using SalesCopying class

Alex on DAX (Alex Kwitny): How to: Copy a sales order using SalesCopying class : There are a million code snippets that show you how to create/copy a sales order that work 80% of the time, but often don't account for ...

A simple customization in MPOS (Blank Operation) with AX7

Hi All, I recently had to add a Blank Operation to Modern POS (MPOS) to open a url from MPOS. Blank Operation as you may already be aware enable you to extend Microsoft Dynamics Retail for POS by adding custom logic that can be triggered from the Retail POS Register buttons. The way to implement Blank Operations in MPOS is different from Enterprise POS as MPOS is a modern app as compared to EPOS which is a windows forms based app. So lets explore a very simple customization i.e. we want to open a URL on triggering a button from MPOS. 1. We would need to start with AX to add a button to the layout of MPOS. If you do not want to disturb the standard layouts its better to copy one of the existing layouts and then modify it using the designer. Please note the designer only opens in Internet Explorer so it will save you time by not trying to open it in other browsers e.g Chrome 2. Next we need to add this layout to the Store where we intend to use it, in

Hyper-V VM 100% disk utilization

I was facing a persistent issue of 100% disk utilization on starting any VM in my Hyper-V. The below link helped me to resolve it https://social.technet.microsoft.com/Forums/office/en-US/2b184f22-ea8c-4bc3-9f64-8b46eeaeef61/hyperv-host-disk-usage-at-100?forum=w8itprovirt

TechTalk

Search This Blog