"Custom Reports..." grayed out, SP2 (latest) installed

What am I missing, here? The "Custom Reports..." context menu appears, but
is grayed out, and no "Standard Reports" context menu item is there. I've
found no reference to additional steps to get these reports enabled/visible.
Help?
thanks,Where exactly you see all these things ?
Amarnath
"Stan Spotts [Computer Aid, Inc]" wrote:
> What am I missing, here? The "Custom Reports..." context menu appears, but
> is grayed out, and no "Standard Reports" context menu item is there. I've
> found no reference to additional steps to get these reports enabled/visible.
> Help?
> thanks,|||In SQL Server Management Studio.
"Amarnath" wrote:
> Where exactly you see all these things ?
> Amarnath
> "Stan Spotts [Computer Aid, Inc]" wrote:
> > What am I missing, here? The "Custom Reports..." context menu appears, but
> > is grayed out, and no "Standard Reports" context menu item is there. I've
> > found no reference to additional steps to get these reports enabled/visible.
> >
> > Help?
> >
> > thanks,

"Changed Context to ..." message when editing permissions w/ VBA

I have a client using a small SQL Express database with an Access front end.

I've created a form in the front end that allows a supervisor the ability to perform two very basic security operations. 1) Adding a new user, and 2) granting/removing write privileges. The code behind the form uses VBA to build some T-SQL strings and then executes them via an ADO connection.

The strings are as follows:

1) Add new login to server:
"CREATE LOGIN [NETWORK\UserName] FROM WINDOWS WITH DEFAULT_DATABASE = MyDatabase"

2) Add user to database:
"USE MyDatabase CREATE USER [NETWORK\UserName]"

3) Grant Write Permissions:
" USE MyDatabase EXEC sp_addrolemember 'db_datawriter', 'NETWORK\UserName' "

4) Remove Write Permissions:
" USE MyDatabase EXEC sp_droprolemember 'db_datawriter', 'NETWORK\UserName' "

I have full privileges over the server & database, and everything runs perfectly.

However, when the supervisor - whose login includes security admin privileges - tries this, he gets a message that says "Changed Context to MyDatabase, Error# -2147217900, 80040e14" and the code fails.

If I grant him "db_owner" status, the message does not come up and everything runs perfectly.

I'm not a security guru or anything, but I suspect that it's not the greatest idea to hand out db_owner privileges.

I ran a search, and the best I could come up with were a couple of KB articles:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;197459
http://support.microsoft.com/default.aspx?scid=KB;EN-US;143339

I'm not even sure these articles are talking about what's happening..

Any ideas?When is the last time your boss ran an office update? Or more specifically, which MDAC is he using?|||When is the last time your boss ran an office update? Or more specifically, which MDAC is he using?
I'm not at the client's location right now, so I can't give a firm answer.. but I had someone there gather the following info..

Access is version 11.6566.8132 SP2

They're running XP Pro version 2002 SP2.

Per this page: http://support.microsoft.com/kb/231943/en-us they should be on at least MDAC 2.8 SP1. However based on the release dates shown on that page, I wouldn't be suprised if they were running 2.8 SP2.

Does that help?|||Ok, went by their office yesterday. MDAC is version 2.8.1117.0.

After a little more time spent, it appears as if this is the 'informational' message passed back to ODBC. It appears that I need to figure out how to trap for it in VB. The KB articles I posted got me started, but I need some more work..

I also seem to still have a SQL issue.. In the little bit of troubleshooting I had time for, it also appears that I have a 2nd error coming in behind the "changed context.." message. If the user is not a dbowner, it says that he doesn't have permissions to run these operations.

Is this correct? Is dbowner status required to change permissions of other users?

"Cannot Generate SSPI Context" for the server itself

