question

pbalendra avatar image
pbalendra asked

i am getting this error when i try to make a connection using php code to a remote ms sql database

the error is SQLSTATE: 08001 code: 53 message: [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. if some can help please.
ms sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

GoranJ avatar image
GoranJ answered
Hi, it could be firewall issue or your SQL server configuration (ie. SQL server does not accept Named Piepes Protocol, or you have wrong connection string...). I use TCP/IP protocol to access SQL server.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

emil87b avatar image
emil87b answered
Hi, Go to start -> SQL Server ... -> configuration tools -> sql server configuration manager make sure you have correct network protocols enabled
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.