Information-Schema and Sys user accounts

[Charlie Price]

I migrated a database from Microsoft Sql server 2005 to a MS Sql server 2008 box. On the old server the under security/users the information_sch ema and sys accounts were active. When I try to enable them using:

Grant Connect To Information_Sch ema the command completes but I get a message stating I cnanot enable this account.

What do I need to do grant these accounts Connect?

this is causing some software to not work properly!

thanks a ton!

[ck9663]

Are you trying to enable the information_sch ema? I believe it is a view, so you cannot enable that.

~~ CK