Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SA Login Password Problems

Author  Topic 

ChetShah
Starting Member

37 Posts

Posted - 2002-07-16 : 06:04:42
Hi,

In SQL Server 6.5 we have problems with setting object level permissions on certain SP's. After some investigation we think the SA password has been corrupted. As an example we have registered the server with SA login and blank password and that works. Then under database - the New Database option is greyed out.

Chet

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2002-07-16 : 08:34:40
Chet,

When you login as sa, can you see the permissions for sa or any user for that matter?

Peace

Rick

Go to Top of Page
   

- Advertisement -