Re: problem to connect sql server 2005 from localhost (W2k3)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have tried both, same problem.

Markus

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> schrieb im Newsbeitrag
news:%23EJv0SfMIHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
Do you have shared memory enabled in SQL Configuration Manager?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Markus" <satmax (at) gmx.at> wrote in message
news:u8uM1OfMIHA.4196@xxxxxxxxxxxxxxxxxxxxxxx
Hi ng!

The facts:
SQL Server 2005 is installed on a Windows 2003 server within a domain.
Every XP-Clients can connect to SQL Server via ODBC without any problems.

The problem
From the localhost I cannot connect to SQL-Server, AND from 2 other W2K
Server in the same Domain I cannot connect to SQL Server.


Here is the original error message, in german:

SQLState: '01000'
SQL Server-Fehler: 772[Microsoft][ODBC SQL Server
Driver][SharedMemory]ConnectionOpen(SECDoClientHandshake())-
Fehler bei der Verbindung: SQLState: '08001' SQL Server-Fehler: 18
[Microsoft][ODBC SQL Server Driver][SharedMemory]SSL Sicherheitsfehler



Have you any hints for me? I worked since 5 Days on this Problem...

The solution: :)

THX
Markus
PS: my german is much better...








.

Relevant Pages

  • developing an international application
    ... 3- Error messages ... I have to use a resource file, and put my messages i want to display into the resource file. ... If my user is using say German Windows, will the err.description be in german automaticlly? ... I also show the error from SQL Server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... I use only TCP/IP normal Client, ... error message it definitely has something to do with Shared Memory so I ... SQL Server 2005 is installed on a Windows 2003 server within a domain. ... my german is much better... ...
    (microsoft.public.sqlserver.connect)
  • Re: developing an international application
    ... It depends of the language setting (which is in a german system standard german) and the used Net version. ... I have taken a look at some information on MSDN, and from what I can figure I have to use a resource file, and put my messages i want to display into the resource file. ... I also show the error from SQL Server. ...
    (microsoft.public.dotnet.languages.vb)
  • BDS 2006 Update 2 German
    ... probably I've missed the announcement, but for those of you, who are awaiting Update 2 German as well and didn't read an announcement either, it is available now. ... InterBase, Firebird, Advantage Database, MS SQL Server and ... NexusDB V2 ...
    (borland.public.delphi.non-technical)
  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... Solid Quality Mentors ... The facts: ... Every XP-Clients can connect to SQL Server via ODBC without any problems. ... my german is much better... ...
    (microsoft.public.sqlserver.connect)