0

i need to establish a conecction to a SQL Server Express from remotes pcs. But i can do it, only can establish it from the pc where is the SQL. Thank you for your help.

Jorge Hernandez
  • 84
  • 8
  • You have to enable remote SQL connection --> http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012 – Triplus Sep 09 '14 at 18:03

1 Answers1

0

If you are using Integrated Security (Windows Authentication) and a local user account (from the PC with SQL installed), such account can only be authenticated on that PC.

For database account (SQL Server Authentication) you'll need to create a database login and enable Mixed authentication (http://msdn.microsoft.com/en-us/library/ms188670.aspx)

vasja
  • 4,732
  • 13
  • 15