test connection to a database without specifying a database

#1

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.

//Tony

#2

Tony (johansson.andersson (AT) telia (DOT) com) writes:

Quote:

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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

Good explained!!

//Tony

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> skrev i meddelandet
news:Xns9F9E9AB5A976Yazorman (AT) 127 (DOT) 0.0.1...

Quote:

Tony (johansson.andersson (AT) telia (DOT) 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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#4

Tony wrote:

Quote:

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

test connection to a database without specifying a database

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

test connection to a database without specifying a database - 11-15-2011 , 07:25 AM

Re: test connection to a database without specifying a database - 11-15-2011 , 08:12 AM

Re: test connection to a database without specifying a database - 11-15-2011 , 08:14 AM

Re: test connection to a database without specifying a database - 11-15-2011 , 08:15 AM