I received the following email from Mike Bikinis. about enterprise manager. “How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”
Following images quickly explain how to connect to SQL Server with different connection property. It can be useful when connection properties need to be changed for SQL Server when connected. I use this in my company when I connect to one of our servers using named pipes instead of TCP/IP. Let us learn about Connection Property of SQL Server Management Studio SSMS.