Last post Feb 13, 2014 12:45 AM by Happy Chen - MSFT
Feb 12, 2014 10:40 AM|nivekd|LINK
I had copy a 2008 R2 database from Server A (Enterprise (64-bit) Version 10.0.2841.0 SP1 Server(NT 6.1 (X64) Build 7601:SP1)
To Server "B" (Enterprise (64-bit) 10.50.4000.0 SP2
Server(NT 6.1 (X64) Build 7601: SP1)
When I click on the application I receive the DBNETLIB ConnectionOpen(Connect...... SQL Server does not exist....... error? I can't seem to figure out why because TCP/IP & Name Pipe is
enable, I am able to login the database and select data from the tables with the account the application is using And my config file is set-up like
Provider=SQLOLEDB;Data Source=ServerB\ServerB.access.local;Initial Catalog=DatabaseName;User Id=LoginAccount;Password=Loginpwd;
What is it that I missing or have wrong?
Feb 13, 2014 12:45 AM|Happy Chen - MSFT|LINK
<div class="sbody kb_tabs_toggle_open" id="MT1" style="margin-left: 40px;">This problem occurs during the discovery phase of the connection. The IPSec policy on the client drops packets from the server when the source IP changes.</div>
To work around this problem, you have to hardcode the TCP port or the Named Pipe of the SQL Server named instance. To do this, use a connection string that is similar to one of the following:
; Hardcoded TCP OLE DB initstring
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=clientID;Data Source=tcp:TcpIpAddress,port
; Hardcoded Named Pipes OLE DB initstring
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=clientID;Data Source=np:\\ServerName\pipe\MSSQL$InstanceName\sql\query
Please check out the link for details:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
Server does not exist or access denied.
Hope it helps you.