SQL Server user name issue

Tags:
Microsoft SQL Server 2000
SQL Server database
SQL Server User Accounts
We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. - aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.”

When we login from the user computer with the same name and password as the server, we are able to see the SQL Server running with the server database. When we login from the user computer with the user account as "aaa," however, the SQL Server is not running with the server name. How can we solve this problem?

Answer Wiki

Thanks. We'll let you know when a new response is added.

What is the exact error message that you are getting?

You probably just need to add the Windows user aaa as a login into the SQL Server.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • The most-watched questions this week: April 20, 2010 - ITKE Community Blog
    [...] SQL Server user name issue asked by a SQL Server reader and answered by [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: