Log-in issue

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Log-in issue

Postby CrispinH » Wed Sep 23, 2009 12:42 pm

Hi

I can log into a remote SQL Server Express 2008 database (across a VPN) with SQL Server Management Studio (SSMS) without problems, but SQL Compare 8 is complaining of a network error: Provider, error 40 - Could not open a connection to SQL Server.

I'm using Windows Authentication in both cases. The remote database is on a sub-domain in the Active Directory forest, but that's not worrying SSMS.

Any ideas anyone?

Thanks

Crispin
CrispinH
 
Posts: 38
Joined: Mon Nov 21, 2005 10:41 am

Postby CrispinH » Wed Sep 23, 2009 2:38 pm

I've worked it out. I hadn't applied the correct user permissions to the particular database, so I was being locked out. The 'network error' was a red herring.
CrispinH
 
Posts: 38
Joined: Mon Nov 21, 2005 10:41 am


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests