AdomdConnection.Cube() Can''t Find Some Cubes In SQL Server2005

I have established some cubes in SQL Server 2005.

But when I use AdomdConnection.Cube() Function to find these cubes, some of these can't be find.

Can someone tell me what reason may be or what I can do ? Thanks!!!

Program: .NET 2005

Server : SQL Server 2005

OS : Windows 2003

P.S. In these Cubes Can't be found, I delete few cubes and establish them again. Then these cubes can be found.

Hi,

The best way is to use a loop to list out all the cubes and check if all of them occur.

Say,

For each oCube in ODatabases.Cubes

Msgbox(oCube.Name)

Next

If all donot occur it might be an issue related to security. Check you have Database wide Privilege.

Thanks

Subhash Subramanyam

|||

Hi~

I use your way and list all the cubes, but some cubes still can not be listed.

And I'm sure I have the database wide privilege.

AdomdConnection.Cube() Can''t Find Some Cubes In SQL Server2005

I have established some cubes in SQL Server 2005.

But when I use AdomdConnection.Cube() Function to find these cubes, some of these can't be find.

Can someone tell me what reason may be or what I can do ? Thanks!!!

Program: .NET 2005

Server : SQL Server 2005

OS : Windows 2003

P.S. In these Cubes Can't be found, I delete few cubes and establish them again. Then these cubes can be found.

Hi,

The best way is to use a loop to list out all the cubes and check if all of them occur.

Say,

For each oCube in ODatabases.Cubes

Msgbox(oCube.Name)

Next

If all donot occur it might be an issue related to security. Check you have Database wide Privilege.

Thanks

Subhash Subramanyam

|||

Hi~

I use your way and list all the cubes, but some cubes still can not be listed.

And I'm sure I have the database wide privilege.

AdomdConnection.Cube() Can''t Find Some Cubes In SQL Server2005

I have established some cubes in SQL Server 2005.

But when I use AdomdConnection.Cube() Function to find these cubes, some of these can't be find.

Can someone tell me what reason may be or what I can do ? Thanks!!!

Program: .NET 2005

Server : SQL Server 2005

OS : Windows 2003

P.S. In these Cubes Can't be found, I delete few cubes and establish them again. Then these cubes can be found.

Hi,

The best way is to use a loop to list out all the cubes and check if all of them occur.

Say,

For each oCube in ODatabases.Cubes

Msgbox(oCube.Name)

Next

If all donot occur it might be an issue related to security. Check you have Database wide Privilege.

Thanks

Subhash Subramanyam

|||

Hi~

I use your way and list all the cubes, but some cubes still can not be listed.

And I'm sure I have the database wide privilege.

ADO Can, EM and QA cannot

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
Please tell me how to run up the Enterprise Manager? Thanks a lot.Hi
It is not a good idea to have SQL Server on an externally exposed server,
and it is always better to dedicate the server for a single use.
If you are connecting using ADO then you should be able to use the client
tools using the same login, check that you are using the same protocols.
John
"goldenshine" wrote:

> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde". Usi
ng
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user t
he
> administrator to login to the server).
> I'm running EM and QA on the webserver(With administrator account), not on
> the client PC.
> The EM and QA can work well before.
> One thing is, the webserver may be infected by virus of Spida Worm.
> Currently, when I try to run EM or QA, then a long time waiting. Then told
> me: connection failed,...
> But the website system is still working well.
> Please tell me how to run up the Enterprise Manager? Thanks a lot.|||Thanks,John,
Can you please tell me how to check the protocols? Since the website(
Asp.net) can use ADO to connect SQL Server and works well, why
EnterpriseManager cannot?
Thanks
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not a good idea to have SQL Server on an externally exposed server,
> and it is always better to dedicate the server for a single use.
> If you are connecting using ADO then you should be able to use the client
> tools using the same login, check that you are using the same protocols.
> John
>
> "goldenshine" wrote:
>|||Hi
Look in the client network configuration utility on the client and the
server network configuration utitlity on the server.
John
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:FA91D6BA-7F42-4BAA-A01C-969E63685059@.microsoft.com...[vbcol=seagreen]
> Thanks,John,
> Can you please tell me how to check the protocols? Since the website(
> Asp.net) can use ADO to connect SQL Server and works well, why
> EnterpriseManager cannot?
> Thanks
>
> "John Bell" wrote:
>

ADO Can, EM and QA cannot

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
Please tell me how to run up the Enterprise Manager? Thanks a lot.
Hi
It is not a good idea to have SQL Server on an externally exposed server,
and it is always better to dedicate the server for a single use.
If you are connecting using ADO then you should be able to use the client
tools using the same login, check that you are using the same protocols.
John
"goldenshine" wrote:

> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
> administrator to login to the server).
> I'm running EM and QA on the webserver(With administrator account), not on
> the client PC.
> The EM and QA can work well before.
> One thing is, the webserver may be infected by virus of Spida Worm.
> Currently, when I try to run EM or QA, then a long time waiting. Then told
> me: connection failed,...
> But the website system is still working well.
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
|||Thanks,John,
Can you please tell me how to check the protocols? Since the website(
Asp.net) can use ADO to connect SQL Server and works well, why
EnterpriseManager cannot?
Thanks
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not a good idea to have SQL Server on an externally exposed server,
> and it is always better to dedicate the server for a single use.
> If you are connecting using ADO then you should be able to use the client
> tools using the same login, check that you are using the same protocols.
> John
>
> "goldenshine" wrote:
|||Hi
Look in the client network configuration utility on the client and the
server network configuration utitlity on the server.
John
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:FA91D6BA-7F42-4BAA-A01C-969E63685059@.microsoft.com...[vbcol=seagreen]
> Thanks,John,
> Can you please tell me how to check the protocols? Since the website(
> Asp.net) can use ADO to connect SQL Server and works well, why
> EnterpriseManager cannot?
> Thanks
>
> "John Bell" wrote:

