Click here to Skip to main content
13,559,022 members
Rate this:
Please Sign up or sign in to vote.
See more:
respected sir,
i m a beginner in want to know how to configure a Microsoft SQL Server 2008 R2.i have a database named as database1.mdf in 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
what should i fill in all these fields.
please help me.its very urgent to me.


you can give me whole description how to make a sql database.
Posted 17-Dec-12 0:53am
Updated 17-Dec-12 1:22am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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!
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.180515.1 | Last Updated 17 Dec 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100