Search results for query: *

Problems solved! Failing over the cluster and back fixed both problems. :) Thanks for everything! -Chris

Solution for drives not showing: I indicated that I had placed all drives necessary as dependencies. I also had restarted the service. That didn't help. However, I decided to fail over the cluster and then back again. That worked. All drives showed up. I don't know why that's different...

They are definitely part of the cluster. The MS KB said that for SQL Server to use them, the SQL resource had to list them as dependencies. They do show up in the available list of dependent drives, and appear to add just fine as dependencies. However, the script to swith the tempdb over...

Any ideas on the second issue? The dependency thing? -Chris

I tried that. I also added these drives as dependencies in the SQL Server cluster resources. Some that are in there show in the Maintenance Plan wizard, some do not. Very odd, and I am sure that it has something to do with network setup (AD and such), but I don't want to get into the...

Nope. They are all basic. Interestingly enough, I can type in the path and it works fine. The drives are just not visible in the Maintenance Plan screen for backup location. I even created a plan and tested just now, so it's simply not showing up in the choice list. I can live with that...

Hi all, I just installed a new instance of SQL Server 2000 Enterprise Edition on a 2-node cluster. The server has 3 local drives and several SANS drives that have been presented to the server. Everything is working quite well, with 2 exceptions. 1. When I try to create a maintenance plan, 2...

mrdenny...interesting. I was under the same impression as catadmin. Paul, let me try that and I'll get back to you. -Chris

Great suggestions. The servers were fresh installs of the OS, and this behavior was exhibited from the very start. SQL never autostarted. The servers are part of the same domain as the user account. There are no DENY policies in place. I double-checked that again. I need to ask the...

Yes. It has "Log on as a Service" rights. It's a custom domain account created specifically for the SQL services. Hmmmmmmmm..... I can't help but wonder if we're looking at this incorrectly. The rights have to be fine unless they are local or the other servers would exhibit the same...

Good question. Windows Server 2003 SP1. :) SQL Server 2000 SP4.

OK. I checked for dependencies. Nothing there. And I didn't see any local security policies that denied anything relevant. Would that make sense, though, since it works once started manually? It's odd that it works, just doesn't start with the OS. -Chris

Good questions. Information Assurance is a bear, here, so all installations are identical, using domain accounts for both the sql service and the agent service. As indicated above, both services are set to Autostart. They are not manual or disabled. I do not use EM or the taskbar to start...

Hey everyone! Good thoughts, all! Paul is right. Everything works beautifully. I didn't alter the system database paths in this case. I think it might be an OS thing as well, but there are no errors anywhere, even in the ERRORLOG where mrdenny suggested. Total puzzle. I use the same...

Yes. That's what I referenced in the original post. There are no errors in any of the event logs. First place I checked. :) And I don't think that it's because the service is failing to start. It just isn't trying to start, though it's set to Automatic. I think. Otherwise, I'd see errors...

I have a couple of servers where SQL Server 2000 Standard Edition is set to Autostart, but the service is not starting on reboot. The event logs look fine. Any ideas? Works fine on most servers, and starts right up manually. -Chris

Hi mrdenny, Thanks for the advice. FTP is not possible because of security at my location, unfortunately. :( Very special case. Perhaps SSIS is the way I'll have to go. Useful FAQ, though! Thank you so much! -Chris

Hi mrdenny, Thanks for responding. What do you think about this possible solution? Would this work? 1. Set up an SSIS package to pull the data from Oracle into a local SQL Server. 2. Set up replication from the local SQL Server to a remote SQL Server. 3. Run scripts and alter the package...

Hi all, I need advice on a strategy to create a reporting instance of a database. There are difficulties involved. I am using SQL Server 2005 Enterprise edition. The Situation: 1. The original data is in Oracle 10g. 2. The Oracle data is a star schema. 3. This data needs to find its way...

Typo. "not a construct" = "now a construct" :)