Cannot see Login account properties

Hi everybody !!!

I have SQLServer 2005 installed and I think a login account is corrupted because Im not able to connect to a database. I get an Timeout expiration error after I clicked on Login Properties or when I try to make a connection to SQLServer 2005 using that login account. Also I cannot review the script needed to create the login, but I do can review the database user properties mapped to this login account.

Is there a way to recreate or repair a login account?

The only solution I have right now is create another login accout, but this involves to modify database connection properties within my code.

Any help, comment or suggestion is really appreciated.

Thans a lot.

I am guessing you are using Microsoft SQL Management Studio object browser to look at the properties, correct? It may be a problem in the tool, I would recommend asking about this one in the tools forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1).

To quickly verify if there is indeed something wrong with this particular login, you can try the following statement:

SELECT * FROM sys.server_principals WHERE name = 'login_name'

Go

You can also try the following statement to make sure the system is able to use this login as a valid principal:

EXECUTE AS LOGIN = 'login_name'

Let us know if you encountered any problem while running these statements.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine