Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (10.35.1.11:1433)\n')

[chchiu]

Hello,

I am trying connect ms sql server 2008 R2 , and the  two clients are win7 and win10, running python 3.5.2 and pymssql-2.1.3-cp35-cp35m-win32 installed.

>>> conn = _mssql.connect(server='10.35.1.11', user='test', password='test123', database='testdb')

Traceback (most recent call last):

  File "<pyshell#0>", line 1, in <module>

    conn = _mssql.connect(server='10.35.1.11', user='test', password='test123', database='testdb')

  File "_mssql.pyx", line 1902, in _mssql.connect (_mssql.c:21821)

  File "_mssql.pyx", line 637, in _mssql.MSSQLConnection.__init__ (_mssql.c:6581)

  File "_mssql.pyx", line 1630, in _mssql.maybe_raise_MSSQLDatabaseException (_mssql.c:17524)

_mssql.MSSQLDatabaseException: (18456, b'DB-Lib error message 20018, severity 11:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (10.35.1.11:1433)\n')

why? help!

[Ramiro Morales]

Read and follow:

http://pymssql.org/en/latest/faq.html#cannot-connect-to-sql-server

--

Ramiro Morales
@ramiromorales

[chchiu]

Still can't work, 

freeTDS doesn't need to be installed in Windows7， right？

Do i miss something in pymssql ？

Ramiro Morales於 2016年8月10日星期三 UTC+8上午5時12分47秒寫道：

[Ramiro Morales]

On Wed, Aug 10, 2016 at 12:10 AM, chchiu <chchi...@gmail.com> wrote:

Still can't work, 

freeTDS doesn't need to be installed in Windows7， right？

Do i miss something in pymssql ？

No, you don''t miss anything.

But please help us to help you.

Give us more details about what you've actually read and tried of. We can't guess.

Have you read the sections:

• By default SQL Server 2005 and newer don’t accept remote connections, you have to use SQL Server Surface Area Configuration and/or SQL Server Configuration Manager to enable specific protocols and network adapters; don’t forget to restart SQL Server after making these changes,

• If SQL Server is on a remote machine, check whether connections are not blocked by any intermediate firewall device, firewall software, antivirus software, or other security facility,

?

Have you tested basic network and TCP connectivity with SQL Server? Does a telnet to port 1433 from the sme client system to the same server work? Do other SQL server clients work?, etc.,

--

You received this message because you are subscribed to the Google Groups "pymssql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pymssql+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ramiro Morales
@ramiromorales

[chchiu]

Hi,

I'd configured the sql server about allow remote connection to this server and set the TCP/IP enabled , TCP port is 1433 in  the TCP/IP property

restarted the sql server

same client telent the sql server using 1433 is ok 

the ESET file security was installed on the sql server. maybe it's the cause but i have no idea to fix it.

Now I use the pypyodbc by DSN connect to sql server, but i still want to use pymssql.

Thanks.

Ramiro Morales於 2016年8月10日星期三 UTC+8下午4時43分05秒寫道：

To unsubscribe from this group and stop receiving emails from it, send an email to pymssql+u...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Ramiro Morales
@ramiromorales