Oracle/MSSQL/MySQL

Unable to connect to MSSQL Server after changing the Server name

images

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. If you wish to try out the 180 days free trial of SQL Server 2019 on-premises which helps build intelligent, mission-critical applications using a scalable, hybrid data platform for demanding workloads. You may also want to download the SQL Server 2019 Developer version (Microsoft SQL Server 2019 and Microsoft SQL Server Management Studio which is a full-featured free edition, licensed for use as a development and test database in a non-production environment. See this article for the differences between various Editions of MsSQL Server.

SQL Server 2019 makes data integration, management and intelligence easier and more intuitive than ever before. You can also download and install SQL Server 2019 on Windows, Linux, and Docker containers

Problem: Since I had this installed on my local machine, I could access it using the localhost or server name.

Solution: You can also use the IP Address to connect as well. This will save a lot of tweaking time.

I hope you found this blog post helpful. If you have any questions, please let me know in the comment session.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x