Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you want to connect to SQL Server remotely, and don't want use the username and password but Windows Authentication, that's just one way - "AD" ,I think AD might cause more problems (but AD is more secure), and I am <strong>really sorry</strong> about that my answer is not correct, I found some references about that issue,I think it might be help.</p> <p><a href="http://support.microsoft.com/kb/811889/en-us" rel="nofollow">1.How to troubleshoot the "Cannot generate SSPI context" error message</a></p> <p><a href="http://blogs.msdn.com/b/sql_protocols/archive/2005/10/15/481297.aspx" rel="nofollow">2.“Cannot Generate SSPI Context” error message, more comments for SQL Server</a></p> <p><a href="http://blogs.msdn.com/b/sql_protocols/archive/2005/10/19/482782.aspx" rel="nofollow">3.“Cannot generate SSPI context” error message, when connect to local SQL Server outside domain</a></p> <p><a href="http://msdn.microsoft.com/en-us/library/ms677949%28v=vs.85%29.aspx" rel="nofollow">4.Service Principal Names (Windows)</a></p> <p><a href="http://support.microsoft.com/kb/822707/en-us" rel="nofollow">5."Access Denied" error message when you try to access remote resources</a></p> <h2>that's bad answer bellow:</h2> <p>If you use <code>"Integrated Security=SSPI"</code>, that means you can't connect to SQL Server remotely.</p> <p>if you want to connect remotely, please use <code>"User Id=myUsername;Password=myPassword;"</code> instead of <code>"Integrated Security=SSPI"</code>.</p> <p>(Of course your SQL Server must accept "remote connection")<a href="http://www.vkinfotek.com/connectionstring.html" rel="nofollow" title="connection string for connecting to data sources">connection string for connecting to data sources</a></p>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. This table or related slice is empty.
    2. VO
      singulars
      1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload