Re: Performance really poor if calling data from sql clients

Hi Stephan,

"Stephan (Germany)" <StephanGermany@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im
Newsbeitrag news:<AEBB7DF6-0A74-4E62-A535-1624D0747DEB@xxxxxxxxxxxxx>...

If I launch the program on the laptop where the database is hosted,

xxx if I choose TCP/IP: error, no SSPI context can be generated

I have seen the SSPI context error in connection with Kerberos problems when
using TCP/IP as a connection protocol. Are you using Active Directory? Is
SQL Server running as a domain user account (especially if the domain user
is not a domain administrator). If so, you may have to use the setspn.exe
utility to register a service principal name for the
service/server/account-combination as described in
http://support.microsoft.com/?scid=kb%3Ben-us%3B319723&x=13&y=13.
Alternatively, if this is possible in your scenario, grant the SQL Server
service account domain administrator rights, restart the server (so it can
register itself in AD), remove the service account from domain admin group
and restart again.

Good luck!

Nils Loeber


.

Relevant Pages

  • RE: Upgrade from 2005 to 2008: Invalid Credentials
    ... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: SPN Requirement
    ... The service account for SQL Server needs to be a domain ... account to allow Write Public Information rights but I'd ... The SQL Network Interface library could not register the Service Principal ... Name for the SQL Server service. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: xp_cmdshell failed to execute because current security context
    ... INFO: databasename: xp_cmdshell failed to execute because ... SQL Server running under has appropriate privilege. ... Server service account does not have all the relevant permissions not the sql ... ontario, canada ...
    (microsoft.public.sqlserver.server)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I am guessing that the SQL Server Agent service account is not what ... rights to remove folders under P:\ReplData. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
Loading