Hi everyone,
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
Showing posts with label cross-post. Show all posts
Showing posts with label cross-post. Show all posts
Thursday, March 22, 2012
Errors in Connecting to SQL Server Compact 3.4 ?
Hi everyone,
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
Sunday, March 11, 2012
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help
|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
.NET Runtime Optimization error on SQL Server 2005
I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.
I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
Thanks,
Kevin
I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,
try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Hi
I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.
Thanks
Steve
|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||Hello,
I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.
I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Any help would be greatly appreciated!!!
|||
We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile
We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.
|||The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.
I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:
Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library
Probably This sequence doesnt work for Sql Server 2005
|||Hihow do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.
Thanks for help|||
Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.
After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.
Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.
Hope I have answered your question
|||thanks. but i see that doesn′t work for SQL2k5? We have it :(regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||
Hi,
Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?
Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.
HTH someone else.
Regards
Nick
DBA - United Co-op Ltd
MCDBA
|||I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.
However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.
I have 32 Bit Machines.
I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.
Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?
I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).
Any new suggestions, workarounds, patches?
Subscribe to:
Posts (Atom)