Cannot connect to SQL Server using Windoows authentication; Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Posted on 2005-05-09
I migrated a database from SQL Server on my local machine to a network server. The development web site is still hosted on my local macheine. When I try to connect to the relocated database, I get the following error:
Microsoft OLE DB Provider for SQL Server (0x80004005) - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I can access the production database (hosted on the same SQL Server) through the the production site (hosted on the same machine as SQL Server). I have made sure the "anonymous" account from the local IIS has been added to the database, and even specified that my local machine can delegate services (Kerberos only).
My server admin kung-fu is quite weak and I am in need of a master :-)