Examples of Web ReportViewer with Remote Processing

We have tried a bunch of different ways to run reports in the ASP.NET Web
ReportViewer. Every attempt to do it ourselves has failed to render.
We have a number of examples of local processing in Web pages. Heck, we
even have built a number of Windows Forms applications that use both local
and remote processing. But we cannot find anything that will cause ASP.Net
to render.
Is it possible that using the Viewer in this case does not work?
Walt Crosby
Chief Architect
Everyday Wirelessdoes your RS and ReportViewer server are on 2 different servers?
and do you use the NTLM authentication?
if yes, you suffer Kerberos issue, search on the MS web site to know how to
setup it.
can you send the the code of your ASPX page which contains the control?
"Microsoft" <Walt.Crosby@.everydaywireless.com> wrote in message
news:ugKGzreWHHA.600@.TK2MSFTNGP05.phx.gbl...
> We have tried a bunch of different ways to run reports in the ASP.NET Web
> ReportViewer. Every attempt to do it ourselves has failed to render.
> We have a number of examples of local processing in Web pages. Heck, we
> even have built a number of Windows Forms applications that use both local
> and remote processing. But we cannot find anything that will cause
> ASP.Net to render.
> Is it possible that using the Viewer in this case does not work?
> Walt Crosby
> Chief Architect
> Everyday Wireless
>|||The Reports Manager and ReportServer are on the same machine as the Web
Site. We have used Report Viewer many times from Windows Forms applications
with very few problems. We have yet to find any examples of Remote Server
processing with Web Report Viewer...
Walt Crosby
"Jeje" <willgart@.hotmail.com> wrote in message
news:1215D799-3869-4CAC-8550-3C5B049AC185@.microsoft.com...
> does your RS and ReportViewer server are on 2 different servers?
> and do you use the NTLM authentication?
> if yes, you suffer Kerberos issue, search on the MS web site to know how
> to setup it.
> can you send the the code of your ASPX page which contains the control?
>
> "Microsoft" <Walt.Crosby@.everydaywireless.com> wrote in message
> news:ugKGzreWHHA.600@.TK2MSFTNGP05.phx.gbl...
>> We have tried a bunch of different ways to run reports in the ASP.NET Web
>> ReportViewer. Every attempt to do it ourselves has failed to render.
>> We have a number of examples of local processing in Web pages. Heck, we
>> even have built a number of Windows Forms applications that use both
>> local and remote processing. But we cannot find anything that will cause
>> ASP.Net to render.
>> Is it possible that using the Viewer in this case does not work?
>> Walt Crosby
>> Chief Architect
>> Everyday Wireless

Evict cluster node BEFORE running SQL setup

Have a two node SQL cluster. Node one has failed and has been evicted from
the cluster i.e. before running the SQL setup and removing the failed node
from SQL and cleaniing the SQL binaries.
What would the best way to proceed?
Can the SQL setup be run after the node has been evicted?
(The intent here is to rebuild the failed node and rejoin the cluster).
Thanks
Staffy
Yes. This scenario is documented in BOL under the index topic Failover
Clustering, recovering from a failover clustering failure. Your situation
fits into scenario 1. You will likely get a lot of errors when you remove
the failed node, but that is normal. The SQL installer is trying to update
that node and it cannot. When you are done, you should see only one node
allowed for the SQL resource group in the Cluster Administrator tool.
If you reuse the server name and IP address, make sure and clean it out of
Active Directory before you attempt to add the rebuilt node back to the
domain. I have seen some wierd behavior because of "tombstoned" entries in
AD.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Staffy" <staffy@.noemail.noemail> wrote in message
news:8C1A95E1-C554-4951-9065-4A0DDA32EAF6@.microsoft.com...
> Have a two node SQL cluster. Node one has failed and has been evicted from
> the cluster i.e. before running the SQL setup and removing the failed node
> from SQL and cleaniing the SQL binaries.
> What would the best way to proceed?
> Can the SQL setup be run after the node has been evicted?
> (The intent here is to rebuild the failed node and rejoin the cluster).
> Thanks
> --
> Staffy

EventID 18456 Login failed for SA

I installed SQL server 2005 Beta2 on my Home Destop machine.
I keep getting the follwoing error message .
I tried running SQL profiler to see what is causing this error.
I found osql-32 as client trying to login to SQL server.
Could not find any process named osql-32 in the task manager.
My computer is not on any network. It runs Road runner.
Is there any way to trace this problem ?
Thanks for your help
Event Type:Failure Audit
Event Source:MSSQLSERVER
Event Category:Logon
Event ID:18456
Date:1/9/2005
Time:12:49:29 PM
User:N/A
Computer:SRINIVAS
Description:
Login failed for user 'sa'. [CLIENT: 219.76.192.221]
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 09 00 00 00 53 00 52 00 ...S.R.
0010: 49 00 4e 00 49 00 56 00 I.N.I.V.
0018: 41 00 53 00 00 00 07 00 A.S....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...
You mention that your computer is not on a network, however the error
mentions an IP address for the client, 219.76.192.221.
Is 'Road Runner' your internet access and when connected to the internet is
your computer protected by a firewall? Could someone externally be accessing
your computer?
Stuart Fish
www.technologic.co.nz
"srinivasa rao Nanduru" <srinivasa rao Nanduru@.discussions.microsoft.com>
wrote in message news:821F173D-8768-4427-9A4B-B92E1FD4CB41@.microsoft.com...
>I installed SQL server 2005 Beta2 on my Home Destop machine.
> I keep getting the follwoing error message .
> I tried running SQL profiler to see what is causing this error.
> I found osql-32 as client trying to login to SQL server.
> Could not find any process named osql-32 in the task manager.
> My computer is not on any network. It runs Road runner.
> Is there any way to trace this problem ?
> Thanks for your help
>
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: Logon
> Event ID: 18456
> Date: 1/9/2005
> Time: 12:49:29 PM
> User: N/A
> Computer: SRINIVAS
> Description:
> Login failed for user 'sa'. [CLIENT: 219.76.192.221]
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 09 00 00 00 53 00 52 00 ...S.R.
> 0010: 49 00 4e 00 49 00 56 00 I.N.I.V.
> 0018: 41 00 53 00 00 00 07 00 A.S....
> 0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
> 0028: 74 00 65 00 72 00 00 00 t.e.r...
>

EventID 18456 Login failed for SA

I installed SQL server 2005 Beta2 on my Home Destop machine.
I keep getting the follwoing error message .
I tried running SQL profiler to see what is causing this error.
I found osql-32 as client trying to login to SQL server.
Could not find any process named osql-32 in the task manager.
My computer is not on any network. It runs Road runner.
Is there any way to trace this problem ?
Thanks for your help
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: Logon
Event ID: 18456
Date: 1/9/2005
Time: 12:49:29 PM
User: N/A
Computer: SRINIVAS
Description:
Login failed for user 'sa'. [CLIENT: 219.76.192.221]
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 09 00 00 00 53 00 52 00 ...S.R.
0010: 49 00 4e 00 49 00 56 00 I.N.I.V.
0018: 41 00 53 00 00 00 07 00 A.S....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...You mention that your computer is not on a network, however the error
mentions an IP address for the client, 219.76.192.221.
Is 'Road Runner' your internet access and when connected to the internet is
your computer protected by a firewall? Could someone externally be accessing
your computer?
Stuart Fish
www.technologic.co.nz
"srinivasa rao Nanduru" <srinivasa rao Nanduru@.discussions.microsoft.com>
wrote in message news:821F173D-8768-4427-9A4B-B92E1FD4CB41@.microsoft.com...
>I installed SQL server 2005 Beta2 on my Home Destop machine.
> I keep getting the follwoing error message .
> I tried running SQL profiler to see what is causing this error.
> I found osql-32 as client trying to login to SQL server.
> Could not find any process named osql-32 in the task manager.
> My computer is not on any network. It runs Road runner.
> Is there any way to trace this problem ?
> Thanks for your help
>
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: Logon
> Event ID: 18456
> Date: 1/9/2005
> Time: 12:49:29 PM
> User: N/A
> Computer: SRINIVAS
> Description:
> Login failed for user 'sa'. [CLIENT: 219.76.192.221]
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 09 00 00 00 53 00 52 00 ...S.R.
> 0010: 49 00 4e 00 49 00 56 00 I.N.I.V.
> 0018: 41 00 53 00 00 00 07 00 A.S....
> 0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
> 0028: 74 00 65 00 72 00 00 00 t.e.r...
>

EventID 18456 Login failed for SA

I installed SQL server 2005 Beta2 on my Home Destop machine.
I keep getting the follwoing error message .
I tried running SQL profiler to see what is causing this error.
I found osql-32 as client trying to login to SQL server.
Could not find any process named osql-32 in the task manager.
My computer is not on any network. It runs Road runner.
Is there any way to trace this problem ?
Thanks for your help
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: Logon
Event ID: 18456
Date: 1/9/2005
Time: 12:49:29 PM
User: N/A
Computer: SRINIVAS
Description:
Login failed for user 'sa'. [CLIENT: 219.76.192.221]
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 09 00 00 00 53 00 52 00 ...S.R.
0010: 49 00 4e 00 49 00 56 00 I.N.I.V.
0018: 41 00 53 00 00 00 07 00 A.S....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...You mention that your computer is not on a network, however the error
mentions an IP address for the client, 219.76.192.221.
Is 'Road Runner' your internet access and when connected to the internet is
your computer protected by a firewall? Could someone externally be accessing
your computer?
--
Stuart Fish
www.technologic.co.nz
"srinivasa rao Nanduru" <srinivasa rao Nanduru@.discussions.microsoft.com>
wrote in message news:821F173D-8768-4427-9A4B-B92E1FD4CB41@.microsoft.com...
>I installed SQL server 2005 Beta2 on my Home Destop machine.
> I keep getting the follwoing error message .
> I tried running SQL profiler to see what is causing this error.
> I found osql-32 as client trying to login to SQL server.
> Could not find any process named osql-32 in the task manager.
> My computer is not on any network. It runs Road runner.
> Is there any way to trace this problem ?
> Thanks for your help
>
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: Logon
> Event ID: 18456
> Date: 1/9/2005
> Time: 12:49:29 PM
> User: N/A
> Computer: SRINIVAS
> Description:
> Login failed for user 'sa'. [CLIENT: 219.76.192.221]
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 09 00 00 00 53 00 52 00 ...S.R.
> 0010: 49 00 4e 00 49 00 56 00 I.N.I.V.
> 0018: 41 00 53 00 00 00 07 00 A.S....
> 0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
> 0028: 74 00 65 00 72 00 00 00 t.e.r...
>

Event Log and SQL Server Agent

