ADO.NET SQL Client Provider default database connection

Question

Does the .NET SQL Client DataProvider always connect using the master database. I've noticed that when I connect to the database to execute an ADO.NET query and then look at the active connections in SQL Management studio, the SPID for the .NET SQL client provider always uses master DB

The initial catalog in my connection string is that of the DB I'm connection to (and this is not master)

"select SPID,DB_NAME(dbid),program_name from sys.sysprocesses where program_name like '%.Net%'"

Here is the Output: alt text http://www.freeimagehosting.net/uploads/1046babbc1.jpg

Have you tried running profiler to see if any statements are executed on the master DB? — Jonathan Parker
– Jonathan Parker, Commented Apr 3, 2009 at 7:30

Andomar · Accepted Answer · 2009-04-03 10:30:04Z

1

SQL Server has a per-user setting for the default database. Right after logon, you'll be in that database, and you'll need rights on that database to be able to logon.

The connection string "Initial Catalog" setting is only applied some time after logon.

answered Apr 3, 2009 at 10:30

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

1 Comment

Abhijeet Patel Over a year ago

Looks that this is exaclty what was going on.

Collectives™ on Stack Overflow

ADO.NET SQL Client Provider default database connection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related