I'm having weird issues with connecting to MS SQL Server. Sometimes it can establish a connection and sometimes it can't. This is both with ODBC and with .net code. This happens on multiple computers. I.e. one minute you can connect, the next you can't.
I have a SQL 2000 server which connects fine every time. So I assume the problem is with the upgraded MS SQL Server. I want to be able to resolve this issue before upgrading the main server to SQL 2005.
Seems it was either a Service Pack issue, (installed SP2) or an IP subnet mask issue. But it's working now.|||Mark answerred. Please post more detailed info (error message) here if the issue comes up again.