Local SQL connection fails
Posted on 2011-03-21
Our 2005 Sql server crashed and we were able to change hardware install 2008 R2 Sql using the same server name and instance name. We have a program that uses a database called ABTT and we have opened port 1433 through the firewall and remote off LAN connections work great, but connections locally fail.
i dont seem to be getting any error messages in the program so is there place to look for messages or a test I can run to determine what the cause is?
I think it is somethng with named pipes, but they look to be enabled and I don't know how to test.