Manage to fix it. The issue was at the server side, i change the TCP/IP port to the right port 1433 from the sql server configuration manager then it pickup.
cheers, On Wed, Jan 31, 2018 at 9:57 AM, sum abiut <suab...@gmail.com> wrote: > Thanks, i will check that out. > > > On Wed, Jan 31, 2018 at 1:12 AM, Mike Bayer <mike...@zzzcomputing.com> > wrote: > >> On Tue, Jan 30, 2018 at 12:52 AM, sum abiut <suab...@gmail.com> wrote: >> > Hi, >> > i am trying to connect to an express server 2008 using pymssql >> following the >> > direction from >> > http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#mod >> ule-sqlalchemy.dialects.mssql.pymssql >> > >> > but i am getting the following error: >> > >> > sqlalchemy.exc.OperationalError: (pymssql.OperationalError) (20009, >> 'DB-Lib >> > error message 20009, severity 9:\nUnable to connect: Adaptive Server is >> > unavailable or does not exist (10.0.11.50 :1433)\nNet-Lib error during >> > Connection timed out (110)\n') >> > >> > appreciate any assistances. >> >> get a successful connection using tsql first: >> >> http://www.freetds.org/userguide/confirminstall.htm >> >> >> then if you can show the exact connection parameters for tsql which >> are known to work we can translate them for pymssql. >> >> >> >> > >> > cheers, >> > Sum >> > >> > -- >> > SQLAlchemy - >> > The Python SQL Toolkit and Object Relational Mapper >> > >> > http://www.sqlalchemy.org/ >> > >> > To post example code, please provide an MCVE: Minimal, Complete, and >> > Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> > description. >> > --- >> > You received this message because you are subscribed to the Google >> Groups >> > "sqlalchemy" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an >> > email to sqlalchemy+unsubscr...@googlegroups.com. >> > To post to this group, send email to sqlalchemy@googlegroups.com. >> > Visit this group at https://groups.google.com/group/sqlalchemy. >> > For more options, visit https://groups.google.com/d/optout. >> >> -- >> SQLAlchemy - >> The Python SQL Toolkit and Object Relational Mapper >> >> http://www.sqlalchemy.org/ >> >> To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> --- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at https://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.