How can we help you today? How can we help you today?

Log-in issue

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
0

Comments

1 comment

Sort by
  • CrispinH
    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
    0

Add comment

Please sign in to leave a comment.