Re: user login fails, no SSPI context




tlyczko wrote:

What else can I do?? This server is set to use a domain account called
sql for the various services, should I set this back to the system
account??

I meant to say local system account, would I have to completely
re-install to make this happen??? It's a dev/test server, it's behind a
firewall, I could get away with this, even though it means re-setting
up the whole server VM, which I also don't mind doing if it would allow
me to have myself and one other person to work on the server properly.

I would actually prefer to have an AD group called SQL DBOs and give
this group sysadmin rights, but I don't think I can do that,
right?????? If I can do it, do I just set this group as a login??

I work for a non-profit agency that is just starting to computerize its
data collection etc. and I am the unofficial DBA...

Thank you, Tom

.



Relevant Pages

  • Re: Cannot Install SQL Server SP2
    ... If you are running the SQL Server service under a domain login try switching it to the Local System account. ... I'm doing a local install and even tried copying the sqlsupport.msi file it's complaining about manually, ...
    (microsoft.public.sqlserver.setup)
  • Re: restoring
    ... it starts up using the local system account. ... see the network folder and i know i have permission to the folder so i don't ... > Tibor Karaszi, SQL Server MVP ... >> a database using these backups onto another server. ...
    (microsoft.public.sqlserver.server)
  • ROLAP Real-time updates enabled #ERR
    ... I have a ROLAP cube and it uses real-time updates with SQL ... After the successful cube processing, ... SQL Server 2000). ... Both services use Local System account. ...
    (microsoft.public.sqlserver.olap)
  • Re: Cant copy databases across network with copy wizard
    ... You would need to change the destination server to run under ... Then you need to restart SQL service. ... >'Your SQL Server Service is running under the local system account. ...
    (microsoft.public.sqlserver.server)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)