Environment users and logins

Hi
We are currently migrating from MSSQL 2000 enterprice to MSSQL 2005
Enterprice, and with that doing a revision of our users.
We would like to be able to do a restore a backup of Production to test.
We would like user privileges on the servers to differ so a given user can
execute some stored procedures on one environment but not the other. Say, we
don’t want a service in test with the wrong connection string to be have
access to production.
We have previously done this by using local user groups on the servers, but
we loose the mapping between the Login name and the user name when we do the
restores.
Any ideas or best practices?
Best regards
MikaelMikael
> We would like to be able to do a restore a backup of Production to test.
No problem, just RESTORE command

> We would like user privileges on the servers to differ so a given user can
> execute some stored procedures on one environment but not the other. Say,
> we
> dont want a service in test with the wrong connection string to be have
> access to production.
MS has introduced in SS2005 lots of new features, like SCHEMA for example.
I'd suggets you to spend a hew days to study it

> We have previously done this by using local user groups on the servers,
> but
> we loose the mapping between the Login name and the user name when we do
> the
> restores.
http://blogs.msdn.com/lcris/archive.../03/567680.aspx
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:48261D3D-86AC-4B6F-8B0A-380101564866@.microsoft.com...
> Hi
> We are currently migrating from MSSQL 2000 enterprice to MSSQL 2005
> Enterprice, and with that doing a revision of our users.
> We would like to be able to do a restore a backup of Production to test.
> We would like user privileges on the servers to differ so a given user can
> execute some stored procedures on one environment but not the other. Say,
> we
> dont want a service in test with the wrong connection string to be have
> access to production.
> We have previously done this by using local user groups on the servers,
> but
> we loose the mapping between the Login name and the user name when we do
> the
> restores.
> Any ideas or best practices?
>
> --
> Best regards
> Mikael

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
Julian
Julian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>
|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who
> is
>
sql

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who[vbcol=seagreen]
> is
>

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How Can I list the users in an NT group, ie I have user Joe Bloggs
who
> is
> > in NT Group Domain/Users.
> >
> > I need to return to a client app what group they are in.
> >
> > Julian
> >
> >
>

Entity Deletion Strategy

Hi,
I'm wondering what the standard practise is for dealing with the
following very common scenario:
You have users who can use your application and they are identified by
email address. Sometimes you want to delete one of these users. You
want to keep some reference to them in the DB for auditing purposes.
Also, you want to be able to free up that email address so it can be
used again.
It seems to me there are two options:
Keep the user in the User table but set its "status" to "deleted". The
problem thought is that now many of the queries against the user table
will have to check status.
Delete the user from the User table, but have it stored in some other
table, a UserAudit table for example.
Is there a standard way of doing this? If so, how is it done? Thanks.Hi
As long as the email address does not have a unique index or is the primary
key you can use the status flag. Depending on how many deleted users you have
(or if you see a significant degredation of performance) then you may or may
not want to partition the table (or create a partitioned view). To remove the
need to add the status check to every where clause you can create an active
users view (and keep table name) of the table. To implement a partioned view
would be the flip side of this (create an new table and transfer the table
name to the partitoned view), once you are using the active users table/view
there would be no T-SQL code change involved with changing over to the other
model.
John
"nickgieschen@.gmail.com" wrote:
> Hi,
> I'm wondering what the standard practise is for dealing with the
> following very common scenario:
> You have users who can use your application and they are identified by
> email address. Sometimes you want to delete one of these users. You
> want to keep some reference to them in the DB for auditing purposes.
> Also, you want to be able to free up that email address so it can be
> used again.
> It seems to me there are two options:
> Keep the user in the User table but set its "status" to "deleted". The
> problem thought is that now many of the queries against the user table
> will have to check status.
> Delete the user from the User table, but have it stored in some other
> table, a UserAudit table for example.
> Is there a standard way of doing this? If so, how is it done? Thanks.
>|||John Bell wrote:
> Hi
> As long as the email address does not have a unique index or is the primary
> key you can use the status flag. Depending on how many deleted users you have
> (or if you see a significant degredation of performance) then you may or may
> not want to partition the table (or create a partitioned view). To remove the
> need to add the status check to every where clause you can create an active
> users view (and keep table name) of the table. To implement a partioned view
> would be the flip side of this (create an new table and transfer the table
> name to the partitoned view), once you are using the active users table/view
> there would be no T-SQL code change involved with changing over to the other
> model.
> John
> "nickgieschen@.gmail.com" wrote:
> > Hi,
> >
> > I'm wondering what the standard practise is for dealing with the
> > following very common scenario:
> >
> > You have users who can use your application and they are identified by
> > email address. Sometimes you want to delete one of these users. You
> > want to keep some reference to them in the DB for auditing purposes.
> > Also, you want to be able to free up that email address so it can be
> > used again.
> >
> > It seems to me there are two options:
> >
> > Keep the user in the User table but set its "status" to "deleted". The
> > problem thought is that now many of the queries against the user table
> > will have to check status.
> >
> > Delete the user from the User table, but have it stored in some other
> > table, a UserAudit table for example.
> >
> > Is there a standard way of doing this? If so, how is it done? Thanks.
> >
> >
You can create a trigger and when you will delete rows deleted rows
will be inserted to history table. So you can create a primary key or
unique key on email address.
Regards
Amish Shah
http://shahamishm.tripod.com

Entity Deletion Strategy

Hi,
I'm wondering what the standard practise is for dealing with the
following very common scenario:
You have users who can use your application and they are identified by
email address. Sometimes you want to delete one of these users. You
want to keep some reference to them in the DB for auditing purposes.
Also, you want to be able to free up that email address so it can be
used again.
It seems to me there are two options:
Keep the user in the User table but set its "status" to "deleted". The
problem thought is that now many of the queries against the user table
will have to check status.
Delete the user from the User table, but have it stored in some other
table, a UserAudit table for example.
Is there a standard way of doing this? If so, how is it done? Thanks.Hi
As long as the email address does not have a unique index or is the primary
key you can use the status flag. Depending on how many deleted users you hav
e
(or if you see a significant degredation of performance) then you may or may
not want to partition the table (or create a partitioned view). To remove th
e
need to add the status check to every where clause you can create an active
users view (and keep table name) of the table. To implement a partioned view
would be the flip side of this (create an new table and transfer the table
name to the partitoned view), once you are using the active users table/view
there would be no T-SQL code change involved with changing over to the other
model.
John
"nickgieschen@.gmail.com" wrote:

> Hi,
> I'm wondering what the standard practise is for dealing with the
> following very common scenario:
> You have users who can use your application and they are identified by
> email address. Sometimes you want to delete one of these users. You
> want to keep some reference to them in the DB for auditing purposes.
> Also, you want to be able to free up that email address so it can be
> used again.
> It seems to me there are two options:
> Keep the user in the User table but set its "status" to "deleted". The
> problem thought is that now many of the queries against the user table
> will have to check status.
> Delete the user from the User table, but have it stored in some other
> table, a UserAudit table for example.
> Is there a standard way of doing this? If so, how is it done? Thanks.
>|||John Bell wrote:
[vbcol=seagreen]
> Hi
> As long as the email address does not have a unique index or is the primar
y
> key you can use the status flag. Depending on how many deleted users you h
ave
> (or if you see a significant degredation of performance) then you may or m
ay
> not want to partition the table (or create a partitioned view). To remove
the
> need to add the status check to every where clause you can create an activ
e
> users view (and keep table name) of the table. To implement a partioned vi
ew
> would be the flip side of this (create an new table and transfer the table
> name to the partitoned view), once you are using the active users table/vi
ew
> there would be no T-SQL code change involved with changing over to the oth
er
> model.
> John
> "nickgieschen@.gmail.com" wrote:
>
You can create a trigger and when you will delete rows deleted rows
will be inserted to history table. So you can create a primary key or
unique key on email address.
Regards
Amish Shah
http://shahamishm.tripod.comsql

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Enterprise Mgr as an end-user data manipulation tool

As DBAs we typically restrict the use of Enterprise Manager and other DBA
Admin type utilities from end-users. Even with a user's SQL server
permissions being appropriately defined and restricted, to limit their
abilities within Enterprise Manager, I typically do not allow end users to
use Enterprise Manager, for the same reason that an Exchange administrator
doesn't allow end-users to run Exchange Administrator to manage their
mailbox. It's an administration utility and is not intended as a data
manipulation interface.
I am faced with a unique situation where a 'power user' insists on wanting
to use SQL Enterprise Manager to access a particular database to which he has
read/write permissions to the production data, as he wants to browse and
modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on a
table and selecting the 'Open, Return All Rows', etc. Due to political
reasons beyond my control, it appears that I will be 'told' to let him use
Enterprise Manager by upper management, so that the user can manage the data
via SQL EM.
Outside of the technical reasons why an end-user should not be using SQL
Enterprise Manager as the GUI to manage data within a database, even with
proper security, does anyone know of official audit guidelines that would
raise a 'red flag' if an audit determined that an end-user(s) were managing
data via SQL Enterprise Manager?
Thanks
D
Apart from read/write to certain tables in the DB, what other rights does
this user have within the server and database? The fact that an end-user
can (knowingly or not), if their rights aren't severely restricted, drop a
table, access and modify security/login info, modify/overwrite/delete
backups, add/remove indexes, etc. would make me wary.
Maybe you can suggest to them that this guy use Access as the front end, and
Link the tables he needs into Access so he can edit to his heart's content
without getting anywhere near EM?
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:D8E94FA5-3F83-4B63-9EFA-1A65F14C1857@.microsoft.com...
> As DBAs we typically restrict the use of Enterprise Manager and other DBA
> Admin type utilities from end-users. Even with a user's SQL server
> permissions being appropriately defined and restricted, to limit their
> abilities within Enterprise Manager, I typically do not allow end users to
> use Enterprise Manager, for the same reason that an Exchange administrator
> doesn't allow end-users to run Exchange Administrator to manage their
> mailbox. It's an administration utility and is not intended as a data
> manipulation interface.
> I am faced with a unique situation where a 'power user' insists on wanting
> to use SQL Enterprise Manager to access a particular database to which he
> has
> read/write permissions to the production data, as he wants to browse and
> modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on
> a
> table and selecting the 'Open, Return All Rows', etc. Due to political
> reasons beyond my control, it appears that I will be 'told' to let him use
> Enterprise Manager by upper management, so that the user can manage the
> data
> via SQL EM.
> Outside of the technical reasons why an end-user should not be using SQL
> Enterprise Manager as the GUI to manage data within a database, even with
> proper security, does anyone know of official audit guidelines that would
> raise a 'red flag' if an audit determined that an end-user(s) were
> managing
> data via SQL Enterprise Manager?
> Thanks
> D

Enterprise Manger Crash Creating user

Please can you help with this?
I created a new users for the first time in SQL Server 2000. While doing
that, Enterprise Manager crashed...and:
1. If I try to add the user again, I get an error because the User already
exists...yet I cannot see it on the console.
2. The user name does not show under Users (or Roles)
Any idea what I need to do to fix it - or what I might be doing wrong?
Is there a problem with Enterprise manager, how can it be fixed? (Looks to
me like it fails while waiting for a response from NT...)Patrik
Open Query Analyzer and use
sp_adduser ,sp_dropuser system stored procedures
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
> Please can you help with this?
> I created a new users for the first time in SQL Server 2000. While
> doing
> that, Enterprise Manager crashed...and:
> 1. If I try to add the user again, I get an error because the User already
> exists...yet I cannot see it on the console.
> 2. The user name does not show under Users (or Roles)
> Any idea what I need to do to fix it - or what I might be doing wrong?
> Is there a problem with Enterprise manager, how can it be fixed? (Looks
> to
> me like it fails while waiting for a response from NT...)
>|||Thx.
Q. Does a SQL Server User Id have be created on the NT Server on which SQL
Server resides? Or can the NT user id be on another server?
"Uri Dimant" wrote:

