在SQL中没有解决的问题 [英] Problem in not solved in sql

问题描述

我的目标计算机sql服务器已经在远程连接中打开，但是源计算机sqlserver不在远程连接中.所以我打开了远程连接，然后将文件还原到目标计算机.但是，同样的错误来了.请帮帮我

在Advance中致谢

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

推荐答案

在可能的情况下始终向我们提供完整的错误消息

Always give us complete error message in your question whenever possible

基本上，当您无法连接到SQL Server时，问题可能是:
1)网络问题，
2)SQL Server配置问题.
3)防火墙问题，
4)客户端驱动程序问题，
5)应用程序配置问题.
6)身份验证和登录问题.

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.

检查这些
解决SQL连接问题的步骤 [ ^ ]
SQL Server 2005连接性问题疑难解答-第一部分 [对SQL Server 2005中的连接问题进行故障排除-第二部分 [ ^ ]
对SQL Server 2005中的连接问题进行故障排除-第III部分 [ ^ ]

顺便说一句，也检查这堆是否有将来的错误

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

尝试一下.

若要禁用Windows防火墙，请按照下列步骤操作:

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.

问候，
Pal

Regards,
Pal

我正在备份数据库并将其还原到另一个系统.但是数据库正在运行，并在源计算机上运行项目.但是该项目没有运行目标计算机.发生以下错误

错误是建立Sql服务器时出现问题，请检查远程连接."

但是在我的目标计算机上打开了远程连接. sql server中的源计算机不在远程连接中.所以我将远程连接设置为开，然后备份并还原到目标数据库.但是会显示相同的错误.

请帮助我

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

这篇关于在SQL中没有解决的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！