search

coderacheal / database-connection-config

This repo contains a notebook to help you set up a connection to a remote Microsoft SQL Server
0 stars 6 forks source link

Connection error line 4 #1

Closed CalyGit closed 1 year ago

CalyGit commented 1 year ago

InterfaceError: ('28000', "[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'dapDB'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'dapDB'. (18456)")

coderacheal commented 1 year ago

Hello @CalyGit please make sure that you have installed pyodbc and your internet connect is good to retrieve the data from the remote server

coderacheal commented 1 year ago

@CalyGit it seems you set the user as dapDB. The user is dataAnalyst_LP2 and dapDB is the database not the user. Please check this in your code

CalyGit commented 1 year ago

@CalyGit it seems you set the user as dapDB. The user is dataAnalyst_LP2 and dapDB is the database not the user. Please check this in your code

This is it. Thanks @coderacheal