Default Connection to master DB

Question

Our application hosted in multitier environment. When the App servers create a connection to the SQL Server it opens the connection on its default database (let's say xyz) but when the Data Servers who use the same connection string opens connection on default database and as well as master database.

Is there any reason for that. Any ideas ?

Are you sure they are using the same connection string? If they were using different logins, they could have different default databases. — Bridge
– Bridge, Commented May 14, 2012 at 14:25

rvphx · Accepted Answer · 2012-05-14 13:39:55Z

1

Check the connection properties on your data server. The driver (OLEDB, ODBC, ADO.NET) all should have a capability of identifying the default database that they connect to. My guess is that the data server driver connects by default to the master database because of the driver property.

answered May 14, 2012 at 13:39

rvphx

2,3909 gold badges43 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Default Connection to master DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related