--------------------------------------------------------------------------
MSSQLDatabaseException Traceback (most recent call last)
File src\pymssql\_pymssql.pyx:646, in pymssql._pymssql.connect()
File src\pymssql\_mssql.pyx:2108, in pymssql._mssql.connect()
File src\pymssql\_mssql.pyx:700, in pymssql._mssql.MSSQLConnection.__init__()
File src\pymssql\_mssql.pyx:1817, in pymssql._mssql.maybe_raise_MSSQLDatabaseException()
File src\pymssql\_mssql.pyx:1834, in pymssql._mssql.raise_MSSQLDatabaseException()
MSSQLDatabaseException: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-LGUPBTK)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-LGUPBTK)\n')
During handling of the above exception, another exception occurred:
OperationalError Traceback (most recent call last)
Cell In[27], line 7
5 from matplotlib import pylab as plt
6 import pymssql
----> 7 conn = pymssql.connect(server=r"DESKTOP-LGUPBTK\MSSQLSERVER01", user="user", password="12345678", database="test")
9 conn = pymssql.connection
10 l1 = 5
File src\pymssql\_pymssql.pyx:652, in pymssql._pymssql.connect()
OperationalError: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-LGUPBTK)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-LGUPBTK)\n')
이러한 오류가 발생합니다.
https://jowild77.tistory.com/41
그리고 db연결필수요소인 ip랑 포트를 명시안했네