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

Re: test connection to a database without specifying a database

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: test connection to a database without specifying a database
Date	Tue, 15 Nov 2011 09:15:16 -0500
Organization	A noiseless patient Spider
Lines	22
Message-ID	<j9ts5u$s3i$1@dont-email.me> (permalink)
References	<4ec26862$0$294$14726298@news.sunsite.dk>
Injection-Date	Tue, 15 Nov 2011 14:15:27 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="28786"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+yRJ10488PADmKPSpAMuG3oUJ7lgwnbCI="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2800.2001
X-Newsreader	Microsoft Outlook Express 6.00.2800.2001
Cancel-Lock	sha1:ePcvteSTEoVFy/dOnFmBFMBV674=
X-Priority	3
X-MSMail-Priority	Normal
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:805

Show key headers only | 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