SQL Server 2005 Connection Problem: Error 26
Posted on 2009-04-22
First, yes, have researched this searching for solutions first. Just about everything found relates to ASP / .NET. This isn't, as far as we can see, an ASP/.NET problem.
Having a problem connecting to a SQL Server 2005 (not Express) instance using SQL Server Management Studio from a newly deployed Windows Server 2008 server. The SQL Server 2005 instance is installed on another server in a different domain from the new server. The same instance can be connected from another Windows Server 2003 machine (in the same domain as the new server). Have checked that appropriate ports are open on the firewall between the two domains. Verified that SQL Server has been configured to accept remote connections (otherwise it wouldn't work from the other server, now would it?). This does not involve ASP / .NET, but will in the future as the new machine is to be the home of web sites and applications migrated from the Server 2003 machine that does connect properly. So, if the ports are open, Surface configuration set-up properly (equivalent to the 2003 configuration), the account used for connection on both machines is the same, what is being missed?
Hope we can get this resolved quickly as we need to get these apps/sites migrated off the old hardware (that is no longer under support).
Many thanks in advance!