Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
Chris
Worse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>
|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>
Showing posts with label admin. Show all posts
Showing posts with label admin. Show all posts
Wednesday, March 21, 2012
Funny Results from using Surface Area Configuration for Features
Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>sql
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>sql
Funny Results from using Surface Area Configuration for Features
Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I am using a Windows account that is a local admin on the server yet when
>> I use Surface Area Configuration for features I only see Reporting
>> Services and Integration Services. I understand that this feature is
>> using WMI but what would stop me from seeing the actual Database Engine
>> components?
>> Thanks
>> Chris
>
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I am using a Windows account that is a local admin on the server yet when
>> I use Surface Area Configuration for features I only see Reporting
>> Services and Integration Services. I understand that this feature is
>> using WMI but what would stop me from seeing the actual Database Engine
>> components?
>> Thanks
>> Chris
>
Monday, March 19, 2012
functions in view
I have a view on SQL server 2000.
Using enterprise mngr to admin it.
In my view I would like to add a column that calculates something with the
other column.
An example could be:
Column Table
a x
b x
a1 y
mycustomcolumn = (a+b)*a1 =>> how can I insert this.
It's a bit like in Ms Access, where you have the expression builder.
THX
nicholas wrote:
> I have a view on SQL server 2000.
> Using enterprise mngr to admin it.
> In my view I would like to add a column that calculates something
> with the other column.
> An example could be:
> Column Table
> a x
> b x
> a1 y
> mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> It's a bit like in Ms Access, where you have the expression builder.
> THX
create table test123 (col1 int, col2 int)
create view vTest
as
Select col1, col2, col3 = col1 * col2
From test123
Don't rely on SQL EM for object maintenance. Learn to use actual DDL
scripting. SQL EM doesn't do everyting and maintaining from scripts give
you a good handle on object design.
David Gugick
Imceda Software
www.imceda.com
|||perfect !
THX a lot
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Zy9QfsEFHA.3924@.TK2MSFTNGP09.phx.gbl...
> nicholas wrote:
> create table test123 (col1 int, col2 int)
> create view vTest
> as
> Select col1, col2, col3 = col1 * col2
> From test123
>
> Don't rely on SQL EM for object maintenance. Learn to use actual DDL
> scripting. SQL EM doesn't do everyting and maintaining from scripts give
> you a good handle on object design.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Using enterprise mngr to admin it.
In my view I would like to add a column that calculates something with the
other column.
An example could be:
Column Table
a x
b x
a1 y
mycustomcolumn = (a+b)*a1 =>> how can I insert this.
It's a bit like in Ms Access, where you have the expression builder.
THX
nicholas wrote:
> I have a view on SQL server 2000.
> Using enterprise mngr to admin it.
> In my view I would like to add a column that calculates something
> with the other column.
> An example could be:
> Column Table
> a x
> b x
> a1 y
> mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> It's a bit like in Ms Access, where you have the expression builder.
> THX
create table test123 (col1 int, col2 int)
create view vTest
as
Select col1, col2, col3 = col1 * col2
From test123
Don't rely on SQL EM for object maintenance. Learn to use actual DDL
scripting. SQL EM doesn't do everyting and maintaining from scripts give
you a good handle on object design.
David Gugick
Imceda Software
www.imceda.com
|||perfect !
THX a lot
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Zy9QfsEFHA.3924@.TK2MSFTNGP09.phx.gbl...
> nicholas wrote:
> create table test123 (col1 int, col2 int)
> create view vTest
> as
> Select col1, col2, col3 = col1 * col2
> From test123
>
> Don't rely on SQL EM for object maintenance. Learn to use actual DDL
> scripting. SQL EM doesn't do everyting and maintaining from scripts give
> you a good handle on object design.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
functions in view
I have a view on SQL server 2000.
Using enterprise mngr to admin it.
In my view I would like to add a column that calculates something with the
other column.
An example could be:
Column Table
a x
b x
a1 y
mycustomcolumn = (a+b)*a1 =>> how can I insert this.
It's a bit like in Ms Access, where you have the expression builder.
THXnicholas wrote:
> I have a view on SQL server 2000.
> Using enterprise mngr to admin it.
> In my view I would like to add a column that calculates something
> with the other column.
> An example could be:
> Column Table
> a x
> b x
> a1 y
> mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> It's a bit like in Ms Access, where you have the expression builder.
> THX
create table test123 (col1 int, col2 int)
create view vTest
as
Select col1, col2, col3 = col1 * col2
From test123
Don't rely on SQL EM for object maintenance. Learn to use actual DDL
scripting. SQL EM doesn't do everyting and maintaining from scripts give
you a good handle on object design.
David Gugick
Imceda Software
www.imceda.com|||perfect !
THX a lot
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Zy9QfsEFHA.3924@.TK2MSFTNGP09.phx.gbl...
> nicholas wrote:
> > I have a view on SQL server 2000.
> > Using enterprise mngr to admin it.
> >
> > In my view I would like to add a column that calculates something
> > with the other column.
> > An example could be:
> >
> > Column Table
> > a x
> > b x
> > a1 y
> > mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> >
> > It's a bit like in Ms Access, where you have the expression builder.
> >
> > THX
> create table test123 (col1 int, col2 int)
> create view vTest
> as
> Select col1, col2, col3 = col1 * col2
> From test123
>
> Don't rely on SQL EM for object maintenance. Learn to use actual DDL
> scripting. SQL EM doesn't do everyting and maintaining from scripts give
> you a good handle on object design.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Using enterprise mngr to admin it.
In my view I would like to add a column that calculates something with the
other column.
An example could be:
Column Table
a x
b x
a1 y
mycustomcolumn = (a+b)*a1 =>> how can I insert this.
It's a bit like in Ms Access, where you have the expression builder.
THXnicholas wrote:
> I have a view on SQL server 2000.
> Using enterprise mngr to admin it.
> In my view I would like to add a column that calculates something
> with the other column.
> An example could be:
> Column Table
> a x
> b x
> a1 y
> mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> It's a bit like in Ms Access, where you have the expression builder.
> THX
create table test123 (col1 int, col2 int)
create view vTest
as
Select col1, col2, col3 = col1 * col2
From test123
Don't rely on SQL EM for object maintenance. Learn to use actual DDL
scripting. SQL EM doesn't do everyting and maintaining from scripts give
you a good handle on object design.
David Gugick
Imceda Software
www.imceda.com|||perfect !
THX a lot
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Zy9QfsEFHA.3924@.TK2MSFTNGP09.phx.gbl...
> nicholas wrote:
> > I have a view on SQL server 2000.
> > Using enterprise mngr to admin it.
> >
> > In my view I would like to add a column that calculates something
> > with the other column.
> > An example could be:
> >
> > Column Table
> > a x
> > b x
> > a1 y
> > mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> >
> > It's a bit like in Ms Access, where you have the expression builder.
> >
> > THX
> create table test123 (col1 int, col2 int)
> create view vTest
> as
> Select col1, col2, col3 = col1 * col2
> From test123
>
> Don't rely on SQL EM for object maintenance. Learn to use actual DDL
> scripting. SQL EM doesn't do everyting and maintaining from scripts give
> you a good handle on object design.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
functions in view
I have a view on SQL server 2000.
Using enterprise mngr to admin it.
In my view I would like to add a column that calculates something with the
other column.
An example could be:
Column Table
a x
b x
a1 y
mycustomcolumn = (a+b)*a1 =>> how can I insert this.
It's a bit like in Ms Access, where you have the expression builder.
THXnicholas wrote:
> I have a view on SQL server 2000.
> Using enterprise mngr to admin it.
> In my view I would like to add a column that calculates something
> with the other column.
> An example could be:
> Column Table
> a x
> b x
> a1 y
> mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> It's a bit like in Ms Access, where you have the expression builder.
> THX
create table test123 (col1 int, col2 int)
create view vTest
as
Select col1, col2, col3 = col1 * col2
From test123
Don't rely on SQL EM for object maintenance. Learn to use actual DDL
scripting. SQL EM doesn't do everyting and maintaining from scripts give
you a good handle on object design.
David Gugick
Imceda Software
www.imceda.com|||perfect !
THX a lot
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Zy9QfsEFHA.3924@.TK2MSFTNGP09.phx.gbl...
> nicholas wrote:
> create table test123 (col1 int, col2 int)
> create view vTest
> as
> Select col1, col2, col3 = col1 * col2
> From test123
>
> Don't rely on SQL EM for object maintenance. Learn to use actual DDL
> scripting. SQL EM doesn't do everyting and maintaining from scripts give
> you a good handle on object design.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Using enterprise mngr to admin it.
In my view I would like to add a column that calculates something with the
other column.
An example could be:
Column Table
a x
b x
a1 y
mycustomcolumn = (a+b)*a1 =>> how can I insert this.
It's a bit like in Ms Access, where you have the expression builder.
THXnicholas wrote:
> I have a view on SQL server 2000.
> Using enterprise mngr to admin it.
> In my view I would like to add a column that calculates something
> with the other column.
> An example could be:
> Column Table
> a x
> b x
> a1 y
> mycustomcolumn = (a+b)*a1 =>> how can I insert this.
> It's a bit like in Ms Access, where you have the expression builder.
> THX
create table test123 (col1 int, col2 int)
create view vTest
as
Select col1, col2, col3 = col1 * col2
From test123
Don't rely on SQL EM for object maintenance. Learn to use actual DDL
scripting. SQL EM doesn't do everyting and maintaining from scripts give
you a good handle on object design.
David Gugick
Imceda Software
www.imceda.com|||perfect !
THX a lot
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Zy9QfsEFHA.3924@.TK2MSFTNGP09.phx.gbl...
> nicholas wrote:
> create table test123 (col1 int, col2 int)
> create view vTest
> as
> Select col1, col2, col3 = col1 * col2
> From test123
>
> Don't rely on SQL EM for object maintenance. Learn to use actual DDL
> scripting. SQL EM doesn't do everyting and maintaining from scripts give
> you a good handle on object design.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Subscribe to:
Posts (Atom)