Skip to content

Instantly share code, notes, and snippets.

@kolosovpetro
Last active August 20, 2023 14:15
Show Gist options
  • Save kolosovpetro/99d3cd87ba20a7718af99cdf4ab2444a to your computer and use it in GitHub Desktop.
Save kolosovpetro/99d3cd87ba20a7718af99cdf4ab2444a to your computer and use it in GitHub Desktop.
Database connection strings

MS SQL local

  • "Data Source=DESKTOP-RN0NICT;Initial Catalog=MoviesCodeFirst;Integrated Security=true;"
  • "Data Source=DESKTOP-CK5PEBD;Initial Catalog=MANGO_DEV;Integrated Security=true;TrustServerCertificate=True;"

MS SQL Docker

  • Server=localhost,1433;Database=MANGO_DEV;User Id=sa;Password=x2yiJt!Fs;TrustServerCertificate=true;

MS SQL Azure

  • Server=tcp:database_name.database.windows.net,1433;Initial Catalog=mango-dev-serverless;Persist Security Info=False;User ID={user_name};Password={pass};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Postgres Docker

  • "Server=localhost;User Id=postgres;Password=postgres;Database=MoviesCodeFirst;"

IIS local

  • Data Source=RazumovskyVM;Initial Catalog=MOVIES_DEV;Integrated Security=true;TrustServerCertificate=True;

External Connection

  • Server=20.166.17.125,1433;Database=MOVIES_DEV;User Id=MyLogin;Password=6I4l0b3PaOArOho7SzLl;TrustServerCertificate=true;

Internal via User

  • Server=127.0.0.1,1433;Database=MOVIES_DEV;User Id=MyLogin;Password=6I4l0b3PaOArOho7SzLl;TrustServerCertificate=true;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment