MSSQL Authentication failed against database server

I was trying to connect to MSSQL server that runs on azure.
Both commands

npx prisma db pull

npx prisma db pull

and

prisma studio

prisma studio

are able to connect and pull the data
but when I am trying to connect during the runtime of the application, i get

PrismaClientInitializationError: Authentication failed against database server at....

PrismaClientInitializationError: Authentication failed against database server at....

I am using a simple DATABASE_URL in a .env file to connect, and here is my db.ts file

import { PrismaClient } from '@prisma/client'

let prisma: PrismaClient
declare global {
  var __db: PrismaClient | undefined
}

if (process.env.NODE_ENV === 'production') {
  prisma = new PrismaClient()
  prisma.$connect()
} else {
  if (!global.__db) {
    global.__db = new PrismaClient()
    global.__db.$connect()
  }
  prisma = global.__db
}

export { prisma }

import { PrismaClient } from '@prisma/client'

let prisma: PrismaClient
declare global {
  var __db: PrismaClient | undefined
}

if (process.env.NODE_ENV === 'production') {
  prisma = new PrismaClient()
  prisma.$connect()
} else {
  if (!global.__db) {
    global.__db = new PrismaClient()
    global.__db.$connect()
  }
  prisma = global.__db
}

export { prisma }

Yeah, I am not sure what causes the issue, but it is odd because the

npx prisma db pull

npx prisma db pull

and

prisma studio

prisma studio

use same connection string

I wonder if anyone else had a similar experience.

Prisma•17mo ago•

3 replies

MSSQL Authentication failed against database server

I was trying to connect to MSSQL server that runs on azure.
Both commands

npx prisma db pull

npx prisma db pull

and

prisma studio

prisma studio

are able to connect and pull the data
but when I am trying to connect during the runtime of the application, i get

PrismaClientInitializationError: Authentication failed against database server at....

PrismaClientInitializationError: Authentication failed against database server at....

I am using a simple DATABASE_URL in a .env file to connect, and here is my db.ts file

import { PrismaClient } from '@prisma/client'

let prisma: PrismaClient
declare global {
  var __db: PrismaClient | undefined
}

if (process.env.NODE_ENV === 'production') {
  prisma = new PrismaClient()
  prisma.$connect()
} else {
  if (!global.__db) {
    global.__db = new PrismaClient()
    global.__db.$connect()
  }
  prisma = global.__db
}

export { prisma }

import { PrismaClient } from '@prisma/client'

let prisma: PrismaClient
declare global {
  var __db: PrismaClient | undefined
}

if (process.env.NODE_ENV === 'production') {
  prisma = new PrismaClient()
  prisma.$connect()
} else {
  if (!global.__db) {
    global.__db = new PrismaClient()
    global.__db.$connect()
  }
  prisma = global.__db
}

export { prisma }

Yeah, I am not sure what causes the issue, but it is odd because the

npx prisma db pull

npx prisma db pull

and

prisma studio

prisma studio

use same connection string

I wonder if anyone else had a similar experience.

MSSQL Authentication failed against database server

Similar Threads

MSSQL Authentication failed against database server

Similar Threads

Similar Threads

Similar Threads