> Patrik
> Open Query Analyzer and use
> sp_adduser ,sp_dropuser system stored procedures
>
>
>
> "Patrick" <Patrick@.discussions.microsoft.com> wrote in message
> news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
>
>|||Patrick
Users and Logins are two different things
1)Logins are created to allow the person access to SQL Server .
2) Users are created to grant/allow access to the database/s located on the
server
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:21715426-1674-48EE-A782-0709C183E456@.microsoft.com...[vbcol=seagreen]
> Thx.
> Q. Does a SQL Server User Id have be created on the NT Server on which
> SQL
> Server resides? Or can the NT user id be on another server?
> "Uri Dimant" wrote:
>

Enterprise Manager Very Slow on one PC

I have had a problem with EM being extremely slow. The first time this
ocurred it was related to one users Windows Logon Profile... i.e. whichever
PC he logged onto, EM was very slow to connect and run. It turned out his
Windows Network roaming profile was corrupt and fixing this solved the
problem.
I now have the same problem on my PC but it is PC dependant... i.e. it
doesn't matter who logs onto this PC, EM is always slow. If I log onto
another PC EM runs fine.
Any ideas what may have gone wrong on my PC?
Could it be Windows registry values that are incorrect? If so is there a way
of checking these registry values?
I have tried creating a new Windows logon profile and uninstalling and
reinstalling EM. I do not want to have to resort to rebuilding the PC.
Any ideas would be great
Thanks
Martyn
Did you check to see if ODBC tracing is turned on? You can
check from the ODBC data source administrator, go to the
tracing tab. If the button on the left has the caption Stop
Tracing Now, the tracing is turned on. Click on the button
and the caption will change to start tracing now - meaning
that tracing is turned off.
-Sue
On Thu, 23 Sep 2004 01:35:03 -0700, "martynhogg"
<martynhogg@.discussions.microsoft.com> wrote:

>I have had a problem with EM being extremely slow. The first time this
>ocurred it was related to one users Windows Logon Profile... i.e. whichever
>PC he logged onto, EM was very slow to connect and run. It turned out his
>Windows Network roaming profile was corrupt and fixing this solved the
>problem.
>I now have the same problem on my PC but it is PC dependant... i.e. it
>doesn't matter who logs onto this PC, EM is always slow. If I log onto
>another PC EM runs fine.
>Any ideas what may have gone wrong on my PC?
>Could it be Windows registry values that are incorrect? If so is there a way
>of checking these registry values?
>I have tried creating a new Windows logon profile and uninstalling and
>reinstalling EM. I do not want to have to resort to rebuilding the PC.
>Any ideas would be great
>Thanks
>Martyn
|||Sue, you are a genius!!! I've posted on several sites and no-one could answer
this one. It worked! Thankyou so much!
Martyn
"Sue Hoegemeier" wrote:

> Did you check to see if ODBC tracing is turned on? You can
> check from the ODBC data source administrator, go to the
> tracing tab. If the button on the left has the caption Stop
> Tracing Now, the tracing is turned on. Click on the button
> and the caption will change to start tracing now - meaning
> that tracing is turned off.
> -Sue
> On Thu, 23 Sep 2004 01:35:03 -0700, "martynhogg"
> <martynhogg@.discussions.microsoft.com> wrote:
>
>
sql

Enterprise Manager Query Tool

