Can't authenticate in SQL Mgmt Studio
in [Server Configuration]
|
From: Frank Hamelly, MCP-GP, MCT, MVP on 14 Dec 2009 08:51 SQL 2005. No problem logging directly into the server with sa credentials. However, can't authenticate using same credentials in SQL Mgmt Studio - receive error message 10061 - TCP provider - No connection could be made because the target machine actively refused it. I get the same error when trying to set an ODBC to the machine. This machine had SQL 2008 installed and uninstalled on it, then SQL 2005 installed. Could that be causing the problem? Much thanks in advance for your help. Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com
From: Uri Dimant on 14 Dec 2009 09:04 Frank Hmm could be I recall one of my clients had the same problem Anyway, have you read that article http://blogs.msdn.com/sql_protocols/archive/2007/07/19/tcp-provider-no-connection-could-be-made-because-the-target-machine-actively-refused-it.aspx "Frank Hamelly, MCP-GP, MCT, MVP" <fhamelly(a)eastcoast-dynamics.com> wrote in message news:af2d7d2a-56e8-4546-8bd0-de945c1385c3(a)a21g2000yqc.googlegroups.com... > SQL 2005. No problem logging directly into the server with sa > credentials. However, can't authenticate using same credentials in > SQL Mgmt Studio - receive error message 10061 - TCP provider - No > connection could be made because the target machine actively refused > it. > > I get the same error when trying to set an ODBC to the machine. > > This machine had SQL 2008 installed and uninstalled on it, then SQL > 2005 installed. Could that be causing the problem? > > Much thanks in advance for your help. > > Frank Hamelly > MCP-GP, MCT, MVP > East Coast Dynamics > www.eastcoast-dynamics.com
From: Frank Hamelly, MCP-GP, MCT, MVP on 14 Dec 2009 09:49 Thanks Umi. It turned out to be a port issue that we looked at about 20 times and missed until this morning. Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com
|
Pages: 1 Prev: Nolock Hint Next: move to new windows server and upgrade sql server 2000 to 2008 |