Biggest Addiction - TEA

My Day starts with a TEA . Without TEA no work :)

Sunday, January 18, 2015

Steps to connect to SQL Express Remotely

Problem: How to connect to SQL Express Remotely in same network (say. corporate network) I have used SQLCMD to check whether I am able to access the SQL Express server on remote machine. Steps to execute: SQL Server Management Studio (SSMS) Open SSMS ,  Right click on SQLExpress to open properties of the SQL Server. Click on Connections. Make sure in Remote server connections, Allow remote connections to this server is checked. SQL...