连接到SQL SERVER 2012 [英] Connecting to SQL SERVER 2012
问题描述
我即将放弃。在过去的3周里，我一直在努力将SQL SERVER 2012安装到运行Windows 7的LONOVO笔记本电脑上。我有一个C＃程序我正在使用SQL数据库开发（我不能丢失已经存在的数据）。我已经下载了SQL SERVER和相关软件大约3次（每次下载3小时），每次最后我都无法连接到我的数据库，收到大量错误消息，大部分是指错误26,40,53和50我知道在Googling上有大约1000个引用此问题的各种错误消息。我试图应用其中许多没有成功，而其他许多不适用于我的情况或我的配置（Windows 7，尝试使用C＃访问本地计算机上的数据库）。
不幸的是，由于某种原因，我试图从在这台机器上运行良好的SQL SERVER 2008 R1升级。以下是我收到的典型错误消息：
建立与SQL Server的连接时发生网络相关或特定于实例的错误。服务器找不到或无法访问。验证实例名称是否正确以及SQL Server是否配置为允许远程连接。（提供程序：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）（Microsoft SQL Server） ，错误：53）
附加信息：
网络相关或特定于实例的错误在建立与SQL Server的连接时发生。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供程序：SQL网络接口，错误：26 - 查找指定的服务器/实例时出错）（Microsoft SQL Server，错误：-1）
是的，我已经制作确定MSSQLSERVER正在运行
没有SQLBROWSER没有运行，当我尝试启动它时，我收到消息：
此操作无法完成。访问被拒绝
是的我试图连接防火墙已禁用（相同的错误消息）
我无法手动检查端口1433是否被阻止，因为我不确定怎么做。
这只代表了我尝试过的一小部分事情。
问题：
1）有关我可能在我的系统上尝试的步骤的任何建议，看看我是否可以使用C＃连接到SQL SERVER 2012？
2）最好只是放弃，回到SQL SERVER 2008 R1，尝试让它工作并忘记SQL Server 2012？
3）关于如何获取数据的任何其他建议？
I'm about to give up. I've been working on getting SQL SERVER 2012 onto my LONOVO Laptop running Windows 7 for the past 3 weeks. I have a C# program I'm developing using the SQL database (I can't afford to lose the data that is already present). I've downloaded SQL SERVER and associated software about 3 times (3 hours per download) and each time in the end I am unable to connect to my database receiving an assortment of error messages most referring to errors 26, 40, 53, and 50. I know there are about 1000 references to this problem upon Googling for the various error messages. I have attempted to apply a good number of them without success and many others don't apply to my situation or my configuration (Windows 7, attempting to access the database on my local machine with C#).
It's unfortunate that for some reason or other I attempted to upgrade from SQL SERVER 2008 R1 that worked perfectly on this machine. The following are a typical selection of error messages I have received:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)"
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
Yes, I've made sure MSSQLSERVER is running
NO SQLBROWSER is not running and when I attempt to start it I get the message:
"This operation could not be completed. Access Denied"
Yes I have attempted to connect with the firewall disabled (same error messages)
I have not been able to manually check whether or not Port 1433 is blocked because I'm not sure how to do this.
This represents just a small number of the things I have attempted.
Question:
1) Any advice on steps I might try on my system to see if I can connect to SQL SERVER 2012 with C#?
2) Is it best to just give up, go back to SQL SERVER 2008 R1, try to get it working and forget about SQL Server 2012?
3) Any other suggestions on how to get my data back?
推荐答案
阅读以下内容：
了解SQL Server配置管理器 [ ^ ]
如何：在SQL Server配置管理器（SQL Server Express）中启用网络访问 [ ^ ]
Read the following :
Understanding SQL Server Configuration Manager[^]
How to: Enable Network Access in SQL Server Configuration Manager (SQL Server Express)[^]
这篇关于连接到SQL SERVER 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
