create database in ms sql server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: create database in ms sql server

  1. #1
    Join Date
    Mar 2004
    Location
    malaysia
    Posts
    150

    create database in ms sql server

    I already install all components in ms sql server CD. Once i open the SQL query analyser a small window(connect to sql server) diplayed which wanted me to select a sql server to connect but i do not know how to create it. Anyone can help me to create sql server?

    The combo box is empty so i type the localhost to it.
    Let see the error message.
    http://www.geocities.com/au81070205/sql.JPG

    How to prove that my computer have already created local database?

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Instead of localhost, type "(local)" (without the quotes) or simply a period (.) for the server name.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Mar 2004
    Location
    malaysia
    Posts
    150
    It does not work also maybe i do not have the database in local computer. How to create it? The error message is still the same once i key in "." .

  4. #4
    Join Date
    Nov 2004
    Location
    Huddinge, Sweden
    Posts
    283
    To have the database on your computer, you need to install the server components.
    Then make sure SQL Server is actually running.
    By default, SQL Server installs 6 databases: master, tempdb, model, pubs, msdb and Northwind, so you should be able to connect and run some queries against one of those.
    Then use SQL Enterprise Manager to create your database.

    Rune
    If you hit a brick wall, you didn't jump high enough!

  5. #5
    Join Date
    Mar 2004
    Location
    malaysia
    Posts
    150

    i know why

    I know why already. It is because i just can install the client. When i was installing , a message box came out that mentioned my OS is only can install the client. ****!!!! but how come the MDX sample application can be run? where is the database/instance? . How can i reuse it ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center