Can't get MS SQL 2005 to connect to my local server
Posted on 2013-06-17
My hard drive died, so I had it replaced. The tech company reinstalled Windows 7 Professional, and I installed SQL 2005, 64 bit. It connects to other servers, but it won't connect to my local server. The typical, non-descript error: 18456. I searched forums for answers. I made sure IIS was started, I added port 1433. I even uninstalled and reinstalled it to make sure I set it up to just use Windows Authentication. Nothing changed.
Various instructions talk about SQL Server Express, but I'm using Microsoft SQL Server Management Studio, so I don't know if that's a different program or what.
There are many links to Microsoft or other forums...some times I don't understand what they're saying, other times, I can't figure out how to get to what they recommend.
Can anyone help?