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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQL Server Ask the Experts
    [...] 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following