Basically the windows authentication is not working at all on this newly
installed sql 2k on win 2k, even it is not coming up at the server itself.
The Authentication is on the mix mode but only sql authentication works. It
is interesting when I use the sa (at the server) to connect it shows few
databases (excluding master, temp, msdb,…) and when I login locally as admin
to the box using sa it shows all dbs. This machine is connected to the SAN
but it is not clustered. The identical server at the disaster site does not
have this problem!
I looked at articles but they are all refer to a computer connecting to the
server. The admin who installed this left the organization and I have no idea
how he did the installation or even if he renamed this sql server after the
installation.
Any ideas where I should look?
Thank you,
I take the part with system databases not shown back.
The Authentication problem exist when the server is on the netwrok. Anywhere
I should look?
Thank you.
"ktf" wrote:

> Basically the windows authentication is not working at all on this newly
> installed sql 2k on win 2k, even it is not coming up at the server itself.
> The Authentication is on the mix mode but only sql authentication works. It
> is interesting when I use the sa (at the server) to connect it shows few
> databases (excluding master, temp, msdb,…) and when I login locally as admin
> to the box using sa it shows all dbs. This machine is connected to the SAN
> but it is not clustered. The identical server at the disaster site does not
> have this problem!
> I looked at articles but they are all refer to a computer connecting to the
> server. The admin who installed this left the organization and I have no idea
> how he did the installation or even if he renamed this sql server after the
> installation.
> Any ideas where I should look?
> Thank you,
|||FYI,
I added 'Named Pipes' into Client Network Utility and it fixed my problem.
ktf
"ktf" wrote:
[vbcol=seagreen]
> I take the part with system databases not shown back.
> The Authentication problem exist when the server is on the netwrok. Anywhere
> I should look?
> Thank you.
> "ktf" wrote:

"Cannot Generate SSPI Context" for the server itself

Basically the windows authentication is not working at all on this newly
installed sql 2k on win 2k, even it is not coming up at the server itself.
The Authentication is on the mix mode but only sql authentication works. It
is interesting when I use the sa (at the server) to connect it shows few
databases (excluding master, temp, msdb,â?¦) and when I login locally as admin
to the box using sa it shows all dbs. This machine is connected to the SAN
but it is not clustered. The identical server at the disaster site does not
have this problem!
I looked at articles but they are all refer to a computer connecting to the
server. The admin who installed this left the organization and I have no idea
how he did the installation or even if he renamed this sql server after the
installation.
Any ideas where I should look?
Thank you,I take the part with system databases not shown back.
The Authentication problem exist when the server is on the netwrok. Anywhere
I should look?
Thank you.
"ktf" wrote:
> Basically the windows authentication is not working at all on this newly
> installed sql 2k on win 2k, even it is not coming up at the server itself.
> The Authentication is on the mix mode but only sql authentication works. It
> is interesting when I use the sa (at the server) to connect it shows few
> databases (excluding master, temp, msdb,â?¦) and when I login locally as admin
> to the box using sa it shows all dbs. This machine is connected to the SAN
> but it is not clustered. The identical server at the disaster site does not
> have this problem!
> I looked at articles but they are all refer to a computer connecting to the
> server. The admin who installed this left the organization and I have no idea
> how he did the installation or even if he renamed this sql server after the
> installation.
> Any ideas where I should look?
> Thank you,|||FYI,
I added 'Named Pipes' into Client Network Utility and it fixed my problem.
ktf
"ktf" wrote:
> I take the part with system databases not shown back.
> The Authentication problem exist when the server is on the netwrok. Anywhere
> I should look?
> Thank you.
> "ktf" wrote:
> > Basically the windows authentication is not working at all on this newly
> > installed sql 2k on win 2k, even it is not coming up at the server itself.
> > The Authentication is on the mix mode but only sql authentication works. It
> > is interesting when I use the sa (at the server) to connect it shows few
> > databases (excluding master, temp, msdb,â?¦) and when I login locally as admin
> > to the box using sa it shows all dbs. This machine is connected to the SAN
> > but it is not clustered. The identical server at the disaster site does not
> > have this problem!
> > I looked at articles but they are all refer to a computer connecting to the
> > server. The admin who installed this left the organization and I have no idea
> > how he did the installation or even if he renamed this sql server after the
> > installation.
> > Any ideas where I should look?
> > Thank you,

