Page 1 of 1
How do i connect to the MS SQL server using an IP
Posted: Thu 29 Jun 2006 10:24
by Customer
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,
Posted: Thu 29 Jun 2006 12:27
by Jackson
In connection string you should write
Data Source=192.168.0.1
or using property TCustomDAConnection.Server:
MSConnection1.Server := '192.168.0.1'.
Posted: Thu 29 Jun 2006 12:37
by Customer
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.
Posted: Thu 29 Jun 2006 14:02
by Jackson
Please make sure that TCP/IP protocol is enabled for your server instance.
Posted: Thu 29 Jun 2006 14:41
by Customer
Hmmm
Maybe a stupid question.
But where do I setup that?
With kind regards,
Posted: Thu 29 Jun 2006 15:00
by Customer
It is enabled, I've verified it.
Posted: Fri 30 Jun 2006 08:07
by Jackson
Please specify what error message do you get when trying to connect.
Can you establish connection using ADO?