Hi Helper,
When I boot me server up, I always get an alert that says at least one
service or driver failed. I checked all of the logs in the event viewer.
The error is in the Application log. When I look at the properties of the
error I get a dialog box that has the description "Unable to read the
eventlog (Reason: The event log has changed between read operations). The
Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event ID is
318.
How do I resolve this problem? What can I do to prevent getting this Alert
message and get this fixed?
Thanks,
KeithThat's nothing to worry about.
That message isn't the service failing to start, have a look in Event Viewer
(System). This is more likely to contain the service that's failing.
HTH
Ryan Waight, MCDBA, MCSE
"Keith Norris" <klnorris@.comcast.net> wrote in message
news:naqdna69F685MjaiRVn-gg@.comcast.com...
> Hi Helper,
> When I boot me server up, I always get an alert that says at least one
> service or driver failed. I checked all of the logs in the event viewer.
> The error is in the Application log. When I look at the properties of the
> error I get a dialog box that has the description "Unable to read the
> eventlog (Reason: The event log has changed between read operations). The
> Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event ID
is
> 318.
> How do I resolve this problem? What can I do to prevent getting this
Alert
> message and get this fixed?
> Thanks,
> Keith
>|||There are no errors in the event viewer (System). There are only warnings
or information. There are no errors in the other event viewers either such
as Directory Service, DNS Server, File Replication Service, Service, or
Security. There are only messages of type Information and Warning. The
original message I describe below is of type Error with an X in a red
circle. Isn't it only the error messages rather than the information and
warning messages that cause the alerts? I do not want the Alert Message
saying at least on service or driver failed on boot up. I hope this
provides you with additional information to help me solve the problem. I'm
new to networking and database administration.
Thanks,
Keith
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:OH$E06TpDHA.3844@.tk2msftngp13.phx.gbl...
> That's nothing to worry about.
> That message isn't the service failing to start, have a look in Event
Viewer
> (System). This is more likely to contain the service that's failing.
>
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Keith Norris" <klnorris@.comcast.net> wrote in message
> news:naqdna69F685MjaiRVn-gg@.comcast.com...
> > Hi Helper,
> >
> > When I boot me server up, I always get an alert that says at least one
> > service or driver failed. I checked all of the logs in the event
viewer.
> > The error is in the Application log. When I look at the properties of
the
> > error I get a dialog box that has the description "Unable to read the
> > eventlog (Reason: The event log has changed between read operations).
The
> > Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event ID
> is
> > 318.
> >
> > How do I resolve this problem? What can I do to prevent getting this
> Alert
> > message and get this fixed?
> >
> > Thanks,
> > Keith
> >
> >
>|||We can ensure it's not SQL Server causing the 'Service Failed to Start
message' in the following manner.
In Control Services :-
Set the startup of SQLServerAgent and MSSQLServer to Manual
Stop both services
Clear all 3 Event Logs.
Reboot the Server.
The SQL Services are now not trying to start, if the Service didn't start
message appears it definalty hasn't come from SQL.
Alternitavly, Control Panel / Servcies.
Look at every service, ensure those with a Startup Type of AutoMatic are
all Status = Started.
If you have any Automatic starters that are not Started -- bingo...
HTH
Ryan Waight, MCDBA, MCSE
"Keith Norris" <klnorris@.comcast.net> wrote in message
news:gPKdnVEvmuxEIjaiRVn-jw@.comcast.com...
> There are no errors in the event viewer (System). There are only warnings
> or information. There are no errors in the other event viewers either
such
> as Directory Service, DNS Server, File Replication Service, Service, or
> Security. There are only messages of type Information and Warning. The
> original message I describe below is of type Error with an X in a red
> circle. Isn't it only the error messages rather than the information and
> warning messages that cause the alerts? I do not want the Alert Message
> saying at least on service or driver failed on boot up. I hope this
> provides you with additional information to help me solve the problem.
I'm
> new to networking and database administration.
> Thanks,
> Keith
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:OH$E06TpDHA.3844@.tk2msftngp13.phx.gbl...
> > That's nothing to worry about.
> >
> > That message isn't the service failing to start, have a look in Event
> Viewer
> > (System). This is more likely to contain the service that's failing.
> >
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Keith Norris" <klnorris@.comcast.net> wrote in message
> > news:naqdna69F685MjaiRVn-gg@.comcast.com...
> > > Hi Helper,
> > >
> > > When I boot me server up, I always get an alert that says at least one
> > > service or driver failed. I checked all of the logs in the event
> viewer.
> > > The error is in the Application log. When I look at the properties of
> the
> > > error I get a dialog box that has the description "Unable to read the
> > > eventlog (Reason: The event log has changed between read operations).
> The
> > > Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event
ID
> > is
> > > 318.
> > >
> > > How do I resolve this problem? What can I do to prevent getting this
> > Alert
> > > message and get this fixed?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> >
> >
>

Event ID: 421

I get this error in My Event Log on My WSUS server. I am running a Windows 2000 with SQL 2K SP4.

Connection to database failed. Reason=Cannot open database requested in login 'SUSDB'. Login fails. Login failed for user 'WSUS\ASPNET'.. Connection string: Data Source=WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection; Trustedd_Connection=Yes;Pooling='true'; Max Pool Size = 100

The web account does not have access to sqlserver. Run the following to enable access.

--allow connection to sqlserver

exec sp_grantlogin 'WSUS\ASPNET'

go

--change to the database you want to give access

use <db>

go

--allow database connection

exec sp_grantdbaccess 'WSUS\ASPNET'

go

I suggest you take a look at these stored procedures in book online. Also, take a look at "sp_addsrvrolemember" and "sp_addrolemember".

Event ID: 17806 - Attack on SQL Server

