Friday, March 30, 2012

pfpagealloc error

I am running Sql Server 2005 SP 2 CTP and keep getting an error which says Internal Error pfpagealloc.cpp file is corrupt. This did not happen with SP1 and is very speradic. I get the problem when using both excel and the visual studio browser to manipulate an anylsis services database. I can then try again and everything works. I also get the same problem sometimes with my overnight rebuild of the cube.

Paul

Please, please. If you can catch the repro schenario, create a report with http://connect.microsoft.com/sql.

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

|||

We just applied SP 2 CTP and we are periodically getting the same error.

However, if we run the same MDX query immediately, we do not encounter it again. We can then run many other MDX queries without incident, but eventually we will generate the error again.

Error message is below:

Executing the query ...

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Execution complete

|||

Please report this with http://connect.microsoft.com/sql.

This looks like a memory pressure problem. See if you get enoght memory for Analysis Server.

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

|||

This is exactly the issue I was getting and I did try to log my problem with connect. Unfortunately they obviously needed log files to be able to trace the problem and as unfortunately the system was live I had to go back to sp1.

Please let me know if you have any luck with a resolution I will contine to check on connect site.

pfpagealloc error

I am running Sql Server 2005 SP 2 CTP and keep getting an error which says Internal Error pfpagealloc.cpp file is corrupt. This did not happen with SP1 and is very speradic. I get the problem when using both excel and the visual studio browser to manipulate an anylsis services database. I can then try again and everything works. I also get the same problem sometimes with my overnight rebuild of the cube.

Paul

Please, please. If you can catch the repro schenario, create a report with http://connect.microsoft.com/sql.

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

|||

We just applied SP 2 CTP and we are periodically getting the same error.

However, if we run the same MDX query immediately, we do not encounter it again. We can then run many other MDX queries without incident, but eventually we will generate the error again.

Error message is below:

Executing the query ...

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Execution complete

|||

Please report this with http://connect.microsoft.com/sql.

This looks like a memory pressure problem. See if you get enoght memory for Analysis Server.

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

|||

This is exactly the issue I was getting and I did try to log my problem with connect. Unfortunately they obviously needed log files to be able to trace the problem and as unfortunately the system was live I had to go back to sp1.

Please let me know if you have any luck with a resolution I will contine to check on connect site.

sql

PF Usage

I have a SQL server 2005 box with 8 GB physical memory. The windows task
manager reports 7.4G PF Usage. Is this accurate?Hello,
It should be correct. But use the performance monitor to measure the correct
usage. Take a look int the below URL:-
http://msdn2.microsoft.com/en-us/library/ms176018.aspx
Thanks
Hari
"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:55174532-F7F0-4EEC-8427-81C271DFF935@.microsoft.com...
>I have a SQL server 2005 box with 8 GB physical memory. The windows task
> manaer reports 7.4G PF Usage. Is this accurate?

PF numbers

Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
this number is calculated. According to help : It is 'The amount of paging
file being used by the system.' Considering I have paging file 2GB big how
come Task Manager shows 10.3 GB?
Thanks you in advance,
Igor
Hi
Have you checked that the Page File is not also on other discs?
What does performance monitor show for this?
John
"imarchenko" wrote:

> Hello!
> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
> RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
> this number is calculated. According to help : It is 'The amount of paging
> file being used by the system.' Considering I have paging file 2GB big how
> come Task Manager shows 10.3 GB?
>
> Thanks you in advance,
> Igor
>
>
|||John,
There is only one Page File located on drive C.
Igor
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ABD53369-1AEC-4893-A353-58DE3D716359@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked that the Page File is not also on other discs?
> What does performance monitor show for this?
> John
> "imarchenko" wrote:

PF numbers

Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
this number is calculated. According to help : It is 'The amount of paging
file being used by the system.' Considering I have paging file 2GB big how
come Task Manager shows 10.3 GB?
Thanks you in advance,
IgorHi
Have you checked that the Page File is not also on other discs?
What does performance monitor show for this?
John
"imarchenko" wrote:
> Hello!
> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
> RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
> this number is calculated. According to help : It is 'The amount of paging
> file being used by the system.' Considering I have paging file 2GB big how
> come Task Manager shows 10.3 GB?
>
> Thanks you in advance,
> Igor
>
>|||John,
There is only one Page File located on drive C.
Igor
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ABD53369-1AEC-4893-A353-58DE3D716359@.microsoft.com...
> Hi
> Have you checked that the Page File is not also on other discs?
> What does performance monitor show for this?
> John
> "imarchenko" wrote:
>> Hello!
>> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
>> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB
>> of
>> RAM. SQL Server is restricted to 10GB. There is only one page file
>> 2046MB.
>> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
>> this number is calculated. According to help : It is 'The amount of
>> paging
>> file being used by the system.' Considering I have paging file 2GB big
>> how
>> come Task Manager shows 10.3 GB?
>>
>> Thanks you in advance,
>> Igor
>>
>>

PF numbers

Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
this number is calculated. According to help : It is 'The amount of paging
file being used by the system.' Considering I have paging file 2GB big how
come Task Manager shows 10.3 GB?
Thanks you in advance,
IgorHi
Have you checked that the Page File is not also on other discs?
What does performance monitor show for this?
John
"imarchenko" wrote:

> Hello!
> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
> RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
> this number is calculated. According to help : It is 'The amount of paging
> file being used by the system.' Considering I have paging file 2GB big how
> come Task Manager shows 10.3 GB?
>
> Thanks you in advance,
> Igor
>
>|||John,
There is only one Page File located on drive C.
Igor
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ABD53369-1AEC-4893-A353-58DE3D716359@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked that the Page File is not also on other discs?
> What does performance monitor show for this?
> John
> "imarchenko" wrote:
>

Pevious SQL statement for Reporting Services:

I need to write a SQL statement or IIF statement to get results that I need in Reporting Services. Below is what I need and I am unsure how to create the statement for my results.

I have a lot number which is associated with a PB Number and an Expected Start and Expected End Date that is running in production. The lot number is a parameter that the end user will key in the report. I need the report to display the previous lot number which ran on the same PB number. I think that I would need to use the Expected State Date and the Expected End date for that lot's running time in order to get the previous lot number. How would I write the SQL statement? ANY SUGGESTIONS?

Thanks, Ronda

So how do you define "previous lot number". Is it a lot number that has an earlier start date?

If that is the case I would try something like this

select top 1 LotNumber from table_name t1 where LotNumber != @.LotNum AND PbNumber in (select PbNumber from table_name t2 where LotNumber = @.LotNum) order by StartDate descending

I'm not sure about descending on the end. It might have to be ascending. I forgot how Dates are ordered.

sql

Petterns for SQL Tables and Stored Procedures

I am looking for some patterns in SQL Server. The Patterns and Paractices
did not seem to have what I am looking for, but it would seem to me that it
is a very commmon scenario that must have been covered.
Basically, it is the problem of aggregating data for overviews.
Assume the following:
Table Services
[SID][ServiceName][ServiceCategoryID][PI
D] [AmmountDue]
Table Payer
[PID][PayerCategory][PayerName]
Table Payments
[PayID][SID][Date][Amount][PID] ** Occasionally a third party might pay
for someone else
Table ServiceCategory
[ServiceCategoryID][ServiceCategoryName]
Table PayerCategory
[PayerCategoryID][PayerCategoryName]
Now, I want to get a summary of the data very quickly that breaks things
down like:
By ServiceCategory
TotalAmountPaid TotalDue AmountDueFrom30DaysAgo ADF31-60DaysAgo
adf61-90Days Ago
Then break these down by PayerCategory
This would seem like a common type of thing, and Ican think of ways to do
this but that take a lot of time, if there are millions of rows, and I can
imagine that triggers might be useful here to keep up to date, but I am
unfamiliar with them.
If you can give me any guidance on this it owuld be helpful. For extra
points, what about being able to dynamically change the periods from say
0-30days to 0-15 days)
Thanks a lot
BBFor starters, you need to post some ddl, sample data and expected results.
Not just a narrative.
I can tell you this though - without dates in your services table or
payments table to know when the service and payments took place, what you're
looking for is impossible.
"bobbyballgame" wrote:

> I am looking for some patterns in SQL Server. The Patterns and Paractices
> did not seem to have what I am looking for, but it would seem to me that i
t
> is a very commmon scenario that must have been covered.
> Basically, it is the problem of aggregating data for overviews.
> Assume the following:
> Table Services
> [SID][ServiceName][ServiceCategoryID][PI
D] [AmmountDue]
> Table Payer
> [PID][PayerCategory][PayerName]
> Table Payments
> [PayID][SID][Date][Amount][PID] ** Occasionally a third party might pay
> for someone else
> Table ServiceCategory
> [ServiceCategoryID][ServiceCategoryName]
> Table PayerCategory
> [PayerCategoryID][PayerCategoryName]
>
> Now, I want to get a summary of the data very quickly that breaks things
> down like:
> By ServiceCategory
> TotalAmountPaid TotalDue AmountDueFrom30DaysAgo ADF31-60DaysAgo
> adf61-90Days Ago
> Then break these down by PayerCategory
>
> This would seem like a common type of thing, and Ican think of ways to do
> this but that take a lot of time, if there are millions of rows, and I can
> imagine that triggers might be useful here to keep up to date, but I am
> unfamiliar with them.
> If you can give me any guidance on this it owuld be helpful. For extra
> points, what about being able to dynamically change the periods from say
> 0-30days to 0-15 days)
> Thanks a lot
> BB
>
>
>|||Steve,
Thanks. The tables are internal ( I would not be allowed to post them) and a
lot more complicated. For example the Payments Table has 31 fields in it, so
I was trying to simplify.
The Service does have a Date field. Sorry about the ommission. Really, I am
looking for a general pattern for the problem of needing aggregate data from
many, amny rows quickly, so I thought a narrative would be more useful.
I will work on a model that is a little more simple, and for what is worth,
I need the data in XML format from SQL 2000.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:070D02CF-7367-4593-91F4-6533588D830E@.microsoft.com...
> For starters, you need to post some ddl, sample data and expected results.
> Not just a narrative.
> I can tell you this though - without dates in your services table or
> payments table to know when the service and payments took place, what
> you're
> looking for is impossible.
>
> "bobbyballgame" wrote:
>

pessimistic vs optimistic concurrency control

Could someone explain to me what the difference between pessimistic (for examle 2PL) and optimistic concurrency control is?I have never heard of "2PL" before, but anyway:

Pessimistic means you actually lock the data when you select it to make sure nobody else can update it before you do. For example in Oracle you would SELECT ... FROM ... WHERE ... FOR UPDATE;

Optimistic means that you do not lock the data when you select it, but when you subsequently update it you check that it has not been updated by someone else in the meanwhile, otherwise your update fails. There are various ways to do this - record version numbers, last_update timestamps, or just check all the data values like this:

UPDATE ...
SET val1 = :new_val1, val2 = :new_val2, ...
WHERE key = :key
and val1 = :old_val1, val2 = :old_val2, ...;

(:old_val1, :new_val1 are variables holding the selected and modified values for column val1).

Pessimistic locking requires that a database session is maintained between the select and the update. In web-based applications, no database connection is maintained and so optimistic locking must be used.|||I suspect that mrmonkeyboy meant 2PC, a common abbreviation for two phase commit. I can see a slight resemblance between pessimistic locking and two phase commit... Both of them are intensely statefull.

-PatP|||Ok! Thanks a lot for the info!

-Mr Monkeyboy|||FYI: Two Phase Locking Protocol ( 2PL )

"In a given transaction, all locks precede all unlocks, i.e. once a transaction has released a lock it cannot acquire any more locks.

2PL guarantees serializability for all transactions that go to conclusion"|||Thanks, I hadn't come across that term before.

Pessimistic locking

I am attempting to try a pesimistic lock, meaning that i want to lock a row or table for a period of time and then relase it when i am done. To test this i wrote the following:

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
BEGIN TRANsaction
Select * From configurationitem WITH (ROWLOCK,xlock)
where name = 'NextReceiptNumber' and category = 'AR';

Declare @.i int
set @.i = 0
while @.i < 300000
Begin
print @.i
set @.i = @.i + 1
end
COMMIT TRANsaction

To test, while the above is looping i open another query window and select from the same table using the following:

Select ConfigurationItemValue From configurationitem where ItemID = 418

This does not work because this query returns IMMEDIATELY. However, if I change the query to the following:

Select ConfigurationItemValue From configurationitem where name = 'NextReceiptNumber' and category = 'AR';

It does not return until the transaction query above is finished (which is the way it should work).

So, my question is, why does it not lock when i select by a primary key but lock when i do NOT select by a primary key (ItemID is a primary key).

thanks in advance.

Ok, I think we are missing something here. Is the primary key value for this row = 418? You should only have an exclusive lock on the row.

This is the table that I tested with, and it did wait when I looked for 418, and not for any other row. Any query that requires a table scan (snapshot isolation not withstanding) will not be able to complete (which would be the case for a query that looks for name and category, no matter what your values are.) This is because other queries will take a lock on every row in the table eventually and will get stuck on the locked rows.

drop table configurationItem
go
create table configurationItem
(
itemId int primary key,
name varchar(100),
category char(2),
configurationItemValue varchar(10)
)
insert into configurationItem
select 418,'NextReceiptNumber','AR','sals'
union all
select 2,'asldfjlka','AT','sals'
union all
select 3,'aqjsadklfaj','DR','sals'
union all
select 4,'ao2ioi23jkasd','DD','sals'
union all
select 5,'alifdjald','CD','sals'
union all
select 6,'ajsdflkasdlkja','CF','sals'
union all
select 7,'juqoiwfewoijlk','TT','sals'
union all
select 8,'asdancas','QR','sals'


|||Using XLOCK in SELECT statements will not prevent reads from happening. This is because SQL Server has a special optimization under read committed isolation level that checks if the row is dirty or not and ignores the xlock if the row has not changed. Since this is acceptable under the read committed isolation level semantics it is by design. So you will have to use a more aggressive locking hint like UPDLOCK with ROWLOCK. But what are you trying that requires such pessimistic locking strategies? Why do you want to do row-by-row procedural processing? Can't you use set-based operations instead?

Pesky Home Page

I can't seem to get my home page to stay put. SOMEHOW, my
home page is from some th.msie.cc/index.php?aid=2003 and
I cannot get rid of it. It has made itself my default
home page. I don't know where in the heck it came from in
the first place...probably my husband and his dirty web
sites !! Please HELP!!RUn internet Explorer. then choose the Tools menu, -> Internet Options... ON
the general tab there is a box where you can set the home page... You can
choose Use Default or set it whereever ie( www.msn.com)
Good luck
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Atlantis" <anonymous@.discussions.microsoft.com> wrote in message
news:1345401c41200$34f0c1f0$a101280a@.phx
.gbl...
> I can't seem to get my home page to stay put. SOMEHOW, my
> home page is from some th.msie.cc/index.php?aid=2003 and
> I cannot get rid of it. It has made itself my default
> home page. I don't know where in the heck it came from in
> the first place...probably my husband and his dirty web
> sites !! Please HELP!!|||This may not be enough because such spyware will overwrite the homepage on s
tartup. Download a copy of SpyBot and/or Adaware. Both will scan and kill sp
ywares.|||
>--Original Message--
>This may not be enough because such spyware will
overwrite the homepage on startup. Download a copy of
SpyBot and/or Adaware. Both will scan and kill spywares.
>.
>Thanks for the help you gave. I ended up installing a
SpyKiller and it has eliminated the problem. The real
problem was solved, through much trial and error, by
going into the registry and resetting the home page and
search site to the web address I desired. I discovered,
too, that all of this was caused when I downloaded AOL
onto my computer. The media player needed for the 9.0 has
the spyware in it and overwrites the homepage settings
for Internet Explorer. I, of course, uninstalled AOL and
went back to Bell South where I was relatively
safe...except for the terrible experience I had with
their Accelerator. DO NOT download it. BellSouth even
says that it is only experimental!!
Again...Thanks!!|||I had the same problem. SpyBot and Ad-ware do not cure it. Delete a file c
:/windows/dp.dll, if you can. I couldn't delete it, but I renamed it, and m
y homepage stays put, now.

Pervassive Client Install

Would anyone install a Pervassive client application into the windows & sql
2005 cluster environment?
I don't see why not, although I'd prefer not to install Pervasive in any
environment.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"John Kamensky" <jkamensky@.whitfordww.com> wrote in message
news:%23fTtgDCVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Would anyone install a Pervassive client application into the windows &
> sql 2005 cluster environment?
>
sql

Pervassive Client Install

Would anyone install a Pervassive client application into the windows & sql
2005 cluster environment?I don't see why not, although I'd prefer not to install Pervasive in any
environment.
--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"John Kamensky" <jkamensky@.whitfordww.com> wrote in message
news:%23fTtgDCVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Would anyone install a Pervassive client application into the windows &
> sql 2005 cluster environment?
>

Pervassive Client Install

Would anyone install a Pervassive client application into the windows & sql
2005 cluster environment?I don't see why not, although I'd prefer not to install Pervasive in any
environment.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"John Kamensky" <jkamensky@.whitfordww.com> wrote in message
news:%23fTtgDCVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Would anyone install a Pervassive client application into the windows &
> sql 2005 cluster environment?
>

pervasive SQL V8 vs SQL server 2000

My company is trying to determine if they need to upgrade from our current Platinum accounting application that uses pervasive SQL V8 to another version of Platinum that uses SQL server 2000.

My manager wants a in-depth analysis comparing pervasive SQL V8 to SQL server 2000.

I have searched the web extensively but information is scarce.

Are there any articles or case studies that do an indepth analysis comparing both databases? Can someone please help me. It would be greatly appreciated.please don't cross-post

if you do not wish your thread to be in the pervasive forum, let me know if you wish it to be moved to the sql server (or any other) forum|||Here's a white paper that talks about cost of ownership of PSQL:
http://www.pervasive.com/download_Check.asp?download=/documentation/whitepapers/pdf/Aberdeen_v8.pdf
You're probably not going to find too many "in depth analysis" comparing the two databases because for the most part they don't occupy the same market.
Pervasive is marketed more for mid sized businesses where SQL Server is marketed toward the enterprise. That doesn't mean that PSQL can't hold it's own in the enterprise. I've seen PSQL running in an environment where there were 1500 + concurrent users hitting the database. I know that some very large companies use PSQL. For example, Fry's electronics uses PSQL for it's Point of Sale system. Here's a link with a "Wall of Fame" for PSQL references.
http://www.pervasive.com/lp/walloffame2/?referer=/psql/index.asp?promo=

Pervasive SQL in same box as MSSQL 2000 ?

Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
would there be any problems setting both up in the same box ?
It works. Still have a few of those in production environment. Hope you are
not using Pervasive for new stuff:-) Bad enough to have legacy crap depend
on it. We are phasing out all Pervasive stuff (and SQL 2000 for that matter)
hope it helps
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F019D688-692A-4F5E-9273-425E0D671C86@.microsoft.com...
> Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
> would there be any problems setting both up in the same box ?

Pervasive SQL in same box as MSSQL 2000 ?

Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
would there be any problems setting both up in the same box ?It works. Still have a few of those in production environment. Hope you are
not using Pervasive for new stuff:-) Bad enough to have legacy crap depend
on it. We are phasing out all Pervasive stuff (and SQL 2000 for that matter)
hope it helps
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F019D688-692A-4F5E-9273-425E0D671C86@.microsoft.com...
> Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
> would there be any problems setting both up in the same box ?sql

Pervasive "Arithmetic overflow occurred." message

I'm encountering a problem with a SQL Server 2000 installation. The steps
to reproduce are simple: log in to the server via OSQL or "Query Analyzer".
Run "sp_help". I immediately receive several "Arithmetic overflow
occurred." messages followed by the standard results expected from
"sp_help". All other queries also report the same error message, though the
results seem to be correct. Doesn't matter what DB I'm running against.
Doesn't matter what ID I've logged in with. I've tried different client
machines. I don't see the problem when I connect to other SQL Server 2000
installations. I also tried it from the console of the SQL Server machine
itself w/"Query Analyzer". Same result.
What would cause this and how do I correct it?
Thanks,
--David
I'd suggest applying the latest service pack
You can get it here :-
http://www.microsoft.com/technet/pro...s/default.mspx
HTH. Ryan
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
> overflow occurred." messages followed by the standard results expected
> from "sp_help". All other queries also report the same error message,
> though the results seem to be correct. Doesn't matter what DB I'm running
> against. Doesn't matter what ID I've logged in with. I've tried different
> client machines. I don't see the problem when I connect to other SQL
> Server 2000 installations. I also tried it from the console of the SQL
> Server machine itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>
|||Are you able gauge which line on sp_help the error is occurring?
If so, you could open the stored procedure and see the source of the problem
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/remotedba.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
Analyzer".
> Run "sp_help". I immediately receive several "Arithmetic overflow
> occurred." messages followed by the standard results expected from
> "sp_help". All other queries also report the same error message, though
the
> results seem to be correct. Doesn't matter what DB I'm running against.
> Doesn't matter what ID I've logged in with. I've tried different client
> machines. I don't see the problem when I connect to other SQL Server 2000
> installations. I also tried it from the console of the SQL Server machine
> itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>
|||Looks to me like we're current (at least for SQL Server 2000):
SELECT @.@.VERSION
GO
Arithmetic overflow occurred.
<...snip...>
Arithmetic overflow occurred.
-----------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23ZQVmF4GGHA.2212@.TK2MSFTNGP15.phx.gbl...
> I'd suggest applying the latest service pack
> You can get it here :-
> http://www.microsoft.com/technet/pro...s/default.mspx
> --
> HTH. Ryan
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>
|||This happens on _any_ query, stored procedure, etc. For instance (pieced
together from "Query Analyzer"):
SELECT @.@.VERSION
GO
Arithmetic overflow occurred.
<...snip...>
Arithmetic overflow occurred.
-----------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
"Jack Vamvas" <info@.nospam.com> wrote in message
news:dqj6l6$2v3$1@.nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
> Are you able gauge which line on sp_help the error is occurring?
> If so, you could open the stored procedure and see the source of the
> problem
>
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/remotedba.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
>
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> Analyzer".
> the
>
|||I did two things and the problem disappeared:
1. I installed the latest _security_ patches (the latest service patches
were
already installed).
2. As required by the security patches, I rebooted the machine.
Seems odd that the problem would be cured by one of these two actions.
Good thing this wasn't a production SQL Server.
--David
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
> overflow occurred." messages followed by the standard results expected
> from "sp_help". All other queries also report the same error message,
> though the results seem to be correct. Doesn't matter what DB I'm running
> against. Doesn't matter what ID I've logged in with. I've tried different
> client machines. I don't see the problem when I connect to other SQL
> Server 2000 installations. I also tried it from the console of the SQL
> Server machine itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>
|||David,
Just seen this KB http://support.microsoft.com/kb/911851/
Chris
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:e55FzMIHGHA.1288@.TK2MSFTNGP09.phx.gbl...
>I did two things and the problem disappeared:
> 1. I installed the latest _security_ patches (the latest service patches
> were
> already installed).
> 2. As required by the security patches, I rebooted the machine.
> Seems odd that the problem would be cured by one of these two actions.
> Good thing this wasn't a production SQL Server.
> --David
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>
>

Pervasive "Arithmetic overflow occurred." message

I'm encountering a problem with a SQL Server 2000 installation. The steps
to reproduce are simple: log in to the server via OSQL or "Query Analyzer".
Run "sp_help". I immediately receive several "Arithmetic overflow
occurred." messages followed by the standard results expected from
"sp_help". All other queries also report the same error message, though the
results seem to be correct. Doesn't matter what DB I'm running against.
Doesn't matter what ID I've logged in with. I've tried different client
machines. I don't see the problem when I connect to other SQL Server 2000
installations. I also tried it from the console of the SQL Server machine
itself w/"Query Analyzer". Same result.
What would cause this and how do I correct it?
Thanks,
--DavidI'd suggest applying the latest service pack
You can get it here :-
http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx
--
HTH. Ryan
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
> overflow occurred." messages followed by the standard results expected
> from "sp_help". All other queries also report the same error message,
> though the results seem to be correct. Doesn't matter what DB I'm running
> against. Doesn't matter what ID I've logged in with. I've tried different
> client machines. I don't see the problem when I connect to other SQL
> Server 2000 installations. I also tried it from the console of the SQL
> Server machine itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>|||Are you able gauge which line on sp_help the error is occurring?
If so, you could open the stored procedure and see the source of the problem
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/remotedba.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
Analyzer".
> Run "sp_help". I immediately receive several "Arithmetic overflow
> occurred." messages followed by the standard results expected from
> "sp_help". All other queries also report the same error message, though
the
> results seem to be correct. Doesn't matter what DB I'm running against.
> Doesn't matter what ID I've logged in with. I've tried different client
> machines. I don't see the problem when I connect to other SQL Server 2000
> installations. I also tried it from the console of the SQL Server machine
> itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>|||Looks to me like we're current (at least for SQL Server 2000):
SELECT @.@.VERSION
GO
Arithmetic overflow occurred.
<...snip...>
Arithmetic overflow occurred.
------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23ZQVmF4GGHA.2212@.TK2MSFTNGP15.phx.gbl...
> I'd suggest applying the latest service pack
> You can get it here :-
> http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx
> --
> HTH. Ryan
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>> I'm encountering a problem with a SQL Server 2000 installation. The
>> steps to reproduce are simple: log in to the server via OSQL or "Query
>> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
>> overflow occurred." messages followed by the standard results expected
>> from "sp_help". All other queries also report the same error message,
>> though the results seem to be correct. Doesn't matter what DB I'm
>> running against. Doesn't matter what ID I've logged in with. I've tried
>> different client machines. I don't see the problem when I connect to
>> other SQL Server 2000 installations. I also tried it from the console of
>> the SQL Server machine itself w/"Query Analyzer". Same result.
>> What would cause this and how do I correct it?
>> Thanks,
>> --David
>>
>|||This happens on _any_ query, stored procedure, etc. For instance (pieced
together from "Query Analyzer"):
SELECT @.@.VERSION
GO
Arithmetic overflow occurred.
<...snip...>
Arithmetic overflow occurred.
------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
"Jack Vamvas" <info@.nospam.com> wrote in message
news:dqj6l6$2v3$1@.nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
> Are you able gauge which line on sp_help the error is occurring?
> If so, you could open the stored procedure and see the source of the
> problem
>
> Jack Vamvas
> __________________________________________________________________
> Receive free SQL tips - register at www.ciquery.com/remotedba.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
>
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>> I'm encountering a problem with a SQL Server 2000 installation. The
>> steps
>> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer".
>> Run "sp_help". I immediately receive several "Arithmetic overflow
>> occurred." messages followed by the standard results expected from
>> "sp_help". All other queries also report the same error message, though
> the
>> results seem to be correct. Doesn't matter what DB I'm running against.
>> Doesn't matter what ID I've logged in with. I've tried different client
>> machines. I don't see the problem when I connect to other SQL Server
>> 2000
>> installations. I also tried it from the console of the SQL Server
>> machine
>> itself w/"Query Analyzer". Same result.
>> What would cause this and how do I correct it?
>> Thanks,
>> --David
>>
>|||I did two things and the problem disappeared:
1. I installed the latest _security_ patches (the latest service patches
were
already installed).
2. As required by the security patches, I rebooted the machine.
Seems odd that the problem would be cured by one of these two actions.
Good thing this wasn't a production SQL Server.
--David
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
> overflow occurred." messages followed by the standard results expected
> from "sp_help". All other queries also report the same error message,
> though the results seem to be correct. Doesn't matter what DB I'm running
> against. Doesn't matter what ID I've logged in with. I've tried different
> client machines. I don't see the problem when I connect to other SQL
> Server 2000 installations. I also tried it from the console of the SQL
> Server machine itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>|||David,
Just seen this KB http://support.microsoft.com/kb/911851/
Chris
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:e55FzMIHGHA.1288@.TK2MSFTNGP09.phx.gbl...
>I did two things and the problem disappeared:
> 1. I installed the latest _security_ patches (the latest service patches
> were
> already installed).
> 2. As required by the security patches, I rebooted the machine.
> Seems odd that the problem would be cured by one of these two actions.
> Good thing this wasn't a production SQL Server.
> --David
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>> I'm encountering a problem with a SQL Server 2000 installation. The
>> steps
>> to reproduce are simple: log in to the server via OSQL or "Query
>> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
>> overflow occurred." messages followed by the standard results expected
>> from "sp_help". All other queries also report the same error message,
>> though the results seem to be correct. Doesn't matter what DB I'm
>> running
>> against. Doesn't matter what ID I've logged in with. I've tried
>> different
>> client machines. I don't see the problem when I connect to other SQL
>> Server 2000 installations. I also tried it from the console of the SQL
>> Server machine itself w/"Query Analyzer". Same result.
>> What would cause this and how do I correct it?
>> Thanks,
>> --David
>>
>
>

Pervasive "Arithmetic overflow occurred." message

I'm encountering a problem with a SQL Server 2000 installation. The steps
to reproduce are simple: log in to the server via OSQL or "Query Analyzer".
Run "sp_help". I immediately receive several "Arithmetic overflow
occurred." messages followed by the standard results expected from
"sp_help". All other queries also report the same error message, though the
results seem to be correct. Doesn't matter what DB I'm running against.
Doesn't matter what ID I've logged in with. I've tried different client
machines. I don't see the problem when I connect to other SQL Server 2000
installations. I also tried it from the console of the SQL Server machine
itself w/"Query Analyzer". Same result.
What would cause this and how do I correct it?
Thanks,
--DavidI'd suggest applying the latest service pack
You can get it here :-
http://www.microsoft.com/technet/pr...ds/default.mspx
HTH. Ryan
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
> overflow occurred." messages followed by the standard results expected
> from "sp_help". All other queries also report the same error message,
> though the results seem to be correct. Doesn't matter what DB I'm running
> against. Doesn't matter what ID I've logged in with. I've tried different
> client machines. I don't see the problem when I connect to other SQL
> Server 2000 installations. I also tried it from the console of the SQL
> Server machine itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>|||Are you able gauge which line on sp_help the error is occurring?
If so, you could open the stored procedure and see the source of the problem
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/remotedba.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
Analyzer".
> Run "sp_help". I immediately receive several "Arithmetic overflow
> occurred." messages followed by the standard results expected from
> "sp_help". All other queries also report the same error message, though
the
> results seem to be correct. Doesn't matter what DB I'm running against.
> Doesn't matter what ID I've logged in with. I've tried different client
> machines. I don't see the problem when I connect to other SQL Server 2000
> installations. I also tried it from the console of the SQL Server machine
> itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>|||Looks to me like we're current (at least for SQL Server 2000):
SELECT @.@.VERSION
GO
Arithmetic overflow occurred.
<...snip...>
Arithmetic overflow occurred.
----
----
----
--
---
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23ZQVmF4GGHA.2212@.TK2MSFTNGP15.phx.gbl...
> I'd suggest applying the latest service pack
> You can get it here :-
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx[/ur
l]
> --
> HTH. Ryan
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>|||This happens on _any_ query, stored procedure, etc. For instance (pieced
together from "Query Analyzer"):
SELECT @.@.VERSION
GO
Arithmetic overflow occurred.
<...snip...>
Arithmetic overflow occurred.
----
----
----
--
---
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
"Jack Vamvas" <info@.nospam.com> wrote in message
news:dqj6l6$2v3$1@.nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
> Are you able gauge which line on sp_help the error is occurring?
> If so, you could open the stored procedure and see the source of the
> problem
>
> Jack Vamvas
> ________________________________________
__________________________
> Receive free SQL tips - register at www.ciquery.com/remotedba.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
>
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> Analyzer".
> the
>|||I did two things and the problem disappeared:
1. I installed the latest _security_ patches (the latest service patches
were
already installed).
2. As required by the security patches, I rebooted the machine.
Seems odd that the problem would be cured by one of these two actions.
Good thing this wasn't a production SQL Server.
--David
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm encountering a problem with a SQL Server 2000 installation. The steps
> to reproduce are simple: log in to the server via OSQL or "Query
> Analyzer". Run "sp_help". I immediately receive several "Arithmetic
> overflow occurred." messages followed by the standard results expected
> from "sp_help". All other queries also report the same error message,
> though the results seem to be correct. Doesn't matter what DB I'm running
> against. Doesn't matter what ID I've logged in with. I've tried different
> client machines. I don't see the problem when I connect to other SQL
> Server 2000 installations. I also tried it from the console of the SQL
> Server machine itself w/"Query Analyzer". Same result.
> What would cause this and how do I correct it?
> Thanks,
> --David
>|||David,
Just seen this KB http://support.microsoft.com/kb/911851/
Chris
"David Ehrlich" <djehrlich@.hotmail.com> wrote in message
news:e55FzMIHGHA.1288@.TK2MSFTNGP09.phx.gbl...
>I did two things and the problem disappeared:
> 1. I installed the latest _security_ patches (the latest service patches
> were
> already installed).
> 2. As required by the security patches, I rebooted the machine.
> Seems odd that the problem would be cured by one of these two actions.
> Good thing this wasn't a production SQL Server.
> --David
> "David Ehrlich" <djehrlich@.hotmail.com> wrote in message
> news:uIzZU$3GGHA.740@.TK2MSFTNGP12.phx.gbl...
>
>

Perspectives with ADOMD.NET and AMO

I am trying to filter our application's cube metadata list (measures, kpis, dimensions, etc.) by perspectives.

Unless I have totally missed something it appears that ADOMD.NET has 0 support for perspectives. You can not iterate measures, dimensions, etc. by perspective using ADOMD.NET. Can anyone verify this or correct me if I'm missing something?

While AMO can be used to iterate measures, dimensions, etc. by perspective, none of its PerspectiveDimension, CubeDimension, PerspectiveMeasure, etc. objects contain UniqueName fields. AMO does not seem to provide any UniqueName fields. Can anyone also verify this or correct me if I'm wrong?

I am currently having to utilize both ADOMD.NET and AMO in order to build the metadata list and support perspective filtering, and I keep thinking there has to be a better way! This is also requiring a LOT of For Looping in order to match up an object in ADOMD.NET to the corresponding object in AMO.

Thanks,
Terry

Perspectives are returned as regular cubes in ADOMD.NET. For browsing data, they are cubes, while from the metadata point of view they are separate entities, so they appear separately in AMO, but not ADOMD.NET.

UniqueName is indeed not exposed in AMO because it's not part of the objects definitions (aka metadata). For example, a DimensionAttribute in AMO doesn't have the UniqueName property, but when browsing the members of that attribute, each will have an UniqueName.

Adrian Dumitrascu

|||Hi Adrian,

Thank you for your help! I'm still a bit confused though. I can not find any property setting within ADOMD.NET to set the perspective that I want to restrict by. Your previous post led me to believe it might be setting on the AdomdConnection object and that thereafter everything would be restricted to that perspective; however, I have not been able to find that in the documentation. Would you please clarify for me how to restrict everything returned in ADOMD.NET to a given perspective?

Thank you,
Terry|||

If you want to define what measures, dimensions and/or attributes to include in a perspective, you need to use AMO. The Cube class in AMO has a collection of Perspectives.

After that, the perspective will appear as any other cube (in excel, or when browsing with ADOMD.NET or other browser), alongside the other cubes and perspectives.

If you want certain users to only see certain measures, dimensions or attributes, but not the rest of the cube, dimensions or attributes, then using a perspective is not the way to go. Perspectives are not a security feature, they are only used to customize the view of a cube. Instead you should define a Role for each category of users and then CubePermissions. That ensures that certain users only see the data they are allowed.

|||Thanks Adrian! I wasn't expecting the perspective to show up as their own cubes, so I didn't look in the ADOMD.NET cube collection.

For others that need to know this, you can iterate all the perspectives of a given cube by looking at adomdConnection.Cubes(i).Properties("BASE_CUBE_NAME") = "My Real Cube" and then use each of those Cube objects to find the perspective-specific measures, dimensions, etc.

Thanks again,
Terry

Perspectives in Report Models Generated for SSAS Cubes not Working

I never got an answer on this so I am reposting this issue. Also, please note that I have consistently reproduced this issue on multiple perspectives within and accross multiple cubes on 3 different SQL Server Instances. I have also had no problem with perspectives within Report Models that were not generated from an SSAS Cube.

Specifics:

=========

I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.

Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.

Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.

By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.

I find it very dissapointing that I have not recieved any response to this issue. I am trying to convince a Federal Bureau to move forward with SQL Server 2005 as its defacto BI Technology, and Ad Hoc reporting is very important. I am starting to wonder if this is the correct approach considering the limited support and the amount of issues I have come accross when using Reporting Services with SSAS.sql

Perspectives in Report Models Generated for SSAS Cubes not Working

I never got an answer on this so I am reposting this issue. Also, please note that I have consistently reproduced this issue on multiple perspectives within and accross multiple cubes on 3 different SQL Server Instances. I have also had no problem with perspectives within Report Models that were not generated from an SSAS Cube.

Specifics:

=========

I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.

Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.

Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.

By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.

I find it very dissapointing that I have not recieved any response to this issue. I am trying to convince a Federal Bureau to move forward with SQL Server 2005 as its defacto BI Technology, and Ad Hoc reporting is very important. I am starting to wonder if this is the correct approach considering the limited support and the amount of issues I have come accross when using Reporting Services with SSAS.

Perspectives Defined in Analysis Cube not working in Report Builder

I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.

Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.

Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.

By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.

Help!!!!

Certainly the perspective in the Report Model should reflect the definition in the cube.

Does this apply to all the perspectives in the cube, if you define multiple of them?

|||Sorry for my delayed response. The answer to your question is yes, my previous message applied to all of the perspectives in the cube. And I have had the same problem on multiple cubes.|||I have the same problem. You already know a solution?

