ArcServ and SQl Server 2000

Hi,

I am trying to create a backup agent for a SQl Server. I have given the information for the following: instance, AUTHENTICATION, USERNAME, PASSWORD, CONFIRM PASSWORD.

I keep getting the error message, enter valid instance, even though i am entering in the instance.

any ideas?

Is this a named instance? Do you have any special characters like dashes in the server name?

-Sue

|||Problem solved ? If yes, post how you solved it, or if the hint from Sue helped you′.

Jens K. Suessmeyer

http://www.sqlserver2005.de

sql

Architecture

I am very new to RS so please excuse my ignorance. Developers and business
are asking if they can have RS running on the same SQL Server instance I have
my transactional based database's on. I have always segregated my transaction
and DSS database from one another. Does anyone have any documentation
detailing the prerequisites for Reporting Services?Microsoft has a couple of great articles on their web site...
Maybe this one will help
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:DDD8C9EE-C7F2-41FC-91BB-C3400E318785@.microsoft.com...
>I am very new to RS so please excuse my ignorance. Developers and business
> are asking if they can have RS running on the same SQL Server instance I
> have
> my transactional based database's on. I have always segregated my
> transaction
> and DSS database from one another. Does anyone have any documentation
> detailing the prerequisites for Reporting Services?|||Hello Mr. Snyder,
Thank you very much for the doucmentation. Do you know of any whitepapers or
discussions detailing performance of RS?
"Wayne Snyder" wrote:
> Microsoft has a couple of great articles on their web site...
> Maybe this one will help
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:DDD8C9EE-C7F2-41FC-91BB-C3400E318785@.microsoft.com...
> >I am very new to RS so please excuse my ignorance. Developers and business
> > are asking if they can have RS running on the same SQL Server instance I
> > have
> > my transactional based database's on. I have always segregated my
> > transaction
> > and DSS database from one another. Does anyone have any documentation
> > detailing the prerequisites for Reporting Services?
>
>

Applying SP4 on an active/passive 2 way cluster

I have a 2 way cluster and I want to apply SP4 on it.
Basically, I have 2 servers. Server A runs a default instance and
another instance. While the default services is disabled and the other
instance is running, Server B runs the default instance and has the other
instance disabled. This basically acts like a 2 way cluster
(active/passive).
How can I apply SQL Server 2000 SP4 on the 2 servers and have all the
nodes come up the correct way? What are the steps to achieve this?http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-
C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||This is not going to help me. I have explicitly mentioned that I have a 2
way cluster in my original email. So a standard article like you have given
me is NOT going to help.
"Ole Kristian Bangås" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns981DB671F914Folekristianbangaas@.207.46.248.16...
> http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-
> C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
> --
> Ole Kristian Bangås
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:
> This is not going to help me. I have explicitly mentioned that I have
> a 2 way cluster in my original email. So a standard article like you
> have given me is NOT going to help.
Yes, and I don't quite get the problem. Let me quote point two in the
article I gave a link to:
"Run the service pack from the node that owns the group containing the
virtual server that you plan to upgrade. This installs the service pack
files on all nodes in the failover cluster."
Can you please explain what your problem is? As I understand your scenario
you have a two-node two-instance active-passive SQL cluster. An upgrade of
that cluster should be rather straightforward.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:
Correction to my previous post, You actually have an active/active
confuguration, with one instance on each server, but the upgrade procedure
is still valid.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP

Applying SP4 on an active/passive 2 way cluster

I have a 2 way cluster and I want to apply SP4 on it.

Basically, I have 2 servers. Server A runs a default instance and another instance. While the default services is disabled and the other instance is running, Server B runs the default instance and has the other instance disabled. This basically acts like a 2 way cluster (active/passive).

How can I apply SQL Server 2000 SP4 on the 2 servers and have all the nodes come up the correct way? What are the steps to achieve this?Since SQL Server is a shared resource on a clustered server, installing SP4 on one server is automatically done on the other. Everything is transparent to the user/admin.sql

Applying SP4 on an active/passive 2 way cluster

I have a 2 way cluster and I want to apply SP4 on it.
Basically, I have 2 servers. Server A runs a default instance and
another instance. While the default services is disabled and the other
instance is running, Server B runs the default instance and has the other
instance disabled. This basically acts like a 2 way cluster
(active/passive).
How can I apply SQL Server 2000 SP4 on the 2 servers and have all the
nodes come up the correct way? What are the steps to achieve this?http://download.microsoft.com/downl...584E-4DE0-B36F-
C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||This is not going to help me. I have explicitly mentioned that I have a 2
way cluster in my original email. So a standard article like you have given
me is NOT going to help.
"Ole Kristian Bangs" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns981DB671F914Folekristianbangaas@.
207.46.248.16...
> http://download.microsoft.com/downl...584E-4DE0-B36F-
> C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
> --
> Ole Kristian Bangs
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:

> This is not going to help me. I have explicitly mentioned that I have
> a 2 way cluster in my original email. So a standard article like you
> have given me is NOT going to help.
Yes, and I don't quite get the problem. Let me quote point two in the
article I gave a link to:
"Run the service pack from the node that owns the group containing the
virtual server that you plan to upgrade. This installs the service pack
files on all nodes in the failover cluster."
Can you please explain what your problem is? As I understand your scenario
you have a two-node two-instance active-passive SQL cluster. An upgrade of
that cluster should be rather straightforward.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:
Correction to my previous post, You actually have an active/active
confuguration, with one instance on each server, but the upgrade procedure
is still valid.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP

apply server pack 3a to new instances?

How do I apply sp3a to a new instance of sql2000? The original is already upgraded. I added three new instances.Each instance will require the service pack.
When you start the service pack setup program you can select the instance
name from a drop down list.
HTH
Ryan Waight, MCDBA, MCSE
"John" <anonymous@.discussions.microsoft.com> wrote in message
news:69DE0125-4A5C-4015-BE8A-BD15FFA75B1B@.microsoft.com...
> How do I apply sp3a to a new instance of sql2000? The original is already
upgraded. I added three new instances.

Application Event ID 17177

I periodically get the following information from the
application event log:

quote:

---

>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).

---

Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...

quote:

---

> I periodically get the following information from the
> application event log:
>
> Why is this generated? What is the significance of this
> information?
>

---

|||We have a client who is getting the same error except it says a different pr
ocess id. The problem is it is showing up at 12:00 every night when sql ser
ver is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder.
When I view the dat files i
n the directory they are from November, needless to say not current. When I
am in the SQL enterprise manager under management- sql server agent-jobs, I
can see the separate jobs and when I look at the properties they are schedu
led for daily @. 12:00 am.
Why am I not getting updated files in the backup folder? Ntbackup is runni
ng nightly with no errors and is backing up all sql database files along wit
h this MSSQL\Backup folder but the files in it are not current. Ntbackup is
backing up to 4mmtape. An
y help guys would be greatly appreciated.
Phil

Application Event ID 17177

I periodically get the following information from the
application event log:
>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).
Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...
> I periodically get the following information from the
> application event log:
> >This instance of SQL Server has been using a process id
> >of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
> >AM (UTC).
> Why is this generated? What is the significance of this
> information?
>|||We have a client who is getting the same error except it says a different process id. The problem is it is showing up at 12:00 every night when sql server is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder. When I view the dat files in the directory they are from November, needless to say not current. When I am in the SQL enterprise manager under management- sql server agent-jobs, I can see the separate jobs and when I look at the properties they are scheduled for daily @. 12:00 am. Why am I not getting updated files in the backup folder? Ntbackup is running nightly with no errors and is backing up all sql database files along with this MSSQL\Backup folder but the files in it are not current. Ntbackup is backing up to 4mmtape. Any help guys would be greatly appreciated
Phil

App_Data new DB fails

Hello,

I'm trying to create a new SQL Express database in VWD, and I get the error: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

What is this error all about? I don't understand it.

Thanks.

The db when added in VS has no owner and is somehow bound to the profile. So many things can go wrong with that, so instead of guessing, wipe it out and let the IDE recreate it.

This blog saved me days of heartache. Unfortunately, I still wasted time till I came across it.

http://www.sqljunkies.com/WebLog/ktegels/archive/2005/11/15/17401.aspx

1. Disconnect all dbs, close down the IDE, close down SSMS(if any) on your machine.
2. Stop all services and processes related to sql server.
3. Rename(safer than deleting) the whole folder:
c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

4.restart the IDE/SSE.
5. this song-n-dance may not work the first time. Try more than once.

I am really disappointed at the flaky architecture of SSE and have stopped using it since.

HTH!

Anyone using Excel 2007 as client ?

Overall pretty cool, but apparently you can't select a single level of a dimension in the pivot table.

For instance, I have level Year, Quarter, Month, Week, Day.

Having to look at last week's sales per day, I'd be selecting a specific week and I'd have the Day level only as row labels.

This worked in Excel 2003, but I can't figure out how to leave out the Year, Q, M and Week levels.

In the PivotTable Field List, you have a check box next to the Time dimension, but nothing next to each level in the dimension. So you have to have all levels of the dimension in the rows of the pivot.

This means a lot of useless drillthrough for the users as they go down from Year to Quarter to Month to Week to Days.

Am I missing something ?

In Excel 2007 you can display the Day level only by 'hiding' the other levels. If you drill down to the lowest level day, right click on any item | Show/Hide Fields | Uncheck the Year level - the year level is hidden. Repeat for the other levels you want to hide.

Hope this helps!

|||

Thanks Zaheera it does help, that's what I needed.

I think this is a feature that needs improvement, since I need 17 clicks before I have drilled down to Days, and then removed the levels one by one.

|||

To accomplish this in fewer clicks - you can right click on an item in the highest level | Expand/Collapse | Expand to <lowest level>. In one-click you've drilled down to the lowest level. Now you'll need to hide each level one by one as described above (which can be a pain - I agree). Or you can do this in one-step in VBA (Alt + F11 to open the editor, Cntrl + G to go to the immediate window): Activecell.PivotField.CubeField.HiddenLevels = 3 and the top 3 levels will be hidden at once.