SQL cannot read the domain name

Hot Topic

Where is variable used?
SSIS remote connection failing ... local connection OK
How to migrate data from sql server 2005 to local Pocket PC?
How to detect changes to the structure of databases, tables and even SP
HTTP access to Analysis Services 2005 ?
RowGuid
OLE Db Destination task in ASYNC_NETWORK_IO wait state
How to achieve partition parallelism?
ADO.NET Please Help ??
Pakcage Error...How to read files on a different domain?

SQL Server

Error adding a query with Designer
Previous(Expression, AggFunction, PreviousScope, AggScope) ??
Parameterized Query Using Wildcards in VS2005
Cant see image
UK Datetime parameter problem SQL 2005 RS
Remote Connection problem on MS SQL 2000
Can create login, but cannot connect (sa doesn't even work)
Best way to make a database not in use?
Temporary tables
Data Access very slow in .net as compared to VB

SQL cannot read the domain name

Hi, all

I need a help here please.

Im using SQL Server 2000 on a server, and theres clients that need to connect to the sql server, and the clients are the users that have domain ids.

Firstly i run the sqlserver under local system user (default).And the clients which is login into a domain and can automatically login with windows authentification. But before i have already added the domain name for the client in the security login of sql server.

Then, i change the sqlserver services to be run under a local user with no admin right. After that, i cannot use windows authentification, i have to use sa. The reference i used for applying this is written in this url : http://support.microsoft.com/default.aspx scid=kb;en-us;Q283811

The problem is i need to use both the sqlservices to be run under local with no admin right user and i need to use windows authentification.

Please help.

Thank you very much

Felix Adhitya




Answer this question

SQL cannot read the domain name

  • Salvador Cadena

    First, make sure that you change the account through the SQL Server Configuration Manager, not the generic Windows service manager.

    If you have already done so or if that does not solve your problem, consider running the SQL Server under a non-admin domain account instead of a non-admin local account.



  • Martin Koster

    Yes it works, many thanks mate Smile

  • Kishore Annavarapu

    Hi Peter

    Firstly thx a lot for your reply.

    I dont really understand how can i change the account through the sql server configuration manager.

    Please correct me if im wrong, do you mean that i should also configurate the user permission in sql server permission after i made the account and all its permission on the account local computer If yes, i already tried it, and the clients still cannot connect and it produce the same error message.

    And i already tried to run the sql server services under non admin domain account, but the clients still cant connect to the sql server.

    Please help

    Thank you very much

    Regards

    Felix



  • solomonk

    I found the solution for this problem.

    The user that used to run the sql services must be given permission to "impersonate a client after authentication" in Security Policy.

    But there is another problem : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=333949&SiteID=1&mode=1

    Thank you

    Best Regards

    Felix Adhitya



  • SQL cannot read the domain name
Answer this question