SQL Server Performance Forum – Threads Archive
Import Error
I want to import the data from remote database. I know the IP address of that machine and password of user ‘sa#%92.By using RDC and same IP address I am able to connect the database, but while importing data from that machine it gives me error [DBNETLIB] [ConnectionOpen (Connect ())] SQL Server does not exist or access denied.
What is wrong? Surendra Kalekar
Are you getting the connection in QA after giving I.P. Address.
Because i think sometimes its not possible to connect thru QA by supplying I.P. address.
So i feel same logic goes here.
quote:Originally posted by ranjitjain
Are you getting the connection in QA after giving I.P. Address.
Because i think sometimes its not possible to connect thru QA by supplying I.P. address.
So i feel same logic goes here.
It is giving me the same error while connecting through QA.
Surendra Kalekar
Because i think sometimes its not possible to connect thru QA by supplying I.P. address.
So i feel same logic goes here.
Please refer: http://support.microsoft.com/default.aspx?id=328306 PRB: Configuring DSNs with SQL Server Net-Libraries
http://support.microsoft.com/default.aspx?id=289573
quote:Originally posted by dineshasanka
Please refer:
http://support.microsoft.com/default.aspx?id=328306
PRB: Configuring DSNs with SQL Server Net-Libraries
http://support.microsoft.com/default.aspx?id=289573
http://support.microsoft.com/default.aspx?id=289573
Thanks Rajat & Dinesh
Surendra Kalekar
]]>