INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL Create Error Login - Server Principal Already exists

SQL Create Error Login - Server Principal Already exists

(OP)
Hello. I have a program that creates it's own user in SQL. A new SQL server was just added to our domain and I am moving our databases to this server.

I am using our program to create a specific SQL login and receive the error: The Server Principal 'MyUserName' already exists.

I have checked sys.server_principals, but the 'MyUserName' principal is not listed. Any ideas on what I can check?

RE: SQL Create Error Login - Server Principal Already exists

You say you are using a program to create the new user...is this an application? First thing I would check is that the program is pointing to the new server, you might still be trying to create it on the old server where the login already exists.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

RE: SQL Create Error Login - Server Principal Already exists

(OP)
Hi there. Thanks for the reply. Yes it is an application. During the username creation process we enter the servername\instancename along with the sa username/password and the database name. I am sure that during this process we are pointing to the correct server.

RE: SQL Create Error Login - Server Principal Already exists

Have you tried to use SQL commands on the server to create the login, just to see if it works? That will help narrow down the issue. If using SQL commands on the server creates the user, you know it's an issue with the application. If it doesn't create it and returns the same error, that will let you focus on the server itself.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close