Error Reporting service

hi
i am using SQL Server 2005 reporting services, i am getting an error message while deploying .rdl file error is:" Connection could not be established to remote server http://localhost/ReportServer"
Additional information is :
"client found response content type of text/html; charset=utf-8 but expected text/XML"Are you just trying to connect through the browser or to upload a file?|||Oh sorry I see. Are you able to connet to the instance through the browser?|||now its working properly, i have executed aspnet_regsql -ga aspnet commond on command prompt. But now while deploying i m getting another problem: "An internal error occurred on the report server. See the error log for more details."

Error messages in Client

Hi
I am running a software package that access SQL Server files. I am getting
these messages:
* "Invalid pointer operation"
* "The RPC server is unavailable"
* "Access violation at address 40006834 in module 'rtl60.bpl'. Read of
address FFFFFFFF" when deleting an event
* "Access violation at address 40006834 in module 'rtl60.bpl'.
Anyone know what may cause these
Thanks
c
I would ask the vendor of the software package as these sound like
application errors, not SQL Server errors.
Andrew J. Kelly SQL MVP
"cds" <cdsaus2001@.yahoo.com.au> wrote in message
news:42be882f$0$14822$afc38c87@.news.optusnet.com.a u...
> Hi
> I am running a software package that access SQL Server files. I am getting
> these messages:
> * "Invalid pointer operation"
> * "The RPC server is unavailable"
> * "Access violation at address 40006834 in module 'rtl60.bpl'. Read of
> address FFFFFFFF" when deleting an event
> * "Access violation at address 40006834 in module 'rtl60.bpl'.
>
> Anyone know what may cause these
>
> Thanks
> c
>

error message....

hi

I have the followin code but it isnot working giving the following error message

String or binary data would be truncated.
The statement has been terminated.

string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";

SqlCommand command = newSqlCommand(sqlStrInsert, conn);

command.ExecuteNonQuery();

thanks

if this forum is out of my topic, please write the related forum's name

You really, really, really should not do that becasue this leaves a security hole for SQL injection, imagine you user input (which should be treaten as suspious), enter in the textbox2 the following text:

'',NULL'); DROP DATABASE model; --

THis would cause the model database to be dropped, I am sure you don′t want to do this. :-) Always use parametrized queries for the access, that can′t be comnposed as easy as in the sample code of yours.

HTH, Jens Suessmeyer.

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

but I dont understand the security hole reason, how I overcome it please explain with a sample

thank you

|||

hi,

Jens already provide the example..

you "load" a dynamic SQL statement into tbl_izinTalep table that must be evenutally executed...

if your loaded statement has been "tampered" with malicious code, like Jens said, you will be very sad

your code is

string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";

but if someone adds "; DROP DATABASE model" to your statement, it will be executed as well..

have a look at http://www.sommarskog.se/dynamic_sql.html for futher info about dynamic SQL..

regards

error message....

hi

I have the followin code but it isnot working giving the following error message

String or binary data would be truncated.
The statement has been terminated.

string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";

SqlCommand command = new SqlCommand(sqlStrInsert, conn);

command.ExecuteNonQuery();

thanks

if this forum is out of my topic, please write the related forum's name

You really, really, really should not do that becasue this leaves a security hole for SQL injection, imagine you user input (which should be treaten as suspious), enter in the textbox2 the following text:

'',NULL'); DROP DATABASE model; --

THis would cause the model database to be dropped, I am sure you don′t want to do this. :-) Always use parametrized queries for the access, that can′t be comnposed as easy as in the sample code of yours.

HTH, Jens Suessmeyer.

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

but I dont understand the security hole reason, how I overcome it please explain with a sample

thank you

|||

hi,

Jens already provide the example..

you "load" a dynamic SQL statement into tbl_izinTalep table that must be evenutally executed...

if your loaded statement has been "tampered" with malicious code, like Jens said, you will be very sad

your code is

string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";

but if someone adds "; DROP DATABASE model" to your statement, it will be executed as well..

have a look at http://www.sommarskog.se/dynamic_sql.html for futher info about dynamic SQL..

regards

error message while creating table in the database

Hi

I created database using SQL server and runs under Cassini. The creation of database is ok but I have a problem when I am creating the table in database. Whenever I execute the code to create the tables, it shows the error message like 'Server not found' or just hang there. Does anybody know why it hang while I am creating the table? Is it because of the code or it's the time out error. Pls help as I am very new to this area.

MZAre you tying to create tables in SQL Server (Query Analyzer or Enterprise Manager), or in Web Matrix, or in your web application code, or...? If you can clarify where you are experiencing problems we should be able to help.

Terri

Error Message 8152

Hi
I wonder if anyone can help, I am getting the following error messages when
I try to do a number of things.
1. Select Job > Script job as > create to > any option file / query editor
2. View Job History.
The error I get gives you the result script failed for job 'RunMe'
(Microsoft.sqlserver.smo), enumerate target server failed, and so on then
string or binary data would be truncated ( MS SQL Server Error 8152)
I also get the same error if I try and run a job.
The interesting thing is that if I failover the server the view job history
works on the 1st server in the cluster but the select job and script still
does not work.
We have a 2 server SQL 2005 Cluster with SP1, in active/passive mode.
Also on the cluster we have two instances running and these features work on
one instance all the time and not on the other
Any ideas where to look or what to look for would be ideal
Thanks
Al
Hi
Have you checked that the jobsteps reference the correct instance on the
virtual server?
John
"Al" wrote:

> Hi
> I wonder if anyone can help, I am getting the following error messages when
> I try to do a number of things.
> 1. Select Job > Script job as > create to > any option file / query editor
> 2. View Job History.
> The error I get gives you the result script failed for job 'RunMe'
> (Microsoft.sqlserver.smo), enumerate target server failed, and so on then
> string or binary data would be truncated ( MS SQL Server Error 8152)
> I also get the same error if I try and run a job.
> The interesting thing is that if I failover the server the view job history
> works on the 1st server in the cluster but the select job and script still
> does not work.
> We have a 2 server SQL 2005 Cluster with SP1, in active/passive mode.
> Also on the cluster we have two instances running and these features work on
> one instance all the time and not on the other
> Any ideas where to look or what to look for would be ideal
> Thanks
> Al
|||Hi John
The job is specific to a database on that specific instance, as currently
the only db in the other instance is aspstate.
As I say it is a weird one.
I have two servers
server a - 172.21.24.30
server b - 172.21.24.31
sql cluster - 172.21.24.34
Instance One - both have names
Instance Two
Running in an active / passive mode if you are logged on to server A you can
look at the history for the job no problem, but if you look on to server B
you cannot look at the job history and get the 8152 error or 0x80041010.
At this point I must say I am refering to Server A and B as the server that
the cluster is connecting to at that point in time
Also if you try to create a script from the job it reports the same error
but this time on both server A and B.
To add another thing into the mix I downloaded and installed SQL SP2 on my
local PC which was running SQL2005, and had the same problem reading the job
history after the install of SP2 it could read the job history logs but could
not create the script of the job from SQL Agent.
If I try to script the aspstate job from Instance 2 on Server A it works but
do it on Server B and it fails, but do it for Instance 1 and it works.
I have included the error message I get when attempting to create the script.
From SQL
TITLE: Microsoft SQL Server Management Studio
Script failed for Job 'Get LES Payments Daily import from GENIESERVER'.
(Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3027.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Script+Job&LinkId=20476[/url]
ADDITIONAL INFORMATION:
Enumerate target servers failed for Job 'Get LES Payments Daily import from
GENIESERVER'. (Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3027.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Enumerate+target+servers+Job&LinkId=20476[/url]
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476[ /url]
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
String or binary data would be truncated. (Microsoft SQL Server, Error: 8152)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .2047&EvtSrc=MSSQLServer&EvtID=8152&LinkId=20476[/url]
BUTTONS:
OK
From Eventviewer
Event filter with query "select * from __InstanceModificationEvent within 10
where TargetInstance isa 'Win32_Service'" could not be (re)activated in
namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error
0x80041010. Events may not be delivered through this filter until the problem
is corrected.
Any advise would be great.
Al
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked that the jobsteps reference the correct instance on the
> virtual server?
> John
> "Al" wrote:
|||Hi
Unfortunately I can't suggest anything more other than contacting PSS. It
does sounds like there is something more than just this job which is not
correct, therefore rebuilding the cluster may be one option. It doesn't sound
like you are using version control to maintain your scripts, if you do have a
good script then you could always drop the job and re-create it to see if the
situation changes for the new job.
John
"Al" wrote:
[vbcol=seagreen]
> Hi John
> The job is specific to a database on that specific instance, as currently
> the only db in the other instance is aspstate.
> As I say it is a weird one.
> I have two servers
> server a - 172.21.24.30
> server b - 172.21.24.31
> sql cluster - 172.21.24.34
> Instance One - both have names
> Instance Two
> Running in an active / passive mode if you are logged on to server A you can
> look at the history for the job no problem, but if you look on to server B
> you cannot look at the job history and get the 8152 error or 0x80041010.
> At this point I must say I am refering to Server A and B as the server that
> the cluster is connecting to at that point in time
> Also if you try to create a script from the job it reports the same error
> but this time on both server A and B.
> To add another thing into the mix I downloaded and installed SQL SP2 on my
> local PC which was running SQL2005, and had the same problem reading the job
> history after the install of SP2 it could read the job history logs but could
> not create the script of the job from SQL Agent.
> If I try to script the aspstate job from Instance 2 on Server A it works but
> do it on Server B and it fails, but do it for Instance 1 and it works.
> I have included the error message I get when attempting to create the script.
> From SQL
> --
> TITLE: Microsoft SQL Server Management Studio
> --
> Script failed for Job 'Get LES Payments Daily import from GENIESERVER'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3027.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Script+Job&LinkId=20476[/url]
> --
> ADDITIONAL INFORMATION:
> Enumerate target servers failed for Job 'Get LES Payments Daily import from
> GENIESERVER'. (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3027.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Enumerate+target+servers+Job&LinkId=20476[/url]
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476[ /url]
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> String or binary data would be truncated. (Microsoft SQL Server, Error: 8152)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .2047&EvtSrc=MSSQLServer&EvtID=8152&LinkId=20476[/url]
> --
> BUTTONS:
> OK
> --
>
> --
> From Eventviewer
> --
> Event filter with query "select * from __InstanceModificationEvent within 10
> where TargetInstance isa 'Win32_Service'" could not be (re)activated in
> namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error
> 0x80041010. Events may not be delivered through this filter until the problem
> is corrected.
> Any advise would be great.
> Al
> "John Bell" wrote:
|||John
We do have a microsoft contract so I will contact them, this is the first
script we have put on the server so is the only version
but thanks for trying to help
AL
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Unfortunately I can't suggest anything more other than contacting PSS. It
> does sounds like there is something more than just this job which is not
> correct, therefore rebuilding the cluster may be one option. It doesn't sound
> like you are using version control to maintain your scripts, if you do have a
> good script then you could always drop the job and re-create it to see if the
> situation changes for the new job.
> John
> "Al" wrote:
|||Hi
My assumption was that this script was upgraded from SQL 2000!
If you do have a file with this scripted you can create a new job (with a
different name) and disable the current one and then see if you have the same
problems.
John
"Al" wrote:
[vbcol=seagreen]
> John
> We do have a microsoft contract so I will contact them, this is the first
> script we have put on the server so is the only version
> but thanks for trying to help
> AL
> "John Bell" wrote:
|||John
Thanks. I tried that no difference, I have even created a job from Scratch
then try to use the Create to - so I can create a script and it does not
work. An example of the job is to give users permissions to the aspstate
tables in tempdb. Altthough I can use the Drop to command and it will create
a script. It sounds like there is something not right but I am at a loss to
what that is. It looks like some things work and others dont I may have to
remove the instant and reinstall but I am not sure how easy that will be as
it will be up to the team responsible for the application
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> My assumption was that this script was upgraded from SQL 2000!
> If you do have a file with this scripted you can create a new job (with a
> different name) and disable the current one and then see if you have the same
> problems.
> John
> "Al" wrote:

Error Message 8152

Hi
I wonder if anyone can help, I am getting the following error messages when
I try to do a number of things.
1. Select Job > Script job as > create to > any option file / query editor
2. View Job History.
The error I get gives you the result script failed for job 'RunMe'
(Microsoft.sqlserver.smo), enumerate target server failed, and so on then
string or binary data would be truncated ( MS SQL Server Error 8152)
I also get the same error if I try and run a job.
The interesting thing is that if I failover the server the view job history
works on the 1st server in the cluster but the select job and script still
does not work.
We have a 2 server SQL 2005 Cluster with SP1, in active/passive mode.
Also on the cluster we have two instances running and these features work on
one instance all the time and not on the other
Any ideas where to look or what to look for would be ideal
Thanks
AlHi
Have you checked that the jobsteps reference the correct instance on the
virtual server?
John
"Al" wrote:

> Hi
> I wonder if anyone can help, I am getting the following error messages whe
n
> I try to do a number of things.
> 1. Select Job > Script job as > create to > any option file / query editor
> 2. View Job History.
> The error I get gives you the result script failed for job 'RunMe'
> (Microsoft.sqlserver.smo), enumerate target server failed, and so on then
> string or binary data would be truncated ( MS SQL Server Error 8152)
> I also get the same error if I try and run a job.
> The interesting thing is that if I failover the server the view job histor
y
> works on the 1st server in the cluster but the select job and script still
> does not work.
> We have a 2 server SQL 2005 Cluster with SP1, in active/passive mode.
> Also on the cluster we have two instances running and these features work
on
> one instance all the time and not on the other
> Any ideas where to look or what to look for would be ideal
> Thanks
> Al|||Hi John
The job is specific to a database on that specific instance, as currently
the only db in the other instance is aspstate.
As I say it is a weird one.
I have two servers
server a - 172.21.24.30
server b - 172.21.24.31
sql cluster - 172.21.24.34
Instance One - both have names
Instance Two
Running in an active / passive mode if you are logged on to server A you can
look at the history for the job no problem, but if you look on to server B
you cannot look at the job history and get the 8152 error or 0x80041010.
At this point I must say I am refering to Server A and B as the server that
the cluster is connecting to at that point in time
Also if you try to create a script from the job it reports the same error
but this time on both server A and B.
To add another thing into the mix I downloaded and installed SQL SP2 on my
local PC which was running SQL2005, and had the same problem reading the job
history after the install of SP2 it could read the job history logs but coul
d
not create the script of the job from SQL Agent.
If I try to script the aspstate job from Instance 2 on Server A it works but
do it on Server B and it fails, but do it for Instance 1 and it works.
I have included the error message I get when attempting to create the script
.
From SQL
--
TITLE: Microsoft SQL Server Management Studio
--
Script failed for Job 'Get LES Payments Daily import from GENIESERVER'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...ob&LinkId=20476
ADDITIONAL INFORMATION:
Enumerate target servers failed for Job 'Get LES Payments Daily import from
GENIESERVER'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...ob&LinkId=20476
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
String or binary data would be truncated. (Microsoft SQL Server, Error: 8152
)
For help, click:
http://go.microsoft.com/fwlink?Prod...52&LinkId=20476
BUTTONS:
OK
--
From Eventviewer
--
Event filter with query "select * from __InstanceModificationEvent within 10
where TargetInstance ISA 'Win32_Service'" could not be (re)activated in
namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error
0x80041010. Events may not be delivered through this filter until the proble
m
is corrected.
Any advise would be great.
Al
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked that the jobsteps reference the correct instance on the
> virtual server?
> John
> "Al" wrote:
>|||Hi
Unfortunately I can't suggest anything more other than contacting PSS. It
does sounds like there is something more than just this job which is not
correct, therefore rebuilding the cluster may be one option. It doesn't soun
d
like you are using version control to maintain your scripts, if you do have
a
good script then you could always drop the job and re-create it to see if th
e
situation changes for the new job.
John
"Al" wrote:
[vbcol=seagreen]
> Hi John
> The job is specific to a database on that specific instance, as currently
> the only db in the other instance is aspstate.
> As I say it is a weird one.
> I have two servers
> server a - 172.21.24.30
> server b - 172.21.24.31
> sql cluster - 172.21.24.34
> Instance One - both have names
> Instance Two
> Running in an active / passive mode if you are logged on to server A you c
an
> look at the history for the job no problem, but if you look on to server B
> you cannot look at the job history and get the 8152 error or 0x80041010.
> At this point I must say I am refering to Server A and B as the server tha
t
> the cluster is connecting to at that point in time
> Also if you try to create a script from the job it reports the same error
> but this time on both server A and B.
> To add another thing into the mix I downloaded and installed SQL SP2 on my
> local PC which was running SQL2005, and had the same problem reading the j
ob
> history after the install of SP2 it could read the job history logs but co
uld
> not create the script of the job from SQL Agent.
> If I try to script the aspstate job from Instance 2 on Server A it works b
ut
> do it on Server B and it fails, but do it for Instance 1 and it works.
> I have included the error message I get when attempting to create the scri
pt.
> From SQL
> --
> TITLE: Microsoft SQL Server Management Studio
> --
> Script failed for Job 'Get LES Payments Daily import from GENIESERVER'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...ob&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> Enumerate target servers failed for Job 'Get LES Payments Daily import fro
m
> GENIESERVER'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...ob&LinkId=20476
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> String or binary data would be truncated. (Microsoft SQL Server, Error: 81
52)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...52&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
> --
> From Eventviewer
> --
> Event filter with query "select * from __InstanceModificationEvent within
10
> where TargetInstance ISA 'Win32_Service'" could not be (re)activated in
> namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of err
or
> 0x80041010. Events may not be delivered through this filter until the prob
lem
> is corrected.
> Any advise would be great.
> Al
> "John Bell" wrote:
>|||John
We do have a microsoft contract so I will contact them, this is the first
script we have put on the server so is the only version
but thanks for trying to help
AL
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Unfortunately I can't suggest anything more other than contacting PSS. It
> does sounds like there is something more than just this job which is not
> correct, therefore rebuilding the cluster may be one option. It doesn't so
und
> like you are using version control to maintain your scripts, if you do hav
e a
> good script then you could always drop the job and re-create it to see if
the
> situation changes for the new job.
> John
> "Al" wrote:
>|||Hi
My assumption was that this script was upgraded from SQL 2000!
If you do have a file with this scripted you can create a new job (with a
different name) and disable the current one and then see if you have the sam
e
problems.
John
"Al" wrote:
[vbcol=seagreen]
> John
> We do have a microsoft contract so I will contact them, this is the first
> script we have put on the server so is the only version
> but thanks for trying to help
> AL
> "John Bell" wrote:
>|||John
Thanks. I tried that no difference, I have even created a job from Scratch
then try to use the Create to - so I can create a script and it does not
work. An example of the job is to give users permissions to the aspstate
tables in tempdb. Altthough I can use the Drop to command and it will create
a script. It sounds like there is something not right but I am at a loss to
what that is. It looks like some things work and others dont I may have to
remove the instant and reinstall but I am not sure how easy that will be as
it will be up to the team responsible for the application
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> My assumption was that this script was upgraded from SQL 2000!
> If you do have a file with this scripted you can create a new job (with a
> different name) and disable the current one and then see if you have the s
ame
> problems.
> John
> "Al" wrote:
>