"Cannot Generate SSPI Context" for the server itself

Basically the windows authentication is not working at all on this newly
installed sql 2k on win 2k, even it is not coming up at the server itself.
The Authentication is on the mix mode but only sql authentication works. It
is interesting when I use the sa (at the server) to connect it shows few
databases (excluding master, temp, msdb,…) and when I login locally as adm
in
to the box using sa it shows all dbs. This machine is connected to the SAN
but it is not clustered. The identical server at the disaster site does not
have this problem!
I looked at articles but they are all refer to a computer connecting to the
server. The admin who installed this left the organization and I have no ide
a
how he did the installation or even if he renamed this sql server after the
installation.
Any ideas where I should look?
Thank you,I take the part with system databases not shown back.
The Authentication problem exist when the server is on the netwrok. Anywhere
I should look?
Thank you.
"ktf" wrote:

> Basically the windows authentication is not working at all on this newly
> installed sql 2k on win 2k, even it is not coming up at the server itself.
> The Authentication is on the mix mode but only sql authentication works. I
t
> is interesting when I use the sa (at the server) to connect it shows few
> databases (excluding master, temp, msdb,…) and when I login locally as a
dmin
> to the box using sa it shows all dbs. This machine is connected to the SAN
> but it is not clustered. The identical server at the disaster site does no
t
> have this problem!
> I looked at articles but they are all refer to a computer connecting to th
e
> server. The admin who installed this left the organization and I have no i
dea
> how he did the installation or even if he renamed this sql server after th
e
> installation.
> Any ideas where I should look?
> Thank you,|||FYI,
I added 'Named Pipes' into Client Network Utility and it fixed my problem.
ktf
"ktf" wrote:
[vbcol=seagreen]
> I take the part with system databases not shown back.
> The Authentication problem exist when the server is on the netwrok. Anywhe
re
> I should look?
> Thank you.
> "ktf" wrote:
>

"Cannot generate SSPI context" error message in SQL 2005 Beta 2

executing dimension process, the system return an error :
- Cannot generate SSPI context"
I'm not understand where is the problem....all config parameters are
correct...
What could be the reason of this?
my system configuration
Win XP SP2 Pro Ed.
SQL 2005 Beta 2
SQL Server 2005 CTP/Beta questions to
http://communities.microsoft.com/new...r2005&slcid=us
please.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cmarchi" <cmarchi@.discussions.microsoft.com> wrote in message
news:7FF32AE8-3632-40C9-BA97-7D2116606D42@.microsoft.com...
> executing dimension process, the system return an error :
> - Cannot generate SSPI context"
> I'm not understand where is the problem....all config parameters are
> correct...
> What could be the reason of this?
> my system configuration
> Win XP SP2 Pro Ed.
> SQL 2005 Beta 2

"Cannot generate SSPI context" error message in SQL 2005 Beta 2

executing dimension process, the system return an error :
- Cannot generate SSPI context"
I'm not understand where is the problem....all config parameters are
correct...
What could be the reason of this?
my system configuration
Win XP SP2 Pro Ed.
SQL 2005 Beta 2SQL Server 2005 CTP/Beta questions to
http://communities.microsoft.com/ne...lcid=us

please.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cmarchi" <cmarchi@.discussions.microsoft.com> wrote in message
news:7FF32AE8-3632-40C9-BA97-7D2116606D42@.microsoft.com...
> executing dimension process, the system return an error :
> - Cannot generate SSPI context"
> I'm not understand where is the problem....all config parameters are
> correct...
> What could be the reason of this?
> my system configuration
> Win XP SP2 Pro Ed.
> SQL 2005 Beta 2