MSSQL - (2) - 17055

In the Event Log I received next message:
Source: MSSQL
Category: (2)
ID: 17055
17204:
FCB: Open failed: Could not open device <DB path> for virtual device number
(VDN) 1.
I have a SQL Server 2000 (SP3a) on a Windows NT Server 4.0 (SP6a). Now
database working is OK.
What's the problem?
Michael S. Androsov
EXPOCENTRPerhaps some other process had the file open at that time? Anti-virus or similar?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in message
news:4EA285B5-9FA9-44B6-9523-1B34397EB4FC@.microsoft.com...
> In the Event Log I received next message:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 17204:
> FCB: Open failed: Could not open device <DB path> for virtual device number
> (VDN) 1.
> I have a SQL Server 2000 (SP3a) on a Windows NT Server 4.0 (SP6a). Now
> database working is OK.
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>

MSSQL - (2) - 17055

I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a) computer. And I received next message in the Event Log:
Source: MSSQL
Category: (2)
ID: 17055
18052: Error: 9001, Severity: 21, State: 4
What's the problem?
Michael S. Androsov
EXPOCENTRMisha
It might be a hardware issue, see these KB's for more information:
Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
http://support.microsoft.com/support/kb/articles/q259/2/37.asp
Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
http://support.microsoft.com/support/kb/articles/q154/6/90.asp
Q244780 Information About Event ID 51
http://support.microsoft.com/support/kb/articles/q244/7/80.asp
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>|||Michael,
Can be due to a number of reasons.Check 'Eventid.Net'
http://www.eventid.net/display.asp?eventid=17055&source=
Are all the databases in the server running fine?Is there any entry in the
SQLServer error log around the same timestamp?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>|||Sorry, but this articles is not for my problem.
Michael S. Androsov
EXPOCENTR
"Uri Dimant" wrote:
> Misha
> It might be a hardware issue, see these KB's for more information:
> Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
> http://support.microsoft.com/support/kb/articles/q259/2/37.asp
> Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
> http://support.microsoft.com/support/kb/articles/q154/6/90.asp
> Q244780 Information About Event ID 51
> http://support.microsoft.com/support/kb/articles/q244/7/80.asp
>
>
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> > I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
> computer. And I received next message in the Event Log:
> > Source: MSSQL
> > Category: (2)
> > ID: 17055
> > 18052: Error: 9001, Severity: 21, State: 4
> >
> > What's the problem?
> >
> > Michael S. Androsov
> > EXPOCENTR
> >
>
>|||I don't find a message about my problems in your URL. But all massages in this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this utility.
My databases is working normally on this seerver.
Michael S. Androsov
EXPOCENTR
"Dinesh T.K" wrote:
> Michael,
> Can be due to a number of reasons.Check 'Eventid.Net'
> http://www.eventid.net/display.asp?eventid=17055&source=
> Are all the databases in the server running fine?Is there any entry in the
> SQLServer error log around the same timestamp?
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> > I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
> computer. And I received next message in the Event Log:
> > Source: MSSQL
> > Category: (2)
> > ID: 17055
> > 18052: Error: 9001, Severity: 21, State: 4
> >
> > What's the problem?
> >
> > Michael S. Androsov
> > EXPOCENTR
> >
>
>|||Michael,
The messages in eventid.net is from people who faced that particular event
ID in diffrerent circumstances.If yours doesnt match, then okay, we need to
look elsewhere.
The reason why I asked if all databases are fine is because I checked the
Error: 9001 in BooksOnLine and it mentioned that the error may occur if the
log file is missing.Now, from your reply, Iam not sure if 9001 in this
context represents the one in BOL.
>>May be my problem with NTBACKUP?
Are the errors appearing even now? at regular intervals? If so, compare the
timing of the error with the backup.Also, since the source is sqlserver, you
can also check the sqlserver errorlog.May be, a detailed description is
present there.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:8E12C100-B02F-43C1-89AC-D3A03FBB6B3B@.microsoft.com...
> I don't find a message about my problems in your URL. But all massages in
this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this
utility.
> My databases is working normally on this seerver.
> Michael S. Androsov
> EXPOCENTR
> "Dinesh T.K" wrote:
> > Michael,
> >
> > Can be due to a number of reasons.Check 'Eventid.Net'
> > http://www.eventid.net/display.asp?eventid=17055&source=
> >
> > Are all the databases in the server running fine?Is there any entry in
the
> > SQLServer error log around the same timestamp?
> >
> > --
> > Dinesh
> > SQL Server MVP
> > --
> > --
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote
in
> > message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> > > I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
> > computer. And I received next message in the Event Log:
> > > Source: MSSQL
> > > Category: (2)
> > > ID: 17055
> > > 18052: Error: 9001, Severity: 21, State: 4
> > >
> > > What's the problem?
> > >
> > > Michael S. Androsov
> > > EXPOCENTR
> > >
> >
> >
> >

MSResultSetGenerator does not work any more

I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool":

Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9

I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database.

I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate.

Things I tried to repair this so far:
- VS2005 repair setup
- Reinstalled SQL Compact Edition
- Reinstalled ADO .NET Sync Services
- Reinstalled VS2005 SP1

I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works.

When I add tables to the database it does not.

This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next.

Did you make any progress? Please report

|||Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues.|||Thanks, but I'm already running VS as admin.|||Mathias - I now have the same configuration with you and I am experiencing the same issues. It appears the updates do not play well with the designer (at least under Vista).|||Thanks for testing this. Looks like I have to wait for the final VS Vista upgrade or use it in a VPC with XP.

MSResultSetGenerator does not work any more

I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool":

Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9

I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database.

I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate.

