How to allow remote connection in Microsoft SQL Server
In this video I was able to access the SQL Server that belong to virtualization machine from my main laptop through SQL Server itself. Let's go with steps as usual X SQL Server device want access Y SQL Server device, we will apply all settings on Y device. - Open SQL Server Configuartion Manager then go to Protocols for MSSQLSERVER - Change TCP/IP to Enabled then right click and left click on properties, go to IPv4 change Enabled to 'yes' then go down to IPALL and make sure TCP Port number is 1433. - Open Windows Defender Firewall and then left click on Advanced settings and you open new rule for Inbound Rules and Outbound Rules. * Rule type is port Next * TCP/IP protocol then you type the port number for SQL Server 1433 Next *Action left click on Allow the connection Next *Profile left click on all Domain,Private,Public Next * Name type anything then left click on Finish - Go to Services and Restart SQL Server (MSSQLSERVER) - Now you open SQL Server in X device then type Server Name of SQL Server Y device and choose SQL Server Authenication. - Put Login and Password of Y SQL Server device - Go to options and change Network Protocol to TCP/IP - left click on connect SQL Server databases of Y device is appearing in X SQL Server device and I hope you enjoyed watching the video :) Notes: SQL Server of Y device must have Login and Password for access.
Download
0 formatsNo download links available.