仅安装了 SQL Server 配置工具。有什么问题吗?
我在系统上安装了 SQL Server 2005 Express 版本。我使用的是 Windows 7(64 位)操作系统。
安装的时候说兼容性问题。不过,它已经安装并显示安装成功。但是,只安装了配置工具。
另外,如何创建数据库或如何使用它。
谢谢 维奈查鲁鲁
I installed SQL Server 2005 Express edition on my system. I am using Windows 7 (64 Bit) OS.
While installing it said compatibility issues. Though, it got installed and showed successfully installed. But, only the configuration tools were installed.
Also, how to create a database or how can I use it.
Thanks
Vinaychalluru
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
Windows 7 上的 SQL Server 2005 确实存在兼容性问题。我相信这些问题已在通过 Windows Update 提供的服务包中得到解决。
关于问题的第二部分,SQL Server 2005 不附带任何图形管理工具,但是您可以下载 SQL Server Management Studio Express,来自 Microsoft 免费。
SQL Server 提供了一个命令行环境,允许您连接到服务器并执行 SQL 语句。
要连接到 SQL Server Express Edition 实例,假设使用了默认实例名称,您可以在命令提示符下键入以下内容
sqlcmd -S .\SQLEXPRESS
如果成功,您将看到 SQLCMD 提示符,如下所示就像
1)
从那里您可以执行任何有效的 SQL 语句,包括将创建数据库的这条 SQL 语句
CREATE DATABASE YourDatabaseName;
为了使该语句生效,您还需要发出
GO
cimmandThere are indeed compatibility issues with SQL Server 2005 on Windows 7. I believe that these were addressed in a service pack which is available through Windows Update.
With respect to the second part of your question, SQL Server 2005 does not ship with any graphical management tools, you can however download SQL Server Management Studio Express free from Microsoft.
A command-line environement is provided with SQL Server that will allow you to connect to the server and execute SQL statements.
To connect to SQL Server Express Edition instances, assuming the default instance name was used, you can type the following at a command prompt
sqlcmd -S .\SQLEXPRESS
If ths succeeds you will see the SQLCMD prompt which looks like
1)
From there you can execute any valid SQL statement, including this one which will create a database
CREATE DATABASE YourDatabaseName;
For the statement to have an effect,you also need to issue the
GO
cimmand