I have build up an SQL Server 2008 R2 on Windows Server 2008 R2.
However, there is a connection problem with an x86 (32-bit) application which works fine under Windows XP Professional, but does not neither under Windows 7 nor Windows Server.
The connection string is as followed:
Dim bConn As New ADODB.Connection
Dim s As String
s = "Provider=SQLNCLI10;Server=" & ip & ",1433;Database = xxx;Uid=yyy; Pwd=zzz; Trusted_Connection=no;"
This snippet works (!) fine under x86 Windows XP Professional.
Only Windows 7 64 Bit AND Windows Server 64 Bit report an error:
"Database connection could not be established:
Named Pipes-Provider: Could not connect to SQL Server "
Named Pipes is deactivated on the Server. And I don't want Named Pipes.
TCP-Port is 1433 AND OPEN !!!
Even the Firewall on the server is down and deactivated.
Please help !