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.[vbcol=seagreen]
> My install is the only one that does not show the users.
> "bassbuster" wrote:
users[vbcol=seagreen]
correct[vbcol=seagreen]
change.[vbcol=seagreen]
displays my[vbcol=seagreen]
the[vbcol=seagreen]

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 correc
t
> rights. I have uninstalled Enterprise Manager and reinstalled with no chan
ge.
> 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.[vbcol=seagreen]
> My install is the only one that does not show the users.
> "bassbuster" wrote:
>
users[vbcol=seagreen]
correct[vbcol=seagreen]
change.[vbcol=seagreen]
displays my[vbcol=seagreen]
the[vbcol=seagreen]

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 Cannot Display Table Records or Run Query

I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot view table data or use the Query part of EM. When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using the credentials you supplied." I believe that this is a EM issue as I cannot view table content on other remote server. ANy ideas? Might this be an IE security patch disallowing some connectivity ?

--Frank

--
Message posted via http://www.sqlmonster.com"Frank Rizzo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:08f32b66479d4ddcbe5ab7a876ff377d@.SQLMonster.c om...
>I have a new installation of SQL Server 2000 Dev Edition on a Win2K3
>Standard Edition Server that I used for development. I just set this
>machine up in th last week and installed all Win2K3 patches and then
>installed SQL2K and SP3a. I have a single named instance. I just noticed
>today that I cannot view table data or use the Query part of EM. When I
>right click a table and select Open Table->Return All Rows it gives me an
>error dialog "An unexpected error happened during this operation". While
>the EM is diplaying this dialog the EM screen looks like Internet Explorer
>and says "Action Canceled - You might not have permission to view this
>directory or page using the credentials you supplied." I believe that this
>is a EM issue as I cannot view table content on other remote server. ANy
>ideas? Might this be an IE security patch disallowing some connectivity ?
> --Frank
> --
> Message posted via http://www.sqlmonster.com

A number of people seem to have had similar issues - if you Google the
newsgroups, you'll see that the usual response is to reinstall either the
MSSQL client tools (including SP3a) and/or the latest MDAC version.
Unfortunately, it doesn't always seem to solve the problem.

Simon

enterprise manager alignment problem

Hi,
After I installed SP3 for MSSQL 2000, the display in the enterprise manager
is not as before. There is an alignment problem of right to left.
For example when displaying all rows of a table, the rows of the datagarid
are aligned
to the right instead to the left.
How can I fix it?
--
Ohad Young
Medical Informatics Research Center
Ben Gurion University
Information System Eng
Office Phone: 972-8-6477160
Cellular Phone: 972-54-518301
E-Mail: ohadyn@.bgumail.bgu.ac.ilHi Sue,
Yes, the locale (in the regional settings) are set to English(United
States).
It was OK before I installed SP3. It only started after SP3 was installed.
Ohad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
> I've seen this once or twice before with different regional
> settings. Is your locale set to English(United States) ? If
> not, try setting to that and see if the alignment goes back
> to what you expected.
> -Sue
> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
> <ohadyn@.bgumail.bgu.ac.il> wrote:
> >Hi,
> >After I installed SP3 for MSSQL 2000, the display in the enterprise
manager
> >is not as before. There is an alignment problem of right to left.
> >For example when displaying all rows of a table, the rows of the
datagarid
> >are aligned
> >to the right instead to the left.
> >
> >How can I fix it?
>|||I'm out of ideas - I've only seen it with the locale issue.
I'd check that the same SPs were applied to server and
clients. I'd check MDAC configuration/versions as well.
Maybe someone else has some ideas on whatever else could be
going on.
-Sue
On Tue, 26 Aug 2003 20:41:40 +0200, "Ohad Young"
<ohadyn@.bgumail.bgu.ac.il> wrote:
>Hi Sue,
>Yes, the locale (in the regional settings) are set to English(United
>States).
>It was OK before I installed SP3. It only started after SP3 was installed.
>Ohad
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
>> I've seen this once or twice before with different regional
>> settings. Is your locale set to English(United States) ? If
>> not, try setting to that and see if the alignment goes back
>> to what you expected.
>> -Sue
>> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
>> <ohadyn@.bgumail.bgu.ac.il> wrote:
>> >Hi,
>> >After I installed SP3 for MSSQL 2000, the display in the enterprise
>manager
>> >is not as before. There is an alignment problem of right to left.
>> >For example when displaying all rows of a table, the rows of the
>datagarid
>> >are aligned
>> >to the right instead to the left.
>> >
>> >How can I fix it?
>|||Hi Ohad,
This problem is strange. Do you mean the SQL Enterprise Manager and SQL
Server are installed on the same machine? Does this problem occur on the
other computer? Maybe you could try to reinstall the SQL Server Enterprise
Manager, and then check to see if the problem occurs again. For more
information regarding installing the SQL Server Enterprise Manager, please
refer to the article below:
This step-by-step guide describes how to install a SQL Server 2000 basic
local installation.
303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
http://support.microsoft.com/?id=303747
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
I have the same alignment problem with EM sp3 on both WinXP and Win2K.
When the locale is set to Hebrew, the EM screens (layout and data) are
aligned to the right.
Changing the locale to English fixes the problem on both platforms.
I must use hebrew as my locale, otherwise outlook and other apps
display hebrew text as gibberish...
Ofer
v-yshao@.online.microsoft.com (Michael Shao [MSFT]) wrote in message news:<YevPw1JbDHA.2116@.cpmsftngxa06.phx.gbl>...
> Hi Ohad,
> This problem is strange. Do you mean the SQL Enterprise Manager and SQL
> Server are installed on the same machine? Does this problem occur on the
> other computer? Maybe you could try to reinstall the SQL Server Enterprise
> Manager, and then check to see if the problem occurs again. For more
> information regarding installing the SQL Server Enterprise Manager, please
> refer to the article below:
> This step-by-step guide describes how to install a SQL Server 2000 basic
> local installation.
> 303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
> http://support.microsoft.com/?id=303747
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.|||Hello Ohad,
My name is Venu Cherukupalli and I will be the
support engineer working with you on this issue. I have sent an EMail to
you regarding the action plan but I did not get any response. As per that
Email, the action plan is
1) Send me a screenshot of the Enterprise Manager which is posing problems.
2) Using Access, try to create a Linked Table to a SQL Server and see if
you notice the same problem in the designer.
Let me know if you have any questions or concerns.
Thanks
Venu Cherukupalli
Microsoft SQL Server Support

Enterprise Manager - Want to display date in different format

Currently I am using Enterprise Manager to see the table content. It is
displaying date in American format but i want to view it as British date.
How can i change the settings so that i can view it differently ?
regards
Manisha
"manisha_css" wrote:

> Currently I am using Enterprise Manager to see the table content. It is
> displaying date in American format but i want to view it as British date.
> How can i change the settings so that i can view it differently ?
> regards
> Manisha
Manisha -
Try following Steps :-
1. Go to EM
2. Go to Security --> Logins (Inside EM)
3. Double Click your Login Name.
4. Inside General Tab of Login Window, Change the Language to the desired one.
5. Exit EM & Start a New Instance of EM
6. Right Click Server Name & Edit SQL Server Registration Property
7. Connect with your Credentials.
8. Verify Date Time columns from existing tables.
Regards
Surajit

Enterprise Manager - Want to display date in different format

Currently I am using Enterprise Manager to see the table content. It is
displaying date in American format but i want to view it as British date.
How can i change the settings so that i can view it differently ?
regards
Manisha"manisha_css" wrote:
> Currently I am using Enterprise Manager to see the table content. It is
> displaying date in American format but i want to view it as British date.
> How can i change the settings so that i can view it differently ?
> regards
> Manisha
Manisha -
Try following Steps :-
1. Go to EM
2. Go to Security --> Logins (Inside EM)
3. Double Click your Login Name.
4. Inside General Tab of Login Window, Change the Language to the desired one.
5. Exit EM & Start a New Instance of EM
6. Right Click Server Name & Edit SQL Server Registration Property
7. Connect with your Credentials.
8. Verify Date Time columns from existing tables.
Regards
Surajit