How to access 2 instance of SQL server remotely with same IP address

-


Scenario- You have 2 SQL servers with different versions installed in your machine for example one is sql server 2008 r2 and another one is sql server 2014

Now you want to access both the servers through IP address in this case if you have installed SQL server 2008 in default instance mode and sql server 2014 with manual instance name

so when you will connect with IP address it will make connection with SQL server 2008 R2 because the port number(1433) will going to be use with default instances.
You will have to make below settings in the SQL server configuration manager for making access to SQL server 2014.Follow below steps.

Steps-)
Go to-SQL Server network manager-Select Protocol for SQL2014-Double Click on TC/IP and select tab IP Address-Here Find IPALL-give the port number in TCPPort-Apply and restart SQL Server service. Even you can change default port.




Comments

Post a Comment

Popular posts from this blog

Core 5 Security Epics in AWS Cloud

-
Image
AWS Core Security EPICs refer to the foundational security features and capabilities provided by Amazon Web Services (AWS) to ensure the security of customer data and resources in the cloud. EPICs stands for "Elevated Privileges Isolation and Control," which are key principles of cloud security. Identity and Access Management (IAM) - AWS IAM is a powerful tool that helps users manage access to AWS resources. It provides a centralized view of all users and resources, allowing administrators to create, manage, and enforce security policies. IAM enables administrators to create roles with specific permissions, set up policies that define which actions can be performed on resources, and manage users and groups. IAM also supports multi-factor authentication (MFA), which provides an extra layer of security for users. Network Security - AWS provides a wide range of security controls to help protect the network infrastructure. These include virtual private cloud (VPC), network acces
Read more

Why do you need to monitor your network?

-
Image
               Monitoring  your network is essential for several               reasons, including: Security: Monitoring your network can help you identify potential security breaches or threats, such as unauthorized access or suspicious activity. It allows you to take action quickly to prevent or minimize any damage caused by a security incident. Performance: Monitoring your network can help you identify performance issues such as slow network speed or bandwidth constraints. You can then take action to optimize your network to improve its performance. Availability: Network downtime can result in lost productivity and revenue. Monitoring your network can help you identify and resolve issues quickly, reducing the amount of downtime your network experiences.                                                                                     Compliance: Depending on your industry or organization, you may be required to meet specific compliance requirements. Network monitoring can help y
Read more

How to change Domain account logging password

-
Image
If my system is in domain and we have sufficient privilege for changing password of our account or Server admin has already given us permission for doing this task. We need to follow this process for this. Press Ctrl+Alt+Delete you will gate following screen from here you can change your account password.  
Read more