ADO Can, EM and QA cannot

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
Please tell me how to run up the Enterprise Manager? Thanks a lot.Hi
It is not a good idea to have SQL Server on an externally exposed server,
and it is always better to dedicate the server for a single use.
If you are connecting using ADO then you should be able to use the client
tools using the same login, check that you are using the same protocols.
John
"goldenshine" wrote:
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
> administrator to login to the server).
> I'm running EM and QA on the webserver(With administrator account), not on
> the client PC.
> The EM and QA can work well before.
> One thing is, the webserver may be infected by virus of Spida Worm.
> Currently, when I try to run EM or QA, then a long time waiting. Then told
> me: connection failed,...
> But the website system is still working well.
> Please tell me how to run up the Enterprise Manager? Thanks a lot.|||Thanks,John,
Can you please tell me how to check the protocols? Since the website(
Asp.net) can use ADO to connect SQL Server and works well, why
EnterpriseManager cannot?
Thanks
"John Bell" wrote:
> Hi
> It is not a good idea to have SQL Server on an externally exposed server,
> and it is always better to dedicate the server for a single use.
> If you are connecting using ADO then you should be able to use the client
> tools using the same login, check that you are using the same protocols.
> John
>
> "goldenshine" wrote:
> > Dear all,
> > I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
> > this user name and password, and with ADO, I established our website.
> > Now the website is still working well,can input data,show data!!
> >
> > But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> > Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
> > administrator to login to the server).
> >
> > I'm running EM and QA on the webserver(With administrator account), not on
> > the client PC.
> > The EM and QA can work well before.
> > One thing is, the webserver may be infected by virus of Spida Worm.
> > Currently, when I try to run EM or QA, then a long time waiting. Then told
> > me: connection failed,...
> > But the website system is still working well.
> >
> > Please tell me how to run up the Enterprise Manager? Thanks a lot.|||Hi
Look in the client network configuration utility on the client and the
server network configuration utitlity on the server.
John
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:FA91D6BA-7F42-4BAA-A01C-969E63685059@.microsoft.com...
> Thanks,John,
> Can you please tell me how to check the protocols? Since the website(
> Asp.net) can use ADO to connect SQL Server and works well, why
> EnterpriseManager cannot?
> Thanks
>
> "John Bell" wrote:
>> Hi
>> It is not a good idea to have SQL Server on an externally exposed server,
>> and it is always better to dedicate the server for a single use.
>> If you are connecting using ADO then you should be able to use the client
>> tools using the same login, check that you are using the same protocols.
>> John
>>
>> "goldenshine" wrote:
>> > Dear all,
>> > I'm using SQl Server 2K on a webserver and the sa password is "abcde".
>> > Using
>> > this user name and password, and with ADO, I established our website.
>> > Now the website is still working well,can input data,show data!!
>> >
>> > But I cannot login to this SQL Server with "Enterprise Manager" or
>> > "Query
>> > Analyzer" on the server. Either with sa or Windows-Authenticate. (I
>> > user the
>> > administrator to login to the server).
>> >
>> > I'm running EM and QA on the webserver(With administrator account), not
>> > on
>> > the client PC.
>> > The EM and QA can work well before.
>> > One thing is, the webserver may be infected by virus of Spida Worm.
>> > Currently, when I try to run EM or QA, then a long time waiting. Then
>> > told
>> > me: connection failed,...
>> > But the website system is still working well.
>> >
>> > Please tell me how to run up the Enterprise Manager? Thanks a lot.

ADO can run, EnterpriseManager cannot ?

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
Please tell me how to run up the Enterprise Manager? Thanks a lot.
Hi
Check that your machine where EM and QA are installed on can actually ping
the SQL Server.
If ADO can connect, so can EM and QA, as long as it can talk to the server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>
|||Can you post the exact error message. Also check out this kb.
http://support.microsoft.com/kb/287932
-oj
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>
|||Thanks to Mike and oj,
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
"oj" wrote:

> Can you post the exact error message. Also check out this kb.
> http://support.microsoft.com/kb/287932
> --
> -oj
>
> "goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
> news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
>
>

ADO can run, EnterpriseManager cannot ?

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
Please tell me how to run up the Enterprise Manager? Thanks a lot.Hi
Check that your machine where EM and QA are installed on can actually ping
the SQL Server.
If ADO can connect, so can EM and QA, as long as it can talk to the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>|||Can you post the exact error message. Also check out this kb.
http://support.microsoft.com/kb/287932
--
-oj
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>|||Thanks to Mike and oj,
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
"oj" wrote:
> Can you post the exact error message. Also check out this kb.
> http://support.microsoft.com/kb/287932
> --
> -oj
>
> "goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
> news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> > Dear all,
> > I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> > Using
> > this user name and password, and with ADO, I established our website.
> > Now the website is still working well,can input data,show data!!
> >
> > But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> > Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> > the
> > administrator to login to the server).
> >
> > Please tell me how to run up the Enterprise Manager? Thanks a lot.
> >
> >
>
>

ADO can run, EnterpriseManager cannot ?

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
Please tell me how to run up the Enterprise Manager? Thanks a lot.Hi
Check that your machine where EM and QA are installed on can actually ping
the SQL Server.
If ADO can connect, so can EM and QA, as long as it can talk to the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>|||Can you post the exact error message. Also check out this kb.
http://support.microsoft.com/kb/287932
-oj
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>|||Thanks to Mike and oj,
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
"oj" wrote:

> Can you post the exact error message. Also check out this kb.
> http://support.microsoft.com/kb/287932
> --
> -oj
>
> "goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
> news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
>
>