Problem with Large SQL Log file

I'm having a problem with this file SQL log file
It appear by itself in the C: root directory and its filesize keep increasing while the SQL server is running even when I just open/ shutdown the SQL server. It had so far go up to 4GB in just a day.
I had actually keep log files of the SQL Server in another folder, so the SQL file is not created by me nor for any purpose. It keep coming back even when I remove it. Anyone can tell me what's the problem? Is it a virus or whatever?
Hi,
SQL file in C drive is not used by SQL Server. THis file is created by ODBC.
When ever we click the ODBC trace option, this SQL file will be updated and
have all the tracing information.
How to delete or move the file to a alternate location:-
1. Go to COntrol panel--Admin tools- Data sources (ODBC)
2. Double click on ODBC , CLick the Tracing Tab (In the top)
3. If it is Stop tracing then actually Tracing is going on.
4. In that case click "Stop Tracing"
5. Go to C drive root and delete the file or move the file to a diffrent
folder
6. When ever you require you can enable the tracing.
Thanks
Hari
MCDBA
"Kian" <anonymous@.discussions.microsoft.com> wrote in message
news:430A0105-2E68-4999-AEA7-B6D475828E33@.microsoft.com...
> I'm having a problem with this file SQL log file
> It appear by itself in the C: root directory and its filesize keep
increasing while the SQL server is running even when I just open/ shutdown
the SQL server. It had so far go up to 4GB in just a day.
> I had actually keep log files of the SQL Server in another folder, so the
SQL file is not created by me nor for any purpose. It keep coming back even
when I remove it. Anyone can tell me what's the problem? Is it a virus or
whatever?

Problem with Large SQL Log file

I'm having a problem with this file SQL log file
It appear by itself in the C: root directory and its filesize keep increasin
g while the SQL server is running even when I just open/ shutdown the SQL se
rver. It had so far go up to 4GB in just a day.
I had actually keep log files of the SQL Server in another folder, so the SQ
L file is not created by me nor for any purpose. It keep coming back even wh
en I remove it. Anyone can tell me what's the problem? Is it a virus or what
ever?Hi,
SQL file in C drive is not used by SQL Server. THis file is created by ODBC.
When ever we click the ODBC trace option, this SQL file will be updated and
have all the tracing information.
How to delete or move the file to a alternate location:-
1. Go to COntrol panel--Admin tools- Data sources (ODBC)
2. Double click on ODBC , CLick the Tracing Tab (In the top)
3. If it is Stop tracing then actually Tracing is going on.
4. In that case click "Stop Tracing"
5. Go to C drive root and delete the file or move the file to a diffrent
folder
6. When ever you require you can enable the tracing.
Thanks
Hari
MCDBA
"Kian" <anonymous@.discussions.microsoft.com> wrote in message
news:430A0105-2E68-4999-AEA7-B6D475828E33@.microsoft.com...
> I'm having a problem with this file SQL log file
> It appear by itself in the C: root directory and its filesize keep
increasing while the SQL server is running even when I just open/ shutdown
the SQL server. It had so far go up to 4GB in just a day.
> I had actually keep log files of the SQL Server in another folder, so the
SQL file is not created by me nor for any purpose. It keep coming back even
when I remove it. Anyone can tell me what's the problem? Is it a virus or
whatever?sql

Problem with Large SQL Log file

I'm having a problem with this file SQL log fil
It appear by itself in the C: root directory and its filesize keep increasing while the SQL server is running even when I just open/ shutdown the SQL server. It had so far go up to 4GB in just a day
I had actually keep log files of the SQL Server in another folder, so the SQL file is not created by me nor for any purpose. It keep coming back even when I remove it. Anyone can tell me what's the problem? Is it a virus or whatever?Hi,
SQL file in C drive is not used by SQL Server. THis file is created by ODBC.
When ever we click the ODBC trace option, this SQL file will be updated and
have all the tracing information.
How to delete or move the file to a alternate location:-
1. Go to COntrol panel--Admin tools- Data sources (ODBC)
2. Double click on ODBC , CLick the Tracing Tab (In the top)
3. If it is Stop tracing then actually Tracing is going on.
4. In that case click "Stop Tracing"
5. Go to C drive root and delete the file or move the file to a diffrent
folder
6. When ever you require you can enable the tracing.
Thanks
Hari
MCDBA
"Kian" <anonymous@.discussions.microsoft.com> wrote in message
news:430A0105-2E68-4999-AEA7-B6D475828E33@.microsoft.com...
> I'm having a problem with this file SQL log file
> It appear by itself in the C: root directory and its filesize keep
increasing while the SQL server is running even when I just open/ shutdown
the SQL server. It had so far go up to 4GB in just a day.
> I had actually keep log files of the SQL Server in another folder, so the
SQL file is not created by me nor for any purpose. It keep coming back even
when I remove it. Anyone can tell me what's the problem? Is it a virus or
whatever?

