• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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?
newdb.JPG
error.JPG
0
nicedone
Asked:
nicedone
  • 3
  • 3
1 Solution
 
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...
0
 
Aaron ShiloChief Database ArchitectCommented:
hi

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.

Aaron.
0
 
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?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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.

then in ssms enter ./INSTANCENAME OR MACHINENAME/INSTANCENAME.
0
 
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?
sql.JPG
0
 
Aaron ShiloChief Database ArchitectCommented:
ok you have sql server express installed

just use :    .\sqlexpress
0
 
nicedoneAuthor Commented:
thnk you
0
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now