I want to create a sql database in visual studio by selecting the Data Connections(right click) then Create New Sql Server Database but Nothing comes up in the server field how can i create database?

I want to create a new sql database but unfortunately i could not create it because it asks me to choose server and then choose if windows or sql authentication then it asks me a name for the database, but since server comes empty and altough i tried computer name or the ip address i gave me the error in the second attachment ,how can i create one sql database?
Who is Participating?
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
ok you have sql server express installed

just use :    .\sqlexpress
lcohanDatabase AnalystCommented:
"but since server comes empty"...

Do you have access to ANY SQL Server or did you installed SQL 2008 Developer Edition (for instance - it's for free)?

",how can i create one sql database?"

Only after you have access to a SQL Server then you can connect to a it and create a database...
Aaron ShiloChief Database ArchitectCommented:

if the sql server is installed localy just enter "LOCALHOST" or "." or "MACHINENAME"
use windows authentication.

if the server is remotly installed ask the admin to grant you a user/password and instance address so you can connect and create a new database.

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

nicedoneAuthor Commented:
Hi, it is local but i enter localhost or the machine name (tried both) and i give it a name but i still get the error in the second picture?
Aaron ShiloChief Database ArchitectCommented:
ok so it seems you have maybe a NAMED INSTANCE.

got to "start->programs->mssql server->configuration tools->sql server configuration manager " and under services sql server(INSTANCENAME) you instance name should appear in the brackets.

nicedoneAuthor Commented:
Hi unfortunately i dont see an instance name in configuration manager and i dont know how to add that , i posted the screen when i open sql server conf. manager when services selected any recommendation that i should do?
nicedoneAuthor Commented:
thnk you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.