Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    India
    Posts
    17

    Unanswered: Unable to add dbo alias

    I have an account with sso_role in a server but i'm not able to add alias in the database of the server. Can anyone let me know what is the issue.

    I also have another server where the same account with sso_role create the alias.

    Please let me know how should i investigate this.

  2. #2
    Join Date
    Sep 2006
    Posts
    15
    Only a DBO and SA can create alias

    Your other server account could already be a DBO or alias as DBO

  3. #3
    Join Date
    Sep 2003
    Location
    India
    Posts
    17
    Quote Originally Posted by EddieA
    Only a DBO and SA can create alias

    Your other server account could already be a DBO or alias as DBO

    I have checked the other server and found my id same as the one in which i want to create the alias. The id has a sso_role on both the server and checked the database but the id is not there. I have checked the sysalternates tables too but could not find this suid. Is there any other way way i can check why its permiting me to create in one server and not in other.

    Thanks,

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Is the dbowner for this database the same as on your other server?

    When you ask questions as these, you need to put in the error message that you get to help people attempt to answer your query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •