any installation no-no's?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely remember that I used all the installation defaults with MSDE. That
led to a problem whenever the administrator, or whoever the user was when it
was installed, changed thier password, the connection to the database no
longer worked.
Can anyone suggest a source of information that might be useful to me to
read before I install MSDE 2000?
Thanks for your help, John Brown
John Brown
hi John,
John Brown wrote:
> We are installing MS Win Server 2003 and my old version (7?) of MSDE
> is not supported. So I will download MSDE 2000 and install it. I do
> not have a lot of experience installing MSDE. I installed it a few
> times years ago and, with a few exceptions, it has run just fine
> since then.
> I vaguely remember that I used all the installation defaults with
> MSDE. That led to a problem whenever the administrator, or whoever
> the user was when it was installed, changed thier password, the
> connection to the database no longer worked.
> Can anyone suggest a source of information that might be useful to me
> to read before I install MSDE 2000?
> Thanks for your help, John Brown
modifying the "sa" password was a problem for MSDE 1.0 relating to Windows
account running the SQL Server Agent, but this does not apply to MSDE
2000... and there are not other problems I'm aware of.. but, of course, you
should have a look at the readme file bundled with the installation
package...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Any help on this SMO request?

My evaluation copy ran-out and I uninstlaled the previous and installed anothrer evaluation edition. The installation was successful. I created a SSIS package importing a tale from Oracle 10G XE to the SQL 2005 on my machine. I saved the package on the server. The SSIS service is working but when I try to refresh the node, I get this message. The help linl leads to no where:

--

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
TCP Provider: No connection could be made because the target machine actively refused it. (Microsoft SQL Native Client)

Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
TCP Provider: No connection could be made because the target machine actively refused it. (Microsoft SQL Native Client)

My efforts so far:

I have verified the items in the Surface area screen, everythign looks good.

SSIS service has started.

Both teh Network Server TCP/IP dynmaic port and the SQL Client TCP/IP dynamic port are the same.

I have no problem logging in to any of the services. But I get this message.

I tried to create a package from Visual Studio, but that also did not succeed.

In my previous set up, I created perhaps 1/ 2 dozen different packages.

I am puzzzled.

I appreciate if some one could throw some light.

If you could get the function call stack when the error occurs, that would help diagnose the problem. At the bottom of the exception message box, there is a little icon with a tooltip like "technical details" which displays this information.

Also, if you could provide more specific steps to reproduce the problem, that would help too. Are you using SSIS when you get this problem, or some Management Studio UI that uses SSIS, like the Copy Database Wizard? You can get more specific SSIS configuration help in the SSIS forum here: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1

Thanks,
Steve

Any Advice on Monitoring Performance of Processing Cubes in AS2000

Hi,
I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure what
would good figures and what would be poor ones.
We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.
Thanks in advance.
standard best practices:
to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...
You'll find the best parameters for your system.
also, try to process your partitions / cubes in parrallel.
put the distinct count measures in a dedicated cube
your better counter is the overall time taken to do your process ;-)
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
|||First, these two white papers:
http://www.microsoft.com/technet/pro.../anservog.mspx
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.
Hope that helps.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.

Any Advice on Monitoring Performance of Processing Cubes in AS2000

Hi,
I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure wha
t
would good figures and what would be poor ones.
We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.
Thanks in advance.standard best practices:
to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...
You'll find the best parameters for your system.
also, try to process your partitions / cubes in parrallel.
put the distinct count measures in a dedicated cube
your better counter is the overall time taken to do your process ;-)
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.|||First, these two white papers:
http://www.microsoft.com/technet/pr...n/anservog.mspx
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.
Hope that helps.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.