pyodbc -> MS-SQL Server Named Instance ?
Adam Tauno Williams
awilliam at whitemice.org
Tue Jul 2 11:00:05 EDT 2019
On Tue, 2019-07-02 at 09:41 -0400, Adam Tauno Williams wrote:
> On Tue, 2019-07-02 at 07:36 +0200, Frank Millman wrote:
> > On 2019-07-01 10:13 PM, Adam Tauno Williams wrote:
> > > I am trying to connect to a Named Instance on an MS-SQL server
> > > using pyODBC.
It appears that the instance location service doesn't work. Digging
out the instance->power assignment I can change the error message and
create an authentication failed even in the Event Log!
It is sorta progress. :(
>>> db = pyodbc.connect(
... driver='ODBC Driver 13 for SQL Server',
... server=r'sql.example.com,51994',
... database='dbname',
... user='*******',
... password='*******', )
Traceback (most recent call last):
File "<stdin>", line 6, in <module>
pyodbc.Error: ('28000', "[28000] [Microsoft][ODBC Driver 13 for SQL
Server][SQL Server]Login failed for user '*******'. (18456)
(SQLDriverConnect)")
--
Highland Park Neighborhood Association
Adam Tauno Williams, Board Chair
Grand Rapids, MI.
More information about the Python-list
mailing list