VC 2.5, SQL 2005 DB Users

[sdaniely]

While thinking I was working in one DB but actually working in my SQL 2005 VirtualCenter DB, I entered Security | Users area and deleted a user. I can not for the life of me recall what user it was nor do we have a backup. There have been no errors or failures thus far...What are the default USERS which are populated in here? I have dbo, guest, INFORMATION_SCHEMA, SQL Admin and sys in there now.

Thanks - Sean

[HyperSprite]

You might want to look under your servers Security, Logins section

If you created your login manually, the default is for the user to have the

same name as the login.

If there is nothing there that looks right, or if it is just the defaults,

look in your ODBC, System DSN for you VirtualCenter connection, that should

have the login listed.

Once you make the user, give it db_owner rights on your

VirtualCenter db.