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.
How to prove that my computer have already created local database?
Instead of localhost, type "(local)" (without the quotes) or simply a period (.) for the server name.
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
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 "." .
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.
If you hit a brick wall, you didn't jump high enough!
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 ?
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center