hi expert Connection failed: SQLState: '01000'

[Former Member]

hi

i am getting error while conneting server with client.

error :

Microsoft SQL Server Login

Connection failed: SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).

Connection failed:

SQLState: u201808001u2019

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.

plz help me

Rajkumar

[Former Member · Accepted solution]

Hi Rajkumar,

This seems like it might be an SQL server error related to TCP/IP Sockets. There are a couple of articles on the Microsfot knowledge base that might be useful to you:

[BUG: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol|http://support.microsoft.com/kb/306865]

Or

[PRB: ODBC Connection Failed: SQLState: '08001' DBMSSOCN|http://support.microsoft.com/kb/195566]

There are other related articles there too, if you search using the error messages you posted above.

Are you seeing these errors while connecting the DI, Business One or with an ODBC connection?

Regards,

Niall

SAP Business One Forums

[Former Member · Accepted solution]

thanks for reply

actually i install the client at other pc and from thier i trying to connect server where i already install sap b1 server.

i tried what u given link.

Awaiting soon reply

Rajkumar Gupta