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.