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

Re: test connection to a database without specifying a database

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: test connection to a database without specifying a database
Date	2011-11-15 09:15 -0500
Organization	A noiseless patient Spider
Message-ID	<j9ts5u$s3i$1@dont-email.me> (permalink)
References	<4ec26862$0$294$14726298@news.sunsite.dk>

Show all headers | View raw

Tony wrote:
> Hello!
>
> 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.
>
It uses the default database for the login (every login has a default
database that defaults to master if none is chosen when the login is
created)

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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