I have a fact table with 32.000.000 rows. In cube editor , I want to create
a
private time dimension based on a datetime type column of my fact table.
after I press next button on "select advanced options" window, several
minutes passes and then a "finish" button appears in the same window
instead of next button. when I pressed finish, I got pop up message "the nam
e
cannot be an empty string" but I have no place to write the name of the
dimension.I typically discourage creating a time dimension like this. I strongly
recommend that you create an independent dimension table which incorporates
"Time". Then use the timestamps from your fact table as FKs to this
dimension. This is normally the best approach because it:
1) allows you to model data which does not exist, e.g. holidays, weekends,
etc, which are not represented in your fact table.
2) dimension processing goes much faster (i.e. you don't have to scan
multiple rows); this is particularly true here because the system will issue
a SELECT DISTINCT to process the private time dimension.
3) private dimensions must always be reprocessed when you process the fact
table -- which can greatly increase your overhead (see #2 above)
4) you will always be limited to a single partition because you can't build
across multiple fact tables (which can limit your scalability, query
response time, rolling "n" months -- all of which use multiple partitions).
5) if you create an independent time dimension table, you can have
interesting extensions to just a timestamp, e.g. model holidays, seasons,
work-days compared to weekends, etc.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Banu_Tr" <Banu_Tr@.discussions.microsoft.com> wrote in message
news:ABBE65C4-C6C8-4DF5-AEB8-2DFBE6489608@.microsoft.com...
> I have a fact table with 32.000.000 rows. In cube editor , I want to
create a
> private time dimension based on a datetime type column of my fact table.
> after I press next button on "select advanced options" window, several
> minutes passes and then a "finish" button appears in the same window
> instead of next button. when I pressed finish, I got pop up message "the
name
> cannot be an empty string" but I have no place to write the name of the
> dimension.
Showing posts with label based. Show all posts
Showing posts with label based. Show all posts
Tuesday, March 20, 2012
Cannot Create private Time Dimension
I have a fact table with 32.000.000 rows. In cube editor , I want to create a
private time dimension based on a datetime type column of my fact table.
after I press next button on "select advanced options" window, several
minutes passes and then a "finish" button appears in the same window
instead of next button. when I pressed finish, I got pop up message "the name
cannot be an empty string" but I have no place to write the name of the
dimension.
I typically discourage creating a time dimension like this. I strongly
recommend that you create an independent dimension table which incorporates
"Time". Then use the timestamps from your fact table as FKs to this
dimension. This is normally the best approach because it:
1) allows you to model data which does not exist, e.g. holidays, weekends,
etc, which are not represented in your fact table.
2) dimension processing goes much faster (i.e. you don't have to scan
multiple rows); this is particularly true here because the system will issue
a SELECT DISTINCT to process the private time dimension.
3) private dimensions must always be reprocessed when you process the fact
table -- which can greatly increase your overhead (see #2 above)
4) you will always be limited to a single partition because you can't build
across multiple fact tables (which can limit your scalability, query
response time, rolling "n" months -- all of which use multiple partitions).
5) if you create an independent time dimension table, you can have
interesting extensions to just a timestamp, e.g. model holidays, seasons,
work-days compared to weekends, etc.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Banu_Tr" <Banu_Tr@.discussions.microsoft.com> wrote in message
news:ABBE65C4-C6C8-4DF5-AEB8-2DFBE6489608@.microsoft.com...
> I have a fact table with 32.000.000 rows. In cube editor , I want to
create a
> private time dimension based on a datetime type column of my fact table.
> after I press next button on "select advanced options" window, several
> minutes passes and then a "finish" button appears in the same window
> instead of next button. when I pressed finish, I got pop up message "the
name
> cannot be an empty string" but I have no place to write the name of the
> dimension.
sql
private time dimension based on a datetime type column of my fact table.
after I press next button on "select advanced options" window, several
minutes passes and then a "finish" button appears in the same window
instead of next button. when I pressed finish, I got pop up message "the name
cannot be an empty string" but I have no place to write the name of the
dimension.
I typically discourage creating a time dimension like this. I strongly
recommend that you create an independent dimension table which incorporates
"Time". Then use the timestamps from your fact table as FKs to this
dimension. This is normally the best approach because it:
1) allows you to model data which does not exist, e.g. holidays, weekends,
etc, which are not represented in your fact table.
2) dimension processing goes much faster (i.e. you don't have to scan
multiple rows); this is particularly true here because the system will issue
a SELECT DISTINCT to process the private time dimension.
3) private dimensions must always be reprocessed when you process the fact
table -- which can greatly increase your overhead (see #2 above)
4) you will always be limited to a single partition because you can't build
across multiple fact tables (which can limit your scalability, query
response time, rolling "n" months -- all of which use multiple partitions).
5) if you create an independent time dimension table, you can have
interesting extensions to just a timestamp, e.g. model holidays, seasons,
work-days compared to weekends, etc.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Banu_Tr" <Banu_Tr@.discussions.microsoft.com> wrote in message
news:ABBE65C4-C6C8-4DF5-AEB8-2DFBE6489608@.microsoft.com...
> I have a fact table with 32.000.000 rows. In cube editor , I want to
create a
> private time dimension based on a datetime type column of my fact table.
> after I press next button on "select advanced options" window, several
> minutes passes and then a "finish" button appears in the same window
> instead of next button. when I pressed finish, I got pop up message "the
name
> cannot be an empty string" but I have no place to write the name of the
> dimension.
sql
Thursday, March 8, 2012
Cannot create a report - VS 2005/SQL 2005
I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
in my case 2 pc's are now fixed!!! Great!!!!|||
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
"Error 1001: The SavedState Dictionary contains inconsistent
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
===================================
Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)
Program Location:at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
Is anyone else having the same problem?
Any help will be appreciated.
Thanks
Sumeetsame error here.... anyone got a work around or a fix?|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
|||Hi Albert,I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.
-Albert
|||Will do.However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
Albert Yen - MS wrote:
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.
in my case 2 pc's are now fixed!!! Great!!!!|||
Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
|||
The latest version of Refactor and CodeRush both is 2.0.1
Both can be downloaded from www.devexpress.com
Sumeet
|||I downloaded the software. I tried to install it , but it could not be installed due to error:"Error 1001: The SavedState Dictionary contains inconsistent
data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
Cannot create a report - VS 2005/SQL 2005
I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
in my case 2 pc's are now fixed!!! Great!!!!|||
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
"Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
===================================
Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)
Program Location:at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
Is anyone else having the same problem?
Any help will be appreciated.
Thanks
Sumeet
same error here.... anyone got a work around or a fix?|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
|||Hi Albert,I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.
-Albert
|||Will do.However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
Albert Yen - MS wrote:
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.
in my case 2 pc's are now fixed!!! Great!!!!|||
Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
|||
The latest version of Refactor and CodeRush both is 2.0.1
Both can be downloaded from www.devexpress.com
Sumeet
|||I downloaded the software. I tried to install it , but it could not be installed due to error:"Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
Cannot create a report - VS 2005/SQL 2005
I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
in my case 2 pc's are now fixed!!! Great!!!!|||
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
"Error 1001: The SavedState Dictionary contains inconsistent
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
===================================
Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)
Program Location:at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
Is anyone else having the same problem?
Any help will be appreciated.
Thanks
Sumeetsame error here.... anyone got a work around or a fix?|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
|||Hi Albert,I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.
-Albert
|||Will do.However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.
in my case 2 pc's are now fixed!!! Great!!!!|||
Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
|||
The latest version of Refactor and CodeRush both is 2.0.1
Both can be downloaded from www.devexpress.com
Sumeet
|||I downloaded the software. I tried to install it , but it could not be installed due to error:"Error 1001: The SavedState Dictionary contains inconsistent
data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
Wednesday, March 7, 2012
Cannot connect with Enterprise Manager
Hi All
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
Jono
Jono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
Jono
Jono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
Cannot connect with Enterprise Manager
Hi All
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
Cannot connect with Enterprise Manager
Hi All
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
Subscribe to:
Posts (Atom)