Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts

Tuesday, March 20, 2012

BUG: using FOR XML AUTO

I have installed this software:
- Windows Server 2003, Enterprise Edition.
- SQL Server 2005, Client tools (Server is in an another machine)
- VirusScan Enterprise 8.0.0
When i execute the next query:
USE AdventureWorks
SELECT * FROM Person.Contact
WHERE ContactID = 1 FOR XML AUTO
VirusScan report me this:
Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
Detected As: Exploit-ObscuredHtml
Detection Type: Trojan
Application: SqlWb.exe
And SQL Server Management Studio:
An error occurred while executing batch. Error message is: Invalid calling
sequence: file stream must be initialized first.
*****
I apreciate any sugestion !
Thank you.I turn off the antivirus and the query work,
I reported the problem to McAfee...
"Ubeimar Vergara" wrote:

> I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.

BUG: using FOR XML AUTO

I have installed this software:
- Windows Server 2003, Enterprise Edition.
- SQL Server 2005, Client tools (Server is in an another machine)
- VirusScan Enterprise 8.0.0
When i execute the next query:
USE AdventureWorks
SELECT * FROM Person.Contact
WHERE ContactID = 1 FOR XML AUTO
VirusScan report me this:
Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
Detected As: Exploit-ObscuredHtml
Detection Type: Trojan
Application: SqlWb.exe
And SQL Server Management Studio:
An error occurred while executing batch. Error message is: Invalid calling
sequence: file stream must be initialized first.
*****
I apreciate any sugestion !
Thank you.TURN OFF anti-virus software on the server!!
A properly configured SQL Server 'should' not need anti-virus software
installed on the server.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Ubeimar Vergara" <Ubeimar Vergara@.discussions.microsoft.com> wrote in
message news:9CD7E5A0-C308-44C6-A3EA-A0B4CC2D346F@.microsoft.com...
>I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.|||"Ubeimar Vergara" <Ubeimar Vergara@.discussions.microsoft.com> wrote in
message news:9CD7E5A0-C308-44C6-A3EA-A0B4CC2D346F@.microsoft.com...
>I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
>
Sounds like a bug in your Antivirus program interfering with the operation
of Management Studio on your client computer.
David|||I turn off the antivirus and the query work,
I reported the problem to McAfee...
"Ubeimar Vergara" wrote:
> I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.sql

Saturday, February 25, 2012

Buffer Exception

When running a package created on my local machine i get no errors at all but when i try to run the same package on the server i get an error specifying Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.

I have tried changing the defaultbuffersize of the data flow task but this makes no difference. I think that a buffer size for a particular column is being exceed but i cannot find anywhere to set this property.

Has anyone else struck this error?

What key things are different between your local development box and your server? Different locale settings, 32 to 64 bit perhaps?

Friday, February 24, 2012

browse to reports

Hi,
I have created reports on my local machine as a test.
I can view the reports fine but others can not browse to these reports on my
machine.
I am not using any code, just the front end report creating of reporting
services in Visual studio .net
How can I allow other to view these reports on my machine.
ThanksHi,
Surf to http://servername/reports, click on the properties-tab and add the
users you want to give access.
hth,
Pieter
"Farsh" <Farsh@.discussions.microsoft.com> wrote in message
news:1D124954-0038-4726-8BAC-CDBE70EC6F38@.microsoft.com...
> Hi,
> I have created reports on my local machine as a test.
> I can view the reports fine but others can not browse to these reports on
> my
> machine.
> I am not using any code, just the front end report creating of reporting
> services in Visual studio .net
> How can I allow other to view these reports on my machine.
> Thanks|||first of all u should tell whats the error ppl r getting when they r
trying to access ur report so that it could properly b pointed out n
rectified as per my understanding i believe this would b RSACCESSDENIED
error n u ve to add users login to PERMIT through REPORT MANAGER check
security features/tab in report manager
hope it ll answer|||Thanks
"Pieter van Maasdam" wrote:
> Hi,
> Surf to http://servername/reports, click on the properties-tab and add the
> users you want to give access.
> hth,
> Pieter
> "Farsh" <Farsh@.discussions.microsoft.com> wrote in message
> news:1D124954-0038-4726-8BAC-CDBE70EC6F38@.microsoft.com...
> > Hi,
> > I have created reports on my local machine as a test.
> > I can view the reports fine but others can not browse to these reports on
> > my
> > machine.
> > I am not using any code, just the front end report creating of reporting
> > services in Visual studio .net
> >
> > How can I allow other to view these reports on my machine.
> > Thanks
>
>

