todd.ayers (5/2/2013)
How would I connect to those db that are created?
Well technically you don't connect to a database, you connect to an instance of SQL Server. Then from that connection you can use any database that you have access to.
Assuming you have no other instances on your machine, and it is on your machine you just connect to the server. In the server name you would put (local) including the parenthesis.
Then depending on how you setup authentication you will either use windows Authentication or SQL Server Authentication. Then you will have Master, Model, msdb, tempdb. If you installed Reporting Services you will have a couple of databases for that as well.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/