How do i connect to the MS SQL server using an IP

Customer · Post by **Customer** » Thu 29 Jun 2006 10:24

Hello,

I want to connect to my MS SQL using the IP.

But how do I do that. What parameters do i have to enter in the Connectionstring.

Hoping on a fast reply.

With kind ragards,

Jackson · Post by **Jackson** » Thu 29 Jun 2006 12:27

In connection string you should write
Data Source=192.168.0.1
or using property TCustomDAConnection.Server:
MSConnection1.Server := '192.168.0.1'.

Customer · Post by **Customer** » Thu 29 Jun 2006 12:37

Well

I'm using Delphi 7.

But if i fill in the IP (192.168.1.4) I can't connect to it. Always getting an error. But in the dropdownbox I see the name of the server.

This is my problem.

Jackson · Post by **Jackson** » Thu 29 Jun 2006 14:02

Please make sure that TCP/IP protocol is enabled for your server instance.

Customer · Post by **Customer** » Thu 29 Jun 2006 14:41

Hmmm

Maybe a stupid question.

But where do I setup that?

With kind regards,

Customer · Post by **Customer** » Thu 29 Jun 2006 15:00

It is enabled, I've verified it.

Jackson · Post by **Jackson** » Fri 30 Jun 2006 08:07

Please specify what error message do you get when trying to connect.
Can you establish connection using ADO?