Needed to test a connection string to mirrored SQL Server 2008 databases and this procedure worked very well. By Reza Ghorbani on 5/23/2012. Great and to the point. Thanks a million. By path on 8/17/2012. Thanks so so much. Very Usefull article. I have been looking for something like this for awhile.
Hi,As you have Visual Studio on your machine, I think we can also use the Visual Database Tools of Visual Studio to generate the connection string.Please:1. Create a new data connection to the SQL Server database in theServer Explorer of Visual Studio2. After the connection is established, right-click on the connection name and selectProperties. There is an item called Connection String in theProperties window.Reference:How to: Add New Data Connections in Server Explorer/Database ExplorerPlease remember to mark the replies as answers if they help and unmark them if they provide no help.If you have any feedback, please tell us.
Hi,As you have Visual Studio on your machine, I think we can also use the Visual Database Tools of Visual Studio to generate the connection string.Please:1. Create a new data connection to the SQL Server database in theServer Explorer of Visual Studio2. After the connection is established, right-click on the connection name and selectProperties. There is an item called Connection String in theProperties window.Reference:How to: Add New Data Connections in Server Explorer/Database ExplorerPlease remember to mark the replies as answers if they help and unmark them if they provide no help.If you have any feedback, please tell us.