Red Gate forums :: View topic - Issues with remote connection
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Issues with remote connection

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sigfried trent



Joined: 08 Jun 2009
Posts: 1

PostPosted: Mon Jun 08, 2009 9:37 pm    Post subject: Issues with remote connection Reply with quote

We are using the SDK to do a SQL compare operation.

It is working fine when operating on a local SQL instal and not working when running on a remote sql install.

It simply gives a response that it could not could not open the target database.

I checked the server to verify it allows remote connections. My login has full rights to the database (I created the database using the same windows account.)

I'm wondering if there is an SDK setting I have missed or some other factor I'm missing. I'm quite puzzled.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 684
Location: Cambridge

PostPosted: Wed Jun 10, 2009 3:19 pm    Post subject: Reply with quote

Thanks for your post.

Could you kindly try following things:
1. Try to connect the same remote database through Managemnt studio or query analyser on the same machine from where you are running sdk application see if you get any error.
2. Try using GUI of SQL Compare to compare the same databases see if it throws the same error.
3. Try connecting by using Ipaddress rather than server name : ipaddress\instancename
4. tcp:ip,port
5. tcp:ip\instance name
6. np:servername\instance name
7. np:ipaddress\instance name

Kindly let us kow if that was helpful and solved your problem.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group