c# - How to find SQL Connection String when VS is not installed on the same server as SQL is -

visual studio installed on computer. doing rdp network computer on sql server installed. need put in connection string per network computer on have required database. know how pick connection string when doing within visual studio, here need retrieve via sql server , copy paste vs.

there no magiс in sql server connection string , can construct manually using server name , options.

when you're connecting using username , password looks like

server=myserveraddress;database=mydatabase;user id=myusername;password=mypassword; 

when you're using trusted connection (windows authentication) looks like

server=myserveraddress;database=mydatabase;trusted_connection=true; 

have here more details , options concerning sql server connection strings