Hi,
I see the following event error : failure attempt to access my SQL Server by
some hacker.
Source: MS SQL Server
Event ID: 17806
SSPI handshake failed with error code 0x8009030c while establishing a
connection with integrated security; the connection has been closed.
What preventive measures i can take ?
Please help.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200707/1What make you think this is a hacker?
Is youre db connected with iis on the internet?
Most companies get more then 10.000 hack attemps a day ;)
Just make sure you got the latest security updates --run security baseline
analyser on youre pc to scan for leaks.
If somebody is doing a attack(SQL injection) you should see multiple login
failed messages attempts in youre logs.
Cheers

Event ID: 17806 - Attack on SQL Server

Hi,
I see the following event error : failure attempt to access my SQL Server by
some hacker.
Source: MS SQL Server
Event ID: 17806
SSPI handshake failed with error code 0x8009030c while establishing a
connection with integrated security; the connection has been closed.
What preventive measures i can take ?
Please help.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200707/1
What make you think this is a hacker?
Is youre db connected with iis on the internet?
Most companies get more then 10.000 hack attemps a day ;)
Just make sure you got the latest security updates --run security baseline
analyser on youre pc to scan for leaks.
If somebody is doing a attack(SQL injection) you should see multiple login
failed messages attempts in youre logs.
Cheers

Event ID: 17055 Source: MSSQLSERVER Type: Information Login failed

I am having a problem with one of the website we host that accesses an
SQL2000 database. Every so often I get the above mentioned event in the
App. log accompanied by a error reported by the users browser stating
that the login failed for IUSR_xxxxxx. If I log into the server having
the problem and log out the problem resolves itself. I tried using
Profiler to see if I could see any odd activity and there was no
activity what so ever while the problem persisted. Once the problem
corrected by the login/logout I saw normal activity resume in Profiler.
The only this I noticed different after the login/logout fix was that
the network protocol: Named Pipes actioned appeared to be showing up in
Profiles where it was not before. I have checked all my permissions and
everything seems to be in order(especially since the login/logout seems
to resolve it). Any ideas as to what is causing this?
Thank you in advance,
Ethan Cottrell
Structured Business SystemsBased upon your description, it sounds like you're requesting a Windows
Authenticated connection from the web server, and
it is authenticating using the IUSR account. This account doesn't exist on
the SQL Server , so it fails.
If you then login to the server using Named Pipes, you've authenticated
yourself and any new sessions will piggy-back on this.
If you then check for successfull logins at the server, does it show that
IUSR connected successfully or your domain account?
These two articles may give you a better understanding as well.
332167 IIS 6.0: HOW TO: Configure IIS to Control the Anonymous Password
http://support.microsoft.com/?id=332167
229286 FP2000: Cannot Connect to SQL Database on Windows NT Server Computer
http://support.microsoft.com/?id=229286
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
I already had added the IUSR account to SQL and gave it permissions on
the database. Any pages on the site that do not require a connection to
the database are fine, it is only those ASP pages that connect to the
database that are having this problem. When I use Profiler I can see
that the IUSR account has no problems logging in when there is no
problem, but once the problem occurs the IUSR account activity stops and
is replaced by the NT AUTHORITY/ANONYMOUS or something like that.
I think I may have resolved this issue already, but I am keeping an eye
on it. I forgot to mention earlier that the database in question is
accessing data on a linked server also, and I think that may have been
the source of my problem. We had recently installed a new server (server
B) with a different host name from the original. Server A is where the
website and it's database exist and server B is where the database with
additional data exists (it is the primary db for another site). I added
the old server b's host name to DNS to hopefully eliminate and potential
problems, but that may not have been the case. I have since removed all
linked servers and remote servers and recreated them in both instances
of SQL using the correct host name and am using the sa account to
authenticate between them. Does that sound like it could have been the
source of the problem?
Thank you for your response,
Ethan Cottrell
Structured Business Systems
Kevin McDonnell [MSFT] wrote:
> Based upon your description, it sounds like you're requesting a Windows
> Authenticated connection from the web server, and
> it is authenticating using the IUSR account. This account doesn't exist o
n
> the SQL Server , so it fails.
> If you then login to the server using Named Pipes, you've authenticated
> yourself and any new sessions will piggy-back on this.
> If you then check for successfull logins at the server, does it show that
> IUSR connected successfully or your domain account?
>
> These two articles may give you a better understanding as well.
> 332167 IIS 6.0: HOW TO: Configure IIS to Control the Anonymous Password
> http://support.microsoft.com/?id=332167
> 229286 FP2000: Cannot Connect to SQL Database on Windows NT Server Compute
r
> http://support.microsoft.com/?id=229286
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||DNS issues could certainly cause a problem from the web server to the
database.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Event ID: 17055

