Click here to Skip to main content
11,639,593 members (60,357 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C#4.0
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
Edited 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
0 Suvendu Shekhar Giri 330
1 Sergey Alexandrovich Kryukov 204
2 CPallini 177
3 F-ES Sitecore 170
4 himanshu agarwal 167
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558

Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 17 Dec 2012
Copyright © CodeProject, 1999-2015
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