Directions on how to install SQL 2000 not as Windows admin

Can someone point me to the KB article, guide, or white paper on how to inst
all SQL Server 2000 using a Windows account that is not system administrator
for the the server?"Hal" <Hal@.discussions.microsoft.com> wrote in message
news:EE70A9F1-FC92-4381-8428-8D01475E4B7C@.microsoft.com...
> Can someone point me to the KB article, guide, or white paper on how to
install SQL Server 2000 using a Windows account that is not system
administrator for the the server?<
Hmmm, typically you need to have local administrative rights to perform
application installs. Perhaps you could negiotiate, or create (depending on
your position on this ;), a local account that has administrative rights,
use that for the install, then disable the account once SQL Server is
installed.
Steve|||I appreciate the response, but it wasn't helpful.
I am certain Microsoft has produced a guide to setting up a SQL Server 2000
with an account that is not SysAdmin. I want a link to that guide.
If there isn't a guide, then someone should surely write one.
"Steve Thompson" wrote:

> "Hal" <Hal@.discussions.microsoft.com> wrote in message
> news:EE70A9F1-FC92-4381-8428-8D01475E4B7C@.microsoft.com...
> install SQL Server 2000 using a Windows account that is not system
> administrator for the the server?<
> Hmmm, typically you need to have local administrative rights to perform
> application installs. Perhaps you could negiotiate, or create (depending o
n
> your position on this ;), a local account that has administrative rights,
> use that for the install, then disable the account once SQL Server is
> installed.
> Steve
>
>|||Is your question how to install SQL Server from a Windows account that
does not have Windows administrator rights, or is your question how to
install SQL Server so that the Windows user who installed SQL Server
cannot connect to the new SQL Server as SQL Server system administrator,
or is you question something about post-installation SQL Server setup?
I don't think you can do either of the first two, simply because the
installation makes changes to both Windows and SQL Server that should
not be allowed by someone without administrator privileges.
In any case, it would help if you could be more specific about whether
"account" means Windows account, SQL Server account (login), or
something else, whether SysAdmin refers to the SQL Server system
administrator role or something else, and what you mean by "setting up".
Steve Kass
Drew University
Hal wrote:
[vbcol=seagreen]
>I appreciate the response, but it wasn't helpful.
>I am certain Microsoft has produced a guide to setting up a SQL Server 2000
with an account that is not SysAdmin. I want a link to that guide.
>If there isn't a guide, then someone should surely write one.
>"Steve Thompson" wrote:
>
>|||I'm betting the question is "How do I install SQL 2K and configure it so the
Service Account is something besides the Local System or an Admin Account".
If that's the case, create an account you want the service to run with and
then specify that account
during the install. If you've already installed, then go into Enterprise Ma
nager and select the Security Tab. Type in the account info there and click
on OK. SQL with then apply the correct security permissions to that accoun
t. If you do it in the Ser
vices portion of computer manager, the security permissions won't be applied
and the service will not start.
"Steve Kass" wrote:

> Is your question how to install SQL Server from a Windows account that
> does not have Windows administrator rights, or is your question how to
> install SQL Server so that the Windows user who installed SQL Server
> cannot connect to the new SQL Server as SQL Server system administrator,
> or is you question something about post-installation SQL Server setup?
> I don't think you can do either of the first two, simply because the
> installation makes changes to both Windows and SQL Server that should
> not be allowed by someone without administrator privileges.
> In any case, it would help if you could be more specific about whether
> "account" means Windows account, SQL Server account (login), or
> something else, whether SysAdmin refers to the SQL Server system
> administrator role or something else, and what you mean by "setting up".
> Steve Kass
> Drew University
> Hal wrote:
>
>sql

Digital Dashboards

Hi,
I am trying to find and download Digital Dashboard Resource Kit for SQL 2000 but can't find it. Can any one point me to a URL and usefull resources.
Thanks
DDRK died awhile back. SharePoint provides similar
functionalities (web parts) but it's more focused towards
collaboration.
http://www.microsoft.com/sharepoint/
-Sue
On Sun, 1 Aug 2004 09:05:02 -0700, "mavrick_101"
<mavrick101@.discussions.microsoft.com> wrote:

>Hi,
>I am trying to find and download Digital Dashboard Resource Kit for SQL 2000 but can't find it. Can any one point me to a URL and usefull resources.
>Thanks
>

Differential Backup via Maintenance wizard

(If this is not the correct forum please point me in the right direction)

I am trying to schedule a Daliy differential backup using the Maintenance Wizard. This works fine for me, however I do not see where I can actualy speficy the file name I want to use for the differential backup

I notice that SQL 2005 will add the date and time for example MyDatabase_backup_200703191330. I would like to use a different name, for example MyDatabase_DiffBackup_DateTime. How can I specify this, I am not able to modify the T-SQL that is generated. is there a way to do this? Modify the T-SQL

Do I need to specify "backup databases across one or more files option" if so where do i specify the file name.

Should I create the job manually and execute to a T-SQL statement where I can specify the file name?

Thanks

-javahar

Create a Job and write T-SQL Code for Differential Backup will be great and less problem

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

Different operations along dimensions

I am having a stupid problem with my cube...

The data I have is a floating point number between 0 and 1, representing the utilization of an item (machine, production line), in percent for a time period. Let's say, it was 0.5 for Monday and 0.1 for Tuesday.

Not really the 99.9% reliability we usually look for, hehe - but that is another story. For the examples these low numbers are better and easier.

Anyway, if I want to see the average for Monday and Tuesday I use exactly that function: AVG as aggregation in my cube, and I am done. With the example above, I would get a 30% usage of my production machine. (0,5 + 0,1) / 2 in math speak.

My question now is this: I have not one machine, but several. Along this "machine number" dimension, I do NOT want to average, but really sum up the values: Let's say my 2nd machine did 0,8 for Monday, together with the #1 machine that did 0,5 I'd like to see the Monday really as 1.3, or 130% - the actual display of the number is no issue.

Sounds easy, but somehow I have no idea how to do that. Can I have different functions for each dimension that aggregates a value? Or is that a custom MDX script?

Have you tried changing your measure to use the AverageOfChildren aggregate function (instead of the Sum function)? (This is a measure property, not something in the calc script.) What you have is a semi-additive measure... it should be summed across all dimensions except for the Timem dimension. That's what the AverageOfChildren, LastNonEmpty, etc. aggregate functions are for.|||

Spot on! THANKS!

Defining the dimension as Time and using AverageOfChildren did solve it.

But...

What if I have several time dimensions? I might be doing something wrong, but it seems the AverageOfChildren does the Avg only on the FIRST time dimension in the cube - the other time dimensions are treated as the regular ones... does that make sense?

In my case, having date (year/date) and time (hour/minutes) in separate dimension I think I can solve by cross joining the tables and use that as source for one dimension. But what in a case where you have truly different dates in your cube, say an order date, one delivery date and maybe one invoice date, yet you need your counter to be "avg" or "last" or so along EACH of these datetime dimensions?

|||

You're correct that semi-additive measures sum across all dimensions except the first time dimension. Usually this is what you want... for instance, take an Inventory Status measure group which is a daily snapshot of all your inventory. Besides your main Date dimension, you might also have a Received Date dimension. If you sliced by Received Date, you're wanting to slice down to inventory which was received on that date, but the semi-additive behavior should operate on the main Date dimension not the Received Date dimension.

Your situation is probably not the common one, so you may have to resort to using the calc script to detect which date dimension you have sliced by.

I would avoid putting the days and time of day within the same dimension if you can. It's a simple dimension size concern... a normal Date dimension which goes down to day has 365 members per year. But if you go down to second, it has 31,536,000 members.

Different behavior between VS and IE in rendering reports with fixed headers and a document map

I apologize in advance if this is something already addressed elsewhere (if so - please point me in that direction).

I have created a really simple report that allows 'drill-down' at the group level. To this report I also selected the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features and all worked as expected after deploying.

I then added a Document Map referencing the group level and that too worked within the VS environment. VS displayed a page that contained the requested group in plain view and I could 'drill down' as expected.

But when I deployed the report and subsequently pulled it up in IE I noticed a slightly different behavior in that when selecting an entry from the document map, the start of that group got hidden behind the fixed header such that what was visible was perhaps 1 or 2 group records down. I had to scroll up to see the start of the group I had selected from the document map and then drill down from there.

Removing both the "Repeat header..." and "Header should remain ...." allows me to select a group from the document map (which is always at the top) - but in doing so I lose the fixed header feature.

Does anyone have any ideas what I am doing wrong?

Bob

I am experiencing this same problem as well. I would also like to know if there is a fix or workaround to this.|||I also have an issue with a similar setup. The report works well in VS 05, after deplying the document map displays a short list of entries, I'm unable to navigate to the bottom of the document map listing and I cannot "type ahead" as in VS environment.

Different behavior between VS and IE in rendering reports with fixed headers and a document map

I apologize in advance if this is something already addressed elsewhere (if so - please point me in that direction).

I have created a really simple report that allows 'drill-down' at the group level. To this report I also selected the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features and all worked as expected after deploying.

I then added a Document Map referencing the group level and that too worked within the VS environment. VS displayed a page that contained the requested group in plain view and I could 'drill down' as expected.

But when I deployed the report and subsequently pulled it up in IE I noticed a slightly different behavior in that when selecting an entry from the document map, the start of that group got hidden behind the fixed header such that what was visible was perhaps 1 or 2 group records down. I had to scroll up to see the start of the group I had selected from the document map and then drill down from there.

Removing both the "Repeat header..." and "Header should remain ...." allows me to select a group from the document map (which is always at the top) - but in doing so I lose the fixed header feature.

Does anyone have any ideas what I am doing wrong?

Bob

I am experiencing this same problem as well. I would also like to know if there is a fix or workaround to this.

Different behavior between VS and IE in rendering reports with fixed headers and a document map

I apologize in advance if this is something already addressed elsewhere (if so - please point me in that direction).

I have created a really simple report that allows 'drill-down' at the group level. To this report I also selected the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features and all worked as expected after deploying.

I then added a Document Map referencing the group level and that too worked within the VS environment. VS displayed a page that contained the requested group in plain view and I could 'drill down' as expected.

But when I deployed the report and subsequently pulled it up in IE I noticed a slightly different behavior in that when selecting an entry from the document map, the start of that group got hidden behind the fixed header such that what was visible was perhaps 1 or 2 group records down. I had to scroll up to see the start of the group I had selected from the document map and then drill down from there.

Removing both the "Repeat header..." and "Header should remain ...." allows me to select a group from the document map (which is always at the top) - but in doing so I lose the fixed header feature.

Does anyone have any ideas what I am doing wrong?

Bob

I am experiencing this same problem as well. I would also like to know if there is a fix or workaround to this.|||I also have an issue with a similar setup. The report works well in VS 05, after deplying the document map displays a short list of entries, I'm unable to navigate to the bottom of the document map listing and I cannot "type ahead" as in VS environment.

Differences between 2005, 2000, and Express - documentation, whitepapers?

Can anyone point me in the direction of some NON-sales documentation on the differences between these product? I am sure, especially with Express, there are considerable functionality and architecture differences.

I've looked in BOL, and I've done searches online.

All i seem to get is sales related stuff.

I'm curious about the architecture of SQL 2005, SQL express. In 2000, there was some fairly detailed documentaiton on this subject, but 2005 BOL seems REALLY diffucult to find things.

I may just need to try different keywords...

Here is a good page for 2005: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||

Hello all, two questions that perhaps are related:

Is it a bad idea to use sqlexpress for systemtests if prod-environment is sql2005? I am using stored procs against tables, simple techniques. No fancy stuff like external functions, webservices or similar .

I have to use standard security with a sqluser but I get authorisation failure. Do I need to set sqlexpress to allow mixed mode? How do I do that?

Thanks in advance!

/Rasmus

|||

yacrumb2,

Yes, you can use SQL Express for testing; you wouldn't be able to test SQL Agent Jobs and some of the other more 'advanced' functionality. But for simple stored procedure testing, there should be no problem. However, I would recommend that your test environment closely 'match' the production environment. (Or that you use the Developer's Edition -which cost only about $50 US, and is the same as Enterprise Edition)

Any version can use SQL Authentication, just set for 'Mixed Mode' on the security tab of the Server Properties window in SSMS (or SSMSE). If you are having problems, you may wish to post the error message and how you are trying to connect so we can help you.