Red Gate forums :: View topic - Log-in issue
Return to www.red-gate.com RSS Feed Available

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

Log-in issue

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
CrispinH



Joined: 21 Nov 2005
Posts: 38

PostPosted: Wed Sep 23, 2009 12:42 pm    Post subject: Log-in issue Reply with quote

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
Back to top
View user's profile Send private message
CrispinH



Joined: 21 Nov 2005
Posts: 38

PostPosted: Wed Sep 23, 2009 2:38 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
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