We have noticed some random failures to write data to some
of our databases. In the
research that I have done I think it is being caused by
users querying the tables
with Enterprise Manager's Query Tool. I am seeing table
level locks that are granted
against the table in Mode IS. I am interpreting this to
mean that there is an 'Shared
Intent' Lock on that table. Which to my understanding
means that anyone can continue
to read but that I have also declared an intent to update
the table and therefore
requests for exclusive locks for update, insert or delete
operations would block
until my intent lock is removed. If the block occurs for
too long the blocked call
would then timeout. I believe that Enterprise Manager is
creating this type of lock
because the user interface allows the data that is
displayed to be updated and if the
Intent lock was not declared then data syncronization
issues would occur.
For now I have instructed people who access the tables to
use Query Analyzer since it
will only lock when queries that require the lock are
executed and will not hold the
lock while the user browses the results.
My questions are as follows:
1) Is my interpretation of the IS Mode Table lock correct?
2) Is there a way to prevent Enterprise Manager from
locking the table in this way
(i.e. make the query results read-only)?
3) If the user that is performing the query only has
dbreader privledges then why is
the Intent lock being created?
Thanxshttp://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
":)" <anonymous@.discussions.microsoft.com> wrote in message
news:535b01c4003c$1ec4aca0$a301280a@.phx.gbl...
> We have noticed some random failures to write data to some
> of our databases. In the
> research that I have done I think it is being caused by
> users querying the tables
> with Enterprise Manager's Query Tool. I am seeing table
> level locks that are granted
> against the table in Mode IS. I am interpreting this to
> mean that there is an 'Shared
> Intent' Lock on that table. Which to my understanding
> means that anyone can continue
> to read but that I have also declared an intent to update
> the table and therefore
> requests for exclusive locks for update, insert or delete
> operations would block
> until my intent lock is removed. If the block occurs for
> too long the blocked call
> would then timeout. I believe that Enterprise Manager is
> creating this type of lock
> because the user interface allows the data that is
> displayed to be updated and if the
> Intent lock was not declared then data syncronization
> issues would occur.
> For now I have instructed people who access the tables to
> use Query Analyzer since it
> will only lock when queries that require the lock are
> executed and will not hold the
> lock while the user browses the results.
> My questions are as follows:
> 1) Is my interpretation of the IS Mode Table lock correct?
> 2) Is there a way to prevent Enterprise Manager from
> locking the table in this way
> (i.e. make the query results read-only)?
> 3) If the user that is performing the query only has
> dbreader privledges then why is
> the Intent lock being created?
> Thanxs

Enterprise Manager problem

When a database is restored Enterprise Manager does not display the users
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
--
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no change.
> I notice that when I reinstall Enterprise Manager it immediately displays my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.
> My install is the only one that does not show the users.
> "bassbuster" wrote:
> > When a database is restored Enterprise Manager does not display the
users
> > for the restored database. The account I am signing in with has the
correct
> > rights. I have uninstalled Enterprise Manager and reinstalled with no
change.
> > I notice that when I reinstall Enterprise Manager it immediately
displays my
> > server connections. Which file holds this information and is this file
the
> > likely culprit? Any ideas for solving the issue?

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
Derek
Hi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>
|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:

>Hello,
>I have an interesting situation: We have some remote users who connect to a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>
|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com... [vbcol=seagreen]
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
to a[vbcol=seagreen]
for[vbcol=seagreen]
registration
>
|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:

>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com.. .
>to a
>for
>registration
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
DerekHi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:

>Hello,
>I have an interesting situation: We have some remote users who connect to
a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.
4ax.com...
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
>
to a[vbcol=seagreen]
for[vbcol=seagreen]
registration[vbcol=seagreen]
>|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:

>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.
4ax.com...
>to a
>for
>registration
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
DerekHi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:
>Hello,
>I have an interesting situation: We have some remote users who connect to a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com...
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
> >Hello,
> >
> >I have an interesting situation: We have some remote users who connect
to a
> >SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> >their machines Accoutn Logon errors are generated in on the SQL server
for
> >the login that they are logged onto their computer with. The
registration
> >for the server specifically uses SQL security to authenticate.
> >
> >Anybody have any idea why Ent. Manager would be causing this?
> >
> >Derek
> >
> >
>|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:
>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com...
>> It could be the polling of the services from the clients.
>> You can try turning off the polling on the clients and see
>> if that makes a difference.
>> In Enterprise Manager, go to tools then select options.
>> Clear the checkbox for Server State Polling on the
>> General tab.
>> -Sue
>> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
>> wrote:
>> >Hello,
>> >
>> >I have an interesting situation: We have some remote users who connect
>to a
>> >SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>> >their machines Accoutn Logon errors are generated in on the SQL server
>for
>> >the login that they are logged onto their computer with. The
>registration
>> >for the server specifically uses SQL security to authenticate.
>> >
>> >Anybody have any idea why Ent. Manager would be causing this?
>> >
>> >Derek
>> >
>> >
>

