Home / Questions / 125511
Accepted
Luis Pizarro Ramírez
Asked: 2020-12-19 03:37:59 +0800 CST 2020-12-19 03:37:59 +0800 CST

Get SqlServer 2008 connection string WITHOUT Visual Studio

  • 772

I have a VPS with Windows Server 2012 and with SqlServer already installed. And I developed a Website with connection to BDD on my local PC. The connection string that I use, I generated with Visual Studio when connecting a table from the same IDE.

In my VPS I cannot install other programs , is there a way to obtain the Connection String, only with the SqlServer or SqlManager?

c#

1 Answers

  1. Best Answer

    To obtain the connection string against a database without the need for VS or similar, you can create a file with the .udl extension and open it. This file looks like this:UDL file

    In the provider tab you can switch between SQL Server (default), OLE db and in general the DB types for which you have the drivers installed (OLE comes by default in MS)

    Once the connection parameters have been inserted, press accept and then right click on the file and open with notepad (or notepad++, as you like) and you will get something similar to this: connection string

    I hope it works for you and is what you are looking for.

    Cheers!!

    • 3