how to build a sql database

Question

0.00/5 (No votes)

See more:

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.

Posted 17-Dec-12 0:53am

shalu verma

Updated 17-Dec-12 1:22am

Krunal Rohit

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-12-17T01:11:00

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!

__TR__ · Answer 2 · 2012-12-17T01:18:00

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)[^]

how to build a sql database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0