How to set up trusted connection on SSAS 2005?

Hi,

How to setup trusted connection on SSAS2005?

We followed step by step, but always failed, I have pulled off all my hair for this issue.

We are running AS2005 on Windows server 2003, the AS will be connected via Scorecard web service(Scorecard Manager) which is hosted on Sharepoint server.

Can anybody give me some detailed instructions?

Thanks

What are the step by step instructions you refer to?

Is this question about setting connection from Scorecard web service to AS2005?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Here is the link.

http://www.mosha.com/msolap/articles/kerberos_delegation.htm

Bill

How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003
Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.c om...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003
|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003