0

We bought a virtual dedicated server. Then I installed SQL Server Express on it. And then I installed SQL Server Management Studio to run this on windows server 2008. But I cannot connect the database. It gives me a "cannot connect error". How can I connect to vds' database?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Ender Ariç
  • 49
  • 1
  • 1
  • 10
  • possible duplicate of [Enable remote connections for SQL Server Express 2012](http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012) – marc_s Aug 11 '14 at 15:44
  • See this [other SO question (and its answers!)](http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012) on how to enable remote connections to SQL Server Express (which are **off** by default) – marc_s Aug 11 '14 at 15:45
  • Are you sure you want to logon with Windows Authentication? Are you a logged on user of a domain on the remote system? Try the "SQL Server Authentication" option instead – Alex K. Aug 11 '14 at 15:46
  • I tried SQL Server Authentication but cannot login . I don't want to login with windows authentication. But i cannot login with anyone. @AlexK. – Ender Ariç Aug 11 '14 at 15:53

1 Answers1

0

I installed sql server 2008 R2 management studio on my computer. Then i tried to connect database with remote connection. I opened my firewall port 1433. And it is working.

Ender Ariç
  • 49
  • 1
  • 1
  • 10