Perspectives Defined in Analysis Cube not working in Report Builder

I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.

Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.

Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.

By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.

Help!!!!

Certainly the perspective in the Report Model should reflect the definition in the cube.

Does this apply to all the perspectives in the cube, if you define multiple of them?

|||Sorry for my delayed response. The answer to your question is yes, my previous message applied to all of the perspectives in the cube. And I have had the same problem on multiple cubes.

Perspectives Defined in Analysis Cube not working in Report Builder

I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.

Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.

Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.

By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.

Help!!!!

Certainly the perspective in the Report Model should reflect the definition in the cube.

Does this apply to all the perspectives in the cube, if you define multiple of them?

|||Sorry for my delayed response. The answer to your question is yes, my previous message applied to all of the perspectives in the cube. And I have had the same problem on multiple cubes.

Perspectives 64 Bit Standard Edition - Not Supported

I received the following message:

Error1Errors related to feature availability and configuration: The 'Perspectives' feature is not included in the '64 Bit Standard Edition' SKU.

Does the 64 Bit developer Edition Support this?

Any suggestion we need to test and stage on our dev box before deploying to 64 bit enterprise prod box.

Thanks,

The 64 bit developer edition will allow you to create perspectives.

Here is a link with the different features for each edition:

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

|||

Maybe the Deployment Server Edition property isn't set to Enterprise?

http://groups.google.com/group/microsoft.public.sqlserver.olap/browse_frm/thread/36855351fd3096b2/c7107957b1da7a13?#c7107957b1da7a13

>>

Aggregation function None is not allowed in Standard edition

From:

Chris Webb - view profile

Date:

Fri, Oct 20 2006 12:24 pm

Email:

Chris Webb <onlyforpostingtonewsgro...@.crossjoin.co.uk>

Groups:

microsoft.public.sqlserver.olap

Not yet rated

Rating:

show options

Reply | Reply to Author | Forward | Print | Individual Message | Show original | Report Abuse | Find messages by this author

Hi Roger,

Have you set the Deployment Server Edition property appropriately on your project?


http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!856.entry

HTH,

Chris
--
Chris Webb, MVP
Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk
Blog: http://cwebbbi.spaces.live.com/

sql

personnal edition license question...

Hi,
I have a first server with SQL 2000 ent.
Today this server support multiple small datawarehouses + staging DB + copy
of the source DB.
I want to move the copy of the operationnal databases to another server, but
this server will be never used except during the loading process and during
the copy of the operationnal database to the server.
Can I use the personnal edition on this second server?
What is the impact from a licensing point of view? (and price)
Or can I use the developper edition?
Final option is to install a workgroup edition (?)
thanks.
Jerome.Personal Edition just requires a client licence, either a CAL or
installed on a machine that accesses another processor-licensed server.
PE is limited to 2GB database size however, so that may be an issue.
Dev Edition is licensed only for non-production development and
testing.
Check out the following link for info on the features supported by each
edition
http://www.microsoft.com/sql/evalua...s/choosing.mspx
David Portas
SQL Server MVP
--|||David Portas wrote:
> Personal Edition just requires a client licence, either a CAL or
> installed on a machine that accesses another processor-licensed
> server. PE is limited to 2GB database size however, so that may be an
> issue.
> Dev Edition is licensed only for non-production development and
> testing.
> Check out the following link for info on the features supported by
> each edition
> http://www.microsoft.com/sql/evalua...s/choosing.mspx
> --
> David Portas
> SQL Server MVP
David,
PE does not have a 2GB limit like MSDE. However, it does have the same
query governor in MSDE that throttles SQL Server with more than about 5
connections. I currently have Personal Edition running on my XP laptop
with databases in the 5GB range.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||and what if we have a processor license of SQL 2000 enterprise ?
does the personnal edition follow the same license model?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uUUfsdTmFHA.2860@.TK2MSFTNGP15.phx.gbl...
> David Portas wrote:
> David,
> PE does not have a 2GB limit like MSDE. However, it does have the same
> query governor in MSDE that throttles SQL Server with more than about 5
> connections. I currently have Personal Edition running on my XP laptop
> with databases in the 5GB range.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jj wrote:
> and what if we have a processor license of SQL 2000 enterprise ?
> does the personnal edition follow the same license model?
>
http://www.microsoft.com/sql/howtobuy/personal.mspx
David Gugick
Quest Software
www.imceda.com
www.quest.com|||like other license document from MS...
this document doesn't describe what's appends exactly...
I have a 2 processors license, so I have a 2 processor personnal edition
license?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:OLCUa5UmFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Jj wrote:
> http://www.microsoft.com/sql/howtobuy/personal.mspx
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jj wrote:
> like other license document from MS...
> this document doesn't describe what's appends exactly...
> I have a 2 processors license, so I have a 2 processor personnal
> edition license?
You should speak to a MS licensing exec for licensing questions. My
understanding is that if you own Standard or EE and have a processor
license, you can use Personal Edition on non-server hardware to support
your application when they are not connected to the main server.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, thanks for the correction.
David Portas
SQL Server MVP
--

personnal edition license question...

Hi,
I have a first server with SQL 2000 ent.
Today this server support multiple small datawarehouses + staging DB + copy
of the source DB.
I want to move the copy of the operationnal databases to another server, but
this server will be never used except during the loading process and during
the copy of the operationnal database to the server.
Can I use the personnal edition on this second server?
What is the impact from a licensing point of view? (and price)
Or can I use the developper edition?
Final option is to install a workgroup edition (?)
thanks.
Jerome.
Personal Edition just requires a client licence, either a CAL or
installed on a machine that accesses another processor-licensed server.
PE is limited to 2GB database size however, so that may be an issue.
Dev Edition is licensed only for non-production development and
testing.
Check out the following link for info on the features supported by each
edition
http://www.microsoft.com/sql/evaluat.../choosing.mspx
David Portas
SQL Server MVP
|||David Portas wrote:
> Personal Edition just requires a client licence, either a CAL or
> installed on a machine that accesses another processor-licensed
> server. PE is limited to 2GB database size however, so that may be an
> issue.
> Dev Edition is licensed only for non-production development and
> testing.
> Check out the following link for info on the features supported by
> each edition
> http://www.microsoft.com/sql/evaluat.../choosing.mspx
> --
> David Portas
> SQL Server MVP
David,
PE does not have a 2GB limit like MSDE. However, it does have the same
query governor in MSDE that throttles SQL Server with more than about 5
connections. I currently have Personal Edition running on my XP laptop
with databases in the 5GB range.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||and what if we have a processor license of SQL 2000 enterprise ?
does the personnal edition follow the same license model?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uUUfsdTmFHA.2860@.TK2MSFTNGP15.phx.gbl...
> David Portas wrote:
> David,
> PE does not have a 2GB limit like MSDE. However, it does have the same
> query governor in MSDE that throttles SQL Server with more than about 5
> connections. I currently have Personal Edition running on my XP laptop
> with databases in the 5GB range.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Jj wrote:
> and what if we have a processor license of SQL 2000 enterprise ?
> does the personnal edition follow the same license model?
>
http://www.microsoft.com/sql/howtobuy/personal.mspx
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||like other license document from MS...
this document doesn't describe what's appends exactly...
I have a 2 processors license, so I have a 2 processor personnal edition
license?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:OLCUa5UmFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Jj wrote:
> http://www.microsoft.com/sql/howtobuy/personal.mspx
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Jj wrote:
> like other license document from MS...
> this document doesn't describe what's appends exactly...
> I have a 2 processors license, so I have a 2 processor personnal
> edition license?
You should speak to a MS licensing exec for licensing questions. My
understanding is that if you own Standard or EE and have a processor
license, you can use Personal Edition on non-server hardware to support
your application when they are not connected to the main server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yes, thanks for the correction.
David Portas
SQL Server MVP

personnal edition license question...

Hi,
I have a first server with SQL 2000 ent.
Today this server support multiple small datawarehouses + staging DB + copy
of the source DB.
I want to move the copy of the operationnal databases to another server, but
this server will be never used except during the loading process and during
the copy of the operationnal database to the server.
Can I use the personnal edition on this second server?
What is the impact from a licensing point of view? (and price)
Or can I use the developper edition?
Final option is to install a workgroup edition (?)
thanks.
Jerome.Personal Edition just requires a client licence, either a CAL or
installed on a machine that accesses another processor-licensed server.
PE is limited to 2GB database size however, so that may be an issue.
Dev Edition is licensed only for non-production development and
testing.
Check out the following link for info on the features supported by each
edition
http://www.microsoft.com/sql/evaluation/features/choosing.mspx
--
David Portas
SQL Server MVP
--|||David Portas wrote:
> Personal Edition just requires a client licence, either a CAL or
> installed on a machine that accesses another processor-licensed
> server. PE is limited to 2GB database size however, so that may be an
> issue.
> Dev Edition is licensed only for non-production development and
> testing.
> Check out the following link for info on the features supported by
> each edition
> http://www.microsoft.com/sql/evaluation/features/choosing.mspx
> --
> David Portas
> SQL Server MVP
David,
PE does not have a 2GB limit like MSDE. However, it does have the same
query governor in MSDE that throttles SQL Server with more than about 5
connections. I currently have Personal Edition running on my XP laptop
with databases in the 5GB range.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||and what if we have a processor license of SQL 2000 enterprise ?
does the personnal edition follow the same license model?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uUUfsdTmFHA.2860@.TK2MSFTNGP15.phx.gbl...
> David Portas wrote:
>> Personal Edition just requires a client licence, either a CAL or
>> installed on a machine that accesses another processor-licensed
>> server. PE is limited to 2GB database size however, so that may be an
>> issue.
>> Dev Edition is licensed only for non-production development and
>> testing.
>> Check out the following link for info on the features supported by
>> each edition
>> http://www.microsoft.com/sql/evaluation/features/choosing.mspx
>> --
>> David Portas
>> SQL Server MVP
> David,
> PE does not have a 2GB limit like MSDE. However, it does have the same
> query governor in MSDE that throttles SQL Server with more than about 5
> connections. I currently have Personal Edition running on my XP laptop
> with databases in the 5GB range.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jéjé wrote:
> and what if we have a processor license of SQL 2000 enterprise ?
> does the personnal edition follow the same license model?
>
http://www.microsoft.com/sql/howtobuy/personal.mspx
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||like other license document from MS...
this document doesn't describe what's appends exactly...
I have a 2 processors license, so I have a 2 processor personnal edition
license?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:OLCUa5UmFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Jéjé wrote:
>> and what if we have a processor license of SQL 2000 enterprise ?
>> does the personnal edition follow the same license model?
> http://www.microsoft.com/sql/howtobuy/personal.mspx
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jéjé wrote:
> like other license document from MS...
> this document doesn't describe what's appends exactly...
> I have a 2 processors license, so I have a 2 processor personnal
> edition license?
You should speak to a MS licensing exec for licensing questions. My
understanding is that if you own Standard or EE and have a processor
license, you can use Personal Edition on non-server hardware to support
your application when they are not connected to the main server.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, thanks for the correction.
--
David Portas
SQL Server MVP
--

Personalize Reports for Each User

Hello Everyone,

I am trying to personalze my reports for each user, for example: Say I have a report which takes in userName as a parameter and then generates the report. Is it possible to use the same userName that the user used to login to the reporting services enviornment. This way the user don't have to enter their userName to see the report, it will be entered by default.

Thanks a lot,

-Rohit

Try User!UserID.

|||

Thanks for the reply!!!

I am still not sure where to use this field.

My question again is:

When a user login to Reporting Services, he/she has to enter a domain UserName and domain Password. I want to know if it is possible to grab that userName and use it as a default value for my parameter.

Thanks again,

-Rohit

|||Thanks a lot man...this works!!!|||

Glad I could help.

Personalize Report

Hi all, I was wondering if there is a way to capture the current users windows login and use that to personalize as report by displaying the users name at the top...or customizing report output by using the windows login as a query or report parameter.

This is very simple with Visual Studio 2005.

If you only have SQL 2005, on the edit expression screen use Globals -> UserID.

|||

Yes, it is easy to do... You can create a report parameter to capture the user id by using

=User!UserID

This will return you the credentials of the user who is trying to run the report which you can use anywhere in the report.

sql

Personalization rather than Association

I'm trying to figure out how to build a personalization engine.

If my structure is built with users as case, and products as nested - I’d like to predict best products per user (rather than associated products), and If possible, ignoring products he already bought.

How do I do it?

After building the Association model with Users as Case, Products as Nested, a Prediction join query on the model with the same dataset as the training case will give you a set of suggested products for every user, ignoring the products he already brought (since they will be part of the input case for each user). This might be what you're looking for.

Please let me know if this does not work for you

|||As Shuvro says, associative prediction is personalization as you need it. If you build an associative model and then perform a prediction based on an individual's product list, you will get the "personalized" list of products for that user by default excluding the items already in the basket.|||

Shuvro

I don't have the DMX skills, yet, to do this directly. Can the same results be achieved using the DM wizard? If not could you please point me to an example of the statement that would be required?

Geoff

|||

Yes, you can get the results using the DM query wizard by joining the model to a case table which contains per user products. Open the "Mining Model Prediction" tab, select the Association model and the Case/Nested table under Input Tables, verify that the column mappings are correct and select the function "PredictAssociation" under Field.

You can also look at the tip posted at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1861.aspx for an example on how to perform a DMX query for this scenario.

|||Thank you!

Personalization rather than Association

I'm trying to figure out how to build a personalization engine.

If my structure is built with users as case, and products as nested - I’d like to predict best products per user (rather than associated products), and If possible, ignoring products he already bought.

How do I do it?

After building the Association model with Users as Case, Products as Nested, a Prediction join query on the model with the same dataset as the training case will give you a set of suggested products for every user, ignoring the products he already brought (since they will be part of the input case for each user). This might be what you're looking for.

Please let me know if this does not work for you

|||As Shuvro says, associative prediction is personalization as you need it. If you build an associative model and then perform a prediction based on an individual's product list, you will get the "personalized" list of products for that user by default excluding the items already in the basket.|||

Shuvro

I don't have the DMX skills, yet, to do this directly. Can the same results be achieved using the DM wizard? If not could you please point me to an example of the statement that would be required?

Geoff

|||

Yes, you can get the results using the DM query wizard by joining the model to a case table which contains per user products. Open the "Mining Model Prediction" tab, select the Association model and the Case/Nested table under Input Tables, verify that the column mappings are correct and select the function "PredictAssociation" under Field.

You can also look at the tip posted at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1861.aspx for an example on how to perform a DMX query for this scenario.

|||Thank you!

Personal Web Developer Kit SQL Error

Hi folks,

I get this error message when I try to run my personal web page starter kit (Ctrl + F5) which has come straight out of the box:

Server Error in '/WebSite1' Application.

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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

    If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database. Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[SqlException (0x80131904): 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +173 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1069 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +219 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +49 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +160 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +67 [HttpException (0x80004005): Unable to connect to SQL Server database.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +123 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +89 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +26 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +388


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

In my web administration tool, under the Security tab the following error is listed:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.

and under the provider tab the provider is listed as: AspNetSqlProvider.

So what do I need to do?

(By the way, I wasn't exactly sure where to put this post, but if it gets moved to another forum please may you post the new link? Cheers)

In the default installation, SQL Server installs with very tight security.

Please refer to these articles for help in setting the correct configuration parameters.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

|||I don't seem to have SQL Server 2005 installed (it's not in the start menu, nor in Program Files). Do you think this is the problem? Do I need to install it, and if so, where from?
|||

heebiej wrote:

I don't seem to have SQL Server 2005 installed (it's not in the start menu, nor in Program Files). Do you think this is the problem? Do I need to install it, and if so, where from?

That could be a problem after you install it you still need to use the surface area configuration tool to enable browser services and allow remote and local connection then enable both TCP/IP and Named Pipes. Try the link below to download SQL Server Express with Advanced features, one more thing there are many user improved version of this kit you may want to check the forum for this kit at the Asp.net forums. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/advanced/default.aspx

|||You can download a copy of SQL Server 2005 Express from here.

Personal vs MSDE

Besides the extra storage space. Why would I want to use
the Personal Edition(not free) instead of MSDE (free). I
have read the "Choosing an Edition" related information
but besides space issues, is there any reason not to use
MSDE in favor of the Personal Edition?
Thanks,
MikeHi MT,
With MSDE you don't get "tools". We supply some (details at our site).
Google for others.
HTH,
--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"MT" <miketownsend33@.yahoo.com> wrote in message
news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
> Besides the extra storage space. Why would I want to use
> the Personal Edition(not free) instead of MSDE (free). I
> have read the "Choosing an Edition" related information
> but besides space issues, is there any reason not to use
> MSDE in favor of the Personal Edition?
> Thanks,
> Mike|||Which "Tools"
Mike
>--Original Message--
>Hi MT,
>With MSDE you don't get "tools". We supply some (details
at our site).
>Google for others.
>HTH,
>--
>Greg Low (MVP)
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"MT" <miketownsend33@.yahoo.com> wrote in message
>news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
>> Besides the extra storage space. Why would I want to
use
>> the Personal Edition(not free) instead of MSDE (free).
I
>> have read the "Choosing an Edition" related information
>> but besides space issues, is there any reason not to
use
>> MSDE in favor of the Personal Edition?
>> Thanks,
>> Mike
>
>.
>|||hi MT,
"MT" <MikeTownsend33@.yahoo.com> ha scritto nel messaggio
news:0a4901c34b8d$230f8f00$a301280a@.phx.gbl...
> Which "Tools"
all the client graphical tools to manage SQL Server like Enterpise Manager,
Query Analyzer, Profiler...
MSDE only provides oSql.exe, a command line utility by which you can almost
do the same things but the hard way... via T-SQL statements... =;-) rather
then via a nifty user interface...
for your convenience you can have a look at a prj of mine, at the link
following my sign., that provides a fee user interface similar to Enterprise
Manager..
hth
Andrea Montanari
montanari_andrea@.virgilio.it
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||MSDE is just the relational data engine from within the entire SQL Server
product. That's why its name is Microsoft SQL Server 2000 Desktop ENGINE.
Personal Edition is a full EDITION of SQL Server including:
- Tools: Query Analyzer, Enterprise Manager, Profiler, Index Tuning Wizard,
etc.
- Analysis Services: OLAP, Data Mining
- Various bits and pieces of development libraries, legacy utilities, etc.
In general the scenarios for MSDE vs Personal Edition are very different.
MSDE is intended for use embedded within an application, not as a
multi-application database server. Personal Edition is intended primarily
as a client-side store for an application that runs both on the desktop and
on a server. Since the clients already require a CAL (or the SQL Server
server has Processor Licenses) there is no additional cost to use Personal
Edition in this scenario.
Personal Edition has a secondary use, which is as a way to install a full
edition of SQL Server 2000 on a Windows Desktop OS. So if you purchase
Standard Edition but want to install on Windows XP, you have to install
Personal Edition. You are paying a lot for a server product and then
crippling it (both in the OS selection and the database edition you need to
install), but some people are willing to do that. They save some $ on the
OS, and they get the full SQL Server product other than the governor. If it
meets their needs, great.
MSDE technically isn't free. The MSDE model is that you buy a development
tool and you receive the right to redistributed MSDE at no charge with (and
as part of) applications that you develop USING THAT TOOL. Microsoft has one
no cost development tool, ASP.NET Web Matrix, that includes MSDE as well.
But the no cost redistribution of MSDE in that case is limited to
applications developed with Web Matrix. There is another scenario where you
purchase a SQL Server 2000 edition and get MSDE redistribution rights. In
this case the SQL Server 2000 edition takes on the role of the development
tool.
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"MT" <miketownsend33@.yahoo.com> wrote in message
news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
> Besides the extra storage space. Why would I want to use
> the Personal Edition(not free) instead of MSDE (free). I
> have read the "Choosing an Edition" related information
> but besides space issues, is there any reason not to use
> MSDE in favor of the Personal Edition?
> Thanks,
> Mike|||Thanks!! Much clearer now.
As we have purchased several processor licenses for the
Standard Edition of SQL Server and in some cases we have
installed MSDE on a few laptops so that users could use
the same applications that the Standard Edition is using
to test/develop or in one case subscribe to.
We now have one user who wishes to have a copy of the
Personal Edition installed for the same purpose, and
we're reluctant to do so.. is there a reason that you
could think of why they would need to use the Personal
Edition as opposed to MSDE?
MT
>--Original Message--
>MSDE is just the relational data engine from within the
entire SQL Server
>product. That's why its name is Microsoft SQL Server
2000 Desktop ENGINE.
>Personal Edition is a full EDITION of SQL Server
including:
>- Tools: Query Analyzer, Enterprise Manager, Profiler,
Index Tuning Wizard,
>etc.
>- Analysis Services: OLAP, Data Mining
>- Various bits and pieces of development libraries,
legacy utilities, etc.
>In general the scenarios for MSDE vs Personal Edition
are very different.
>MSDE is intended for use embedded within an application,
not as a
>multi-application database server. Personal Edition is
intended primarily
>as a client-side store for an application that runs both
on the desktop and
>on a server. Since the clients already require a CAL
(or the SQL Server
>server has Processor Licenses) there is no additional
cost to use Personal
>Edition in this scenario.
>Personal Edition has a secondary use, which is as a way
to install a full
>edition of SQL Server 2000 on a Windows Desktop OS. So
if you purchase
>Standard Edition but want to install on Windows XP, you
have to install
>Personal Edition. You are paying a lot for a server
product and then
>crippling it (both in the OS selection and the database
edition you need to
>install), but some people are willing to do that. They
save some $ on the
>OS, and they get the full SQL Server product other than
the governor. If it
>meets their needs, great.
>MSDE technically isn't free. The MSDE model is that you
buy a development
>tool and you receive the right to redistributed MSDE at
no charge with (and
>as part of) applications that you develop USING THAT
TOOL. Microsoft has one
>no cost development tool, ASP.NET Web Matrix, that
includes MSDE as well.
>But the no cost redistribution of MSDE in that case is
limited to
>applications developed with Web Matrix. There is
another scenario where you
>purchase a SQL Server 2000 edition and get MSDE
redistribution rights. In
>this case the SQL Server 2000 edition takes on the role
of the development
>tool.
>
>--
>Hal Berenson, SQL Server MVP
>True Mountain Group LLC
>
>"MT" <miketownsend33@.yahoo.com> wrote in message
>news:07e001c34b6b$1c866720$a401280a@.phx.gbl...
>> Besides the extra storage space. Why would I want to
use
>> the Personal Edition(not free) instead of MSDE (free).
I
>> have read the "Choosing an Edition" related information
>> but besides space issues, is there any reason not to
use
>> MSDE in favor of the Personal Edition?
>> Thanks,
>> Mike
>
>.
>