Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
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
Edited 17-Dec-12 1:22am
v2
Rate this: bad
good
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!
  Permalink  
Rate this: bad
good
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
CREATE DATABASE (Transact-SQL)[^]
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 499
1 Nirav Prabtani 338
2 OriginalGriff 175
3 _Amy 165
4 Abhinav S 160
0 OriginalGriff 7,715
1 Sergey Alexandrovich Kryukov 6,911
2 Maciej Los 3,954
3 Peter Leow 3,698
4 CHill60 2,742


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 17 Dec 2012
Copyright © CodeProject, 1999-2014
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