Connecting to remote SQl server using IP address

Question

2.00/5 (2 votes)

See more:

SQL-Server-2005

, +

Hi all ,I dont have so much experience in SQL server. I'm trying to connect to an SQL Server 2005 via IP address.My connection string is

"Data Source=117.213.4.155,1433;Network Library=DBMSSOCN;Initial Catalog=PostDB;User ID=;Password=")

I'm getting this error.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

I have enabled TCP/IP connection using Surface Configuration tool and I dont have a firewall now.

So how can I solve this? And please give me some advice and insights about storing and retrieving data in remote SQL server. I have no other way to clarify this issue.
Thank you in advance.

Posted 14-May-12 22:13pm

Member 8567943

Add a Solution

Comments

ahsanriaz1K 15-May-12 3:15am

Are you using Management studio for MS SQL server at server side?

Member 8567943 15-May-12 3:16am

Yes I am

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-05-15T00:38:00

Solution 1

This error means, the server you are trying to connect is found, but for some reason denying the client access. Client is trying to connect through an invalid port or it does not allow remote connections or a firewall issue.

Look here for full detailed explanation here:
Error message: TCP Provider.. - Cause & Resolution[^]
MSDN Blog: (provider: TCP Provider, error: 0 - No connection..[^]

If needed, troubleshoot more following this: MSDN Blog: TCP Provider: No connection could be made because..[^]

Posted 15-May-12 0:38am

Sandeep Mewara

Comments

Member 8567943 15-May-12 5:40am

Can I ask a doubt? If I enter my current machine's IP address on the Data Source section, is it similar to entering 'localhost'?

Sandeep Mewara 15-May-12 11:53am

Yes, it should be same thing.

Member 8567943 16-May-12 8:59am

But when I enter localhost it works, when I enter ip it doesnt.

Sandeep Mewara 16-May-12 12:30pm

It depends. I guess, you need a static IP for it. Generally, we have dynamic IP's.

Member 8567943 16-May-12 13:05pm

So you are saying it only works on static ips?

Sandeep Mewara 16-May-12 13:33pm

That's my guess not 100% sure.

Tim Corey 9-Jun-12 22:18pm

You can connect to SQL even if it is on a machine with a dynamic IP. As for localhost being the same as your machine's IP address, the answer is generally yes but not always so. You can enable traffic to localhost but not to the public IP address of the machine, for example.

Sandeep Mewara 10-Jun-12 2:19am

Thanks Tim. Good to know.

devsuja · Answer 2 · 2012-06-08T21:44:00

Solution 3

hi,

pls chk ur sql configuration manager . see, whether tcp/ip is enabled, what port is used. kindly restart ur sql after checking all these details.

Posted 8-Jun-12 21:44pm

devsuja

Reegan Durai.m · Answer 3 · 2012-05-15T03:13:00

Solution 2

see to http://www.codeproject.com/Articles/382261/Database-Backup-and-Restore

Posted 15-May-12 3:13am

Reegan Durai.m

Connecting to remote SQl server using IP address

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

Connecting to remote SQl server using IP address

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us