Base solution for your next web application
Open Closed

Connection String for RAD Tool (Load Entity From Database) #6175


User avatar
0
paulg created

Hi, what should be the Connection String when using the RAD Tool > Load Entity From Database? I have tried using the same as in appsettings.json and other variations, but it does not connect:

Server=.\SQLEXPRESS; Database=TestDB; Trusted_Connection=True;

I only get Instance Failure error.


3 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @paulg

    Does it work if you don't use SQLEXPRESS ? By the way, you should use a different database than AspNet Zero's database.

  • User Avatar
    0
    pindiasoftware created

    Hi @paulg,

    I get the same error with a trusted connection. Try to use a connection string with a valid SQL Server user:

    Data Source=DB_INSTANCE;Initial Catalog=DB_NAME;User ID=DB_USER;Password=DB_PWD

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @paulg

    Please reopen the issue if you haven't solve the problem yet.