I am running a WSUS and get this error in my event log. I am running Windows 2000 with SQL 2K SP4.

1827

CREAR/ALTER DATABASE failed because the resulting cumulative database size would exceed you licensed limit of 2048MB per database.

2 GB is the data size limit for SQL 2000 MSDE databases. You will need a higher end edition to have a larger database.

Event ID: 17053 - Operating system error 112(error not found) encountered

Hi there

I have recently installed a new server for a client running SBS2003 R2 with SQLServer 2005.

I noted that the backup failed the SQL Server database on the consistenty check. On checking the event log I see this message as per above.

It reads in the description

c:\data\law\sqldata\data41_Data.MDF:MSSQL_DBCC6:

Operating system error 112(error not found) encountered.

Looking in the error log I see :

Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.

Error: 17053, Severity: 16, State: 1.

C:\Data\LAW\sqldata\data41_Data.MDF:MSSQL_DBCC6: Operating system error 112(error not found) encountered.

DBCC CHECKDB (data41) WITH no_infomsgs executed by NT AUTHORITY\SYSTEM found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 26 seconds.

This is a new server with about 90% of disk space NTFS still available

Any idea's thanks.

Error 112 means there is not enough space on disk. The system uses sparse file and alternate data stream for its dbcc operation. Look like your C:\ drive does not have enough disk space - you need at least the same amount as the original database.

|||

Hi Thanks for the reply.

The server is new with sbs2003 r2 with about 65Gb free space on C:\ so it can't be not enough free space. The database is not very big..

Any more idesa's

Thanks

Stephen

|||If your sql service is running under any service account then check necessary NTFS privilege for the folder you have mentioned above for that service account.|||

If the service account can't see/get to the disk (doesn't matter if it's empty or not), it will generate error.

Try setting the service account for sqlserver as LocalSystem and try creating the db again.

Event ID: 17053 - Operating system error 112(error not found) encountered

Hi there

I have recently installed a new server for a client running SBS2003 R2 with SQLServer 2005.

I noted that the backup failed the SQL Server database on the consistenty check. On checking the event log I see this message as per above.

It reads in the description

c:\data\law\sqldata\data41_Data.MDF:MSSQL_DBCC6:

Operating system error 112(error not found) encountered.

Looking in the error log I see :

Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.

Error: 17053, Severity: 16, State: 1.

C:\Data\LAW\sqldata\data41_Data.MDF:MSSQL_DBCC6: Operating system error 112(error not found) encountered.

DBCC CHECKDB (data41) WITH no_infomsgs executed by NT AUTHORITY\SYSTEM found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 26 seconds.

This is a new server with about 90% of disk space NTFS still available

Any idea's thanks.

Error 112 means there is not enough space on disk. The system uses sparse file and alternate data stream for its dbcc operation. Look like your C:\ drive does not have enough disk space - you need at least the same amount as the original database.

|||

Hi Thanks for the reply.

The server is new with sbs2003 r2 with about 65Gb free space on C:\ so it can't be not enough free space. The database is not very big..

Any more idesa's

Thanks

Stephen

|||If your sql service is running under any service account then check necessary NTFS privilege for the folder you have mentioned above for that service account.|||

If the service account can't see/get to the disk (doesn't matter if it's empty or not), it will generate error.

Try setting the service account for sqlserver as LocalSystem and try creating the db again.

event ID for windows (trusted) authentication and failed ones as well?

Hello there
I am wondering what I should look for, in the events logs (I have the
security audit enabled to log to event logs) for successful and not
successful connections using windows authentication ?
does anybody know ?If successful or not and if using Windows or SQL logins,
they all log to the application event log under the same
event id of 17055
-Sue
On Mon, 24 Apr 2006 12:44:27 -0600, "Simo Sentissi"
<msentissi@.rightnow.com> wrote:

>Hello there
>I am wondering what I should look for, in the events logs (I have the
>security audit enabled to log to event logs) for successful and not
>successful connections using windows authentication ?
>does anybody know ?
>

Event ID 17055 and 18456

We have in our test room, a SQL server who send every 2 seconds, the
same message. Login failed for user <user name>. - <user name>.
We use mixed mode authentification. The MSSQL server service has the
correct password and the SQL server agent too.
The user account isn't lock and we have others SQL server that use the
same account and the others servers don't send the error message.
I need help, I'm still troubleshooting but If you any ideas. Can you
help me.
Francois Thibault
Test Room Administrator
Try using the SQL Profiler and determine what process, computer etc. is
attempting to log on.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Francois Thibault" <francois.thibault@.snclavalin.com> wrote in message
news:9b5396d4.0408251130.2e9d15c8@.posting.google.c om...
> We have in our test room, a SQL server who send every 2 seconds, the
> same message. Login failed for user <user name>. - <user name>.
> We use mixed mode authentification. The MSSQL server service has the
> correct password and the SQL server agent too.
> The user account isn't lock and we have others SQL server that use the
> same account and the others servers don't send the error message.
> I need help, I'm still troubleshooting but If you any ideas. Can you
> help me.
> Francois Thibault
> Test Room Administrator

Event ID 17055 and 18456

We have in our test room, a SQL server who send every 2 seconds, the
same message. Login failed for user <user name>. - <user name>.
We use mixed mode authentification. The MSSQL server service has the
correct password and the SQL server agent too.
The user account isn't lock and we have others SQL server that use the
same account and the others servers don't send the error message.
I need help, I'm still troubleshooting but If you any ideas. Can you
help me.
Francois Thibault
Test Room AdministratorTry using the SQL Profiler and determine what process, computer etc. is
attempting to log on.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Francois Thibault" <francois.thibault@.snclavalin.com> wrote in message
news:9b5396d4.0408251130.2e9d15c8@.posting.google.com...
> We have in our test room, a SQL server who send every 2 seconds, the
> same message. Login failed for user <user name>. - <user name>.
> We use mixed mode authentification. The MSSQL server service has the
> correct password and the SQL server agent too.
> The user account isn't lock and we have others SQL server that use the
> same account and the others servers don't send the error message.
> I need help, I'm still troubleshooting but If you any ideas. Can you
> help me.
> Francois Thibault
> Test Room Administrator

Event ID 17055 and 18456

We have in our test room, a SQL server who send every 2 seconds, the
same message. Login failed for user <user name>. - <user name>.
We use mixed mode authentification. The MSSQL server service has the
correct password and the SQL server agent too.
The user account isn't lock and we have others SQL server that use the
same account and the others servers don't send the error message.
I need help, I'm still troubleshooting but If you any ideas. Can you
help me.
Francois Thibault
Test Room AdministratorTry using the SQL Profiler and determine what process, computer etc. is
attempting to log on.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Francois Thibault" <francois.thibault@.snclavalin.com> wrote in message
news:9b5396d4.0408251130.2e9d15c8@.posting.google.com...
> We have in our test room, a SQL server who send every 2 seconds, the
> same message. Login failed for user <user name>. - <user name>.
> We use mixed mode authentification. The MSSQL server service has the
> correct password and the SQL server agent too.
> The user account isn't lock and we have others SQL server that use the
> same account and the others servers don't send the error message.
> I need help, I'm still troubleshooting but If you any ideas. Can you
> help me.
> Francois Thibault
> Test Room Administrator

Event id 14151

Replication-Replication Snapshot Subsystem: agent ASPSQL1-Vicor-VicorToVicorMirror-9 failed. The replication agent had encountered an exception.

Source: Replication

Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException

Exception Message: TCP Provider: An existing connection was forcibly closed by the remote host.

Message

For more information, see Help and Support Center at

Please Help

Thanks

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx