From: johansson.andersson@telia.com   
      
   Good explained!!   
      
   //Tony   
      
      
   "Erland Sommarskog"  skrev i meddelandet   
   news:Xns9F9E9AB5A976Yazorman@127.0.0.1...   
   > Tony (johansson.andersson@telia.com) writes:   
   >> I do the following.   
   >> 1.Right click on Data Connection in Server Explorer and choose Add   
   >> connection   
   >> 2. In the Data Source I select Microsoft SQL Server (SqlClient)   
   >> 3.In server name I enter localhost   
   >> 4. I select Use Window Authentication   
   >> 5. I click on Test Connection and the result is Test connection succeeded   
   >>   
   >> Now to my question I really don't understand how this is possible to test   
   > a   
   >> connection   
   >> without specifying any database ?   
   >> Can somebody explain that.   
   >   
   > This is because that SQL Server stores a default database for you, which   
   > you   
   > will be connected to if you do not specify a database. By default this   
   > default database is the master database.   
   >   
   >   
   > --   
   > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
   >   
   > Books Online for SQL Server 2005 at   
   > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   > Books Online for SQL Server 2000 at   
   > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)