Problem with Form Authentication Example

I installed the Microsoft Forms Authentication in Report Services example in
a VPC running Windows 2003, Active Directory, SQl Server Enterprise and SQL
Reporting Servcie Enterprise Edition.
I registered user "john" and modified RSReportServer.config and added and
changed the value for <UserName> tag to be "john".
Stepping through the debugger the demo fails on GetWebResponse because
cookie is null.
I have tried FQDN in RSWebApplication.config but problem persist.
Any idea what is going wrong causing GetWebResponse to fail?I'm using a solution that's primarily based on the Forms Auth sample and I
can say that it does work. Double-check your web.config modifications for
the ReportServer and ReportManager webs according to the instructions in the
sample.
Adrian M.
"John Amason" <jamason@.ics-associates.com> wrote in message
news:uH%23y30Q$EHA.2580@.TK2MSFTNGP15.phx.gbl...
>I installed the Microsoft Forms Authentication in Report Services example
>in
> a VPC running Windows 2003, Active Directory, SQl Server Enterprise and
> SQL
> Reporting Servcie Enterprise Edition.
> I registered user "john" and modified RSReportServer.config and added and
> changed the value for <UserName> tag to be "john".
> Stepping through the debugger the demo fails on GetWebResponse because
> cookie is null.
> I have tried FQDN in RSWebApplication.config but problem persist.
> Any idea what is going wrong causing GetWebResponse to fail?
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe Niel
Thats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>
|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>
|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:
> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a écrit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>>Hi
>>I recently upgraded my infrastructure to Active Directory 2003.
>>Since then I'm having two problems when I start Enterprise Manager and
>>connect on 2003 sever member with SQL2000 sp3a:
>>1 On non-member machine, I use SQL authentication to register the server
>>and
>>in the security log I keep getting dozens of Event ID 529 (unkown username
>>or bad password) every minutes.
>>The user in the event is the local account logged on the workstation.
>>2 on member machines, I have three successfull events (logoff/privilges
>>assigned/logon) every 10 seconds
>>In the first case, why does it try to log on with the local account ?
>>In the second case why does it logoff/logon every 10 seconds ?
>>
>>I can't remove this audit (international group security policy...) and the
>>security logs are full in about 2 weeks with 600,000+ events!! I can't
>>manage that!
>>Thanks in advance for your help.
>>Regards,
>>Christophe Niel
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server a
nd
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server an
d
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>
>

Problem with Deployed Report

I deployed my phone directory to the server and now dynamic images are no longer being displayed. They are specifically employee photos based on a naming convention. I used the path as ''file:/// etc.'' and when I open up my start menu and throw it into run it works fine. It also runs fine in my visual studio report, but for whatever reason when its deployed it no-longer runs. Does anyone know what could eb causing this problem?

Hello,

You may check to see if the reporting services execution account has access to the file share where the photo's are stored.

Jarret

Problem with db connection

My application works properly with development area (VS 2005) , When I created virtual directory and call using browser (IE 7.0) , error occurs exacly the same below

ERROR:

Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.

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

Exception Details:System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.

Source Error:

Line 4932: this.Adapter.SelectCommand.Parameters[2].Value = ((int)(PROFIL));Line 4933: neuron.KULLANICI_TANIMLARIDataTable dataTable = new neuron.KULLANICI_TANIMLARIDataTable();Line 4934: this.Adapter.Fill(dataTable);Line 4935: return dataTable;Line 4936: }

Connection String is below

"Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\neuron2007_AJAX\\App_Data\\neuron_Data.MDF;Integrated Security=True;User Instance=True";

How can I solve this problem?

Thanks

Did you grant the ASPNET user account permission for the database?

Jeff

|||

Are you publishing to a remote server and are you publishing a copy of the local database that you are connecting to in that connection string?

Did you grant the correct permissions for Integrated Security?

|||

Yes BRCK231\ASPNET has rights below

- db_datareader

- db_datawriter

But connection is done with user BORINTERNAL\CBOZLAGAN for BRCK231\SQLEXPRESS sqlexpress 2005 server

|||

Is the website set up (via IIS) to accept anonymous connections? If not, please give that a try.

Mark

|||

Did you figure it out yet?