Thursday, February 16, 2012

BrightStor ArcServe Question

I have a strange problem that seemed to appear around 4 days ago.
We are running SQL2000 on a Windows 2003 Server machine - fully updated by
Microsoft Windows Updates. The machine is running BrightStor ArcServe 11.0
and SQL agent and BAOF agent.
My backups are scehduled to run every evening at 18:30. However, after 10
minutes (after backing up the Registry and System State) the job crashes with
E8604.
I updated the product with a patch off the CASupportConnect site, to deal
with the SQL Agent. This was yesterday afternoon when I applied the patch
and rebooted. I did a test backup (C drive and a SQL database and it worked
fine). Last nights backup crashed (as mentioned above). However, when I ran
the job manually the backup worked fine.
It seems that I am only getting the problem on scheduled jobs. The backups
have been going on everyday for several months, and this is a new one for me.
Can someone help?
The machine it is running on is a Dell PE4600 with an LTO2 PowerVault 110T
Internal tape drive. The BrightStor ArcServe version is v11.0. Build is
2670.
The patch I installed yesterday was the QO70769.CAZ.
Please help!
skc
Hi
Are you backing up to tape directly or to disc and t hen tape?
What are your scheduled jobs doing?
Which version of SQL Server is this?
John
"Skc" wrote:

> I have a strange problem that seemed to appear around 4 days ago.
> We are running SQL2000 on a Windows 2003 Server machine - fully updated by
> Microsoft Windows Updates. The machine is running BrightStor ArcServe 11.0
> and SQL agent and BAOF agent.
> My backups are scehduled to run every evening at 18:30. However, after 10
> minutes (after backing up the Registry and System State) the job crashes with
> E8604.
> I updated the product with a patch off the CASupportConnect site, to deal
> with the SQL Agent. This was yesterday afternoon when I applied the patch
> and rebooted. I did a test backup (C drive and a SQL database and it worked
> fine). Last nights backup crashed (as mentioned above). However, when I ran
> the job manually the backup worked fine.
> It seems that I am only getting the problem on scheduled jobs. The backups
> have been going on everyday for several months, and this is a new one for me.
> Can someone help?
> The machine it is running on is a Dell PE4600 with an LTO2 PowerVault 110T
> Internal tape drive. The BrightStor ArcServe version is v11.0. Build is
> 2670.
> The patch I installed yesterday was the QO70769.CAZ.
> Please help!
> skc

BrightStor ArcServe Question

I have a strange problem that seemed to appear around 4 days ago.
We are running SQL2000 on a Windows 2003 Server machine - fully updated by
Microsoft Windows Updates. The machine is running BrightStor ArcServe 11.0
and SQL agent and BAOF agent.
My backups are scehduled to run every evening at 18:30. However, after 10
minutes (after backing up the Registry and System State) the job crashes wit
h
E8604.
I updated the product with a patch off the CASupportConnect site, to deal
with the SQL Agent. This was yesterday afternoon when I applied the patch
and rebooted. I did a test backup (C drive and a SQL database and it worked
fine). Last nights backup crashed (as mentioned above). However, when I ra
n
the job manually the backup worked fine.
It seems that I am only getting the problem on scheduled jobs. The backups
have been going on everyday for several months, and this is a new one for me
.
Can someone help?
The machine it is running on is a Dell PE4600 with an LTO2 PowerVault 110T
Internal tape drive. The BrightStor ArcServe version is v11.0. Build is
2670.
The patch I installed yesterday was the QO70769.CAZ.
Please help!
skcHi
Are you backing up to tape directly or to disc and t hen tape?
What are your scheduled jobs doing?
Which version of SQL Server is this?
John
"Skc" wrote:

