Can we control the privilege of Drilling down?

How can we control the privilege of Drilling down?

For example:

There are for sale area of a company.

The manager of the company can view the total sale report of whole company, and view the individual sales report of the four area. The sales can view the total sale report of whole company, but they can only drill down the area of himself,they can not drill down the other area .

How can I do that?

Hi,
you can perform check of privilege of drilling down by Code in (ReportProperties).
For example (in Properties):
[Row].Visibility = Code.MyFunction
where MyFunction check if the Current user has necessary privilege to see selected row.

Best Regards

Can we contol the privilege of Drilling down

How can we contol the privilege of Drilling down?
For example:
There are for sale area of a company.
The manager of the company can view the total sale reoprt of whole company,
and view the individual sales report of the four area. The sales can view
the total sale reoprt of whole company, but the can only drill down the area
of themself, they can not drill down the other area .
How can I do that?Can any one help me!
"ad" <ad@.wfes.tcc.edu.tw> ¼¶¼g©ó¶l¥ó·s»D
:O3OBudyXFHA.3040@.TK2MSFTNGP14.phx.gbl...
> How can we contol the privilege of Drilling down?
> For example:
> There are for sale area of a company.
> The manager of the company can view the total sale reoprt of whole
company,
> and view the individual sales report of the four area. The sales can view
> the total sale reoprt of whole company, but the can only drill down the
area
> of themself, they can not drill down the other area .
> How can I do that?
>sql

Can we add tooltip to the Reports available in Report Manager?

Hi,
In my Report Manager window, I have created the Folder "Test" and under this folder I have uploaded 2 .rdl file. When I am placing the cursor over the Report Items, it shows 'Items in Test' instead I want to show Some Other Message.

Is it possible?

ThanksI'm sorry, this is not possible.

-Daniel

Can we add tooltip to the Reports available in Report Manager?

Hi,
In my Report Manager window, I have created the Folder "Test" and under this folder I have uploaded 2 .rdl file. When I am placing the cursor over the Report Items, it shows 'Items in Test' instead I want to show Some Other Message.

Is it possible?

ThanksI'm sorry, this is not possible.

-Daniel

Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?

Hi,
I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
would like to install SQL 2005 native client (Mgnt Studio etc) on the same PC.
Can they be coexisted and both can be used ? OR
I have to uninstall 2000 client first.
Regards,
Johnny
Hello,
They can co-exist. Make sure you installl the software in seperate
directory.
Thanks
Hari
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:F553693B-19D1-4EA7-9EEC-062287EE1628@.microsoft.com...
> Hi,
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
> would like to install SQL 2005 native client (Mgnt Studio etc) on the same
> PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
> Regards,
> Johnny
|||Johnny (Johnny@.discussions.microsoft.com) writes:
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC.
> I would like to install SQL 2005 native client (Mgnt Studio etc) on the
> same PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
They can co-exist as Hari said.
I just like to make a clafication: SQL Native Client is a single DLL
which contains an updated ODBC driver and an updated OLE DB provider
for SQL 2005. SQL Native is a redistributable component. SQL Native is
about the first which is installed when you run the SQL Server installation.
You are apparently thinking of the Workstation components, of which some
may use SQL Native Client, but far from all do. Management Studio, for
instance, uses SqlClient, a .Net provider. ("Native" in SQL Native Client
refers to that it is in native code, as opposed to the managed code of
..Net.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Can someone tell me what this means in SQL 7.0?

This is what I see in SQL Manager.
Thanks.
--
George Hester
_________________________________the database server is running and you are connected to it|||Well then what does it mean when the little red squiggly line is NOT =
there? Same thing? hmm...
--=20
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message =
news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...

quote:

---

> the database server is running and you are connected to it
>=20
>

---

|||The squiggly line means you are connected. Its absence means you are not
connected. It may appear there is no difference if security is set up (and
the server is registered) such that you don't need to enter a password to
connect. However, there is a definite difference.
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23z%231WAe2DHA.2528@.TK2MSFTNGP10.phx.gbl...
Well then what does it mean when the little red squiggly line is NOT there?
Same thing? hmm...
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message
news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...

quote:

---

> the database server is running and you are connected to it
>

---

|||It should mean that SQL Server is running but you are not connected.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||OK so the red squigly line means the MSSQL Service is starting without a =
user account and its concommitant password? That makes sense because =
the service is starting with the LocalSystem account. For some reason I =
am unable to change the account used to start the service. When I try =
to set the service to use My Administrator account in the Enterprise =
Manager I get a "A required priviledge is not held by the client." I =
suppose I could set the MSSQL Service to start using the Administrator =
account in the Services applet of Windows 2000. I haven't tried that =
because I felt if I couldn't do it in the Enterprise Manager then trying =
it there would fail just as well. But I'll give that a shot.
--=20
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message =
news:OdTNsIe2DHA.2184@.TK2MSFTNGP12.phx.gbl...

quote:

---

> The squiggly line means you are connected. Its absence means you are =

---

not

quote:

---

> connected. It may appear there is no difference if security is set up =

---

(and

quote:

---

> the server is registered) such that you don't need to enter a password =

---

to

quote:

---

> connect. However, there is a definite difference.
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23z%231WAe2DHA.2528@.TK2MSFTNGP10.phx.gbl...
> Well then what does it mean when the little red squiggly line is NOT =

---

there?

quote:

---

> Same thing? hmm...
>=20
> --=20
> George Hester
> __________________________________
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...
>=20
>

---

|||No. The red squigly line has NOTHING to do with the account that the
service is using. It indicates that EM has established a connection to the
server (using whatever account / security is specified in the registration).
EM is only an application that can be used to manage database servers. It
is only an application - it is NOT the database server program / service.
If you are having problems changing the account under which the DBMS runs,
then I suggest that you start a new thread with the appropriate subject and
details. In addition, you should search the newsgroups - as most issues
have been addressed (and are often FAQs).
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23qpbbmi2DHA.2156@.TK2MSFTNGP12.phx.gbl...
OK so the red squigly line means the MSSQL Service is starting without a
user account and its concommitant password? That makes sense because the
service is starting with the LocalSystem account. For some reason I am
unable to change the account used to start the service. When I try to set
the service to use My Administrator account in the Enterprise Manager I get
a "A required priviledge is not held by the client." I suppose I could set
the MSSQL Service to start using the Administrator account in the Services
applet of Windows 2000. I haven't tried that because I felt if I couldn't
do it in the Enterprise Manager then trying it there would fail just as
well. But I'll give that a shot.
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message
news:OdTNsIe2DHA.2184@.TK2MSFTNGP12.phx.gbl...

quote:

---

> The squiggly line means you are connected. Its absence means you are not
> connected. It may appear there is no difference if security is set up

---

(and

quote:

---

> the server is registered) such that you don't need to enter a password to
> connect. However, there is a definite difference.
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23z%231WAe2DHA.2528@.TK2MSFTNGP10.phx.gbl...
> Well then what does it mean when the little red squiggly line is NOT

---

there?

quote:

---

> Same thing? hmm...
> --
> George Hester
> __________________________________
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...
>

---

|||I have. The red sqiggly line is not right.
--=20
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message =
news:u7Lb9Mq2DHA.1924@.TK2MSFTNGP10.phx.gbl...

quote:

---

> No. The red squigly line has NOTHING to do with the account that the
> service is using. It indicates that EM has established a connection =

---

to the

quote:

---

> server (using whatever account / security is specified in the =

---

registration).

quote:

---

> EM is only an application that can be used to manage database servers. =

---

It

quote:

---

> is only an application - it is NOT the database server program / =

---

service.

quote:

---

> If you are having problems changing the account under which the DBMS =

---

runs,

quote:

---

> then I suggest that you start a new thread with the appropriate =

---

subject and

quote:

---

> details. In addition, you should search the newsgroups - as most =

---

issues

quote:

---

> have been addressed (and are often FAQs).
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23qpbbmi2DHA.2156@.TK2MSFTNGP12.phx.gbl...
> OK so the red squigly line means the MSSQL Service is starting without =

---

a

quote:

---

> user account and its concommitant password? That makes sense because =

---

the

quote:

---

> service is starting with the LocalSystem account. For some reason I =

---

am

quote:

---

> unable to change the account used to start the service. When I try to =

---

set

quote:

---

> the service to use My Administrator account in the Enterprise Manager =

---

I get

quote:

---

> a "A required priviledge is not held by the client." I suppose I =

---

could set

quote:

---

> the MSSQL Service to start using the Administrator account in the =

---

Services

quote:

---

> applet of Windows 2000. I haven't tried that because I felt if I =

---

couldn't

quote:

---

> do it in the Enterprise Manager then trying it there would fail just =

---

as

quote:

---

> well. But I'll give that a shot.
>=20
> --=20
> George Hester
> __________________________________
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:OdTNsIe2DHA.2184@.TK2MSFTNGP12.phx.gbl...
are not[QUOTE]
up[QUOTE]
> (and
password to[QUOTE]
> there?
>=20
>

---

can see sql2k sp3, but cannot connect?

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can al
so
see that port 1433 is open.
But, when I try to connect to it, I get the connection could not be
estiablished.
sql server does not exist or access denied.
I have pretty much all the port except for 1433 tcp and udp blocked.
How can I troubleshoot getting this connected. It is located on my local
network - so it is not a connection problem.
--
Thanks in advance, Les CaudleI think it was a name resolution problem, with so few ports open.
When I created a registration by ip address rather than name, it connected
immediately.
Confusing that the name showed up in Enterprise Manager. Would be nice if i
t
would automatically try to use just the ip (which it must know, as it can se
e
it).
On Wed, 18 Aug 2004 19:17:14 -0500, Les Caudle <very@.tiredofspam.com> wrote:

>With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can a
lso
>see that port 1433 is open.
>But, when I try to connect to it, I get the connection could not be
>estiablished.
>sql server does not exist or access denied.
>I have pretty much all the port except for 1433 tcp and udp blocked.
>How can I troubleshoot getting this connected. It is located on my local
>network - so it is not a connection problem.

can see sql2k sp3, but cannot connect?

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also
see that port 1433 is open.
But, when I try to connect to it, I get the connection could not be
estiablished.
sql server does not exist or access denied.
I have pretty much all the port except for 1433 tcp and udp blocked.
How can I troubleshoot getting this connected. It is located on my local
network - so it is not a connection problem.
Thanks in advance, Les Caudle
I think it was a name resolution problem, with so few ports open.
When I created a registration by ip address rather than name, it connected
immediately.
Confusing that the name showed up in Enterprise Manager. Would be nice if it
would automatically try to use just the ip (which it must know, as it can see
it).
On Wed, 18 Aug 2004 19:17:14 -0500, Les Caudle <very@.tiredofspam.com> wrote:

>With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also
>see that port 1433 is open.
>But, when I try to connect to it, I get the connection could not be
>estiablished.
>sql server does not exist or access denied.
>I have pretty much all the port except for 1433 tcp and udp blocked.
>How can I troubleshoot getting this connected. It is located on my local
>network - so it is not a connection problem.

Can Report Manager be accessed as an Internet application?

Is Report Manager designed to be accessed over the Internet, and if so, is
there a forms based login that can be enabled?
-- Chris, SSSIhttp://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
"Chris G." wrote:
> Is Report Manager designed to be accessed over the Internet, and if so, is
> there a forms based login that can be enabled?
> -- Chris, SSSI|||Mark,
Will that sample run against 2005 Reporting Services with little or no
modification?
-- Chris, SSSI
"Mark" wrote:
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> "Chris G." wrote:
> > Is Report Manager designed to be accessed over the Internet, and if so, is
> > there a forms based login that can be enabled?
> >
> > -- Chris, SSSI|||I couldn't say, to be honest. I was never even able to get it working with
2000, although that doesn't mean you'd have the same luck (or lack thereof).
If this doesn't work with 2005, then I'm pretty sure there must be resources
online--by Microsoft or somebody else--for implementing the forms
authentication custom extension.
Hope this helps,
Mark
"Chris G." wrote:
> Mark,
> Will that sample run against 2005 Reporting Services with little or no
> modification?
> -- Chris, SSSI
>
> "Mark" wrote:
> > http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> >
> > "Chris G." wrote:
> >
> > > Is Report Manager designed to be accessed over the Internet, and if so, is
> > > there a forms based login that can be enabled?
> > >
> > > -- Chris, SSSI|||Hi Chris,
Thank you for you post and thanks Marks' help.
In the SQL Server 2005 Books online, there is a section about the Forms
Authentication in Reporting Services 2005.
Authentication in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms152899.aspx
Also there is a sample in the SQL Server if you install the samples.
Security Extension Sample
http://msdn2.microsoft.com/en-us/library/ms160724.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Can not show all level in analysis manager MSSQL Server 2000

Hi,

I use MSsql server 2000 and analysis service for create cube.But when I drilldown many Dimension on Analysis manager it can not show all level.
If I drilldown some level it can show data but when I drilldown many level so it have many row (I test about 60,000) it can not show result.
How can I show all result in Analysis manager or other tool ?

Thank you : )I sometimes use MDX sample aplication i got with the installation of Analysys Services to run MDX queries on cube data.

If you simply want to browse some specific portion of the data, maybe it would help to write MDX queries specifying smaller subsets of the data?

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florence
Hi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>
|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

Can not registre SQL in Enterprise Manager

Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 and
work wuth tables fine !!!
Using the Enterprise Manager from the W2003 server, we have checked
the following:
-Network Configuration button on the General tab
Is TCP/IP enabled?
-In the Connections tab, the Query time-out value is not set too low (600
seconds)
-There is not a maximum concurrent user connections value set
(unlimited).
Also, we can register others remote servers and work fine.
Any idea ?
Thank you very much !
Charles.It's the login timeout you want to try increasing. See my
reply to your post in .connect for steps to do this.
-Sue
On Sat, 17 Apr 2004 12:20:44 +0200, "Charles"
<ccolell@.softeng.es> wrote:

>Hello,
>I try to register a remote SQL Server 2000 installed in a W2003, but it
>doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
>In that network , there is not any firewall and port 1433 is open in the
>router. What it really surpises me, is that
>I can connect via ODBC to any database of that remote SQL Server2000 and
>work wuth tables fine !!!
>Using the Enterprise Manager from the W2003 server, we have checked
>the following:
> -Network Configuration button on the General tab
> Is TCP/IP enabled?
> -In the Connections tab, the Query time-out value is not set too low (60
0
>seconds)
> -There is not a maximum concurrent user connections value set
>(unlimited).
>Also, we can register others remote servers and work fine.
>Any idea ?
>Thank you very much !
>Charles.
>

Can not registre SQL in Enterprise Manager

Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 and
work wuth tables fine !!!
Using the Enterprise Manager from the W2003 server, we have checked
the following:
-Network Configuration button on the General tab
Is TCP/IP enabled?
-In the Connections tab, the Query time-out value is not set too low (600
seconds)
-There is not a maximum concurrent user connections value set
(unlimited).
Also, we can register others remote servers and work fine.
Any idea ?
Thank you very much !
Charles.
It's the login timeout you want to try increasing. See my
reply to your post in .connect for steps to do this.
-Sue
On Sat, 17 Apr 2004 12:20:44 +0200, "Charles"
<ccolell@.softeng.es> wrote:

>Hello,
>I try to register a remote SQL Server 2000 installed in a W2003, but it
>doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
>In that network , there is not any firewall and port 1433 is open in the
>router. What it really surpises me, is that
>I can connect via ODBC to any database of that remote SQL Server2000 and
>work wuth tables fine !!!
>Using the Enterprise Manager from the W2003 server, we have checked
>the following:
> -Network Configuration button on the General tab
> Is TCP/IP enabled?
> -In the Connections tab, the Query time-out value is not set too low (600
>seconds)
> -There is not a maximum concurrent user connections value set
>(unlimited).
>Also, we can register others remote servers and work fine.
>Any idea ?
>Thank you very much !
>Charles.
>

Can not register SQLServer2000 in Enterprise Manager

Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 and
work wuth tables fine !!!
Using the Enterprise Manager from the W2003 server, we have checked
the following:
-Network Configuration button on the General tab
Is TCP/IP enabled?
-In the Connections tab, the Query time-out value is not set too low (600
seconds)
-There is not a maximum concurrent user connections value set
(unlimited).
Also, we can register others remote servers and work fine.
Any idea ?
Thank you very much !
Charles.
Charles,
Try increasing the login timeout used by Enterprise Manager.
In Enterprise Manager, go to the menu to Tools, then select
Options. Click on the Advanced tab and increase the login
timeout from the default 4 seconds. Try 10 or 15 seconds
instead and see if that helps.
-Sue
On Sat, 17 Apr 2004 12:14:30 +0200, "Charles"
<ccolell@.softeng.es> wrote:

>Hello,
>I try to register a remote SQL Server 2000 installed in a W2003, but it
>doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
>In that network , there is not any firewall and port 1433 is open in the
>router. What it really surpises me, is that
>I can connect via ODBC to any database of that remote SQL Server2000 and
>work wuth tables fine !!!
>Using the Enterprise Manager from the W2003 server, we have checked
>the following:
> -Network Configuration button on the General tab
> Is TCP/IP enabled?
> -In the Connections tab, the Query time-out value is not set too low (600
>seconds)
> -There is not a maximum concurrent user connections value set
>(unlimited).
>Also, we can register others remote servers and work fine.
>Any idea ?
>Thank you very much !
>Charles.
>
|||Yes !!!! Thanks a lot Sue.
Have a nice day,
Charles.
"Sue Hoegemeier" <Sue_H@.nomail.please> escribi en el mensaje
news:4eg680hvekta8k50ar1c21fadjcsn7p62i@.4ax.com... [vbcol=seagreen]
> Charles,
> Try increasing the login timeout used by Enterprise Manager.
> In Enterprise Manager, go to the menu to Tools, then select
> Options. Click on the Advanced tab and increase the login
> timeout from the default 4 seconds. Try 10 or 15 seconds
> instead and see if that helps.
> -Sue
> On Sat, 17 Apr 2004 12:14:30 +0200, "Charles"
> <ccolell@.softeng.es> wrote:
(600
>

Can not register SQLServer2000 in Enterprise Manager

Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 and
work wuth tables fine !!!
Using the Enterprise Manager from the W2003 server, we have checked
the following:
-Network Configuration button on the General tab
Is TCP/IP enabled?
-In the Connections tab, the Query time-out value is not set too low (600
seconds)
-There is not a maximum concurrent user connections value set
(unlimited).
Also, we can register others remote servers and work fine.
Any idea ?
Thank you very much !
Charles.Charles,
Try increasing the login timeout used by Enterprise Manager.
In Enterprise Manager, go to the menu to Tools, then select
Options. Click on the Advanced tab and increase the login
timeout from the default 4 seconds. Try 10 or 15 seconds
instead and see if that helps.
-Sue
On Sat, 17 Apr 2004 12:14:30 +0200, "Charles"
<ccolell@.softeng.es> wrote:

>Hello,
>I try to register a remote SQL Server 2000 installed in a W2003, but it
>doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
>In that network , there is not any firewall and port 1433 is open in the
>router. What it really surpises me, is that
>I can connect via ODBC to any database of that remote SQL Server2000 and
>work wuth tables fine !!!
>Using the Enterprise Manager from the W2003 server, we have checked
>the following:
> -Network Configuration button on the General tab
> Is TCP/IP enabled?
> -In the Connections tab, the Query time-out value is not set too low (60
0
>seconds)
> -There is not a maximum concurrent user connections value set
>(unlimited).
>Also, we can register others remote servers and work fine.
>Any idea ?
>Thank you very much !
>Charles.
>|||Yes !!!! Thanks a lot Sue.
Have a nice day,
Charles.
"Sue Hoegemeier" <Sue_H@.nomail.please> escribi en el mensaje
news:4eg680hvekta8k50ar1c21fadjcsn7p62i@.
4ax.com...
> Charles,
> Try increasing the login timeout used by Enterprise Manager.
> In Enterprise Manager, go to the menu to Tools, then select
> Options. Click on the Advanced tab and increase the login
> timeout from the default 4 seconds. Try 10 or 15 seconds
> instead and see if that helps.
> -Sue
> On Sat, 17 Apr 2004 12:14:30 +0200, "Charles"
> <ccolell@.softeng.es> wrote:
>
(600[vbcol=seagreen]
>