Things I tried to repair this so far:
- VS2005 repair setup
- Reinstalled SQL Compact Edition
- Reinstalled ADO .NET Sync Services
- Reinstalled VS2005 SP1

I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works.

When I add tables to the database it does not.

This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next.

Did you make any progress? Please report

|||Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues.|||Thanks, but I'm already running VS as admin.|||Mathias - I now have the same configuration with you and I am experiencing the same issues. It appears the updates do not play well with the designer (at least under Vista).|||Thanks for testing this. Looks like I have to wait for the final VS Vista upgrade or use it in a VPC with XP.

MSMQ did not make MQIS database in SQL 2000

I believe this is why I am having a error at boot from the Service =
Control Manager:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7022
Date: 12/14/2004
Time: 1:54:04 AM
User: N/A
Computer: HESTER
Description:
The Microsoft Search service hung on starting.=20
It hangs but has started when I get to the desktop. This started =
immediately after I installed the Windows 2000
Component MSMQ. I did not do it with Routing and I lessened =
permissions. This on the domain controller.=20
According to this article:
http://support.microsoft.com/default...b;en-us;193510
I should have an ODBC System DSN called MQIS pointing to a database in =
SQL that was made by the
installation of MSMQ called MQIS. Well I have the DSN but I don't have =
the database. It was not made. SQL 2000 SP3. How do I fix this? Is =
there some kind of sp which I can run in Query Manager that will in fact =
make this database the MSMQ is expecting?
Thanks.
--=20
George Hester
_________________________________
Well that's the end of the Op sys. It's been hosed. Thanks MSMQ.
--=20
George Hester
_________________________________
"George Hester" <hesterloli@.hotmail.com> wrote in message =
news:u#DZi2a4EHA.2452@.TK2MSFTNGP14.phx.gbl...
I believe this is why I am having a error at boot from the Service =
Control Manager:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7022
Date: 12/14/2004
Time: 1:54:04 AM
User: N/A
Computer: HESTER
Description:
The Microsoft Search service hung on starting.=20
It hangs but has started when I get to the desktop. This started =
immediately after I installed the Windows 2000
Component MSMQ. I did not do it with Routing and I lessened =
permissions. This on the domain controller.=20
According to this article:
http://support.microsoft.com/default...b;en-us;193510
I should have an ODBC System DSN called MQIS pointing to a database in =
SQL that was made by the
installation of MSMQ called MQIS. Well I have the DSN but I don't have =
the database. It was not made. SQL 2000 SP3. How do I fix this? Is =
there some kind of sp which I can run in Query Manager that will in fact =
make this database the MSMQ is expecting?
Thanks.
--=20
George Hester
_________________________________

MSMQ did not make MQIS database in SQL 2000

I believe this is why I am having a error at boot from the Service = Control Manager:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7022
Date: 12/14/2004
Time: 1:54:04 AM
User: N/A
Computer: HESTER
Description:
The Microsoft Search service hung on starting.
It hangs but has started when I get to the desktop. This started = immediately after I installed the Windows 2000
Component MSMQ. I did not do it with Routing and I lessened = permissions. This on the domain controller. According to this article:
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;193510
I should have an ODBC System DSN called MQIS pointing to a database in = SQL that was made by the
installation of MSMQ called MQIS. Well I have the DSN but I don't have = the database. It was not made. SQL 2000 SP3. How do I fix this? Is = there some kind of sp which I can run in Query Manager that will in fact = make this database the MSMQ is expecting?
Thanks.
-- George Hester
_________________________________Well that's the end of the Op sys. It's been hosed. Thanks MSMQ.
-- George Hester
_________________________________
"George Hester" <hesterloli@.hotmail.com> wrote in message =news:u#DZi2a4EHA.2452@.TK2MSFTNGP14.phx.gbl...
I believe this is why I am having a error at boot from the Service =Control Manager:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7022
Date: 12/14/2004
Time: 1:54:04 AM
User: N/A
Computer: HESTER
Description:
The Microsoft Search service hung on starting.
It hangs but has started when I get to the desktop. This started =immediately after I installed the Windows 2000
Component MSMQ. I did not do it with Routing and I lessened =permissions. This on the domain controller. According to this article:
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;193510
I should have an ODBC System DSN called MQIS pointing to a database in =SQL that was made by the
installation of MSMQ called MQIS. Well I have the DSN but I don't have =the database. It was not made. SQL 2000 SP3. How do I fix this? Is =there some kind of sp which I can run in Query Manager that will in fact =make this database the MSMQ is expecting?
Thanks.
-- George Hester
_________________________________sql

MSDTC?

I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-Jim
Check to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:

>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message DLL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native error
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim

MSDTC?

I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DL
L
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Serv
er]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-JimCheck to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:

>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message D
LL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native erro
r
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Ser
ver]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim

MSDTC?

I keep getting this error on my application server...what does it mean?

The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: Failed to enlist in DTC:
SQL state 37000, native error 8501, error message [Microsoft][ODBC SQL
Server Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..

any help would be appreciated...thanks

-Jim
On Oct 16, 2:09 pm, "Jimbo" <jim.fer...@.motorola.comwrote:

Quote:

Originally Posted by

I keep getting this error on my application server...what does it mean?
>
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: Failed to enlist in DTC:
SQL state 37000, native error 8501, error message [Microsoft][ODBC SQL
Server Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..
>
any help would be appreciated...thanks
>
-Jim

It seems you're trying to run global/XA transactions including the
SQLServer as one resource, and in order to do XA, MS SQLServer
needs it's MSDTC running. (MS Distributed Transaction Coordinator).
Joe Weinstein at BEA Systems