Hi, I am still a new in C# and visual Studio. I now wants to create a database in visual studio, after i click file in visual studio, as step below :

1)file>> new >> project
2) Other Project types >> Database

Is that my steps correct? Where to find my server name?

First of all you have to create or open a project. Select Project menu + Add New Item + choose Service-based Database. Once you add database in your project you may retrieve server name via Server Explorer (View menu + Server Explorer)

I had tried but it generates an error like " Generate user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
How come like that ? Is that i missing some steps?

When i choose local database , it can be added. Is it possible if i choose that database ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.