| View previous topic :: View next topic |
| Author |
Message |
Guest
|
 Posted: Wed May 09, 2007 8:11 am Post subject: Connecting SQL Server using IP address |
 |
|
Hi,
I am using BDS 2006 and MS SQL. I would like to connect SQL using IP
address
of SQL Server. But ADO Connection gives permition to enter only
Server Name.
Is there a way of using IP address ?
Thanks
Mucahit |
|
| Back to top |
|
 |
Oliver Townshend
Guest
|
| Posted: Wed May 09, 2007 1:41 pm Post subject: Re: Connecting SQL Server using IP address |
|
|
| Quote: | I am using BDS 2006 and MS SQL. I would like to connect SQL using IP
address
of SQL Server. But ADO Connection gives permition to enter only
Server Name.
Is there a way of using IP address ?
|
IP addresses should work fine. I suspect you have a connectivity problem.
Are you able to connect using Query Analyzer or Management Studio?
Oliver Townshend |
|
| Back to top |
|
|
Guest
|
| Posted: Thu May 10, 2007 8:11 am Post subject: Re: Connecting SQL Server using IP address |
|
|
On May 9, 11:41 am, "Oliver Townshend" <oliveratcodelegaldotcomdotau>
wrote:
| Quote: | I am using BDS 2006 and MS SQL. I would like to connect SQL using IP
address
of SQL Server. But ADO Connection gives permition to enter only
Server Name.
Is there a way of using IP address ?
IP addresses should work fine. I suspect you have a connectivity problem.
Are you able to connect using Query Analyzer or Management Studio?
Oliver Townshend
|
On the SQL server, query analyzer works fine if I give server name.
But when I enter
IP address of the server, it can not connect. On the client side
query analyzer never
works. |
|
| Back to top |
|
|
Reader
Guest
|
| Posted: Wed May 16, 2007 11:04 pm Post subject: Re: Connecting SQL Server using IP address |
|
|
mcelikag (AT) ebim (DOT) net wrote:
| Quote: | But ADO Connection gives permition to enter only
Server Name.
Is there a way of using IP address ?
|
Have you tried typing that IP address against the Server Name? |
|
| Back to top |
|
|
Rob Uttley
Guest
|
| Posted: Tue May 22, 2007 7:28 am Post subject: Re: Connecting SQL Server using IP address |
|
|
In article <1179816031.231155.11700 (AT) p47g2000hsd (DOT) googlegroups.com>,
mcelikag (AT) ebim (DOT) net (celik) wrote:
| Quote: | I entered IP address against the Server Name but it gives an error.
Can not connect.
|
Do you know for sure that the server is listening to IP traffic? By
default, SQL Express now comes with the TCP/IP listener switched off - you
have to go into the (curiously named) Surface Area Configuration tool to
switch this function on.
If you're connecting to 'proper' SQL Server, this will probably already be
on. So you might want to check that you are not having some kind of
firewall issue. Can you connect to the SQL Server via TCP from the server
itself, via the loopback address (127.0.0.1)?
Try posting the connection string you're using, so we can have a look at
that.
Cheers!
Rob
--
Robsoft Systems Ltd, Chester, UK
rob (AT) robsoft (DOT) co.uk http://www.robsoft.co.uk |
|
| Back to top |
|
|
celik
Guest
|
| Posted: Tue May 22, 2007 8:11 am Post subject: Re: Connecting SQL Server using IP address |
|
|
On 16 Mayıs, 21:04, Reader <Rea...@NoMail.com> wrote:
| Quote: | mceli...@ebim.net wrote:
But ADO Connection gives permition to enter only
Server Name.
Is there a way of using IP address ?
Have you tried typing that IP address against the Server Name?
|
I entered IP address against the Server Name but it gives an error.
Can not connect. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
