Problem in not solved in sql

Question

1.00/5 (1 vote)

See more:

My target machine sql server is already turn on in Remote connection but the source machine sqlserver is not in remote connection. so i turn on to remote connection and then restore the file to target machine . But the same error is come. Please help me

Thanks in Advance

Posted 13-Dec-11 1:15am

devausha

Add a Solution

Comments

E.F. Nijboer 13-Dec-11 7:18am

Your question is not very clear. Try to explain all the steps you took.

koolprasad2003 13-Dec-11 7:30am

what error you got ? please explain.

[no name] 13-Dec-11 9:29am

So what is the error message?

[no name] 14-Dec-11 0:18am

could you please explain more on your scenario & expectations ?

3 solutions

Solution 2

I am backup my database and restore it to another system. But the database is working and run the project at source machine. But the project didn't run the target machine. The following errors are occured

"The error is Problem occured while establishing Sql server Please check the remote connections."

But the remote Connection is turned on in my target machine. The Source machine in sql server is not in remote connections. so i set the remote connection to on, and then i backup and restore to my target database. But the same error is displayed.

Please help me

Posted 13-Dec-11 1:49am

devausha

Comments

Balakrishnan Dhinakaran 13-Dec-11 7:55am

your question is not so clear...can you please explain your question in tamil..

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

thatraja · Accepted Answer · 2011-12-13T01:47:00

Always give us complete error message in your question whenever possible

From link[^]:
Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.

Check these
Steps to troubleshoot SQL connectivity issues[^]
SQL Server 2005 Connectivity Issue Troubleshoot - Part I[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part II[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part III[^]

BTW check this bunch also for future errors

palraj001 · Accepted Answer · 2011-12-13T02:48:00

Solution 3

try this.

To disable Windows Firewall, follow these steps:

1. Click Start, click Run, type Firewall.cpl, and then click OK.
2. On the General tab, click Off (not recommended).
3. Click OK.

Regards,
Pal

Posted 13-Dec-11 2:48am

palraj001