如何构建一个sql数据库
尊敬的先生,
ima初学者在asp.net.i想知道如何配置Microsoft SQL Server 2008 R2.i在asp.net应用程序中使用c#命名为database1.mdf如何在sql server 2008 R2中使用它。当我启动microsoft sql server 2008 R2时会显示三个字段:
1.server type
2.server name
3.authentication。
我应该填写所有这些字段。
请帮助我。对我来说非常紧急罢工>。
或
你可以给我整个描述如何制作一个sql数据库。
respected sir,
i m a beginner in asp.net.i want to know how to configure a Microsoft SQL Server 2008 R2.i have a database named as database1.mdf in asp.net application using c# ,how this can be used in sql server 2008 R2.When I start microsoft sql server 2008 R2 three fields are shown :
1.server type
2.server name
3.authentication.
what should i fill in all these fields.
please help me.its very urgent to me.
or
you can give me whole description how to make a sql database.
我们无法回答 - 我们无法访问你的系统。
什么您正在查看的是登录屏幕 - 它建立了访问任何特定数据库的权限。
首先,为服务器类型选择数据库引擎。
然后,使用下拉选择服务器 - hopef ully会有一个列表。
然后你可以使用配置SQL服务器安装时选择的凭据。
你需要在你尝试附加数据库之前将其全部排除!
We can''t answer that - we do not have access to your system.
What you are looking at is the login screen - which establishes your rights to access any particular database.
First, select "Database engine" for the Server Type.
Then, use the drop down to select a server - hopefully there will be a list.
Then you can use the credentials you selected when you configured your SQL server installation.
You need to sort that all out before you even try to attach a database!
请参阅以下链接,了解如何连接到SQL服务器
如何使用SQL Server Management Studio连接到SQL Server 2008 [ ^ ]
以下链接显示如何在数据库中附加mdf文件
如何在SQL Server中附加数据库 [ ^ ]
在数据库中附加没有ldf文件的mdf文件 [ ^ ]
附加数据库 [ ^ ]
创建新的数据库参考
创建数据库(Transact-SQL) [ ^ ]
Refer the below link for instructions on how to connect to SQL server
How to connect to SQL Server 2008 using SQL Server Management Studio[^]
The below links show how to attach a mdf file in database
How to Attach a Database in SQL Server[^]
Attach mdf file without ldf file in Database[^]
Attach a Database[^]
To create a new database refer
CREATE DATABASE (Transact-SQL)[^]