SQL Server 2005 设置问题
我有两个问题都与（我相信）我的 SQL Server 设置有关。 我已经在我的 Vista 64 Home Premium 盒子上从 MSDN 下载的 x64 版本安装了 SQL Server（完整的东西）。 在遇到多个问题后，我终于让它工作了。 这是一个新的盒子，所以我移植了一个需要从另一台服务器处理的数据库。 这也很好用。 然而，当我尝试在 SQL Server Management Studio 中打开数据库时，我的第一个问题出现了：
“无法找到请求的 .Net Framework 数据提供程序。它可能未安装。(System.Data)”
该框本身不是新的，而且肯定已经安装了.NET（我相信是版本3）。 我发现有人将此作为错误发布，但由于团队（SQL Server 团队）无法重现它，因此他们将其删除。 我尝试安装推荐的SP3补丁，但没有成功。 仅当我尝试打开表格来查看数据时（右键单击并“打开表格”）。 我什至可以执行查询并检索结果（从管理工作室内部）。 我会遵循几乎任何建议来尝试使其正常工作。
我的第二个问题是我无法连接到服务器。 我以为我可以解决它（通过查询），但我没有发现它在盒子上添加了任何 ODBC 连接，只是添加了驱动程序。 Management Studio 可以很好地访问数据库，但机器本身似乎无法识别其上正在运行的任何内容，至少在默认端口（1433）上是这样，不，我没有命名实例。 当尝试手动将服务器添加到 DSN 或任何数据源时，它找不到 SQL 服务器（在“控制面板”>“管理工具”>“数据源 (ODBC)”下）。在 SQL Server Management Studio 下，它显示为已注册的数据库服务器（我认为这是因为它连接在端口 1434 上，据我所知，这是我的主要问题，即使我无法打开表（第一个问题），我也绝对需要能够对其进行设置，以便我可以连接到它。我连接的语言源是 ColdFusion，它设置为独立服务器（未安装 IIS，现在不使用它）。
I have two issues both related to (I believe) my SQL Server setup. I have installed SQL Server (the full thing) from MSDN downloads of the x64 version on my Vista 64 Home Premium box. After running into multiple issues I finally got it working. This is a new box so I ported over a database that I need to work on from another server. That also worked fine. My first issue however came when I tried to open a database in SQL Server Management Studio:
"Unable to find the requested .Net Framework Data Provider. It may not be installed. (System.Data)"
The box itself isn't new and definitely has .NET installed (version 3 I believe). I found that someone posted this as a bug but as the team (SQL Server team) could not reproduce it, they removed it. I've tried installing the recommended SP3 patch to no avail. It's only when I try to open a table for viewing the data (right-click and "Open Table"). I can even execute queries and retrieve results (from inside management studio). I'll follow pretty much any suggestion to try and get this working.
My second issue is that I cannot connect to the server. I thought I could just work around it (with queries), but I did not find that it added any ODBC connections on the box, just the drivers. Management Studio can access the DB just fine, but the machine itself doesn't appear to recognize that anything is running on it, at least on the default port (1433) and no, I do not have a named instance. When trying to manually add the server to the DSN or any datasources it cannot find the SQL server (under Control Panel > Administrative Tools > Data Sources (ODBC). Under SQL Server Management Studio it appears as a registered database server (I think this is because it connects on port 1434 from what I hear? not sure). This is my primary problem, and even if I can't open the tables (the first issue) I absolutely NEED to be able to set it up so that I can connect to it. The language source I am connecting from is ColdFusion which is set up as a stand-alone server (IIS not installed, not using it right now).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
至于连接到它，请确保所有服务都在运行。 特别是 SQL Server 代理。
另外，检查 SQL Server 2005 Surface Area 的服务和连接配置。 检查“远程连接”下的“本地和远程”连接是否打开。 它可能被设置为“仅限本地”。
As for connecting to it, make sure all the services are running. SQL Server Agent in particular.
Also, check in the SQL Server 2005 Surface Area configuration for Services and Connections. Check under "Remote Connections" to see if "local and remote" connections are on. It might be set to "local only".
CF 版本 6+ 不使用操作系统的 ODBC 连接。 他们使用 JDBC over IP 进行连接。 您需要确保已允许使用 SQL Server Configuration Studio 与数据库建立 TCP/IP 连接。 然后，使用 CF 管理员页面中的数据源页面（通常为 localhost:port/cfide/administrator，将“port”替换为您用于 CF 内置服务器的端口）。
CF versions 6+ do not use the OS's ODBC connections. They use JDBC over IP to connect. You need to make sure you have allowed TCP/IP connections to the DB using the SQL Server Configuration Studio. Then, use the Data Sources page in the CF Administrator page (usually localhost:port/cfide/administrator, replacing "port" with the port you're using for the CF built-in server).
SQL Server 2005 默认情况下是为了更加安全，因此并非所有协议都默认开放。
也许您正在考虑带有命名实例的 SQL 浏览器。
你尝试过这个过程吗？
http://oakleafblog.blogspot.com/ 2007/03/orcas-march-ctp-on-vista-database.html
SQL Server 2005 is meant to be more secure by default, so not all the protocols are opened up by default.
Maybe you're thinking of the SQL Browser with named instances.
Did you try this process?
http://oakleafblog.blogspot.com/2007/03/orcas-march-ctp-on-vista-database.html