> I have a strange problem that seemed to appear around 4 days ago.
> We are running SQL2000 on a Windows 2003 Server machine - fully updated by
> Microsoft Windows Updates. The machine is running BrightStor ArcServe 11.
0
> and SQL agent and BAOF agent.
> My backups are scehduled to run every evening at 18:30. However, after 10
> minutes (after backing up the Registry and System State) the job crashes w
ith
> E8604.
> I updated the product with a patch off the CASupportConnect site, to deal
> with the SQL Agent. This was yesterday afternoon when I applied the patch
> and rebooted. I did a test backup (C drive and a SQL database and it work
ed
> fine). Last nights backup crashed (as mentioned above). However, when I
ran
> the job manually the backup worked fine.
> It seems that I am only getting the problem on scheduled jobs. The backup
s
> have been going on everyday for several months, and this is a new one for
me.
> Can someone help?
> The machine it is running on is a Dell PE4600 with an LTO2 PowerVault 110T
> Internal tape drive. The BrightStor ArcServe version is v11.0. Build is
> 2670.
> The patch I installed yesterday was the QO70769.CAZ.
> Please help!
> skc

BrightStor ArcServe Question

I have a strange problem that seemed to appear around 4 days ago.
We are running SQL2000 on a Windows 2003 Server machine - fully updated by
Microsoft Windows Updates. The machine is running BrightStor ArcServe 11.0
and SQL agent and BAOF agent.
My backups are scehduled to run every evening at 18:30. However, after 10
minutes (after backing up the Registry and System State) the job crashes with
E8604.
I updated the product with a patch off the CASupportConnect site, to deal
with the SQL Agent. This was yesterday afternoon when I applied the patch
and rebooted. I did a test backup (C drive and a SQL database and it worked
fine). Last nights backup crashed (as mentioned above). However, when I ran
the job manually the backup worked fine.
It seems that I am only getting the problem on scheduled jobs. The backups
have been going on everyday for several months, and this is a new one for me.
Can someone help?
The machine it is running on is a Dell PE4600 with an LTO2 PowerVault 110T
Internal tape drive. The BrightStor ArcServe version is v11.0. Build is
2670.
The patch I installed yesterday was the QO70769.CAZ.
Please help!
skcHi
Are you backing up to tape directly or to disc and t hen tape?
What are your scheduled jobs doing?
Which version of SQL Server is this?
John
"Skc" wrote:
> I have a strange problem that seemed to appear around 4 days ago.
> We are running SQL2000 on a Windows 2003 Server machine - fully updated by
> Microsoft Windows Updates. The machine is running BrightStor ArcServe 11.0
> and SQL agent and BAOF agent.
> My backups are scehduled to run every evening at 18:30. However, after 10
> minutes (after backing up the Registry and System State) the job crashes with
> E8604.
> I updated the product with a patch off the CASupportConnect site, to deal
> with the SQL Agent. This was yesterday afternoon when I applied the patch
> and rebooted. I did a test backup (C drive and a SQL database and it worked
> fine). Last nights backup crashed (as mentioned above). However, when I ran
> the job manually the backup worked fine.
> It seems that I am only getting the problem on scheduled jobs. The backups
> have been going on everyday for several months, and this is a new one for me.
> Can someone help?
> The machine it is running on is a Dell PE4600 with an LTO2 PowerVault 110T
> Internal tape drive. The BrightStor ArcServe version is v11.0. Build is
> 2670.
> The patch I installed yesterday was the QO70769.CAZ.
> Please help!
> skc