Hi all,
How are those of you that run MSDE admin the thing?
The Web Data Administrator doesn't seem to much of a solution.
Sean.
hi Sean,
"Sean S - ECU" <SeanSECU@.discussions.microsoft.com> ha scritto nel messaggio
news:FBB4C248-520A-4BC4-BF5A-9E51F6A1D0C4@.microsoft.com...
> Hi all,
> How are those of you that run MSDE admin the thing?
> The Web Data Administrator doesn't seem to much of a solution.
you can have a look at a free prj of mine, at the link foolowing my sign.;
other third parties tools (free and commercial) are listed at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" wrote:
> you can have a look at a free prj of mine, at the link foolowing my sign.;
> http://www.aspfaq.com/show.asp?id=2442
Excellent! Thanks.
Sean.
Showing posts with label admin. Show all posts
Showing posts with label admin. Show all posts
Thursday, February 9, 2012
Admin. of SSRS via SQL Server Mgmt Studio
I would like to be able to administer SQL Server Reporting Services (SSRS)
via the SQL Server Management Studio (SSMS). It appears, in our setup at
least, that the only individuals who are able to use the SSMS are those who
are included in the BUILTIN\Administrators group (admins on the server). Our
setup calls for a separation of roles between those who setup/manage the
servers (setup apps on the servers - local admins on the server) and those
who will administer the application after it is installed. I am setup with
the System Administrator Role and with Content Manager in the HOME folder. I
am not able to connect to the SSRS instance via SSMS, where the local admins
(BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
way for the non local admins to use SSMS to administer SSRS?What is it that you are trying to do. Most of the type of admin type work to
do with RS is done via Report Manager (the protal that ships with RS).
Subscriptions, assigning roles, etc. What are you trying to do that you need
to use SSMS to do?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LTC" <LTC@.discussions.microsoft.com> wrote in message
news:A4AEDC9B-D588-4DDB-9729-F1A309EDCA39@.microsoft.com...
>I would like to be able to administer SQL Server Reporting Services (SSRS)
> via the SQL Server Management Studio (SSMS). It appears, in our setup at
> least, that the only individuals who are able to use the SSMS are those
> who
> are included in the BUILTIN\Administrators group (admins on the server).
> Our
> setup calls for a separation of roles between those who setup/manage the
> servers (setup apps on the servers - local admins on the server) and those
> who will administer the application after it is installed. I am setup
> with
> the System Administrator Role and with Content Manager in the HOME folder.
> I
> am not able to connect to the SSRS instance via SSMS, where the local
> admins
> (BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
> way for the non local admins to use SSMS to administer SSRS?|||I have been using Report Manager portal for RS, however I use the SSMS to
administer SS DBMS and SSAS. It would be more convenient to work all within
one tool.
"Bruce L-C [MVP]" wrote:
> What is it that you are trying to do. Most of the type of admin type work to
> do with RS is done via Report Manager (the protal that ships with RS).
> Subscriptions, assigning roles, etc. What are you trying to do that you need
> to use SSMS to do?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LTC" <LTC@.discussions.microsoft.com> wrote in message
> news:A4AEDC9B-D588-4DDB-9729-F1A309EDCA39@.microsoft.com...
> >I would like to be able to administer SQL Server Reporting Services (SSRS)
> > via the SQL Server Management Studio (SSMS). It appears, in our setup at
> > least, that the only individuals who are able to use the SSMS are those
> > who
> > are included in the BUILTIN\Administrators group (admins on the server).
> > Our
> > setup calls for a separation of roles between those who setup/manage the
> > servers (setup apps on the servers - local admins on the server) and those
> > who will administer the application after it is installed. I am setup
> > with
> > the System Administrator Role and with Content Manager in the HOME folder.
> > I
> > am not able to connect to the SSRS instance via SSMS, where the local
> > admins
> > (BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
> > way for the non local admins to use SSMS to administer SSRS?
>
>
via the SQL Server Management Studio (SSMS). It appears, in our setup at
least, that the only individuals who are able to use the SSMS are those who
are included in the BUILTIN\Administrators group (admins on the server). Our
setup calls for a separation of roles between those who setup/manage the
servers (setup apps on the servers - local admins on the server) and those
who will administer the application after it is installed. I am setup with
the System Administrator Role and with Content Manager in the HOME folder. I
am not able to connect to the SSRS instance via SSMS, where the local admins
(BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
way for the non local admins to use SSMS to administer SSRS?What is it that you are trying to do. Most of the type of admin type work to
do with RS is done via Report Manager (the protal that ships with RS).
Subscriptions, assigning roles, etc. What are you trying to do that you need
to use SSMS to do?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LTC" <LTC@.discussions.microsoft.com> wrote in message
news:A4AEDC9B-D588-4DDB-9729-F1A309EDCA39@.microsoft.com...
>I would like to be able to administer SQL Server Reporting Services (SSRS)
> via the SQL Server Management Studio (SSMS). It appears, in our setup at
> least, that the only individuals who are able to use the SSMS are those
> who
> are included in the BUILTIN\Administrators group (admins on the server).
> Our
> setup calls for a separation of roles between those who setup/manage the
> servers (setup apps on the servers - local admins on the server) and those
> who will administer the application after it is installed. I am setup
> with
> the System Administrator Role and with Content Manager in the HOME folder.
> I
> am not able to connect to the SSRS instance via SSMS, where the local
> admins
> (BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
> way for the non local admins to use SSMS to administer SSRS?|||I have been using Report Manager portal for RS, however I use the SSMS to
administer SS DBMS and SSAS. It would be more convenient to work all within
one tool.
"Bruce L-C [MVP]" wrote:
> What is it that you are trying to do. Most of the type of admin type work to
> do with RS is done via Report Manager (the protal that ships with RS).
> Subscriptions, assigning roles, etc. What are you trying to do that you need
> to use SSMS to do?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LTC" <LTC@.discussions.microsoft.com> wrote in message
> news:A4AEDC9B-D588-4DDB-9729-F1A309EDCA39@.microsoft.com...
> >I would like to be able to administer SQL Server Reporting Services (SSRS)
> > via the SQL Server Management Studio (SSMS). It appears, in our setup at
> > least, that the only individuals who are able to use the SSMS are those
> > who
> > are included in the BUILTIN\Administrators group (admins on the server).
> > Our
> > setup calls for a separation of roles between those who setup/manage the
> > servers (setup apps on the servers - local admins on the server) and those
> > who will administer the application after it is installed. I am setup
> > with
> > the System Administrator Role and with Content Manager in the HOME folder.
> > I
> > am not able to connect to the SSRS instance via SSMS, where the local
> > admins
> > (BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
> > way for the non local admins to use SSMS to administer SSRS?
>
>
Admin Version of WITH(UPDLOCK)?
Is there anything I can do from the Enterprise Manager console or from
within a JDBC connection to achieve the same effect as WITH(UPDLOCK)?
You can use SET TRANSACTION ISOLATION LEVEL to change the default isolation
level for the transaction. However, UPDLOCK does not map to an isolation
level, and in any case I don't think you would want that lock on every
SELECT statement. Maybe you can tell us a little more on what you want to
achieve?
Right now I'd be happy with even a minimal level of concurrency from SQL
Server via multiple JDBC connections. :-(
>
Right now I'd be happy with even a minimal level of concurrency from SQL
Server via multiple JDBC connections. :-(
>
The code/SQL we're using works like a charm when stress- / load-tested
against multiple users / threads under Oracle, Derby, MySQL, etc. but
deadlocks constantly and consistently under SQL Server.
>
So far WITH(UPDLOCK) doesn't seem to be doing much. Neither does
selectMethod=cursor. I'm not a DBA, so I figure there must be something
I'm not doing right (or not doing at all).
>
Either that, or every other SQL database on the planet is a *LOT* more
forgiving and/or better equipped to deal with deadlocks than SQL Server
is. More than happy at this point to be proved completely wrong. ;-)
Different DB-engines have different architectures, and what works well on
one engine may not work well on another, even if the code as such is
portable.
within a JDBC connection to achieve the same effect as WITH(UPDLOCK)?
Yes, I could change all of my SQL statements to include the lock... but
isn't there any way to set or tweak something in SQL Server so that I won't
have to hack a lot of code* to make things concurrent? Perhaps a way to set
UPDLOCK as the default behaviour for the server, or schema, or table, or
something?
Jerry H.
* == The existing SQL has to remain as generic as possible so that it can be
implemented for four other databases.Jerry Hewett (jerhewet@.yahoo.com) writes:
Quote:
Originally Posted by
Is there anything I can do from the Enterprise Manager console or from
within a JDBC connection to achieve the same effect as WITH(UPDLOCK)?
>
Yes, I could change all of my SQL statements to include the lock... but
isn't there any way to set or tweak something in SQL Server so that I
won't have to hack a lot of code* to make things concurrent? Perhaps a
way to set UPDLOCK as the default behaviour for the server, or schema,
or table, or something?
You can use SET TRANSACTION ISOLATION LEVEL to change the default isolation
level for the transaction. However, UPDLOCK does not map to an isolation
level, and in any case I don't think you would want that lock on every
SELECT statement. Maybe you can tell us a little more on what you want to
achieve?
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns980C634CC98A6Yazorman@.127.0.0.1...
Quote:
Originally Posted by
Maybe you can tell us a little more on what you want to achieve?
Right now I'd be happy with even a minimal level of concurrency from SQL
Server via multiple JDBC connections. :-(
The code/SQL we're using works like a charm when stress- / load-tested
against multiple users / threads under Oracle, Derby, MySQL, etc. but
deadlocks constantly and consistently under SQL Server.
So far WITH(UPDLOCK) doesn't seem to be doing much. Neither does
selectMethod=cursor. I'm not a DBA, so I figure there must be something I'm
not doing right (or not doing at all).
Either that, or every other SQL database on the planet is a *LOT* more
forgiving and/or better equipped to deal with deadlocks than SQL Server is.
More than happy at this point to be proved completely wrong. ;-)
Jerry H.|||Jerry Hewett (jerhewet@.yahoo.com) writes:
Quote:
Originally Posted by
"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns980C634CC98A6Yazorman@.127.0.0.1...
>
Quote:
Originally Posted by
>Maybe you can tell us a little more on what you want to achieve?
>
Right now I'd be happy with even a minimal level of concurrency from SQL
Server via multiple JDBC connections. :-(
>
The code/SQL we're using works like a charm when stress- / load-tested
against multiple users / threads under Oracle, Derby, MySQL, etc. but
deadlocks constantly and consistently under SQL Server.
>
So far WITH(UPDLOCK) doesn't seem to be doing much. Neither does
selectMethod=cursor. I'm not a DBA, so I figure there must be something
I'm not doing right (or not doing at all).
>
Either that, or every other SQL database on the planet is a *LOT* more
forgiving and/or better equipped to deal with deadlocks than SQL Server
is. More than happy at this point to be proved completely wrong. ;-)
Different DB-engines have different architectures, and what works well on
one engine may not work well on another, even if the code as such is
portable.
Since you did not include any information of what you are actually doing,
it's impossible to assist further.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Admin User Account from Front -end Interface
Hi all,
I would like to create User Account(mean user can admin
user account) from Front-end (using VB 6.0), pls give How
to, sample program or manual how to.
TIAYou can create a new SQL Server login account using sp_addlogin:
EXEC sp_addlogin 'AdminAccount', 'AdminPassword'
Or you can grant an existing windows account access to SQL Server with
sp_grantlogin:
EXEC sp_grantlogin 'MyDomain\AdminAccount'
If the account is to be a server administrator, you can add it to the
sysadmin server role:
EXEC sp_addsrvrolemember 'AdminAccount', 'sysadmin'
or
EXEC sp_addsrvrolemember 'MyDomain\AdminAccount', 'sysadmin'
Note that you shouldn't use a sysadmin login for routine application access.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
<thankch@.hotmail.com> wrote in message
news:045b01c3c9c3$6b3384d0$a301280a@.phx.gbl...
I would like to create User Account(mean user can admin
user account) from Front-end (using VB 6.0), pls give How
to, sample program or manual how to.
TIAYou can create a new SQL Server login account using sp_addlogin:
EXEC sp_addlogin 'AdminAccount', 'AdminPassword'
Or you can grant an existing windows account access to SQL Server with
sp_grantlogin:
EXEC sp_grantlogin 'MyDomain\AdminAccount'
If the account is to be a server administrator, you can add it to the
sysadmin server role:
EXEC sp_addsrvrolemember 'AdminAccount', 'sysadmin'
or
EXEC sp_addsrvrolemember 'MyDomain\AdminAccount', 'sysadmin'
Note that you shouldn't use a sysadmin login for routine application access.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
<thankch@.hotmail.com> wrote in message
news:045b01c3c9c3$6b3384d0$a301280a@.phx.gbl...
quote:
> Hi all,
> I would like to create User Account(mean user can admin
> user account) from Front-end (using VB 6.0), pls give How
> to, sample program or manual how to.
> TIA
>
admin tool for MSDE?
What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USA
My favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>
|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USA
My favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>
|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>
admin tool for MSDE?
What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>
admin tool for MSDE?
What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>> What admin tools are developers using for MSDE applications? If SQL
>> Server
>> Enterprise Manager is unavailable and the Web Access tool is just too
>> clunky, what else is popular?
>> Thanks,
>> Bill
>> Cincinnati,OH USA
>>
>
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>> What admin tools are developers using for MSDE applications? If SQL
>> Server
>> Enterprise Manager is unavailable and the Web Access tool is just too
>> clunky, what else is popular?
>> Thanks,
>> Bill
>> Cincinnati,OH USA
>>
>
Admin sql login
Hi all,
If I want to create Amin user in SQL and give that user all permissions like
sa login.
How would I do that without having to go into each database and creating
roles
or checking permissions for each task?
thanks
GVYou can add the user to the sysadmin fixed server role.
-Sue
On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@.musc.edu>
wrote:
>Hi all,
>If I want to create Amin user in SQL and give that user all permissions lik
e
>sa login.
>How would I do that without having to go into each database and creating
>roles
>or checking permissions for each task?
>thanks
>GV
>|||Thanks
GV
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:q6lq01d8hitujnvbqovus510hfgqo6m00k@.
4ax.com...
> You can add the user to the sysadmin fixed server role.
> -Sue
> On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@.musc.edu>
> wrote:
>
>
If I want to create Amin user in SQL and give that user all permissions like
sa login.
How would I do that without having to go into each database and creating
roles
or checking permissions for each task?
thanks
GVYou can add the user to the sysadmin fixed server role.
-Sue
On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@.musc.edu>
wrote:
>Hi all,
>If I want to create Amin user in SQL and give that user all permissions lik
e
>sa login.
>How would I do that without having to go into each database and creating
>roles
>or checking permissions for each task?
>thanks
>GV
>|||Thanks
GV
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:q6lq01d8hitujnvbqovus510hfgqo6m00k@.
4ax.com...
> You can add the user to the sysadmin fixed server role.
> -Sue
> On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@.musc.edu>
> wrote:
>
>
Admin role lost - inability to administer database
When I open SQL Server Enterprise Administrator to create or manipulate data
bases errors are thrown at me for not having appropriate permissions. Howeve
r, on one database I am able to modify its contents, tables and so forth.
How have I lost access? What can I do to fix it?Hi,
Are you trying to do this with a user with "DB_OWNER" role. In this case
only the database which is assigned this role will only have the permission.
If you have to perform administrative task on all databases then either
register using "SA" user or a Login with "Sys Admin" server fixed role.
How to identify the role assigned:
1. Login to Query Analyser as "SA"
2. Execute the procedure sp_helplogins <login name>
Note:
Automatically the permissions will never be lost / revoked in SQL server.
Thanks
Hari
MCDBA
"John Russell" <anonymous@.discussions.microsoft.com> wrote in message
news:46C5D23D-730B-4820-97B6-F6A710E73C81@.microsoft.com...
> When I open SQL Server Enterprise Administrator to create or manipulate
databases errors are thrown at me for not having appropriate permissions.
However, on one database I am able to modify its contents, tables and so
forth.
> How have I lost access? What can I do to fix it?
bases errors are thrown at me for not having appropriate permissions. Howeve
r, on one database I am able to modify its contents, tables and so forth.
How have I lost access? What can I do to fix it?Hi,
Are you trying to do this with a user with "DB_OWNER" role. In this case
only the database which is assigned this role will only have the permission.
If you have to perform administrative task on all databases then either
register using "SA" user or a Login with "Sys Admin" server fixed role.
How to identify the role assigned:
1. Login to Query Analyser as "SA"
2. Execute the procedure sp_helplogins <login name>
Note:
Automatically the permissions will never be lost / revoked in SQL server.
Thanks
Hari
MCDBA
"John Russell" <anonymous@.discussions.microsoft.com> wrote in message
news:46C5D23D-730B-4820-97B6-F6A710E73C81@.microsoft.com...
> When I open SQL Server Enterprise Administrator to create or manipulate
databases errors are thrown at me for not having appropriate permissions.
However, on one database I am able to modify its contents, tables and so
forth.
> How have I lost access? What can I do to fix it?
Admin rights to Report Manager disappeared...?
Hi,
Out of the blue I have lost administration rights to RS Report Manager. I
can no longer access several reports (others do work). When I connect to the
Report Manager the GUI is displayed, but I can't access all of the usual tabs
(ie. under the properties tab I can only see the 'General' and 'Security'
options, nothing else.)
I've tried accessing Report Manager via a client with domain admin rights
and via the RS server with local admin rights still the same problem...
Can anybody get me started on troubleshooting?
Kind Regards,
Casey.Casey,
I had this same problem...everything worked fine and then out of the
blue I couldn't update reports, deploy new reports, log into Report
Manager. I discovered that in Computer Management console when I Right
clicked on Default Web Site and went into Properties, then Directory
Security, then clicked on Anonymous Access and Authentication control,
and clicked the Edit button, that I did have Anonymous Access set.
When I tried to remote into that web server and perform changes I was
getting logged in as the anonymous user account with the limited rights
I gave that account. After hours when I'm working on the web server
now, I turn the anonymous option off, Restart IIS and do my
work...finally with the proper rights.
I hope this helps...
Jeff
Out of the blue I have lost administration rights to RS Report Manager. I
can no longer access several reports (others do work). When I connect to the
Report Manager the GUI is displayed, but I can't access all of the usual tabs
(ie. under the properties tab I can only see the 'General' and 'Security'
options, nothing else.)
I've tried accessing Report Manager via a client with domain admin rights
and via the RS server with local admin rights still the same problem...
Can anybody get me started on troubleshooting?
Kind Regards,
Casey.Casey,
I had this same problem...everything worked fine and then out of the
blue I couldn't update reports, deploy new reports, log into Report
Manager. I discovered that in Computer Management console when I Right
clicked on Default Web Site and went into Properties, then Directory
Security, then clicked on Anonymous Access and Authentication control,
and clicked the Edit button, that I did have Anonymous Access set.
When I tried to remote into that web server and perform changes I was
getting logged in as the anonymous user account with the limited rights
I gave that account. After hours when I'm working on the web server
now, I turn the anonymous option off, Restart IIS and do my
work...finally with the proper rights.
I hope this helps...
Jeff
admin realted questions
Hi
Few questions more newbie kind of things hope you can help out:
1- SQL 2000 on Windows 2000 ( and XP ), how can I utilize performance
monitoring tools on a daily basis to detect workload, usage and keep
it in a text file as a base line. What are thye most important parms
to set? Is perf monitor is part of SQL server or part of win2k or both
exacyly same?
2- Current activity in EM, has process info, locks/P ID and lock
Object. When these things can be really useful? Do I have to watch
them manually or is the a way to set it up? Is scripts do the better
job?
3- how can I see how much physical mem sql server used? how is the
process and memeory utilization? Can I set alarm if it goes very up I
get inform. How
4- Some basic scripts but important for daily DB check?
Thankssoalvajavab1@.yahoo.com (David McGeorge) wrote in message news:<bc907f76.0407271400.4e764384@.posting.google.com>...
> Hi
> Few questions more newbie kind of things hope you can help out:
> 1- SQL 2000 on Windows 2000 ( and XP ), how can I utilize performance
> monitoring tools on a daily basis to detect workload, usage and keep
> it in a text file as a base line. What are thye most important parms
> to set? Is perf monitor is part of SQL server or part of win2k or both
> exacyly same?
Performance monitor is an operating system tool, and it has numerous
counters for monitoring MSSQL. Check out "Monitoring Server
Performance and Activity" in Books Online for information about it,
and other tools such as Profiler. You might also find this helpful:
http://www.sql-server-performance.com/q&a84.asp
>
> 2- Current activity in EM, has process info, locks/P ID and lock
> Object. When these things can be really useful? Do I have to watch
> them manually or is the a way to set it up? Is scripts do the better
> job?
When one process is blocking another, you can use this information to
see what's going on, although personally I prefer sp_who2 for that
purpose.
>
> 3- how can I see how much physical mem sql server used? how is the
> process and memeory utilization? Can I set alarm if it goes very up I
> get inform. How
Performance Monitor can tell you the memory used by any process,
including MSSQL, and you can set alerts based on a threshold, either
from Perfmon itself or from the SQL Server Agent alerts dialogue. Note
that MSSQL will take all the memory on the server by default (unless
you configure it not to) - this is not a bad thing, unless you have
other applications running on the same server.
> 4- Some basic scripts but important for daily DB check?
Probably the easiest way to get going quickly is to create a
maintenance plan in Enterprise Manager. The plan can backup your
databases and/or perform integrity checks on them.
Simon
Admin Performance Issues, Large amount of DBs
I have a large amout of dbs (150) on my SQL Server and when using the enterprise manager to do administrational tasks like Backup, Restore etc. it takes 1.5 hour to open the Database folder. Server is 2xP4, 3Gb RAM. Any ideas on how to manage this number of dbs on the same server and instance of SQL.
Cheers!Use scripts ?
-PatP|||If you can run utilities on server itself, register server as "(LOCAL)" which is local named pipes. Also make sure "Enable shared memory protocol" is checked in Client Network Utility on server.
Otherwise if you can not use server console to run utilities make sure you use TCP/IP protocol.
Hans.
Cheers!Use scripts ?
-PatP|||If you can run utilities on server itself, register server as "(LOCAL)" which is local named pipes. Also make sure "Enable shared memory protocol" is checked in Client Network Utility on server.
Otherwise if you can not use server console to run utilities make sure you use TCP/IP protocol.
Hans.
Admin password for new installtion
Hi,
I just installed VS.NET 2005 on my computer and along the way SQL Server Express edition got installed too. What is the default sa password right out of the box? I actually want to use Windows authentication but was not able to set my domain account in there w/ administrative rights. I'd appreciate some help here.
Thanks,
Sam
My guess is that the default installation here uses Windows authentication and does not set an sa password. You can use any of the management tools (Management Tools Express in Express Advanced) or T-SQL to set the sa password and change the authentication method.
Thanks,
Sam Lester (MSFT)
Admin password
After I changed my admin password in Windows, my SQL Server Service Manager
(i.e. the Agent) no longer starts up. How do I fix this?
Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you dont need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.
But keep the following quote from MS in mind: "Security Note The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> After I changed my admin password in Windows, my SQL Server Service
> Manager
> (i.e. the Agent) no longer starts up. How do I fix this?
>
(i.e. the Agent) no longer starts up. How do I fix this?
Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you dont need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.
But keep the following quote from MS in mind: "Security Note The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> After I changed my admin password in Windows, my SQL Server Service
> Manager
> (i.e. the Agent) no longer starts up. How do I fix this?
>
Admin password
After I changed my admin password in Windows, my SQL Server Service Manager
(i.e. the Agent) no longer starts up. How do I fix this?Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you dont need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.
But keep the following quote from MS in mind: "Security Note The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> After I changed my admin password in Windows, my SQL Server Service
> Manager
> (i.e. the Agent) no longer starts up. How do I fix this?
>
(i.e. the Agent) no longer starts up. How do I fix this?Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you dont need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.
But keep the following quote from MS in mind: "Security Note The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> After I changed my admin password in Windows, my SQL Server Service
> Manager
> (i.e. the Agent) no longer starts up. How do I fix this?
>
Admin password
After I changed my admin password in Windows, my SQL Server Service Manager
(i.e. the Agent) no longer starts up. How do I fix this?Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you don´t need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.
But keep the following quote from MS in mind: "Security Note The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> After I changed my admin password in Windows, my SQL Server Service
> Manager
> (i.e. the Agent) no longer starts up. How do I fix this?
>
(i.e. the Agent) no longer starts up. How do I fix this?Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you don´t need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.
But keep the following quote from MS in mind: "Security Note The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> After I changed my admin password in Windows, my SQL Server Service
> Manager
> (i.e. the Agent) no longer starts up. How do I fix this?
>
admin or other role
I have one other question. How do you define roles? What role(s) are required to fully administer SQL Server? What role(s) are required to fully administer a single database in SQL Server?
thanks,
In Books Online, look up [fixed server roles] and [fixed database roles].
Those roles are predefined. You can also create your own roles (which only has permissions that you grant to them.)
Full server administration = sysadmin.
Single database administration = db_owner.
admin name change does not allow mssql to start up
I installed mssql 2K when the sys admin acount name was adminis1. I used that as the service startup account. Everything worked fine. I had to change the sys admin account name to adminis2. When I rebooted Mssql would not start up (because adminis1 did not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local standards thing)
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
admin name change does not allow mssql to start up
I installed mssql 2K when the sys admin acount name was adminis1. I used that as the service startup account. Everything worked fine. I had to change the sys admin account name to adminis2. When I rebooted Mssql would not start up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?
Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
d not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?
Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
admin name change does not allow mssql to start up
I installed mssql 2K when the sys admin acount name was adminis1. I used th
at as the service startup account. Everything worked fine. I had to change
the sys admin account name to adminis2. When I rebooted Mssql would not st
art up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) th
en rebooted but mssql would still not start. I renamed the sys admin accoun
t back to the original name and now mssql starts up. We still need to go to
the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
at as the service startup account. Everything worked fine. I had to change
the sys admin account name to adminis2. When I rebooted Mssql would not st
art up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) th
en rebooted but mssql would still not start. I renamed the sys admin accoun
t back to the original name and now mssql starts up. We still need to go to
the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)