Enterprise manager - Prevent Users from seeing other databases

Is there someway to prevent SQL2000 users seeing other databases in the
list, when they connect using enterprising manager. The login-security
prevents them from modifying other db & tables, but is there some way list
only the database the user has access too. Somewhat like this utility at
http://www.aspenterprisemanager.com does.
Regards
Arijit
Not currently. This will be in the next version.
Andrew J. Kelly SQL MVP
"Arijit Upadhyay" <arijit@.ganashakti.co.in> wrote in message
news:uY9%23giCJEHA.4016@.tk2msftngp13.phx.gbl...
> Is there someway to prevent SQL2000 users seeing other databases in the
> list, when they connect using enterprising manager. The login-security
> prevents them from modifying other db & tables, but is there some way list
> only the database the user has access too. Somewhat like this utility at
> http://www.aspenterprisemanager.com does.
> Regards
> Arijit
>

Entering Notes/Comments/Remarks to Report

Hi, there,

We intended to create a report that allows users to enter remarks, comments or additional notes in supporting the report.

Can it be done in SSRS? FYI, we are using SQL Server 2005 Enterprise.

Thank you.

Regards,

Yong Hwee

You want to annotate within the report, or you want to add extended properties to the report? If it is the first, then there is no way without changing the RDL or annotating the exported format. If it is the second, then you can use SetProperties/GetProperties to write/retrieve extended properties (including your annotations) programmatically.|||

Hi, John,

Thank you for your reply. Sorry for my ignorance. In fact, we are still thinking the way to cater this requirement. Currently, the report is in Excel workbook. Annotations are entered directly to the workbook. Users are producing this report every mth. If possible, we would like users to enter the annotations to the report and saved. It seems like the second method using SetProperties/GetProperties is the better choice but what are the possible ways of implemeting it?

We are looking for a intuitive solution that allows monthly reports to be saved and retrieved later. The results in the saved reports should not change irregardless of the underlying source. I think this is just like the 'report snapshot' in SSRS.

Thank you.

Regards,

Yong Hwee

|||You can use history snapshots for archiving previously generated reports, but we don't support setting/getting properties on individual snapshots, only the report item itself.|||

Hi, John,

Thank you for the reply.

Regards,

Yong Hwee

Entering Notes/Comments/Remarks to Report

Hi, there,

We intended to create a report that allows users to enter remarks, comments or additional notes in supporting the report.

Can it be done in SSRS? FYI, we are using SQL Server 2005 Enterprise.

Thank you.

Regards,

Yong Hwee

You want to annotate within the report, or you want to add extended properties to the report? If it is the first, then there is no way without changing the RDL or annotating the exported format. If it is the second, then you can use SetProperties/GetProperties to write/retrieve extended properties (including your annotations) programmatically.|||

Hi, John,

Thank you for your reply. Sorry for my ignorance. In fact, we are still thinking the way to cater this requirement. Currently, the report is in Excel workbook. Annotations are entered directly to the workbook. Users are producing this report every mth. If possible, we would like users to enter the annotations to the report and saved. It seems like the second method using SetProperties/GetProperties is the better choice but what are the possible ways of implemeting it?

We are looking for a intuitive solution that allows monthly reports to be saved and retrieved later. The results in the saved reports should not change irregardless of the underlying source. I think this is just like the 'report snapshot' in SSRS.

Thank you.

Regards,

Yong Hwee

|||You can use history snapshots for archiving previously generated reports, but we don't support setting/getting properties on individual snapshots, only the report item itself.|||

Hi, John,

Thank you for the reply.

Regards,

Yong Hwee