Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #803

Re: test connection to a database without specifying a database

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

test connection to a database without specifying a database "Tony" <johansson.andersson@telia.com> - 2011-11-15 14:25 +0100
  Re: test connection to a database without specifying a database Erland Sommarskog <esquel@sommarskog.se> - 2011-11-15 14:12 +0000
    Re: test connection to a database without specifying a database "Tony" <johansson.andersson@telia.com> - 2011-11-15 15:14 +0100
  Re: test connection to a database without specifying a database "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-11-15 09:15 -0500

csiph-web