I'm running a website with NetworkService credentials and I'm able to
connect fine on one DB, but not the other. Both DBs are running SS
2008, and all machines concerned are on the same domain. I've added
machine credentials on both DBs as needed but i'm getting the above
error somehow for one of the DBs.

I'm guessing that the NetworkService machine level authentication is
somehow failing and thereby being reduced to anonymous, but I'm not
sure - never seen this before.

web.config connection strings are as follows:

<setting name="SqlConnectionString" serializeAs="String">
<value>Data Source=Server1; Initial Catalog=DB1; Integrated
Security=True</value>
and
<setting name="SqlConnectionStringBMAT" serializeAs="String">
<value>Data Source=Server2; Initial Catalog=DB2; Integrated
Security=True; Min Pool Size=1; Max Pool Size=200</value>

thanks for any ideas, dave

Dave (djohannsen2 (AT) gmail (DOT) com) writes:
You only talk about databases, but they are in fact differences server
instances. You need to add the machine credentials both on server
level and database level. Verify that they are present by running

SELECT * FROM sys.server_principals
SELECT * FROM sys.database_principals

On both servers, in the databases in question.

Also, check the SQL Server errorlog for the problematic server, and see
what State you have for the error message. Then look at
http://blogs.msdn.com/sql_protocols/...21/536201.aspx
for the meaning of the different states.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx