sql error 15138: February 2012

Sunday, February 26, 2012

error : 'QUOTED_IDENTIFIER, ARITHABORT'

I have an error like this :
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
Can anyone explain to me ? what does it means ?
How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
ThanksI assume this is from a maint plan job?
You have computed columns or views with indexes on them, and you are trying to reorganize the data.
Unfortunately the main wiz doesn't execute the correct SET command for its connection, meaning that
it can't rebuild using DBCC DBREINDEX. You can create a TSQL job yourself from where you specify the
appropriate SET commands and then execute DBCC DBREINDEx (or DBCC INDEXDEFRAG).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Kresna Rudy K" <kresnark@.yahoo.com> wrote in message
news:1ad0401c387e3$55b5a740$a601280a@.phx.gbl...
> I have an error like this :
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> Can anyone explain to me ? what does it means ?
> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
> Thanks|||It's true , this error came from maintainence plan job,
but I still don't understand because I don't use view or
computed column with indexes, I use standart version of
sql 2000, this version doesnot support index view.
Please explain to me,
Thx Tibor.
>--Original Message--
>I assume this is from a maint plan job?
>You have computed columns or views with indexes on them,
and you are trying to reorganize the data.
>Unfortunately the main wiz doesn't execute the correct
SET command for its connection, meaning that
>it can't rebuild using DBCC DBREINDEX. You can create a
TSQL job yourself from where you specify the
>appropriate SET commands and then execute DBCC DBREINDEx
(or DBCC INDEXDEFRAG).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>"Kresna Rudy K" <kresnark@.yahoo.com> wrote in message
>news:1ad0401c387e3$55b5a740$a601280a@.phx.gbl...
>> I have an error like this :
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
failed
>> because the following SET options have incorrect
>> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
>> Can anyone explain to me ? what does it means ?
>> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
>> Thanks
>
>.
>|||Nothing stop you from creating an index on a computed column or a view in standard edition. Try and
you will see:
USE pubs
GO
CREATE view v with schemabinding
as select au_id, au_lname from dbo.authors
GO
create unique clustered index ix on v(au_id)
You can try below to see if you have indexes in view. Run in each database:
select * from sysobjects where type = 'V'
and objectproperty(id, 'IsIndexed') = 1
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"kresna rudy k" <kresnark@.yahoo.com> wrote in message
news:1aeb201c387f2$0aed5ff0$a601280a@.phx.gbl...
> It's true , this error came from maintainence plan job,
> but I still don't understand because I don't use view or
> computed column with indexes, I use standart version of
> sql 2000, this version doesnot support index view.
> Please explain to me,
> Thx Tibor.
>
> >--Original Message--
> >I assume this is from a maint plan job?
> >
> >You have computed columns or views with indexes on them,
> and you are trying to reorganize the data.
> >Unfortunately the main wiz doesn't execute the correct
> SET command for its connection, meaning that
> >it can't rebuild using DBCC DBREINDEX. You can create a
> TSQL job yourself from where you specify the
> >appropriate SET commands and then execute DBCC DBREINDEx
> (or DBCC INDEXDEFRAG).
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> >"Kresna Rudy K" <kresnark@.yahoo.com> wrote in message
> >news:1ad0401c387e3$55b5a740$a601280a@.phx.gbl...
> >> I have an error like this :
> >>
> >> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
> failed
> >> because the following SET options have incorrect
> >> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> >>
> >> Can anyone explain to me ? what does it means ?
> >>
> >> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
> >>
> >> Thanks
> >
> >
> >.
> >

error : Only constants, constant expressions, or variables allowed here.

hi all,
when I try to do the following insert for the table test

create table test (outputs character(10), chk integer)

insert into test values('a',((select count(*) from test where outputs='a')+1))

I am getting the error
The name 'outputs' is illegal in this context. Only constants, constant expressions, or variables allowed here. Column names are illegal.

when i tried the same in DB2 it's working fine. is there anyerror in my syntax or this kind of function not allowed in SQL Server.

regards
MelbUse a SELECT instead of the VALUES clause.

-PatP

Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system
memory to run this query.
--
Thanks,
Mr GeekWithout seeing a stack dump file , it is hard to say exactly what is causing
the problem.
Are the queries that trigger this problem , dealing with UNION ALL or IN
with largae data sets?
Have you thought about upgarding to sp4?
--
Jack Vamvas
__________________________________________________________________
"LSolve" <L0L@.newsgroups.nospam> wrote in message
news:F4561270-E1BA-4B4C-9841-DA55FE250789@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
give
> similar error message.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient
system
> memory to run this query.
> --
> Thanks,
> Mr Geek|||Hello,
Please refer to the following article which describes how to troubleshoot
the slow performance of many concurrent ad-hoc queries:
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lsolve,
If u want to check that ur sql server need more merory then check this
artical .
http://www.computerperformance.co.uk/HealthCheck/Memory_Health.htm
from
Doller

Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insuffic
ient system
memory to run this query.
Thanks,
Mr GeekWithout seeing a stack dump file , it is hard to say exactly what is causing
the problem.
Are the queries that trigger this problem , dealing with UNION ALL or IN
with largae data sets?
Have you thought about upgarding to sp4?
Jack Vamvas
________________________________________
__________________________
"LSolve" <L0L@.newsgroups.nospam> wrote in message
news:F4561270-E1BA-4B4C-9841-DA55FE250789@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
give
> similar error message.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient[/
vbcol]
system[vbcol=seagreen]
> memory to run this query.
> --
> Thanks,
> Mr Geek|||Hello,
Please refer to the following article which describes how to troubleshoot
the slow performance of many concurrent ad-hoc queries:
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lsolve,
If u want to check that ur sql server need more merory then check this
artical .
http://www.computerperformance.co.u...mory_Health.htm
from
Doller

Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system
memory to run this query.
Thanks,
Mr Geek
Without seeing a stack dump file , it is hard to say exactly what is causing
the problem.
Are the queries that trigger this problem , dealing with UNION ALL or IN
with largae data sets?
Have you thought about upgarding to sp4?
Jack Vamvas
__________________________________________________ ________________
"LSolve" <L0L@.newsgroups.nospam> wrote in message
news:F4561270-E1BA-4B4C-9841-DA55FE250789@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
give
> similar error message.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient
system
> memory to run this query.
> --
> Thanks,
> Mr Geek
|||Hello,
Please refer to the following article which describes how to troubleshoot
the slow performance of many concurrent ad-hoc queries:
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Lsolve,
If u want to check that ur sql server need more merory then check this
artical .
http://www.computerperformance.co.uk...ory_Health.htm
from
Doller

ERROR : Host-file columns may be skipped only when copying into the Server

Hi All,

I need to make a query from the SQL Server 2K and save this data as an XML file. What i am trying to do is to execute a bcp utility as follows:

EXEC master..xp_cmdshell 'bcp "SELECT CustID,CustName,CustSurname,CustEmail FROM myOwenDB..T_Customers FOR XML RAW" queryout "c:\customers.xml" -fc:\bcp.fmt -Sservername -Usa -Ppwd -C RAW -r -t'

with bcp.fmt file formatted as

8.0
4
1 SQLCHAR 0 9 "\t" 1 CustID Turkish_CI_AS
2 SQLCHAR 0 100 "\t" 2 CustName Turkish_CI_AS
3 SQLCHAR 0 100 "\t" 3 CustSurname Turkish_CI_AS
4 SQLCHAR 0 100 "\t" 4 CustEmail Turkish_CI_AS

The error is as follows:

Error = [Microsoft][ODBC SQL Server Driver]Host-file columns may be skipped only when copying into the Server

Does anyone have an idea about the problem? Also other techniques to generate XML file are also welcomed:)

Thanks in advance,

Bahtiyar KARANLIKYour select statment only returns one column and you are using a format file that says bcp will be receiving four columns from the select statment.|||Hi,
How can my SQL statement can return only one column? When i execute the statement via Query Analyzer it displays the correct information?

Am i missing a point??

Bahtiyar KARANLIK|||If you execute
SELECT CustID,CustName,CustSurname,CustEmail FROM myOwenDB..T_Customers
In QA you will get four columns, CustID, CustName,CustSurname and CustEmail.

If you execute
SELECT CustID,CustName,CustSurname,CustEmail FROM myOwenDB..T_Customers FOR XML RAW
In QA you will have a resultset with one column. Within the one column you will have an XML string that contains the four above mentioned columns, but they will be contained in one column!

If you execute
select au_id,au_lname,phone,contract from pubs.dbo.authors

you should get something like:

au_id au_lname phone contract
---- ------------ ---- ---
172-32-1176 White 408 496-7223 1

If you execute
select au_id,au_lname,phone,contract from pubsdbo.authors for xml raw

you should get something like:

XML_F52E2B61-18A1-11d1-B105-00805F49916B
------------------------
<row au_id="172-32-1176" au_lname="White" phone="408 496-7223" contract="1"/>

The first has four colums in the result set the second has only one.

ERROR : FOR UPDATE cannot be specified on a READ ONLY ...

Hi All,
I am using SQL Server 2000 + JDeveloper 10g with ADF.
When i try to make changes to data and do COMMIT, I receive ERROR, I
have tried both JDBC Driver from Microsoft and jTDS, both FAILS.
Here is the error :
With Microsoft JDBC Driver :
(oracle.jbo.DMLException) JBO-26080: Error while selecting entity for
Departments
-- LEVEL 1: DETAIL 0 --
(java.sql.SQLException) [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer] FOR UPDATE cannot be specified on a READ ONLY cursor.
With jTDS JDBC Driver :
(oracle.jbo.DMLException) JBO-26080: Error while selecting entity for
Departments
-- LEVEL 1: DETAIL 0 --
(java.sql.SQLException) Line 1: FOR UPDATE clause allowed only for
DECLARE CURSOR.
Pls any body help...
Thank you,
Krist
Quite simple, really. SQL Server does not support FOR UPDATE; at least
not in the way that Oracle does. It's not standard SQL.
Alin,
The jTDS Project.
|||Hi ,
Thank you for your reply, it works now if I use JDBC driver from
Microsoft.
But if I use jTDS JDBC Driver, I get this error :
(oracle.jbo.DMLException) JBO-26041: Failed to post data to database
during "Update": SQL Statement
"UPDATE dbo.DEPARTMENTS SET DEPARTMENT_NAME=? WHERE DEPARTMENT_ID=?".
-- LEVEL 1: DETAIL 0 --
(java.sql.SQLException) Invalid parameter index 1.
Is there any options /setting on jDTS diver that I miss ?
Thank you for your help,
Krist
|||xtanto@.hotmail.com wrote:
> Hi ,
> Thank you for your reply, it works now if I use JDBC driver from
> Microsoft.
> But if I use jTDS JDBC Driver, I get this error :
> (oracle.jbo.DMLException) JBO-26041: Failed to post data to database
> during "Update": SQL Statement
> "UPDATE dbo.DEPARTMENTS SET DEPARTMENT_NAME=? WHERE DEPARTMENT_ID=?".
> -- LEVEL 1: DETAIL 0 --
> (java.sql.SQLException) Invalid parameter index 1.
> Is there any options /setting on jDTS diver that I miss ?
What does this have to do with FOR UPDATE?
Alin.
|||Hi Alin,
I am sorry, yes FOR UPDATE problem already solved after I upgrade to
JDev 10.1.2 and Oracle fix the problem by generating the correct sql
syntax for sqlserver.
However I still have problem with jTDS (described above).
I also post this in jTDS forum.
Thank you,
Krist
|||Could you enable DriverManager logging just before executing the code
that generates the exception and post the resulting log dump?
Alin.

Error : Difference of two datetime columns caused overflow at runtime.

At my job is a dts package that is failing in SQL 2005. I am not a SQL
expert. I am just trying to fix. I put the query in Query Analyzer
and get this error:

(4322 row(s) affected)

Server: Msg 535, Level 16, State 1, Line 1
Difference of two datetime columns caused overflow at runtime.

I am just trying to understand what this means, what I should be
looking for and what could be wrong. Here is the query:

SELECT i.SerialNumber, '' AS mac_number, DATEDIFF([second], 'Jan 1,
1970', s.DateOrdered) AS Support_StartDt, DATEDIFF([second], 'Jan 1,
1970',
s.Warranty_Enddate) AS Support_EndDt,
DATEDIFF([second], 'Jan 1, 1970', c.Registration_Date) AS
Registration_Date, c.FirstName AS enduser_fname,
c.LastName AS enduser_lname, c.CompanyName AS
enduser_companyname, c.ContactEmail AS enduser_email, c.Address AS
enduser_address1,
c.Address2 AS enduser_address2, c.City AS
enduser_city, c.State AS enduser_state, c.Zip AS enduser_zip,
c.WorkPhone AS enduser_phone,
c.Fax AS enduser_fax, d.DealerName AS
dealer_companyname, d.ContactFirstName AS dealer_fname,
d.ContactLastName AS dealer_name,
d.Address1 AS dealer_address, d.City AS
dealer_city, d.State AS dealer_state, d.Zip AS dealer_zip,
d.ContactPhone AS dealer_phone,
d.ContactFax AS dealer_fax,
ISNULL(SUBSTRING(p.ProductName, 11, LEN(p.ProductName) - 10), 'unknown
IWP product') AS product_type, '' AS extra1,
'' AS extra2, '' AS extra3, '' AS extra4, '' AS
extra5, '' AS extra6, '' AS extra7
FROM tblInventory i full outer JOIN
tblDealers d ON i.DealerID = d.DealerID full
OUTER JOIN
tblSupport s ON i.InventoryID = s.InventoryID
full outer JOIN
tblCustomers c ON s.InventoryID = c.InventoryID
LEFT OUTER JOIN
tblProducts p ON LEFT(i.SerialNumber,
PATINDEX('%-%', i.SerialNumber)) = p.SerialPrefix
WHERE i.SerialNumber <> ''

Any ideas would be greatly appreciated.geekwagon@.gmail.com (geekwagon@.gmail.com) writes:
> At my job is a dts package that is failing in SQL 2005. I am not a SQL
> expert. I am just trying to fix. I put the query in Query Analyzer
> and get this error:
>
> (4322 row(s) affected)
> Server: Msg 535, Level 16, State 1, Line 1
> Difference of two datetime columns caused overflow at runtime.
>
> I am just trying to understand what this means, what I should be
> looking for and what could be wrong. Here is the query:
>
> SELECT i.SerialNumber, '' AS mac_number, DATEDIFF([second], 'Jan 1,
> 1970', s.DateOrdered) AS Support_StartDt, DATEDIFF([second], 'Jan 1,
> 1970',
> s.Warranty_Enddate) AS Support_EndDt,
> DATEDIFF([second], 'Jan 1, 1970', c.Registration_Date) AS

One or of the rows has a value that is in 2038 or later in one of the
columns. My bets are on Warranty_Enddate and somehas put in 99991231
for an infinite warranty.

(2038-01-19 03:14:07.000 is the time when the number of seconds since
1970-01-01 exceeds the range of an un integer.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||>From Transact-SQL Reference:

DATEDIFF produces an error if the result is out of range for integer
values. For milliseconds, the maximum number is 24 days, 20 hours, 31
minutes and 23.647 seconds. For seconds, the maximum number is 68 years.

Error : Cannot specify an index or locking hint for a remote data source

We are migrating from sql 7 to sql 2000 and for the time
being leaving the database in sql 7 compatabiliy mode.
Some of the stored procedures reference the tables on a
linked server. The linked server is running sql 2000 and
the database is sql 2000.
When I run the following command
select * from linked_server.database.dbo.tablename (nolock)
I receive the following error
Cannot specify an index or locking hint for a remote data
source.
If I remove the () around nolock the statement runs.
The question(s) I have
1. Did I set something up wrong?
2. Without the () is the nolock still performing the same
function?
3. Assumining I did not error on the configuration, Why do
I receive this error now, and not before?
4. Any ideas to fix the problem without removing the ()?
Thanks in advance for any suggestions/ideas.
John WilliamsWithout the brackets around nolock, the SQL query engine is assigning the
word 'nolock' as an alias to your table in the select statement (i.e.
equivalent to 'as [nolock]').
R
"John Williams" <anonymous@.discussions.microsoft.com> wrote in message
news:27f3501c4636b$941fa990$a301280a@.phx.gbl...
> We are migrating from sql 7 to sql 2000 and for the time
> being leaving the database in sql 7 compatabiliy mode.
> Some of the stored procedures reference the tables on a
> linked server. The linked server is running sql 2000 and
> the database is sql 2000.
> When I run the following command
> select * from linked_server.database.dbo.tablename (nolock)
> I receive the following error
> Cannot specify an index or locking hint for a remote data
> source.
> If I remove the () around nolock the statement runs.
> The question(s) I have
> 1. Did I set something up wrong?
> 2. Without the () is the nolock still performing the same
> function?
> 3. Assumining I did not error on the configuration, Why do
> I receive this error now, and not before?
> 4. Any ideas to fix the problem without removing the ()?
> Thanks in advance for any suggestions/ideas.
> John Williams|||Can you not create a stored procedure on the remote data source that
specifies the hint?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"John Williams" <anonymous@.discussions.microsoft.com> wrote in message
news:27f3501c4636b$941fa990$a301280a@.phx.gbl...
> We are migrating from sql 7 to sql 2000 and for the time
> being leaving the database in sql 7 compatabiliy mode.
> Some of the stored procedures reference the tables on a
> linked server. The linked server is running sql 2000 and
> the database is sql 2000.
> When I run the following command
> select * from linked_server.database.dbo.tablename (nolock)
> I receive the following error
> Cannot specify an index or locking hint for a remote data
> source.
> If I remove the () around nolock the statement runs.
> The question(s) I have
> 1. Did I set something up wrong?
> 2. Without the () is the nolock still performing the same
> function?
> 3. Assumining I did not error on the configuration, Why do
> I receive this error now, and not before?
> 4. Any ideas to fix the problem without removing the ()?
> Thanks in advance for any suggestions/ideas.
> John Williams|||I am not sure if I understand what you are asking? Are you
suggesting that the stored procedure we run on the server
that has the syntax.
Select & from linkerserver.database.dbo.table1 and instead
run a stored procedure on the linked server that
accomplishes the same thing? I can look into this as an
option.
Thanks...
>--Original Message--
>Can you not create a stored procedure on the remote data
source that
>specifies the hint?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Williams" <anonymous@.discussions.microsoft.com>
wrote in message
>news:27f3501c4636b$941fa990$a301280a@.phx.gbl...
>> We are migrating from sql 7 to sql 2000 and for the time
>> being leaving the database in sql 7 compatabiliy mode.
>> Some of the stored procedures reference the tables on a
>> linked server. The linked server is running sql 2000 and
>> the database is sql 2000.
>> When I run the following command
>> select * from linked_server.database.dbo.tablename
(nolock)
>> I receive the following error
>> Cannot specify an index or locking hint for a remote
data
>> source.
>> If I remove the () around nolock the statement runs.
>> The question(s) I have
>> 1. Did I set something up wrong?
>> 2. Without the () is the nolock still performing the
same
>> function?
>> 3. Assumining I did not error on the configuration, Why
do
>> I receive this error now, and not before?
>> 4. Any ideas to fix the problem without removing the ()?
>> Thanks in advance for any suggestions/ideas.
>> John Williams
>
>.
>|||Thanks,
That an excellent point, so I am going to get unwanted
results by removing the (), I am concerned about locking
though, do you know since I cannot specify the nolock
hint, am I getting the benefit of (nolock) somehow?
>--Original Message--
>Without the brackets around nolock, the SQL query engine
is assigning the
>word 'nolock' as an alias to your table in the select
statement (i.e.
>equivalent to 'as [nolock]').
>R
>"John Williams" <anonymous@.discussions.microsoft.com>
wrote in message
>news:27f3501c4636b$941fa990$a301280a@.phx.gbl...
>> We are migrating from sql 7 to sql 2000 and for the time
>> being leaving the database in sql 7 compatabiliy mode.
>> Some of the stored procedures reference the tables on a
>> linked server. The linked server is running sql 2000 and
>> the database is sql 2000.
>> When I run the following command
>> select * from linked_server.database.dbo.tablename
(nolock)
>> I receive the following error
>> Cannot specify an index or locking hint for a remote
data
>> source.
>> If I remove the () around nolock the statement runs.
>> The question(s) I have
>> 1. Did I set something up wrong?
>> 2. Without the () is the nolock still performing the
same
>> function?
>> 3. Assumining I did not error on the configuration, Why
do
>> I receive this error now, and not before?
>> 4. Any ideas to fix the problem without removing the ()?
>> Thanks in advance for any suggestions/ideas.
>> John Williams
>
>.
>|||Yes, I think you will find that if you create a stored procedure on the
remote server, instead of running an ad hoc query locally, you will have
more freedom over transactions within the proc, locking hints, etc. You
should always be using stored procs as opposed to ad hoc statements
anyway...
--
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:274bb01c46371$b02b52a0$a501280a@.phx.gbl...
> I am not sure if I understand what you are asking? Are you
> suggesting that the stored procedure we run on the server
> that has the syntax.
> Select & from linkerserver.database.dbo.table1 and instead
> run a stored procedure on the linked server that
> accomplishes the same thing? I can look into this as an
> option.
> Thanks...
>
> >--Original Message--
> >Can you not create a stored procedure on the remote data
> source that
> >specifies the hint?
> >
> >--
> >http://www.aspfaq.com/
> >(Reverse address to reply.)
> >
> >
> >
> >
> >"John Williams" <anonymous@.discussions.microsoft.com>
> wrote in message
> >news:27f3501c4636b$941fa990$a301280a@.phx.gbl...
> >> We are migrating from sql 7 to sql 2000 and for the time
> >> being leaving the database in sql 7 compatabiliy mode.
> >> Some of the stored procedures reference the tables on a
> >> linked server. The linked server is running sql 2000 and
> >> the database is sql 2000.
> >>
> >> When I run the following command
> >> select * from linked_server.database.dbo.tablename
> (nolock)
> >>
> >> I receive the following error
> >> Cannot specify an index or locking hint for a remote
> data
> >> source.
> >>
> >> If I remove the () around nolock the statement runs.
> >>
> >> The question(s) I have
> >>
> >> 1. Did I set something up wrong?
> >> 2. Without the () is the nolock still performing the
> same
> >> function?
> >> 3. Assumining I did not error on the configuration, Why
> do
> >> I receive this error now, and not before?
> >> 4. Any ideas to fix the problem without removing the ()?
> >>
> >> Thanks in advance for any suggestions/ideas.
> >>
> >> John Williams
> >
> >
> >.
> >

Error : Cannot open user default database. Login failed.

I work with Microsoft visual studio 2005.
i get data from a table by ADO.NET :

SqlConnection sqlConn = new SqlConnection(strConnectionString);
sqlConn.Open();
.....

it works fine.

but when i open the SQL Server 2005 express edition and connect to the server (inside the same computer) to check something and then get back to the VS and run the code again ,the Open() function fails with the exception :

{"Cannot open user default database. Login failed.\r\nLogin failed for user 'DOMAIN\\asaf_a'."

disconnecting the server doesn't help and even closing the SQL Server 2005 application doesn't help.
Only restarting the computer enables the Open() command to work again.

Why ?

Every user has a default database specified. If you are using a SQLConnectinstring you are normally redirecting the user within the connectionstring to a specific database (Initial Catalog). By connecting with another tool which does not have the availbility to choose a starting database the user is redirected to its "home" / default database. If the database was dropped in the meantime, or the user was denied access / or even not granted, the login procedure will fail. You can set the user defaults database with using the procedure sp_defaultdb or by using any gui which can administer the logins.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks jens,

i solved the problem.

It was my connection string all along. it was wrong. This was the problem.

I changed the connection string from :

string strConnectionString = @."Server=.\SQLTESTING;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\TestDB.mdf;Integrated Security=SSPI";

To :

string strConnectionString = @."Server=.\SQLTESTING;Integrated Security=TRUE;Database=TestDB";

now i can use (Open) the TestDB Database from the VS code even when the SQL Server 2005 is also connected to this database.

Thanks!

error : 18452 in clustering; very urgent

We have 2 failover servers and one client in our test environment. We have all the three configured in mixed mode authentication(windows + sql server authentication). But when we are failing over from 1st server to 2nd one, we are getting the following error message,
'Unable to connected to server xxxx: Server : Msg 18452, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'null'. Reason: Not associated with a trusted SQL server connection.'

I got some clue.

For instance we have ser1 and ser2 as clusters. I registered both in the client's EM. Now what I did was, I made ser1 to run and stopped sql service in ser2 (active/passive) through failover. Now in the client's EM I'm able to open ser1 and I cannot access ser2. Now what I did was, I failed over to ser2 ( so sql service in ser1 is stopped). But now I can still be able to access ser1 and also I can access ser2, even I'm able to open query analyzer in ser1 through EM.But when I try to open query analyzer directly, it is giving the same error message. ser1 is the virtual name given to both ser1 and ser2. So I think when connecting through EM, failover is occuring fine.I'm just wondering why is this happening only with dsn. Can anybody help me?

You can get this particular error in a number of scenarios -- the common scenario is when one attempts SQL authentication using an NT login account. If the system is unable to find the login account it will raise this error. It is not clear the scenario behind this error.

|||The information you provided is not sufficient to diagnose the problem. Do you get this error only after failover? If you start the SQL Server serive on node ser2 (using net start and not via cluster admin) do you still get the same error when the client is also running on node2? Do you get this error only when the client is running on a different node than the SQL Server?
The error will be raised when SQL authentication is tried using an NT login account and it seems like the system is not able to find the login account. Make sure you are using the same account to connect after failover.

Error : 15457

Dear USer,
I am getting Error 15457 in my production server. I
have SQL Server 2000 install in production
Please do needful
Regards,
Deepak
Hi,
It is just an informational message, not really an error message. If you
change your server properties or if you view them in Enterprise Manager, you
will see this message in the SQL Server Error log.
So dont worry.
Thanks
Hari
MCDBA
"Deepak Sharma" <anonymous@.discussions.microsoft.com> wrote in message
news:2500001c45ffc$83889460$a401280a@.phx.gbl...
> Dear USer,
> I am getting Error 15457 in my production server. I
> have SQL Server 2000 install in production
> Please do needful
> Regards,
> Deepak

Error : 15457

Dear USer,
I am getting Error 15457 in my production server. I
have SQL Server 2000 install in production
Please do needful
Regards,
DeepakHi,
It is just an informational message, not really an error message. If you
change your server properties or if you view them in Enterprise Manager, you
will see this message in the SQL Server Error log.
So dont worry.
--
Thanks
Hari
MCDBA
"Deepak Sharma" <anonymous@.discussions.microsoft.com> wrote in message
news:2500001c45ffc$83889460$a401280a@.phx.gbl...
> Dear USer,
> I am getting Error 15457 in my production server. I
> have SQL Server 2000 install in production
> Please do needful
> Regards,
> Deepak

Error : 15457

Dear USer,
I am getting Error 15457 in my production server. I
have SQL Server 2000 install in production
Please do needful
Regards,
DeepakHi,
It is just an informational message, not really an error message. If you
change your server properties or if you view them in Enterprise Manager, you
will see this message in the SQL Server Error log.
So dont worry.
Thanks
Hari
MCDBA
"Deepak Sharma" <anonymous@.discussions.microsoft.com> wrote in message
news:2500001c45ffc$83889460$a401280a@.phx
.gbl...
> Dear USer,
> I am getting Error 15457 in my production server. I
> have SQL Server 2000 install in production
> Please do needful
> Regards,
> Deepak

Error : "Parallel worker query thread was involved in a deadlock" in SQL Se

We are running four session of application and each session is running
the same stored procedure against SQL Server database running SP3
patch.
All these four session are doing data intense operation and after some
time three of the process are getting completed correctly and the
fourth give us an DeadLock error message.
The error message which is displayed in the application is normal SQL
Server deadlock message.
But in the profiler we are seeing the below mentioned error message
//
Lock : Deadlock Chain : Parallel worker query thread was involved in a
deadlock" in profiler
//
We know that this error is cause by SQL Server optimization
methodology, we know it has to do with
parallel threads deadlocking each other.
Now we are looking for any documentation or information from the
Microsoft about this, any info will be appreciated.
Regards
Basharat<basharatw@.hotmail.com> wrote in message
news:1115667066.094653.87860@.f14g2000cwb.googlegroups.com...
> We are running four session of application and each session is running
> the same stored procedure against SQL Server database running SP3
> patch.
> All these four session are doing data intense operation and after some
> time three of the process are getting completed correctly and the
> fourth give us an DeadLock error message.
> The error message which is displayed in the application is normal SQL
> Server deadlock message.
> But in the profiler we are seeing the below mentioned error message
> //
> Lock : Deadlock Chain : Parallel worker query thread was involved in a
> deadlock" in profiler
> //
> We know that this error is cause by SQL Server optimization
> methodology, we know it has to do with
> parallel threads deadlocking each other.
> Now we are looking for any documentation or information from the
> Microsoft about this, any info will be appreciated.
> Regards
> Basharat
>
Take a look at the "max degree of parallelism" and "maxdop" query hints in
the books online.
I don't know if it will help in this situation or not.
Rick Sawtell
MCT, MCSD, MCDBA|||> We are running four session of application and each session is running
> the same stored procedure against SQL Server database running SP3
> patch.
> All these four session are doing data intense operation and after some
> time three of the process are getting completed correctly and the
> fourth give us an DeadLock error message.
> The error message which is displayed in the application is normal SQL
> Server deadlock message.
> But in the profiler we are seeing the below mentioned error message
> //
> Lock : Deadlock Chain : Parallel worker query thread was involved in a
> deadlock" in profiler
> //
> We know that this error is cause by SQL Server optimization
> methodology, we know it has to do with
> parallel threads deadlocking each other.
That sounds exactly l ike the problem I was having about two months ago on a
2-cpu server.
There is a MAXDOP option you can specify to set the "maximum degree of
parallelism" on a given SQL statement. I can't remember the sp that we had
to tweak that way, and I couldn't find it in the help index. I believe I
found it by dowing a full text search of BOL. For us, the solution was to
provide the MAXDOP hint and set it to 1 (I think).
If you can get to a source with more than a 3 month history of this NG, you
could search for posts containing MAXDOP from a thread that I started
between 2 & three months ago.
Perhaps someone else can chime in with something more precise.
Peace & happy computing,
Mike Labosh, MCSD
"Escriba coda ergo sum." -- vbSensei
<basharatw@.hotmail.com> wrote in message
news:1115667066.094653.87860@.f14g2000cwb.googlegroups.com...
> Now we are looking for any documentation or information from the
> Microsoft about this, any info will be appreciated.
> Regards
> Basharat
>

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition.

Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account.

Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain.

I get following error:

http://localhost/reportserver:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.

Event Viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Reporting Services LogFiles:

w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running Requests DB : System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)

Thankful for solution or any idea!

Regards, Jonas

Take a look at this thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

|||

Thanks Trish!

If I stop Reporting Services service, restarts the IIS and starts the Reporting Services service again I get following error.

http://localhost/reportserver:

The event source "Report Server" does not exist. (rsEventLogSourceNotFound)

Reporting Services LogFiles:

w3wp!library!1!2006-02-24-16:08:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist.

After some minute I refresh the browser and now I get rsInternalError again.

(This behaviour is repeatable.)

It's possible that I have edit (no change!) the ASP.NET tab under properties for the ReportServer website in IIS 6. Why? Some of my first actions after discovering that the installation didn't work was to look in the IIS 6 MMC...

Any suggestions?

Regards, Jonas

|||

The only way we could fix the problem was to uninstall SQL Server and reinstall it.

We tried everything we could think of but it still didn't help. Now we know not to touch those settings!

|||

After hours of thinking, testing, googleing and head scratching I found a workaround.
I tried to change the Reporting Services application pool identity to a windows account. And it worked. This window account is a member of local administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as application pool identity for Reporting Services.

I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.

Any idea? Anyone?
I really would like to use the Network Service account as recommended by Microsoft.

Regards, Jonas

|||

Try my solution on the following thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1985313&SiteID=1

Regards

Denis

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition.

Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account.

Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain.

I get following error:

http://localhost/reportserver:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.

Event Viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Reporting Services LogFiles:

w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running Requests DB : System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)

Thankful for solution or any idea!

Regards, Jonas

Take a look at this thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

|||

Thanks Trish!

If I stop Reporting Services service, restarts the IIS and starts the Reporting Services service again I get following error.

http://localhost/reportserver:

The event source "Report Server" does not exist. (rsEventLogSourceNotFound)

Reporting Services LogFiles:

w3wp!library!1!2006-02-24-16:08:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist.

After some minute I refresh the browser and now I get rsInternalError again.

(This behaviour is repeatable.)

Any suggestions?

Regards, Jonas

|||

The only way we could fix the problem was to uninstall SQL Server and reinstall it.

We tried everything we could think of but it still didn't help. Now we know not to touch those settings!

|||

I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.

Any idea? Anyone?
I really would like to use the Network Service account as recommended by Microsoft.

Regards, Jonas

|||

Try my solution on the following thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1985313&SiteID=1

Regards

Denis

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003
64bit SP1 Enterprise Edition.
Reporting Services Configuration Manager indicate that everything is ok,
green checks except Encryption Keys and Execution Account.
Reporting Services databases, ReportServer and ReportServerTempDB, is not
"installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in
the same domain.
I get following error:
http://localhost/reportserver:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.
Event Viewer:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at
Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at
Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object
sender, EventArgs e)
at
System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Reporting Services LogFiles:
w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed.
Exception thrown: System.NullReferenceException: Object reference not set to
an instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing. -->
System.NullReferenceException: Object reference not set to an instance of an
object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed.
Exception thrown: System.NullReferenceException: Object reference not set to
an instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running
Requests DB : System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
unused)
Thankful for solution or any idea!
Regards, JonasAfter hours of thinking, testing, googleing and head scratching I found a
workaround.
I tried to change the Reporting Services application pool identity to a
windows account. And it worked. This window account is a member of local
administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as
application pool identity for Reporting Services.
I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.
Any idea? Anyone?
I really would like to use the Network Service account as recommended by
Microsoft.
Regards, Jonas
"JvG" wrote:
> I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003
> 64bit SP1 Enterprise Edition.
> Reporting Services Configuration Manager indicate that everything is ok,
> green checks except Encryption Keys and Execution Account.
> Reporting Services databases, ReportServer and ReportServerTempDB, is not
> "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in
> the same domain.
> I get following error:
> http://localhost/reportserver:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Object reference not set to an instance of an object.
> Event Viewer:
> Event Type: Warning
> Event Source: ASP.NET 2.0.50727.0
> Event Category: Web Event
> Event ID: 1309
> Date: 2006-02-24
> Time: 10:11:35
> User: N/A
> Computer: PRD128ASAL
> Description:
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 2006-02-24 10:11:35
> Event time (UTC): 2006-02-24 09:00:25
> Event ID: ac7dc3e0abc2412aab9566d56f81859e
> Event sequence: 12
> Event occurrence: 7
> Event detail code: 0
> Application information:
> Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
> Trust level: RosettaSrv
> Application Virtual Path: /ReportServer
> Application Path: C:\Program Files\Microsoft SQL
> Server\MSSQL.1\Reporting Services\ReportServer\
> Machine name: XXXXXXXXXX
> Process information:
> Process ID: 1900
> Process name: w3wp.exe
> Account name: NT AUTHORITY\NETWORK SERVICE
> Exception information:
> Exception type: NullReferenceException
> Exception message: Object reference not set to an instance of an object.
> Request information:
> Request URL: http://localhost/reportserver
> Request path: /reportserver
> User host address: 127.0.0.1
> User: DOMAIN\USERID
> Is authenticated: True
> Authentication Type: Negotiate
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Thread information:
> Thread ID: 1
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Is impersonating: True
> Stack trace: at
> Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object
> sender, EventArgs e)
> at
> System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
>
> Custom event details:
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Reporting Services LogFiles:
> w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed.
> Exception thrown: System.NullReferenceException: Object reference not set to
> an instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing. -->
> System.NullReferenceException: Object reference not set to an instance of an
> object.
> at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed.
> Exception thrown: System.NullReferenceException: Object reference not set to
> an instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running
> Requests DB : System.NullReferenceException: Object reference not set to an
> instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
> at
> Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
> unused)
> Thankful for solution or any idea!
> Regards, Jonas

Error (re)installing Sql Server 2000

Hi,
while reinstalling Sql server 2000 (after complete uninstall process),
system says:
"previous installation leaves suspended operations on files into computer.
It needs to be restarted before executing installation program."
Problem still remains , also after resterting pc many times, so i can't
reinstall Sql server 2000 cause there are no skip possibilities to this
dialog box.
I try to restore Ms Server 2003 Enterprise: the problem still remain...
Nicola BazziHi Nicola
Check out manually removing SQL Server at
http://support.microsoft.com/kb/290991 in particular the reference to your
error message.
John
"Nicola" wrote:

> Hi,
> while reinstalling Sql server 2000 (after complete uninstall process),
> system says:
> "previous installation leaves suspended operations on files into computer.
> It needs to be restarted before executing installation program."
> Problem still remains , also after resterting pc many times, so i can't
> reinstall Sql server 2000 cause there are no skip possibilities to this
> dialog box.
> I try to restore Ms Server 2003 Enterprise: the problem still remain...
> --
> Nicola Bazzi

Error (re)installing Sql Server 2000

Hi,
while reinstalling Sql server 2000 (after complete uninstall process),
system says:
"previous installation leaves suspended operations on files into computer.
It needs to be restarted before executing installation program."
Problem still remains , also after resterting pc many times, so i can't
reinstall Sql server 2000 cause there are no skip possibilities to this
dialog box.
I try to restore Ms Server 2003 Enterprise: the problem still remain...
--
Nicola BazziHi Nicola
Check out manually removing SQL Server at
http://support.microsoft.com/kb/290991 in particular the reference to your
error message.
John
"Nicola" wrote:
> Hi,
> while reinstalling Sql server 2000 (after complete uninstall process),
> system says:
> "previous installation leaves suspended operations on files into computer.
> It needs to be restarted before executing installation program."
> Problem still remains , also after resterting pc many times, so i can't
> reinstall Sql server 2000 cause there are no skip possibilities to this
> dialog box.
> I try to restore Ms Server 2003 Enterprise: the problem still remain...
> --
> Nicola Bazzi

Error (Data mining): A catalog is not set for this session

I downloaded a copy of sql server and when I run the following query in the sql management studio after choosing new query , DMX I get the above error

CREATE MINING MODEL [NBSample]

(

CustomerKey LONG KEY,

Gender TEXT DISCRETE,

[Number Cars Owned] LONG DISCRETE,

[Bike Buyer] LONG DISCRETE PREDICT

)

Using Microsoft_Naive_Bayes

Also in the pane Mining Model I get the message No mining models found. The only error I get when I installed SQL server was a COM plus registration error. I am running Windows XP SP2. Can someone please help.

Vijay Mukhi

HOD Helios

Apoligies from the bottom of my heart. I was reading the tutorial in the middle of the night and did not create a database. After creating a database the above query works like a charm. I am using sql server to create an expert system for detecting malware. I tried dozens of neural network , bayesain network , SVM , etc products and believe sql server is far ahead. Sorry once again for the post.

Vijay Mukhi

Helios

Error (bug?) when hiding subtotals in Report Builder report from AS2005 cube

I consequently get an error

message in Report Builder (version 9.0.2047.0) when I make a report

without subtotals when I have the Key attribute of a dimension in

combination with a measure.

The following Report is OK, but when I unselect Show Subtotals, I get an error message.
Date | Count Result
-
10-10-2003 | 200000
-
Total | 200000

The error message is:
For more information about this error navigate to the report server on the local server machine, or enable remote errors
-
Semantic query execution failed.
-
Query execution failed for data set 'dataSet'.
-
An error has occurred during report processing.

I

have tried experimenting with the GroupingBehaviour on

EncourageGrouping or DiscourageGrouping, but without success. I seem to

be the only one with this problem.

I am using Reporting Services 2005 in combination with Analysis Services 2005 (9.00.2153.00)

Because I don't know if the issue is related to Reporting Services or Analysis Services I posted in both forums.

This is probably Reporting Services problem.

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

Error (8626) while inserting record into table with text field and which is the base for i

I have a problem with inserting records into table when an indexed view
is based on it.
Table has text field (without it there is no problem, but I need it).
Here is a sample code:

USE test
GO

CREATE TABLE dbo.aTable (
[id] INT NOT NULL
, [text] TEXT NOT NULL
)
GO

CREATE VIEW dbo.aView
WITH SCHEMABINDING AS
SELECT [id]
, CAST([text] AS VARCHAR(8000)) [text]
FROM dbo.aTable
GO

CREATE TRIGGER dbo.aTrigger ON dbo.aView INSTEAD OF INSERT
AS
BEGIN
INSERT INTO aTable
SELECT [id], [text]
FROM inserted
END
GO

Do the insert into aTable (also through aView).

INSERT INTO dbo.aTable VALUES (1, 'a')
INSERT INTO dbo.aView VALUES (2, 'b')

Still do not have any problem. But when I need index on view

CREATE UNIQUE CLUSTERED INDEX [id] ON dbo.aView ([id])
GO

I get following error while inserting record into aTable:

-- Server: Msg 8626, Level 16, State 1, Procedure aTrigger, Line 4
-- Only text pointers are allowed in work tables, never text, ntext, or
image columns. The query processor produced a query plan that required
a text, ntext, or image column in a work table.

Does anyone know what causes the error?ing42 (Inga.Korczowska@.gmail.com) writes:
> Do the insert into aTable (also through aView).
> INSERT INTO dbo.aTable VALUES (1, 'a')
> INSERT INTO dbo.aView VALUES (2, 'b')
> Still do not have any problem. But when I need index on view
> CREATE UNIQUE CLUSTERED INDEX [id] ON dbo.aView ([id])
> GO
> I get following error while inserting record into aTable:
> -- Server: Msg 8626, Level 16, State 1, Procedure aTrigger, Line 4
> -- Only text pointers are allowed in work tables, never text, ntext, or
> image columns. The query processor produced a query plan that required
> a text, ntext, or image column in a work table.
> Does anyone know what causes the error?

Did you notice the warning when you created the index:

Warning: The optimizer cannot use the index because the select list of
the view contains a non-aggregate expression.

So the index is not of much use. I guess you have hit a restriction
in SQL Server, which does not report as such in a nice way. When I
run your code in SQL 2005, I get:

Msg 1942, Level 16, State 1, Line 1
Cannot create index on view 'tempdb.dbo.aView'. It contains text, ntext,
image or xml columns.

Which is a more resolute message.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error (1552) ODBC, Insert Execute Error

Hi, I have a program called dbms/copy that I use to conver clarion database tables. The program first creates the table, if already exists I delete and recreate. This part works fine. When it tries to insert the records I get the following error message:

Error (1552)

ODBC, Insert Execute Error -> Buffer Contained 100 Records but only 0 Records were written

I created a System DSN ODBC link to the SQL Server. I tried using the "sa" user, as well as creating a user and checking off all available permissions. It seems to be a permissions problem to me, although it appears I have permission to do everything. It is definately able to connect since it has no problem creating/deleting/recreating the table in the SQL Server database.

I tried doing the same import with an ODBC connection to a Microsoft Access database and it works without any problems.

Any idea what's giving me this error?I turned on ODBC tracing and the following errors showed up in the SQL.log file:

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000001
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code -1 (SQL_ERROR)
SQLHSTMT 00E51F98
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000001
SQLINTEGER 0

DIAG [24000] [Microsoft][ODBC Driver Manager] Invalid cursor state (0)

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 7 <SQL_ATTR_CONCURRENCY>
SQLPOINTER 0x00000003
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code -1 (SQL_ERROR)
SQLHSTMT 00E51F98
SQLINTEGER 7 <SQL_ATTR_CONCURRENCY>
SQLPOINTER 0x00000003
SQLINTEGER 0

DIAG [24000] [Microsoft][ODBC Driver Manager] Invalid cursor state (0)

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 0x00000000
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 00E51F98
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 0x00000000
SQLINTEGER 0

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000064
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 00E51F98
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000064 (BADMEM)
SQLINTEGER 0

dbmswin7 f58-b90 ENTER SQLBulkOperations
SQLHSTMT 00E51F98
SQLSMALLINT 4

dbmswin7 f58-b90 EXIT SQLBulkOperations with return code -1 (SQL_ERROR)
SQLHSTMT 00E51F98
SQLSMALLINT 4

DIAG [S1092] [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier (0)

dbmswin7 f58-b90 ENTER SQLRowCount
HSTMT 00E51F98
SQLLEN * 0x0012F7F4

dbmswin7 f58-b90 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 00E51F98
SQLLEN * 0x0012F7F4 (0)

dbmswin7 f58-b90 ENTER SQLDisconnect
HDBC 00E515E8

dbmswin7 f58-b90 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 00E515E8

Originally posted by UltraSmooth
Hi, I have a program called dbms/copy that I use to conver clarion database tables. The program first creates the table, if already exists I delete and recreate. This part works fine. When it tries to insert the records I get the following error message:

Error (1552)

ODBC, Insert Execute Error -> Buffer Contained 100 Records but only 0 Records were written

I created a System DSN ODBC link to the SQL Server. I tried using the "sa" user, as well as creating a user and checking off all available permissions. It seems to be a permissions problem to me, although it appears I have permission to do everything. It is definately able to connect since it has no problem creating/deleting/recreating the table in the SQL Server database.

I tried doing the same import with an ODBC connection to a Microsoft Access database and it works without any problems.

Any idea what's giving me this error?

Error "The OLE DB provider "MSDASQL" has not been registered." on SQL 2005 6

Hi,
I am trying to create a linked server from SQL server 2005 (64bit) to IB 7.5 database.

I installed the driver for IB on SQL box and created a System DNS (using
%SystemRoot%\SysWOW64\odbcad32.exe), tested the connection fine.

Now, on SQL Management Studio, created a linked server to use the System DSN,
sp_addlinkedserver 'MyLinkedSrv', ' ', 'MSDASQL', 'MySYSDNS' -- went fine.

Then ran the openquery,
select * from OPENQUERY(MyLinkedSrv, 'select * from services')

An error msg returned fro the openquery.
The OLE DB provider "MSDASQL" has not been registered.

What am I missing here? I tried with "Native SQL Client" instead MSDASQL but it returns me invaild parameters...

Any advice on this would be aprreciated.

Regards,
Sunny

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=396615&SiteID=1

HTH

Error "Provider cannot be found. It may not be properly installed." after deploying ap

hello folks

i have recently started to work with the analysis services and i am having some problems.

i have made a web application that for now just tries to connect to an analysis server.

The server is installed on an xp sp 2 system.

for testing, i used my local computer, which is running also win xp sp2. After deploying, the application can connect to the AS server on the other machine. the problem occurs when i try to deploy the applicatuion on the production server, which is running win 2k3 server on 32 bit. When deploying, i use the same connection string, so it should try to connect to the AS server installed on a win xp sp2 system.

The first thing that came to my mind was to check the MDAC versions, be cause of the message: "Provider cannot be found. It may not be properly installed."

on my computer, where the application worked ok, the version is MDAC 2.8 SP 1 Windows XP SP 2

on the win2k3 server, the MDAC version is : MDAC 2.8 SP2.... i thought it was the version of the service pack, so o searched for the update of MDAC 2.8 SP1, trying to install mdac 2.8 sp2 to see if i was to see the same error, but i found that mdac 2.8 sp2 is only for win2k3 server, and for win xp is mdac 2.8 sp1, according to this link: http://support.microsoft.com/default.aspx/kb/884103

Now i got confused and have no clues how to make this work...

Can anybody give any hint?

?|||

The Analysis Services provider is not part of the core MDAC, it is available for download from the feature pack at http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

look for the downloads under Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Error "Object reference not set to an instance" on SQL 2005 Reporting Services

Reporting Services on my production server stopped working. If I try to open it from Management studio, I get the error below.

Already tried installing patch 07-040, re-registering asp.net, and a few other stuff. Can you guys help me?

TITLE: Connect to Server

Cannot connect to GRUMIUM.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.2047.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1761909&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=694364&SiteID=1

This could be a variety of things, but is most likely due to some configuration that got "touched" recently.

What has been monkeyed with in IIS or with the report server configuration recently? Undo those changes!

|||

There has been no recent change to my environment. I tried a lot of things already to try re resolve the issue.

- Installed patch 07-040

http://support.microsoft.com/kb/911300/en-us

- tried re-registering asp.net

- tried removing the xmlns from the web.config file from both reportserver and reportmanager folders

All without success. Don't know what else I can do.

Sunday, February 26, 2012

error : 'QUOTED_IDENTIFIER, ARITHABORT'

error : Only constants, constant expressions, or variables allowed here.

Error : insufficient system memory

Error : insufficient system memory

Error : insufficient system memory

Error : insufficient system memory

Error : insufficient system memory

Error : insufficient system memory

ERROR : Host-file columns may be skipped only when copying into the Server

ERROR : FOR UPDATE cannot be specified on a READ ONLY ...

Error : Difference of two datetime columns caused overflow at runtime.

Error : Cannot specify an index or locking hint for a remote data source

Error : Cannot open user default database. Login failed.

error : 18452 in clustering; very urgent

Error : 15457

Error : 15457

Error : 15457

Error : "Parallel worker query thread was involved in a deadlock" in SQL Se

Error (rsInternalError) after installation

Error (rsInternalError) after installation

Error (rsInternalError) after installation

Error (re)installing Sql Server 2000

Error (re)installing Sql Server 2000

Error (Data mining): A catalog is not set for this session

Error (bug?) when hiding subtotals in Report Builder report from AS2005 cube

Error (8626) while inserting record into table with text field and which is the base for i

Error (1552) ODBC, Insert Execute Error

Error "The OLE DB provider "MSDASQL" has not been registered." on SQL 2005 6

Error "Provider cannot be found. It may not be properly installed." after deploying ap

Error "Object reference not set to an instance" on SQL 2005 Reporting Services

sql error 15138

Blog Archive

About Me