Prisma SQLServer Connection database was empty

Question

I'm trying to connect to my SqlServer with Prisma. When i try to "prisma db pull" im getting this error.

P4001 The introspected database was empty

Of course my db is not empty. These are my connection string(database, user and password is true) and schema.prisma;

Connection String at .env:

DATABASE_URL="sqlserver://192.168.1.86;database=***_live_IT;user=***;password=***;encrypt=DANGER_PLAINTEXT;"

schema.prisma:

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
}

And here is my SqlServer Tables(i want to connect ***_live_IT)

SQLServer Databases

And here is Tables of that Database

SQLServer Tables

Any idea is appreciated. Thanks in advance.

Edit: Full text of error here.

PS D:\xampp\htdocs\noip> npx prisma db pull
npm WARN config global `--global`, `--local` are deprecated. Use `--location=global` instead.
Prisma schema loaded from prisma\schema.prisma
Environment variables loaded from .env
Datasource "db" - SQL Server

✖ Introspecting based on datasource defined in prisma\schema.prisma
Error: 
P4001 The introspected database was empty:

prisma db pull could not create any models in your schema.prisma file and you will not be able to generate Prisma Client with the prisma generate command.

To fix this, you have two options:

- manually create a table in your database.
- make sure the database connection URL inside the datasource block in schema.prisma points to a database that is not empty (it must contain at least one table).

Then you can run prisma db pull again.

Answer 1

I solved this problem in a simple way.

prisma db push

then

prisma db pull

Answer 2

adding "schema=<schema_name>" to the database url solved this for me when trying to connect to a local sqlserver. Unfortunately, prisma can only connect to one schema at a time.