How To Create a database in SQL 2005

biggiesmallzz
biggiesmallzz used Ask the Experts™
on
I have just installed SQL2005 Standard upon a Win2K3 server and would like to know how to go about creating a database to use. Also during the installation, i was not prompted to create or setup a sa user account or password. Why is this?

Upon opening the Management Studio, i get a Connect to Server window with three fields, Server Type, Server Name & Authentication. Upon browsing for Local Servers, that field is empty. Can however browse to other instances of SQL 2000.

As you can see, i am new to SQL 2005 having previously only used and worked with SQL2000.

Regards

Big
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
you have to enter the Servername you have to enter the instance name (if you have multiple instances you must enter them in thid format ServerName\InstanceName
Jorge PaulinoIT Pro/Developer
Top Expert 2008

Commented:
You can also look into SQL Server 2005 Books Online, for more information about it
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en 
 

Author

Commented:
Guys,

In Object Explorer, there is no instance of the SQL Server Database Engine to expand.
Please also review the screen shots.
Not sure whether this is relevant, but i had a lot of difficulty installing the SQL Server Management Studio.


sql-1.bmp
sql2.bmp
sql3.bmp

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial