Problem with logon SQL Server (MSDE)

Hi
I am working on a replication database system, I will use SQL Server Enterprise at the main database and I'm planning to have remote databases with MSDE, I installed MSDE in a remote computer using a valid logon account for the domain in the domain controller (I had it connected for the set up). If I disconnect the computer from the network an restart the machine the Sql Server won't start with the cache information.

How can I solve this problem?MSDE Doesn't support a login from the network; only from the local computer.

Am I right?

problem with loging in

I installed a default instance of Enterprise edittion and

didn't face any error during the instalation process.

In Management Studio in the Server Name section for loging in I wrote the name of the local system.

but I couldn't log in.

in

Control Panel \ administrative tools\services

there is no SQL Server service at all.

should I install any thing extra just like Express Edition which I used to install SQL Express in Visual Studio 2005 pakage or like MSDE in SQL Server 2000?

please tell me what to do

thanks.

pooyan

Hello,

It would seem that the core dbms has not been installed correctly - did you perhaps only select client tools during the install?

Reinstall the server components (make sure you run setup from the server, not tools folder).

Cheers,

Rob

problem with login list

Hi,

I'm using the 64-bit version of SQL Server 2005, SP2, on Windows
Server 2003 R2 X64 Enterprise Edition. I've got a bunch of users out
there who are the db_owner, db_accessadmin and db_securityadmin of
their different respective databases. I would expect that they would
be able to add users to their databases, given that a login exists on
the server. However, when they go to browse logins to add a user in
Management Studio, they are only shown a very short list (like,
themselves and sa, and that's it). We have hundreds of logins on the
server, and they should be able to add any one of them to their
databases if they wish. And if they try to type in the login name
directly, they get a permission denied error.

I am the system administrator, so thankfully I've not experienced this
problem, and I can add users for them. But I'd rather they be able to
do it themselves as they see fit. I have experimented by creating a
test SQL-authenticated login, and making it db_owner of a test
database. When I login with that test login and try to add a user, I
see the exact same behavior. The only logins viewable are my test
login and sa. The only other thing I can add is it's not just
occurring with the GUI interface; the same thing happens when I do a
direct query on the master.sys.syslogins view: I only see the same two
logins. So it appears it's happening at that level and the result
appears up in the GUI.

It appears this is a security/permissions thing. Anyone know if
there's a configuration setting or something that might be preventing
non-privileged users from being able to view all the server logins
when attempting to add users to their databases, in which they are
assigned the db_owner role?

Thanks
GringoSkyGringo (doug@.bu.edu) writes:

Quote:

Originally Posted by

>
I'm using the 64-bit version of SQL Server 2005, SP2, on Windows
Server 2003 R2 X64 Enterprise Edition. I've got a bunch of users out
there who are the db_owner, db_accessadmin and db_securityadmin of
their different respective databases. I would expect that they would
be able to add users to their databases, given that a login exists on
the server. However, when they go to browse logins to add a user in
Management Studio, they are only shown a very short list (like,
themselves and sa, and that's it). We have hundreds of logins on the
server, and they should be able to add any one of them to their
databases if they wish. And if they try to type in the login name
directly, they get a permission denied error.

They need to have VIEW DEFINITION on the logins they need to add. There
is no permission VIEW ANY LOGIN, but there is a server-level VIEW ANY
DEFINITION you can grant to them, but I would think twice before you
did.

Quote:

Originally Posted by

The only other thing I can add is it's not just occurring with the GUI
interface; the same thing happens when I do a direct query on the
master.sys.syslogins view: I only see the same two logins. So it
appears it's happening at that level and the result appears up in the
GUI.

It appears that you are of the old SQL 2000 school. :-)

Microsoft did a lot around security in SQL 2005, and one thing is
that objects are no longer visible to everyone. Essentially, you
can only see an object, if you have permission to it.

And the place to look for logins these days, is sys.server_principals.
While the old system tables are around for compatibility, they may not
show aspects that are new to SQL 2005.

--
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

Problem with Jobs

Hello all,

I am having a problem with the sql

DB on the company that I work for.

I got message under job history

on Enterprise manager is :

"The job failed.The Job was invoked by Schedule 15 (Replication

agent schedule.).The last step to run

was step 1 (Run agent.)"

and in the event log is:

Event ID: 208

Source: SQLAgent$(company DB)

"sql server Schedule (company DB)

status:Failed"

Please advice.

Thanks in advance

Kind regards

This relates to replication issues, which can be quite complex depending on what you're trying to do. You should review your replication scheme to ensure that all the data is going where it should. If the replication isn't happening, your files will grow on the distributor until it runs out of room.

If you're new to replication, check here:

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Problem with installing SQL Server 2005

When I'm installing SQL Server 2005 Express Edition (but not only, error was also in Enterprise Edition 2005) there is an error. Everything is fine but on the end SQL Instalation cannot start SQL Service.
Does someone know how to solve this problem?
I'm installing SQL CTp 2005 with the newest .NET 2.0
Help!!What is the error you are seeing?

Dan
http://blogs.msdn.com/dtjones/|||Something like that: "Installer cannot start SQL Service" and everything is unistalling.

Problem with Form Authentication Example

I installed the Microsoft Forms Authentication in Report Services example in
a VPC running Windows 2003, Active Directory, SQl Server Enterprise and SQL
Reporting Servcie Enterprise Edition.
I registered user "john" and modified RSReportServer.config and added and
changed the value for <UserName> tag to be "john".
Stepping through the debugger the demo fails on GetWebResponse because
cookie is null.
I have tried FQDN in RSWebApplication.config but problem persist.
Any idea what is going wrong causing GetWebResponse to fail?I'm using a solution that's primarily based on the Forms Auth sample and I
can say that it does work. Double-check your web.config modifications for
the ReportServer and ReportManager webs according to the instructions in the
sample.
Adrian M.
"John Amason" <jamason@.ics-associates.com> wrote in message
news:uH%23y30Q$EHA.2580@.TK2MSFTNGP15.phx.gbl...
>I installed the Microsoft Forms Authentication in Report Services example
>in
> a VPC running Windows 2003, Active Directory, SQl Server Enterprise and
> SQL
> Reporting Servcie Enterprise Edition.
> I registered user "john" and modified RSReportServer.config and added and
> changed the value for <UserName> tag to be "john".
> Stepping through the debugger the demo fails on GetWebResponse because
> cookie is null.
> I have tried FQDN in RSWebApplication.config but problem persist.
> Any idea what is going wrong causing GetWebResponse to fail?
>

Problem with export of a table to a text file

Dear MSSQL- experts,

I have a strange problem with SQLSERVER 2000.
I tried to export a table of about 40000 lines into a text file using
the Enterprise manager
export assitant. I was astonished to get an exported text file of about
400 MB instead 16 MB which is the normal size of that data.
By examining this file with a text editor I found that the file
included alongside the data of my table MANY zeros which caused the big
file size.

Does someone of you have an idea what could cause the export of
trillions zeros into my textfile and how to only export the significant
data of my table ?

Best regards,

DanielPosting the table definition (CREATE TABLE) would help a lot.

Roy Harvey
Beacon Falls, CT

On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
<Daniel.Wetzler@.sig.bizwrote:

Quote:

Originally Posted by

>Dear MSSQL- experts,
>
>I have a strange problem with SQLSERVER 2000.
>I tried to export a table of about 40000 lines into a text file using
>the Enterprise manager
>export assitant. I was astonished to get an exported text file of about
>400 MB instead 16 MB which is the normal size of that data.
>By examining this file with a text editor I found that the file
>included alongside the data of my table MANY zeros which caused the big
>file size.
>
>Does someone of you have an idea what could cause the export of
>trillions zeros into my textfile and how to only export the significant
>data of my table ?
>
>Best regards,
>
>Daniel

|||Hi Roy,

thanks for your answer.

Here's the table definition :

CREATE TABLE [dbo].[Variables] (
[ID] [varchar] (140) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Var_ref] [int] NOT NULL ,
[Group_Ref] [int] NULL ,
[Machines_Ref] [int] NULL ,
[TransfersID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[Compatibility] [int] NULL ,
[CompatibilityL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [int] NULL ,
[CategoryL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[AnalysisResponsible] [tinyint] NULL ,
[AnalysisPriority] [int] NULL ,
[AnalysisDelta] [int] NULL ,
[AnalysisDeltaValue] [varchar] (30) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[Value] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Length] [int] NULL ,
[Address] [int] NULL ,
[Offset] [int] NULL ,
[Title1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle1] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle2] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle3] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle4] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Best regards,

Daniel

Roy Harvey schrieb:

Quote:

Originally Posted by

Posting the table definition (CREATE TABLE) would help a lot.
>
Roy Harvey
Beacon Falls, CT
>
On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
<Daniel.Wetzler@.sig.bizwrote:
>

Quote:

Originally Posted by

Dear MSSQL- experts,

I have a strange problem with SQLSERVER 2000.
I tried to export a table of about 40000 lines into a text file using
the Enterprise manager
export assitant. I was astonished to get an exported text file of about
400 MB instead 16 MB which is the normal size of that data.
By examining this file with a text editor I found that the file
included alongside the data of my table MANY zeros which caused the big
file size.

Does someone of you have an idea what could cause the export of
trillions zeros into my textfile and how to only export the significant
data of my table ?

Best regards,

Daniel

|||There were no surprises in the table definition. Storage of a row in
SQL Server, with all the varying length columns at their upper limit,
is around 2000 bytes, for whatever that is worth. Output of a maxed
out row to a unicode text file should be no more than a few hundred
bytes longer.

Did you save the DTS package that the export wizard created? Have you
tried running the wizard again? Did you specify fixed-width or
delimited? ASCII or UNICODE? (I expect UNICODE to handle the
NVARCHAR columns.)

I would run the wizard again, being sure to save the package. That at
least will give something to inspect on the code side if the output
file is still screwy.

Roy Harvey
Beacon Falls, CT

On 24 Aug 2006 06:11:12 -0700, "Daniel Wetzler"
<Daniel.Wetzler@.sig.bizwrote:

Quote:

Originally Posted by

>Hi Roy,
>
>thanks for your answer.
>
>Here's the table definition :
>
>
>CREATE TABLE [dbo].[Variables] (
>[ID] [varchar] (140) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Var_ref] [int] NOT NULL ,
>[Group_Ref] [int] NULL ,
>[Machines_Ref] [int] NULL ,
>[TransfersID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>,
>[Compatibility] [int] NULL ,
>[CompatibilityL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
>NULL ,
>[Category] [int] NULL ,
>[CategoryL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>,
>[AnalysisResponsible] [tinyint] NULL ,
>[AnalysisPriority] [int] NULL ,
>[AnalysisDelta] [int] NULL ,
>[AnalysisDeltaValue] [varchar] (30) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[Value] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Length] [int] NULL ,
>[Address] [int] NULL ,
>[Offset] [int] NULL ,
>[Title1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Title2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Title3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Title4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle1] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle2] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle3] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle4] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL
>) ON [PRIMARY]
>GO
>
>Best regards,
>
>Daniel
>
>
>
>Roy Harvey schrieb:
>

Quote:

Originally Posted by

>Posting the table definition (CREATE TABLE) would help a lot.
>>
>Roy Harvey
>Beacon Falls, CT
>>
>On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
><Daniel.Wetzler@.sig.bizwrote:
>>

Quote:

Originally Posted by

>Dear MSSQL- experts,
>
>I have a strange problem with SQLSERVER 2000.
>I tried to export a table of about 40000 lines into a text file using
>the Enterprise manager
>export assitant. I was astonished to get an exported text file of about
>400 MB instead 16 MB which is the normal size of that data.
>By examining this file with a text editor I found that the file
>included alongside the data of my table MANY zeros which caused the big
>file size.
>
>Does someone of you have an idea what could cause the export of
>trillions zeros into my textfile and how to only export the significant
>data of my table ?
>
>Best regards,
>
>Daniel

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe Niel
Thats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>
|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>
|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:
> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a écrit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>>Hi
>>I recently upgraded my infrastructure to Active Directory 2003.
>>Since then I'm having two problems when I start Enterprise Manager and
>>connect on 2003 sever member with SQL2000 sp3a:
>>1 On non-member machine, I use SQL authentication to register the server
>>and
>>in the security log I keep getting dozens of Event ID 529 (unkown username
>>or bad password) every minutes.
>>The user in the event is the local account logged on the workstation.
>>2 on member machines, I have three successfull events (logoff/privilges
>>assigned/logon) every 10 seconds
>>In the first case, why does it try to log on with the local account ?
>>In the second case why does it logoff/logon every 10 seconds ?
>>
>>I can't remove this audit (international group security policy...) and the
>>security logs are full in about 2 weeks with 600,000+ events!! I can't
>>manage that!
>>Thanks in advance for your help.
>>Regards,
>>Christophe Niel
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server a
nd
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server an
d
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>
>

Problem with Enterprise Manager 2000

Hi,
After installing XP SP2 security patches on my box, I can not open
Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
I get two error in event log,
========================
1. Event Type:Error
Event Source:Application Error
Event Category:None
Event ID:1000
Date:1/18/2005
Time:3:30:09 PM
User:N/A
Computer:WXPP-LT_AMINH
Description:
Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
version 5.1.2600.0, fault address 0x0000bb5b.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6d 6d 63 ure mmc
0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
0020: 2e 32 36 30 30 2e 30 20 .2600.0
0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
0038: 36 30 30 2e 30 20 61 74 600.0 at
0040: 20 6f 66 66 73 65 74 20 offset
0048: 30 30 30 30 62 62 35 62 0000bb5b
0050: 0d 0a ..
2.
Event Type:Error
Event Source:Application Error
Event Category:None
Event ID:1001
Date:1/18/2005
Time:3:30:22 PM
User:N/A
Computer:WXPP-LT_AMINH
Description:
Fault bucket 02874011.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 42 75 63 6b 65 74 3a 20 Bucket:
0008: 30 32 38 37 34 30 31 31 02874011
0010: 0d 0a ..
=======================
I removed the patches using reollback option of XP, but after removal even
explorer crashes. I re-installed SQL client tools, but result is same...
Any one has idea how to resolve this?
Thanks,
Hiten
Maybe the snap-in has become corrupt or damaged.
Try renaming the existing SQL Server Enterprise Manager.MSC
file.
Then copy the SQL Server Enterprise Manager.MSC file from
the your SQL Server CD to the same location.
-Sue
On Tue, 18 Jan 2005 12:39:11 -0800, "Hiten"
<Hiten@.discussions.microsoft.com> wrote:

>Hi,
>After installing XP SP2 security patches on my box, I can not open
>Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
>I get two error in event log,
>========================
>1. Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1000
>Date:1/18/2005
>Time:3:30:09 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
>version 5.1.2600.0, fault address 0x0000bb5b.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 41 70 70 6c 69 63 61 74 Applicat
>0008: 69 6f 6e 20 46 61 69 6c ion Fail
>0010: 75 72 65 20 20 6d 6d 63 ure mmc
>0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
>0020: 2e 32 36 30 30 2e 30 20 .2600.0
>0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
>0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
>0038: 36 30 30 2e 30 20 61 74 600.0 at
>0040: 20 6f 66 66 73 65 74 20 offset
>0048: 30 30 30 30 62 62 35 62 0000bb5b
>0050: 0d 0a ..
>2.
>Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1001
>Date:1/18/2005
>Time:3:30:22 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Fault bucket 02874011.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 42 75 63 6b 65 74 3a 20 Bucket:
>0008: 30 32 38 37 34 30 31 31 02874011
>0010: 0d 0a ..
>=======================
>I removed the patches using reollback option of XP, but after removal even
>explorer crashes. I re-installed SQL client tools, but result is same...
>Any one has idea how to resolve this?
>Thanks,
>Hiten
|||Someone with the same problem before SP2 found this to be a workaround:
http://groups-beta.google.com/group/...e66a3e81c65f5e
[I opened] mmc.exe in the Windows/system32 folder and add[ed]
the Enterprise Manager snap-in. Now I can just run enterprise
manager that way! It's not ideal, but it works :-)
Steve Kass
Drew University
Hiten wrote:

>Hi,
>After installing XP SP2 security patches on my box, I can not open
>Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
>I get two error in event log,
>========================
>1. Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1000
>Date:1/18/2005
>Time:3:30:09 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
>version 5.1.2600.0, fault address 0x0000bb5b.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 41 70 70 6c 69 63 61 74 Applicat
>0008: 69 6f 6e 20 46 61 69 6c ion Fail
>0010: 75 72 65 20 20 6d 6d 63 ure mmc
>0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
>0020: 2e 32 36 30 30 2e 30 20 .2600.0
>0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
>0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
>0038: 36 30 30 2e 30 20 61 74 600.0 at
>0040: 20 6f 66 66 73 65 74 20 offset
>0048: 30 30 30 30 62 62 35 62 0000bb5b
>0050: 0d 0a ..
>2.
>Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1001
>Date:1/18/2005
>Time:3:30:22 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Fault bucket 02874011.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 42 75 63 6b 65 74 3a 20 Bucket:
>0008: 30 32 38 37 34 30 31 31 02874011
>0010: 0d 0a ..
>=======================
>I removed the patches using reollback option of XP, but after removal even
>explorer crashes. I re-installed SQL client tools, but result is same...
>Any one has idea how to resolve this?
>Thanks,
>Hiten
>

Problem with enterprise manager ( image attached )

Hi,
I have been having a problem for a couple of weeks, for some reason the
"Create Date" column of both the tables and SP views appear with weird
characters (as shown in the attached image) , This happen both on a local
server as well as on a remote server.
When I connect to the remote server using TS and see the same view the
"Create Date" column appear normally.
What could have happen? and even it's not a big issue I would like to know
how to solve it.
Thanks,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Did you by chance install YUKON Beta on the same box ?
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to know
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>
|||Nop,
I haven't installed it, I have VS.NET 2005 installed , though.
Cheers,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F4BA581B-F664-469D-8C7B-301E72D72292@.microsoft.com...[vbcol=seagreen]
> Did you by chance install YUKON Beta on the same box ?
>
> "Ignacio Machin ( .NET/ C# MVP )" wrote:
local[vbcol=seagreen]
know[vbcol=seagreen]
|||Probably that is the problem..
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to know
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>

Problem with enterprise manager ( image attached )

Hi,
I have been having a problem for a couple of weeks, for some reason the
"Create Date" column of both the tables and SP views appear with weird
characters (as shown in the attached image) , This happen both on a local
server as well as on a remote server.
When I connect to the remote server using TS and see the same view the
"Create Date" column appear normally.
What could have happen? and even it's not a big issue I would like to know
how to solve it.
Thanks,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of TransportationDid you by chance install YUKON Beta on the same box ?
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to kno
w
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>|||Nop,
I haven't installed it, I have VS.NET 2005 installed , though.
Cheers,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F4BA581B-F664-469D-8C7B-301E72D72292@.microsoft.com...[vbcol=seagreen]
> Did you by chance install YUKON Beta on the same box ?
>
> "Ignacio Machin ( .NET/ C# MVP )" wrote:
>
local[vbcol=seagreen]
know[vbcol=seagreen]|||Probably that is the problem..
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to kno
w
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>

Problem with enterprise manager ( image attached )

Hi,
I have been having a problem for a couple of weeks, for some reason the
"Create Date" column of both the tables and SP views appear with weird
characters (as shown in the attached image) , This happen both on a local
server as well as on a remote server.
When I connect to the remote server using TS and see the same view the
"Create Date" column appear normally.
What could have happen? and even it's not a big issue I would like to know
how to solve it.
Thanks,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of TransportationNop,
I haven't installed it, I have VS.NET 2005 installed , though.
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F4BA581B-F664-469D-8C7B-301E72D72292@.microsoft.com...
> Did you by chance install YUKON Beta on the same box ?
>
> "Ignacio Machin ( .NET/ C# MVP )" wrote:
> > Hi,
> >
> > I have been having a problem for a couple of weeks, for some reason the
> > "Create Date" column of both the tables and SP views appear with weird
> > characters (as shown in the attached image) , This happen both on a
local
> > server as well as on a remote server.
> > When I connect to the remote server using TS and see the same view the
> > "Create Date" column appear normally.
> >
> > What could have happen? and even it's not a big issue I would like to
know
> > how to solve it.
> >
> >
> > Thanks,
> >
> > --
> > Ignacio Machin,
> > ignacio.machin AT dot.state.fl.us
> > Florida Department Of Transportation
> >
> >
> >

Problem with Enterprise Manager

When in em, I try to open a table and return all rows, I get a weird error:
"The query cannot be executed because some o fthe files are missing or not
registered."
Also, I cannot connect to the database with a dataadapter in vs (2003)
I can, however, execute an SQL in Query Analyzer.
I have reinstalled several times. Some of the Google articles suggest that
it might be MDAC. I cannot install MDAC either. It says that the operation
is not supported by the OS (xp Pro) The components are already installed.
Any input would be greatly appreciated.
Hi
A few questions!
Did you try and remove the software before re-installing?
Did you rung the MDAC component checker to see if it says your installation
is consistent?
Have you tried to apply any service packs?
You may wish to un-register/re-register all the dlls in {Installation
Directory}\80\Tools\Binn?
John
"walter1234" wrote:

> When in em, I try to open a table and return all rows, I get a weird error:
> "The query cannot be executed because some o fthe files are missing or not
> registered."
> Also, I cannot connect to the database with a dataadapter in vs (2003)
> I can, however, execute an SQL in Query Analyzer.
> I have reinstalled several times. Some of the Google articles suggest that
> it might be MDAC. I cannot install MDAC either. It says that the operation
> is not supported by the OS (xp Pro) The components are already installed.
> Any input would be greatly appreciated.
|||I just ran into this issue myself, I've tried the reinstall etc. I'm going
to try and un-register/re-register all of the DLLs in that directory but
there are 46 of them. Any suggestions on an easy way to do that?
I also tried the suggestions in Article ID: 315868.
Cory Blythe
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> A few questions!
> Did you try and remove the software before re-installing?
> Did you rung the MDAC component checker to see if it says your installation
> is consistent?
> Have you tried to apply any service packs?
> You may wish to un-register/re-register all the dlls in {Installation
> Directory}\80\Tools\Binn?
> John
> "walter1234" wrote:

Problem with Enterprise Manager

When in em, I try to open a table and return all rows, I get a weird error:
"The query cannot be executed because some o fthe files are missing or not
registered."
Also, I cannot connect to the database with a dataadapter in vs (2003)
I can, however, execute an SQL in Query Analyzer.
I have reinstalled several times. Some of the Google articles suggest that
it might be MDAC. I cannot install MDAC either. It says that the operation
is not supported by the OS (xp Pro) The components are already installed.
Any input would be greatly appreciated.Hi
A few questions!
Did you try and remove the software before re-installing?
Did you rung the MDAC component checker to see if it says your installation
is consistent?
Have you tried to apply any service packs?
You may wish to un-register/re-register all the dlls in {Installation
Directory}\80\Tools\Binn?
John
"walter1234" wrote:
> When in em, I try to open a table and return all rows, I get a weird error:
> "The query cannot be executed because some o fthe files are missing or not
> registered."
> Also, I cannot connect to the database with a dataadapter in vs (2003)
> I can, however, execute an SQL in Query Analyzer.
> I have reinstalled several times. Some of the Google articles suggest that
> it might be MDAC. I cannot install MDAC either. It says that the operation
> is not supported by the OS (xp Pro) The components are already installed.
> Any input would be greatly appreciated.|||I just ran into this issue myself, I've tried the reinstall etc. I'm going
to try and un-register/re-register all of the DLLs in that directory but
there are 46 of them. Any suggestions on an easy way to do that?
I also tried the suggestions in Article ID: 315868.
Cory Blythe
"John Bell" wrote:
> Hi
> A few questions!
> Did you try and remove the software before re-installing?
> Did you rung the MDAC component checker to see if it says your installation
> is consistent?
> Have you tried to apply any service packs?
> You may wish to un-register/re-register all the dlls in {Installation
> Directory}\80\Tools\Binn?
> John
> "walter1234" wrote:
> > When in em, I try to open a table and return all rows, I get a weird error:
> > "The query cannot be executed because some o fthe files are missing or not
> > registered."
> > Also, I cannot connect to the database with a dataadapter in vs (2003)
> > I can, however, execute an SQL in Query Analyzer.
> > I have reinstalled several times. Some of the Google articles suggest that
> > it might be MDAC. I cannot install MDAC either. It says that the operation
> > is not supported by the OS (xp Pro) The components are already installed.
> > Any input would be greatly appreciated.

Problem with Enterprise Manager

When in em, I try to open a table and return all rows, I get a weird error:
"The query cannot be executed because some o fthe files are missing or not
registered."
Also, I cannot connect to the database with a dataadapter in vs (2003)
I can, however, execute an SQL in Query Analyzer.
I have reinstalled several times. Some of the Google articles suggest that
it might be MDAC. I cannot install MDAC either. It says that the operation
is not supported by the OS (xp Pro) The components are already installed.
Any input would be greatly appreciated.Hi
A few questions!
Did you try and remove the software before re-installing?
Did you rung the MDAC component checker to see if it says your installation
is consistent?
Have you tried to apply any service packs?
You may wish to un-register/re-register all the dlls in {Installation
Directory}\80\Tools\Binn?
John
"walter1234" wrote:

> When in em, I try to open a table and return all rows, I get a weird error
:
> "The query cannot be executed because some o fthe files are missing or not
> registered."
> Also, I cannot connect to the database with a dataadapter in vs (2003)
> I can, however, execute an SQL in Query Analyzer.
> I have reinstalled several times. Some of the Google articles suggest tha
t
> it might be MDAC. I cannot install MDAC either. It says that the operatio
n
> is not supported by the OS (xp Pro) The components are already installed.
> Any input would be greatly appreciated.|||I just ran into this issue myself, I've tried the reinstall etc. I'm going
to try and un-register/re-register all of the DLLs in that directory but
there are 46 of them. Any suggestions on an easy way to do that?
I also tried the suggestions in Article ID: 315868.
Cory Blythe
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> A few questions!
> Did you try and remove the software before re-installing?
> Did you rung the MDAC component checker to see if it says your installatio
n
> is consistent?
> Have you tried to apply any service packs?
> You may wish to un-register/re-register all the dlls in {Installation
> Directory}\80\Tools\Binn?
> John
> "walter1234" wrote:
>

problem with enterprise manager

I have a problem with SQL Server 7 Standard edition, when i select a database in Enterprise Manager and i want to see the content of tables, i can't see anything: I can see all tables but when i choice "Open Table " and "Return all rows", i see only the menu bar on the top, and all page is blank. :confused:
This problem is on all database, and on all tables, include the system database (as Master).
If i use query analyzer i can work without probems.

Thank in advance

FrancescoSounds like you need to do a reinstal of the client tools.

Why not so a trace for the crack using sqltrace(profiler)?

something is busted though.