Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts

Thursday, March 22, 2012

Couldn't connect server

Hi to all,
When I try to connect SQL 2000 Enterprise client with SQL
Server 2000 Enterprise Server , the following error
message displayed.
Unable to connect to server
Server:Msg 17,Level 16,State 1
Microsoft ODBC SQL Server Driver TCP/IP Sockets SQL
Server does not exist or access denied
How can i solve this problem?
Database Server configuration:
Windows Server 2003 with SQL Server 2000 Enterprise
Edition
Advance thankx
Sankar.First, verify you can make a network connection like a mapped drive to the
server.
Second, open Client Network Utility on your workstation, Server Network
Utility on the server (both programs are in the SQL Program group) and
verify you are both listening on the same protocols in the same order.
Lastly, you should verify MSSQLServer service is running on the server and
that there are no firewalls in between your computers which might be
blocking ports.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Sankar" <anonymous@.discussions.microsoft.com> wrote in message
news:04c801c3d8ea$36ab78e0$a301280a@.phx.gbl...
quote:

> Hi to all,
> When I try to connect SQL 2000 Enterprise client with SQL
> Server 2000 Enterprise Server , the following error
> message displayed.
>
> Unable to connect to server
> Server:Msg 17,Level 16,State 1
> Microsoft ODBC SQL Server Driver TCP/IP Sockets SQL
> Server does not exist or access denied
> How can i solve this problem?
> Database Server configuration:
> Windows Server 2003 with SQL Server 2000 Enterprise
> Edition
>
> Advance thankx
> Sankar.
|||Also, since you are attempting a TCP?IP connection verify that you can ping
the SQL Server machine by name. If not, try specifying the SQL Server
machine name ip address as the server name when attempting to connect. If
the first fails but the second succeeds then there is a name resplution
problem. If the second fails as well then there could be a network related
problem that is preventing the client from accessing the SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||> the SQL Server machine by name. If not, try specifying the SQL Server
quote:

> machine name ip address as the server name when attempting to connect. If
> the first fails but the second succeeds then there is a name resplution
> problem. If the second fails as well then there could be a network related
> problem that is preventing the client from accessing the SQL Server.

I have the same problem but I can ping the machine.
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
http://www.adoanywhere.com/forum
"Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
news:h0mDbBU2DHA.2184@.cpmsftngxa07.phx.gbl...
quote:

> Also, since you are attempting a TCP?IP connection verify that you can

ping
quote:

> the SQL Server machine by name. If not, try specifying the SQL Server
> machine name ip address as the server name when attempting to connect. If
> the first fails but the second succeeds then there is a name resplution
> problem. If the second fails as well then there could be a network related
> problem that is preventing the client from accessing the SQL Server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||Work through this article:
328306 INF: Potential Causes of the ("SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Tuesday, March 20, 2012

Could you please advice appropriate license for SQL Enterprise edition 2005

If CPU is Quad core it ‘s count to 4 or 1 license cpu. Could you please advice appropriate license for SQL Enterprise edition 2005 like server detail below. Actually i don't want to buy license per cpu. How many Cal for SQL enterprise 2005 license that bundle within first order SQL Svr Enterprise Edtn 2005 English .

Processor : QUAD Core 3.0GHZ X 2

Number of user : 4

Thank you for advance

The following link should have all the information you're after:

http://www.microsoft.com/sql/howtobuy/default.mspx

HTH!

Could not start the SQL Server Reporting Services

I am running SQL Server 2005 Enterprise and cannot get the Reporting
Service to start. When trying to start the Reporting Service from the
Control Pannel/Administrative Tools/Services I get the following error:
[ERROR]
Microsoft Management Console
Could not start the SQL Server Reporting Services (MSSQLSERVER) service
on Local Computer. The service did not return an error. This could be
an internal Windows error or an internal service error. If the problem
persists, contact your system administrator.
[/ERROR]
When I try to connect to the service from the Microsoft SQL Server
Management Studio, I get the following error (In an attempt to seperate
error msg, using <error> tags):
[ERROR]
TITLE: Connect to Server
--
Cannot connect to YAMHILL.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_A
uthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest
(Object
sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) <a
href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reportin
gServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationErro
r& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.1399
.00"
target="_blank">Get Online Help</a></li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
--
[/ERROR]
Thanks in advance...Any help is appreciated.
AntoineHi Antoine.
Were you able to get around this? I have having the same problem.
Thanks.
"jonathan_antoine@.excite.com" wrote:

> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get
_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension(
)
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateReque
st(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8p
t;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF330
0;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Report
ingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationEr
ror& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.13
99.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
>|||"jonathan_antoine@.excite.com" wrote:

> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get
_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension(
)
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateReque
st(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8p
t;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF330
0;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Report
ingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationEr
ror& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.13
99.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
I'm having a similar problem, I can't get the Reporting Service to run (SQL
2K5, Win2K Server). Trying to start the service with the configuration tool
throws a timeout error, trying to start the service through the Control Pane
l
throws essentially the same error you posted. I've checked the service
login, it's LocalSystem. Is there a config file where I can change the
timeout? I have had no luck on Google, these message boards, or MS SQL help
.
This is very frustrating! I never had any problems like this with MySQL.
OK, I know mysql doesn't have a reporting module, but installation was much
quicker and smoother, there's one file with all configuration parameters,
it's well-documented, and oh yeah faster, lower-impact, and free.
Any advice is appreciated! I don't know what to try.sql

Could not start the SQL Server Reporting Services

I am running SQL Server 2005 Enterprise and cannot get the Reporting
Service to start. When trying to start the Reporting Service from the
Control Pannel/Administrative Tools/Services I get the following error:
[ERROR]
Microsoft Management Console
Could not start the SQL Server Reporting Services (MSSQLSERVER) service
on Local Computer. The service did not return an error. This could be
an internal Windows error or an internal service error. If the problem
persists, contact your system administrator.
[/ERROR]
When I try to connect to the service from the Microsoft SQL Server
Management Studio, I get the following error (In an attempt to seperate
error msg, using <error> tags):
[ERROR]
TITLE: Connect to Server
--
Cannot connect to YAMHILL.
--
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) <a
href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
target="_blank">Get Online Help</a></li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
--
BUTTONS:
OK
--
[/ERROR]
Thanks in advance...Any help is appreciated.
AntoineHi Antoine.
Were you able to get around this? I have having the same problem.
Thanks.
"jonathan_antoine@.excite.com" wrote:
> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
>|||"jonathan_antoine@.excite.com" wrote:
> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
I'm having a similar problem, I can't get the Reporting Service to run (SQL
2K5, Win2K Server). Trying to start the service with the configuration tool
throws a timeout error, trying to start the service through the Control Panel
throws essentially the same error you posted. I've checked the service
login, it's LocalSystem. Is there a config file where I can change the
timeout? I have had no luck on Google, these message boards, or MS SQL help.
This is very frustrating! I never had any problems like this with MySQL.
OK, I know MySQL doesn't have a reporting module, but installation was much
quicker and smoother, there's one file with all configuration parameters,
it's well-documented, and oh yeah faster, lower-impact, and free.
Any advice is appreciated! I don't know what to try.

Sunday, March 11, 2012

Could not get into server instance

Hi,
I ran Enterprise manager, but I could not get into my
server. It said that it was not running or to check '
the config, which is fine and is Windows Only Authentication.
Here is the weird and scary part. ZoneAlarm had an alert
at the same time. The alert was asking for Management Console
to use USERINIT.EXE to access 192.5.6.30DNS.
This resolves to a.gtld-servers.net which is part of Verisign.
I refused this outbound access and kept retrying to get into
my server in Enterprise. No luck. I then decided to go ahead
and give outbound access. Next time I tried to get into
my server I was able to.
Does anyone know what's up?
I figured that maybe I should change all my logins?
But, does this show that there is a breach of my system?
There has been another odd thing where WSCRIPT.EXE has
been asking for access to DNS servers. That I keep blocked.
I am pretty sure that is a trojan, but do you think this is this related ?
Thanks for any advice.
FoxAs a very first step -- scan your computer for virus or Trojans, I think you
may have a serious exploit on your hands.
Steve
"Fox" <fox @. connexions .net> wrote in message
news:e9HspB2wDHA.2408@.tk2msftngp13.phx.gbl...
quote:

> Hi,
> I ran Enterprise manager, but I could not get into my
> server. It said that it was not running or to check '
> the config, which is fine and is Windows Only Authentication.
> Here is the weird and scary part. ZoneAlarm had an alert
> at the same time. The alert was asking for Management Console
> to use USERINIT.EXE to access 192.5.6.30DNS.
> This resolves to a.gtld-servers.net which is part of Verisign.
> I refused this outbound access and kept retrying to get into
> my server in Enterprise. No luck. I then decided to go ahead
> and give outbound access. Next time I tried to get into
> my server I was able to.
> Does anyone know what's up?
> I figured that maybe I should change all my logins?
> But, does this show that there is a breach of my system?
> There has been another odd thing where WSCRIPT.EXE has
> been asking for access to DNS servers. That I keep blocked.
> I am pretty sure that is a trojan, but do you think this is this related ?
> Thanks for any advice.
> Fox
>
|||I have already scanned several times and have come up with nothing.
I changed all logins related to admin.
A few weeks ago I found entries in my firewall to allow 3 IPs
access. I saw them in there once before and deleted them.
This time I block them entirely from access. It seems I've been
playing a cat and mouse game for a while. But I cannot find
the source and a re-install is out of the question. There were
a few other things that happend earlier this year. I don't
know what to do next to try to find the source of this.
Regards,
Fox
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:eZcXtC$wDHA.3116@.TK2MSFTNGP11.phx.gbl...
quote:

> As a very first step -- scan your computer for virus or Trojans, I think

you
quote:

> may have a serious exploit on your hands.
> Steve
>
> "Fox" <fox @. connexions .net> wrote in message
> news:e9HspB2wDHA.2408@.tk2msftngp13.phx.gbl...
?[QUOTE]
>
|||What are you using as a firewall?
Is this a "live" SQL Server on the internet?
What type of applications are connecting to this Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Wednesday, March 7, 2012

Could not find stored procedure

User creates a sp and the same is visible in the
enterprise manager. The user has rights to execute also.
However the isql gives the above mentioned error even for
sa!!!
No clue please help.Hi Sandip,
Make sure that you are in the right database when trying to execute the
stored procedure. Unless you specify a database with isql, it will use the
default database for that user, which is usually master.
--
Jacco Schalkwijk
SQL Server MVP
"Sandip" <bsandipk@.hotmail.com> wrote in message
news:072701c40022$9dd31140$3501280a@.phx.gbl...
> User creates a sp and the same is visible in the
> enterprise manager. The user has rights to execute also.
> However the isql gives the above mentioned error even for
> sa!!!
> No clue please help.|||Hi!
The user that creates the procedure is owner of te procedure, if it was not
created with a specific owner (i.e. CREATE PROCEDURE owner.name). The sa
loin is mapped to a specific db user dbo, so SQL Server searches dbo.name
procedure. Eithercreate all n+bjects wit dbo as owner, or use two-part name
when using it.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Sandip" <bsandipk@.hotmail.com> wrote in message
news:072701c40022$9dd31140$3501280a@.phx.gbl...
> User creates a sp and the same is visible in the
> enterprise manager. The user has rights to execute also.
> However the isql gives the above mentioned error even for
> sa!!!
> No clue please help.|||Hi ,
To add on to Dejan Sarka post , Simply execute the below query in Query
analyzer
select user_name(uid) as Creator,name from sysobjects where name ='procedure_name'
Replace the procedure_name with actual name.
Incase the the creator name is not DBO then use sp_changeobjectowner (refer
books online) to change the object owner.
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:ugW0lfCAEHA.2660@.TK2MSFTNGP10.phx.gbl...
> Hi!
> The user that creates the procedure is owner of te procedure, if it was
not
> created with a specific owner (i.e. CREATE PROCEDURE owner.name). The sa
> loin is mapped to a specific db user dbo, so SQL Server searches dbo.name
> procedure. Eithercreate all n+bjects wit dbo as owner, or use two-part
name
> when using it.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Sandip" <bsandipk@.hotmail.com> wrote in message
> news:072701c40022$9dd31140$3501280a@.phx.gbl...
> > User creates a sp and the same is visible in the
> > enterprise manager. The user has rights to execute also.
> >
> > However the isql gives the above mentioned error even for
> > sa!!!
> >
> > No clue please help.
>

Saturday, February 25, 2012

could not disable publishing and distribution

hello All,

i am trying to delete publications in SQL 2000, SP4 and getting this
error:

SQL Server Enterprise Manager could not disable publishing and distribution on '<publishername>'.

Error 3724 : cannot drop the procedure
'dbo.sp_sel_F854ED4CD7EA4399EFDB9697F4E24A10_pal' because itis being used for replication.

Thanks and Regards

Kanna


Run sp_removedbreplication in the published database.

Sunday, February 19, 2012

Could not allocate space for object 'MSrepl_commands' in database

We have transaction replication set up in SQL 2K environment . It's simple
SQL 2k publisher to SQL 2K subscriber (both Enterprise). It works fine but
some times(once a week or so) we get error message "Could not allocate space
for object 'MSrepl_commands' in database 'zzzz_distribution' " and log reader
agent gets stopped. I don't see any issues with space and both data and log
files are set for auto grow. When I go back and see DB size is very minimal.
Can you throw some ideas.
Thanks,
Prabhu
This looks like a problem with the distribution database being unable to
grow, can you confirm that the distribution database has space to grow, and
the growth increment is not a percent but a fixed amount like 100 Mgs.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:7BD73EC1-0AF2-494B-AD3C-6AE6F3D2D605@.microsoft.com...
> We have transaction replication set up in SQL 2K environment . It's simple
> SQL 2k publisher to SQL 2K subscriber (both Enterprise). It works fine but
> some times(once a week or so) we get error message "Could not allocate
> space
> for object 'MSrepl_commands' in database 'zzzz_distribution' " and log
> reader
> agent gets stopped. I don't see any issues with space and both data and
> log
> files are set for auto grow. When I go back and see DB size is very
> minimal.
> Can you throw some ideas.
> Thanks,
> Prabhu

Friday, February 17, 2012

cost of upgrade from Standard to Enterprise

Looking to upgrade our Standard SQL 2000 to Enterprise SQL 2000 to take
advantage of the active/passive failover modes and possible data cubes. Any
way to obtain an upgrade license without buying the full $17,000 Enterprise
edition?
I do not have Software assurance. Have Standard licensed for 2 CPUs at a
cost of roughly $8,000
Thanks,
Keith
Kretek International
Hi Keith
It is probably best to talk to your software/systems provider(s) about your
requirements. Also read the licencing information at
http://www.microsoft.com/sql/howtobuy e.g.
http://www.microsoft.com/sql/howtobuy/activepassive.asp
John
"Keith" <Keith@.discussions.microsoft.com> wrote in message
news:B6D310FE-E4CC-4E2D-B563-A0D37E2DCA4C@.microsoft.com...
> Looking to upgrade our Standard SQL 2000 to Enterprise SQL 2000 to take
> advantage of the active/passive failover modes and possible data cubes.
> Any
> way to obtain an upgrade license without buying the full $17,000
> Enterprise
> edition?
> I do not have Software assurance. Have Standard licensed for 2 CPUs at a
> cost of roughly $8,000
> Thanks,
> Keith
> Kretek International

cost of upgrade from Standard to Enterprise

Looking to upgrade our Standard SQL 2000 to Enterprise SQL 2000 to take
advantage of the active/passive failover modes and possible data cubes. Any
way to obtain an upgrade license without buying the full $17,000 Enterprise
edition?
I do not have Software assurance. Have Standard licensed for 2 CPUs at a
cost of roughly $8,000
Thanks,
Keith
Kretek InternationalHi Keith
It is probably best to talk to your software/systems provider(s) about your
requirements. Also read the licencing information at
http://www.microsoft.com/sql/howtobuy e.g.
http://www.microsoft.com/sql/howtobuy/activepassive.asp
John
"Keith" <Keith@.discussions.microsoft.com> wrote in message
news:B6D310FE-E4CC-4E2D-B563-A0D37E2DCA4C@.microsoft.com...
> Looking to upgrade our Standard SQL 2000 to Enterprise SQL 2000 to take
> advantage of the active/passive failover modes and possible data cubes.
> Any
> way to obtain an upgrade license without buying the full $17,000
> Enterprise
> edition?
> I do not have Software assurance. Have Standard licensed for 2 CPUs at a
> cost of roughly $8,000
> Thanks,
> Keith
> Kretek International

cost of upgrade from Standard to Enterprise

Looking to upgrade our Standard SQL 2000 to Enterprise SQL 2000 to take
advantage of the active/passive failover modes and possible data cubes. Any
way to obtain an upgrade license without buying the full $17,000 Enterprise
edition?
I do not have Software assurance. Have Standard licensed for 2 CPUs at a
cost of roughly $8,000
Thanks,
Keith
Kretek InternationalHi Keith
It is probably best to talk to your software/systems provider(s) about your
requirements. Also read the licencing information at
http://www.microsoft.com/sql/howtobuy e.g.
http://www.microsoft.com/sql/howtobuy/activepassive.asp
John
"Keith" <Keith@.discussions.microsoft.com> wrote in message
news:B6D310FE-E4CC-4E2D-B563-A0D37E2DCA4C@.microsoft.com...
> Looking to upgrade our Standard SQL 2000 to Enterprise SQL 2000 to take
> advantage of the active/passive failover modes and possible data cubes.
> Any
> way to obtain an upgrade license without buying the full $17,000
> Enterprise
> edition?
> I do not have Software assurance. Have Standard licensed for 2 CPUs at a
> cost of roughly $8,000
> Thanks,
> Keith
> Kretek International

Tuesday, February 14, 2012

Corrupted table?

We have a SQL Server 2000 database with a table we cannot delete. We first
try from Enterprise Manager, and then tried through VB code, and a stored
procedure, but nothing is able to delete the table. Is there anything else
to try?
Thank you.DROP TABLE <table name>.
But what is the error you get?
--
Jacco Schalkwijk
SQL Server MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>|||Have you tried running DBCC CHECKTABLE?
--
Andrew J. Kelly SQL MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>|||Hi,
First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try with
REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
Take a backup of Database prior to execute DBCC with Repair options.
Thanks
Hari
SQL Server MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>|||Actually, there is no error. Enterprise Manager just freezes, and we have to
stop the task. Query Analyzer, doing the DROP TABLE reacts the same way. We
give it several minutes to come back. It shouldnt' take more than 10 minutes
to drop a table.Maybe we can let it run ...'
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:eYQLnegQFHA.2132@.TK2MSFTNGP09.phx.gbl...
> DROP TABLE <table name>.
> But what is the error you get?
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> > We have a SQL Server 2000 database with a table we cannot delete. We
first
> > try from Enterprise Manager, and then tried through VB code, and a
stored
> > procedure, but nothing is able to delete the table. Is there anything
else
> > to try?
> >
> > Thank you.
> >
> >
>|||That is not what MS recommends. You should not repair without first
determining root cause of the errors and then you should use a backup as the
best way to recover from the error (unless the only repair needed is to
rebuild indexes). Primairly though, you need to work out why the error
happened in the first place.
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try with
> REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
> Take a backup of Database prior to execute DBCC with Repair options.
> Thanks
> Hari
> SQL Server MVP
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> > We have a SQL Server 2000 database with a table we cannot delete. We
first
> > try from Enterprise Manager, and then tried through VB code, and a
stored
> > procedure, but nothing is able to delete the table. Is there anything
else
> > to try?
> >
> > Thank you.
> >
> >
>|||There is no error, we just can't drop the table. We've tried to delete the
table inside Enterprise Manager, from a VB program, and from Query Analyzer.
Each time when the command executes to drop the table, the program freezes,
and we have to stop the task. Maybe we should wait longer (10 minutes) to
see if an error eventually occurs, but after about 10 mins. there is no
error and the program stops responding to the request to drop the table.
I ran DBCC checkTable and there are no reported errors.
ANy ideas? Thanks!
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:uTAONbERFHA.1392@.TK2MSFTNGP10.phx.gbl...
> That is not what MS recommends. You should not repair without first
> determining root cause of the errors and then you should use a backup as
the
> best way to recover from the error (unless the only repair needed is to
> rebuild indexes). Primairly though, you need to work out why the error
> happened in the first place.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try
with
> > REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
> >
> > Take a backup of Database prior to execute DBCC with Repair options.
> >
> > Thanks
> > Hari
> > SQL Server MVP
> >
> > "Dean J Garrett" <info@.amuletc.com> wrote in message
> > news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> > > We have a SQL Server 2000 database with a table we cannot delete. We
> first
> > > try from Enterprise Manager, and then tried through VB code, and a
> stored
> > > procedure, but nothing is able to delete the table. Is there anything
> else
> > > to try?
> > >
> > > Thank you.
> > >
> > >
> >
> >
>|||Blocking? Did you check using sp_who, sp_who2 etc?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:epK3ZkFRFHA.1236@.TK2MSFTNGP14.phx.gbl...
> There is no error, we just can't drop the table. We've tried to delete the
> table inside Enterprise Manager, from a VB program, and from Query Analyzer.
> Each time when the command executes to drop the table, the program freezes,
> and we have to stop the task. Maybe we should wait longer (10 minutes) to
> see if an error eventually occurs, but after about 10 mins. there is no
> error and the program stops responding to the request to drop the table.
> I ran DBCC checkTable and there are no reported errors.
> ANy ideas? Thanks!
>
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:uTAONbERFHA.1392@.TK2MSFTNGP10.phx.gbl...
>> That is not what MS recommends. You should not repair without first
>> determining root cause of the errors and then you should use a backup as
> the
>> best way to recover from the error (unless the only repair needed is to
>> rebuild indexes). Primairly though, you need to work out why the error
>> happened in the first place.
>> Regards
>> --
>> Paul Randal
>> Dev Lead, Microsoft SQL Server Storage Engine
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>> news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...
>> > Hi,
>> >
>> > First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try
> with
>> > REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
>> >
>> > Take a backup of Database prior to execute DBCC with Repair options.
>> >
>> > Thanks
>> > Hari
>> > SQL Server MVP
>> >
>> > "Dean J Garrett" <info@.amuletc.com> wrote in message
>> > news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
>> > > We have a SQL Server 2000 database with a table we cannot delete. We
>> first
>> > > try from Enterprise Manager, and then tried through VB code, and a
>> stored
>> > > procedure, but nothing is able to delete the table. Is there anything
>> else
>> > > to try?
>> > >
>> > > Thank you.
>> > >
>> > >
>> >
>> >
>>
>

Corrupted table?

We have a SQL Server 2000 database with a table we cannot delete. We first
try from Enterprise Manager, and then tried through VB code, and a stored
procedure, but nothing is able to delete the table. Is there anything else
to try?
Thank you.
DROP TABLE <table name>.
But what is the error you get?
Jacco Schalkwijk
SQL Server MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>
|||Have you tried running DBCC CHECKTABLE?
Andrew J. Kelly SQL MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>
|||Hi,
First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try with
REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
Take a backup of Database prior to execute DBCC with Repair options.
Thanks
Hari
SQL Server MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>
|||Actually, there is no error. Enterprise Manager just freezes, and we have to
stop the task. Query Analyzer, doing the DROP TABLE reacts the same way. We
give it several minutes to come back. It shouldnt' take more than 10 minutes
to drop a table.Maybe we can let it run ...?
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:eYQLnegQFHA.2132@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> DROP TABLE <table name>.
> But what is the error you get?
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
first[vbcol=seagreen]
stored[vbcol=seagreen]
else
>
|||That is not what MS recommends. You should not repair without first
determining root cause of the errors and then you should use a backup as the
best way to recover from the error (unless the only repair needed is to
rebuild indexes). Primairly though, you need to work out why the error
happened in the first place.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try with
> REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
> Take a backup of Database prior to execute DBCC with Repair options.
> Thanks
> Hari
> SQL Server MVP
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
first[vbcol=seagreen]
stored[vbcol=seagreen]
else
>
|||There is no error, we just can't drop the table. We've tried to delete the
table inside Enterprise Manager, from a VB program, and from Query Analyzer.
Each time when the command executes to drop the table, the program freezes,
and we have to stop the task. Maybe we should wait longer (10 minutes) to
see if an error eventually occurs, but after about 10 mins. there is no
error and the program stops responding to the request to drop the table.
I ran DBCC checkTable and there are no reported errors.
ANy ideas? Thanks!
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:uTAONbERFHA.1392@.TK2MSFTNGP10.phx.gbl...
> That is not what MS recommends. You should not repair without first
> determining root cause of the errors and then you should use a backup as
the
> best way to recover from the error (unless the only repair needed is to
> rebuild indexes). Primairly though, you need to work out why the error
> happened in the first place.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...
with
> first
> stored
> else
>
|||Blocking? Did you check using sp_who, sp_who2 etc?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:epK3ZkFRFHA.1236@.TK2MSFTNGP14.phx.gbl...
> There is no error, we just can't drop the table. We've tried to delete the
> table inside Enterprise Manager, from a VB program, and from Query Analyzer.
> Each time when the command executes to drop the table, the program freezes,
> and we have to stop the task. Maybe we should wait longer (10 minutes) to
> see if an error eventually occurs, but after about 10 mins. there is no
> error and the program stops responding to the request to drop the table.
> I ran DBCC checkTable and there are no reported errors.
> ANy ideas? Thanks!
>
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:uTAONbERFHA.1392@.TK2MSFTNGP10.phx.gbl...
> the
> rights.
> with
>

Corrupted table?

We have a SQL Server 2000 database with a table we cannot delete. We first
try from Enterprise Manager, and then tried through VB code, and a stored
procedure, but nothing is able to delete the table. Is there anything else
to try?
Thank you.DROP TABLE <table name>.
But what is the error you get?
Jacco Schalkwijk
SQL Server MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>|||Have you tried running DBCC CHECKTABLE?
Andrew J. Kelly SQL MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>|||Hi,
First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try with
REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
Take a backup of Database prior to execute DBCC with Repair options.
Thanks
Hari
SQL Server MVP
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
> We have a SQL Server 2000 database with a table we cannot delete. We first
> try from Enterprise Manager, and then tried through VB code, and a stored
> procedure, but nothing is able to delete the table. Is there anything else
> to try?
> Thank you.
>|||Actually, there is no error. Enterprise Manager just freezes, and we have to
stop the task. Query Analyzer, doing the DROP TABLE reacts the same way. We
give it several minutes to come back. It shouldnt' take more than 10 minutes
to drop a table.Maybe we can let it run ...'
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:eYQLnegQFHA.2132@.TK2MSFTNGP09.phx.gbl...
> DROP TABLE <table name>.
> But what is the error you get?
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
first[vbcol=seagreen]
stored[vbcol=seagreen]
else[vbcol=seagreen]
>|||That is not what MS recommends. You should not repair without first
determining root cause of the errors and then you should use a backup as the
best way to recover from the error (unless the only repair needed is to
rebuild indexes). Primairly though, you need to work out why the error
happened in the first place.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> First Execute DBCC CHECKTABLE(TABLENAME), If it gives error then try with
> REPAIR OPTIONS. See DBCC CHECKTABLE command in books online.
> Take a backup of Database prior to execute DBCC with Repair options.
> Thanks
> Hari
> SQL Server MVP
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:%23kZjFGgQFHA.1236@.TK2MSFTNGP14.phx.gbl...
first[vbcol=seagreen]
stored[vbcol=seagreen]
else[vbcol=seagreen]
>|||There is no error, we just can't drop the table. We've tried to delete the
table inside Enterprise Manager, from a VB program, and from Query Analyzer.
Each time when the command executes to drop the table, the program freezes,
and we have to stop the task. Maybe we should wait longer (10 minutes) to
see if an error eventually occurs, but after about 10 mins. there is no
error and the program stops responding to the request to drop the table.
I ran DBCC checkTable and there are no reported errors.
ANy ideas? Thanks!
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:uTAONbERFHA.1392@.TK2MSFTNGP10.phx.gbl...
> That is not what MS recommends. You should not repair without first
> determining root cause of the errors and then you should use a backup as
the
> best way to recover from the error (unless the only repair needed is to
> rebuild indexes). Primairly though, you need to work out why the error
> happened in the first place.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:#rmRpFkQFHA.2876@.TK2MSFTNGP09.phx.gbl...
with[vbcol=seagreen]
> first
> stored
> else
>|||Blocking? Did you check using sp_who, sp_who2 etc?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:epK3ZkFRFHA.1236@.TK2MSFTNGP14.phx.
gbl...
> There is no error, we just can't drop the table. We've tried to delete the
> table inside Enterprise Manager, from a VB program, and from Query Analyze
r.
> Each time when the command executes to drop the table, the program freezes
,
> and we have to stop the task. Maybe we should wait longer (10 minutes) to
> see if an error eventually occurs, but after about 10 mins. there is no
> error and the program stops responding to the request to drop the table.
> I ran DBCC checkTable and there are no reported errors.
> ANy ideas? Thanks!
>
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:uTAONbERFHA.1392@.TK2MSFTNGP10.phx.gbl...
> the
> rights.
> with
>

Corrupted Table removal problem

I have a table that I can no longer make design changes too, remove
altogether, or view all rows for. Enterprise manager just hangs. I can do
a view top 1 record, but not view all. I'm testing some stored procedures
to fill ntext fields using writetext and seem to be corrupting it somehow.
All other tables and database work fine ... problems occur here only.
Ideas on how to fix or move forward with this.
Thanks,
Andrew
Your best bet is usually to restore from a previous good backup. If this is
a table in which the data is not critical or can be rebuilt you might want
to take a look at DBCC CHECKTABLE in BooksOnLine.
Andrew J. Kelly SQL MVP
"Andrew Jones" <ajones@.kvmhc.org> wrote in message
news:10fdjev1ikfg8ac@.corp.supernews.com...
> I have a table that I can no longer make design changes too, remove
> altogether, or view all rows for. Enterprise manager just hangs. I can
do
> a view top 1 record, but not view all. I'm testing some stored procedures
> to fill ntext fields using writetext and seem to be corrupting it somehow.
> All other tables and database work fine ... problems occur here only.
> Ideas on how to fix or move forward with this.
> Thanks,
> Andrew
>

Corrupted table

When I try and examine a table in one of my MS SQL Server 2000 databases I
get the following error from Enterprise Manager:
[Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset
0X00000000038000 in file ...MDF
How do I go about fixing this?
Thanks,
Hi
In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
corruption is. Check all the DBs on the server.
Start looking for you most recent backup.
If the corruption is not too bad, you might be able to run DBCC CECKDB
REPAIR_REBUILD
else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you may
loose data).
Generally, corruption is caused by hardware faults.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> When I try and examine a table in one of my MS SQL Server 2000 databases I
> get the following error from Enterprise Manager:
> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset
> 0X00000000038000 in file ...MDF
> How do I go about fixing this?
> Thanks,
>
>
|||"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl:

> I/O error (bad page ID) detected during read at offset
Run...
DBCC CHECKDB
Regards
JTC ^..^
|||Also look at http://www.karaszi.com/SQLServer/inf...suspect_db.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi
> In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
> corruption is. Check all the DBs on the server.
> Start looking for you most recent backup.
> If the corruption is not too bad, you might be able to run DBCC CECKDB
> REPAIR_REBUILD
> else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you
> may loose data).
> Generally, corruption is caused by hardware faults.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>
|||Thanks Mike. I was able to Export the table SQL definition, delete the table
and then recreate it from the script.
- Andrew
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Also look at http://www.karaszi.com/SQLServer/inf...suspect_db.asp
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
databases
>
|||Hi Andrew,
Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
ensure that database is in good shape.
Note:
As part of your routine maintenance please schedule a DBCC CHECKDB for all
production databases. This will help you to identify issues earlier.
Thanks
Hari
SQL Server MVP
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
> Thanks Mike. I was able to Export the table SQL definition, delete the
> table
> and then recreate it from the script.
> - Andrew
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
> databases
>
|||Andrew,
A key here that Mike mentioned is "Generally, corruption is caused by
hardware faults".
now that you solved the immediate issue of data\table corruption. The next
step is to figure out "WHY".
If you dont do this, your data is likely going to become corrupt again very
soon.
I suspect a disk is going haywire on you or your RAID Controller is kicking
the bucket.
I just went through this with two different customers. One turned out to be
disk, hte other turned out to be RAID Controller.
cheers
Greg Jackson
PDX, Oregon
|||I'll do that.
- Andrew
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:efyvtDTWFHA.3280@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi Andrew,
> Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
> ensure that database is in good shape.
> Note:
> As part of your routine maintenance please schedule a DBCC CHECKDB for all
> production databases. This will help you to identify issues earlier.
> Thanks
> Hari
> SQL Server MVP
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
http://www.karaszi.com/SQLServer/inf...suspect_db.asp[vbcol=seagreen]
CECKDB
>
|||This is on a development machine rather than a production server so I
suspect it may have been roughly rebooted periodically. There hasn't been
any other evidence of disk problems so i am just backing up frequently for
now.
Thanks,
Andrew
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:OPRePnVWFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Andrew,
> A key here that Mike mentioned is "Generally, corruption is caused by
> hardware faults".
> now that you solved the immediate issue of data\table corruption. The next
> step is to figure out "WHY".
> If you dont do this, your data is likely going to become corrupt again
very
> soon.
> I suspect a disk is going haywire on you or your RAID Controller is
kicking
> the bucket.
> I just went through this with two different customers. One turned out to
be
> disk, hte other turned out to be RAID Controller.
>
> cheers
>
> Greg Jackson
> PDX, Oregon
>

Corrupted table

When I try and examine a table in one of my MS SQL Server 2000 databases I
get the following error from Enterprise Manager:
[Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset
0X00000000038000 in file ...MDF
How do I go about fixing this?
Thanks,
Hi
In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
corruption is. Check all the DBs on the server.
Start looking for you most recent backup.
If the corruption is not too bad, you might be able to run DBCC CECKDB
REPAIR_REBUILD
else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you may
loose data).
Generally, corruption is caused by hardware faults.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> When I try and examine a table in one of my MS SQL Server 2000 databases I
> get the following error from Enterprise Manager:
> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset
> 0X00000000038000 in file ...MDF
> How do I go about fixing this?
> Thanks,
>
>
|||"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl:

> I/O error (bad page ID) detected during read at offset
Run...
DBCC CHECKDB
Regards
JTC ^..^
|||Also look at http://www.karaszi.com/SQLServer/inf...suspect_db.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi
> In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
> corruption is. Check all the DBs on the server.
> Start looking for you most recent backup.
> If the corruption is not too bad, you might be able to run DBCC CECKDB
> REPAIR_REBUILD
> else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you
> may loose data).
> Generally, corruption is caused by hardware faults.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>
|||Thanks Mike. I was able to Export the table SQL definition, delete the table
and then recreate it from the script.
- Andrew
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Also look at http://www.karaszi.com/SQLServer/inf...suspect_db.asp
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
databases
>
|||Hi Andrew,
Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
ensure that database is in good shape.
Note:
As part of your routine maintenance please schedule a DBCC CHECKDB for all
production databases. This will help you to identify issues earlier.
Thanks
Hari
SQL Server MVP
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
> Thanks Mike. I was able to Export the table SQL definition, delete the
> table
> and then recreate it from the script.
> - Andrew
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
> databases
>
|||Andrew,
A key here that Mike mentioned is "Generally, corruption is caused by
hardware faults".
now that you solved the immediate issue of data\table corruption. The next
step is to figure out "WHY".
If you dont do this, your data is likely going to become corrupt again very
soon.
I suspect a disk is going haywire on you or your RAID Controller is kicking
the bucket.
I just went through this with two different customers. One turned out to be
disk, hte other turned out to be RAID Controller.
cheers
Greg Jackson
PDX, Oregon
|||I'll do that.
- Andrew
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:efyvtDTWFHA.3280@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi Andrew,
> Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
> ensure that database is in good shape.
> Note:
> As part of your routine maintenance please schedule a DBCC CHECKDB for all
> production databases. This will help you to identify issues earlier.
> Thanks
> Hari
> SQL Server MVP
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
http://www.karaszi.com/SQLServer/inf...suspect_db.asp[vbcol=seagreen]
CECKDB
>
|||This is on a development machine rather than a production server so I
suspect it may have been roughly rebooted periodically. There hasn't been
any other evidence of disk problems so i am just backing up frequently for
now.
Thanks,
Andrew
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:OPRePnVWFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Andrew,
> A key here that Mike mentioned is "Generally, corruption is caused by
> hardware faults".
> now that you solved the immediate issue of data\table corruption. The next
> step is to figure out "WHY".
> If you dont do this, your data is likely going to become corrupt again
very
> soon.
> I suspect a disk is going haywire on you or your RAID Controller is
kicking
> the bucket.
> I just went through this with two different customers. One turned out to
be
> disk, hte other turned out to be RAID Controller.
>
> cheers
>
> Greg Jackson
> PDX, Oregon
>

Corrupted table

When I try and examine a table in one of my MS SQL Server 2000 databases I
get the following error from Enterprise Manager:
[Microsoft][ODBC..] I/O error (bad page ID) detected during read at
offset
0X00000000038000 in file ...MDF
How do I go about fixing this?
Thanks,Hi
In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
corruption is. Check all the DBs on the server.
Start looking for you most recent backup.
If the corruption is not too bad, you might be able to run DBCC CECKDB
REPAIR_REBUILD
else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you may
loose data).
Generally, corruption is caused by hardware faults.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> When I try and examine a table in one of my MS SQL Server 2000 databases I
> get the following error from Enterprise Manager:
> [Microsoft][ODBC..] I/O error (bad page ID) detected during read a
t offset
> 0X00000000038000 in file ...MDF
> How do I go about fixing this?
> Thanks,
>
>|||"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl:

> I/O error (bad page ID) detected during read at offset
Run...
DBCC CHECKDB
Regards
JTC ^..^|||Also look at http://www.karaszi.com/SQLServer/in..._suspect_db.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi
> In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
> corruption is. Check all the DBs on the server.
> Start looking for you most recent backup.
> If the corruption is not too bad, you might be able to run DBCC CECKDB
> REPAIR_REBUILD
> else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you
> may loose data).
> Generally, corruption is caused by hardware faults.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>|||Thanks Mike. I was able to Export the table SQL definition, delete the table
and then recreate it from the script.
- Andrew
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
> Also look at http://www.karaszi.com/SQLServer/in..._suspect_db.asp
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
databases[vbcol=seagreen]
>|||Hi Andrew,
Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
ensure that database is in good shape.
Note:
As part of your routine maintenance please schedule a DBCC CHECKDB for all
production databases. This will help you to identify issues earlier.
Thanks
Hari
SQL Server MVP
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
> Thanks Mike. I was able to Export the table SQL definition, delete the
> table
> and then recreate it from the script.
> - Andrew
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
> databases
>|||Andrew,
A key here that Mike mentioned is "Generally, corruption is caused by
hardware faults".
now that you solved the immediate issue of data\table corruption. The next
step is to figure out "WHY".
If you dont do this, your data is likely going to become corrupt again very
soon.
I suspect a disk is going haywire on you or your RAID Controller is kicking
the bucket.
I just went through this with two different customers. One turned out to be
disk, hte other turned out to be RAID Controller.
cheers
Greg Jackson
PDX, Oregon|||I'll do that.
- Andrew
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:efyvtDTWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi Andrew,
> Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
> ensure that database is in good shape.
> Note:
> As part of your routine maintenance please schedule a DBCC CHECKDB for all
> production databases. This will help you to identify issues earlier.
> Thanks
> Hari
> SQL Server MVP
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
http://www.karaszi.com/SQLServer/in..._suspect_db.asp[vbcol=seagreen]
CECKDB[vbcol=seagreen]
>|||This is on a development machine rather than a production server so I
suspect it may have been roughly rebooted periodically. There hasn't been
any other evidence of disk problems so i am just backing up frequently for
now.
Thanks,
Andrew
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:OPRePnVWFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Andrew,
> A key here that Mike mentioned is "Generally, corruption is caused by
> hardware faults".
> now that you solved the immediate issue of data\table corruption. The next
> step is to figure out "WHY".
> If you dont do this, your data is likely going to become corrupt again
very
> soon.
> I suspect a disk is going haywire on you or your RAID Controller is
kicking
> the bucket.
> I just went through this with two different customers. One turned out to
be
> disk, hte other turned out to be RAID Controller.
>
> cheers
>
> Greg Jackson
> PDX, Oregon
>

Corrupted table

When I try and examine a table in one of my MS SQL Server 2000 databases I
get the following error from Enterprise Manager:
[Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset
0X00000000038000 in file ...MDF
How do I go about fixing this?
Thanks,"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl:
> I/O error (bad page ID) detected during read at offset
Run...
DBCC CHECKDB
--
Regards
JTC ^..^|||Hi
In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
corruption is. Check all the DBs on the server.
Start looking for you most recent backup.
If the corruption is not too bad, you might be able to run DBCC CECKDB
REPAIR_REBUILD
else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you may
loose data).
Generally, corruption is caused by hardware faults.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> When I try and examine a table in one of my MS SQL Server 2000 databases I
> get the following error from Enterprise Manager:
> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset
> 0X00000000038000 in file ...MDF
> How do I go about fixing this?
> Thanks,
>
>|||Also look at http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi
> In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
> corruption is. Check all the DBs on the server.
> Start looking for you most recent backup.
> If the corruption is not too bad, you might be able to run DBCC CECKDB
> REPAIR_REBUILD
> else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you
> may loose data).
> Generally, corruption is caused by hardware faults.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> When I try and examine a table in one of my MS SQL Server 2000 databases
>> I
>> get the following error from Enterprise Manager:
>> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at
>> offset
>> 0X00000000038000 in file ...MDF
>> How do I go about fixing this?
>> Thanks,
>>
>|||Thanks Mike. I was able to Export the table SQL definition, delete the table
and then recreate it from the script.
- Andrew
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
> Also look at http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread the
> > corruption is. Check all the DBs on the server.
> >
> > Start looking for you most recent backup.
> >
> > If the corruption is not too bad, you might be able to run DBCC CECKDB
> > REPAIR_REBUILD
> > else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but you
> > may loose data).
> >
> > Generally, corruption is caused by hardware faults.
> >
> > Regards
> > --
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@.epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> > news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> >> When I try and examine a table in one of my MS SQL Server 2000
databases
> >> I
> >> get the following error from Enterprise Manager:
> >>
> >> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at
> >> offset
> >> 0X00000000038000 in file ...MDF
> >>
> >> How do I go about fixing this?
> >>
> >> Thanks,
> >>
> >>
> >>
> >
> >
>|||Hi Andrew,
Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
ensure that database is in good shape.
Note:
As part of your routine maintenance please schedule a DBCC CHECKDB for all
production databases. This will help you to identify issues earlier.
Thanks
Hari
SQL Server MVP
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
> Thanks Mike. I was able to Export the table SQL definition, delete the
> table
> and then recreate it from the script.
> - Andrew
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
>> Also look at http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
>> > Hi
>> >
>> > In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread
>> > the
>> > corruption is. Check all the DBs on the server.
>> >
>> > Start looking for you most recent backup.
>> >
>> > If the corruption is not too bad, you might be able to run DBCC CECKDB
>> > REPAIR_REBUILD
>> > else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but
>> > you
>> > may loose data).
>> >
>> > Generally, corruption is caused by hardware faults.
>> >
>> > Regards
>> > --
>> > Mike Epprecht, Microsoft SQL Server MVP
>> > Zurich, Switzerland
>> >
>> > IM: mike@.epprecht.net
>> >
>> > MVP Program: http://www.microsoft.com/mvp
>> >
>> > Blog: http://www.msmvps.com/epprecht/
>> >
>> > "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
>> > news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> >> When I try and examine a table in one of my MS SQL Server 2000
> databases
>> >> I
>> >> get the following error from Enterprise Manager:
>> >>
>> >> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at
>> >> offset
>> >> 0X00000000038000 in file ...MDF
>> >>
>> >> How do I go about fixing this?
>> >>
>> >> Thanks,
>> >>
>> >>
>> >>
>> >
>> >
>>
>|||Andrew,
A key here that Mike mentioned is "Generally, corruption is caused by
hardware faults".
now that you solved the immediate issue of data\table corruption. The next
step is to figure out "WHY".
If you dont do this, your data is likely going to become corrupt again very
soon.
I suspect a disk is going haywire on you or your RAID Controller is kicking
the bucket.
I just went through this with two different customers. One turned out to be
disk, hte other turned out to be RAID Controller.
cheers
Greg Jackson
PDX, Oregon|||I'll do that.
- Andrew
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:efyvtDTWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi Andrew,
> Now you should be in good shape, but still run a DBCC CHECKDB(DBNAME) and
> ensure that database is in good shape.
> Note:
> As part of your routine maintenance please schedule a DBCC CHECKDB for all
> production databases. This will help you to identify issues earlier.
> Thanks
> Hari
> SQL Server MVP
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:e2s03xOWFHA.628@.tk2msftngp13.phx.gbl...
> > Thanks Mike. I was able to Export the table SQL definition, delete the
> > table
> > and then recreate it from the script.
> >
> > - Andrew
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:uzMoM3JWFHA.584@.TK2MSFTNGP15.phx.gbl...
> >> Also look at
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> >> news:OgvrizJWFHA.3320@.TK2MSFTNGP12.phx.gbl...
> >> > Hi
> >> >
> >> > In Query Analyzer, run DBCC CHECKDB to get an idea of how widespread
> >> > the
> >> > corruption is. Check all the DBs on the server.
> >> >
> >> > Start looking for you most recent backup.
> >> >
> >> > If the corruption is not too bad, you might be able to run DBCC
CECKDB
> >> > REPAIR_REBUILD
> >> > else, you would need to use DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS (but
> >> > you
> >> > may loose data).
> >> >
> >> > Generally, corruption is caused by hardware faults.
> >> >
> >> > Regards
> >> > --
> >> > Mike Epprecht, Microsoft SQL Server MVP
> >> > Zurich, Switzerland
> >> >
> >> > IM: mike@.epprecht.net
> >> >
> >> > MVP Program: http://www.microsoft.com/mvp
> >> >
> >> > Blog: http://www.msmvps.com/epprecht/
> >> >
> >> > "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> >> > news:O4XR1rJWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> >> >> When I try and examine a table in one of my MS SQL Server 2000
> > databases
> >> >> I
> >> >> get the following error from Enterprise Manager:
> >> >>
> >> >> [Microsoft][ODBC..] I/O error (bad page ID) detected during read at
> >> >> offset
> >> >> 0X00000000038000 in file ...MDF
> >> >>
> >> >> How do I go about fixing this?
> >> >>
> >> >> Thanks,
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||This is on a development machine rather than a production server so I
suspect it may have been roughly rebooted periodically. There hasn't been
any other evidence of disk problems so i am just backing up frequently for
now.
Thanks,
Andrew
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:OPRePnVWFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Andrew,
> A key here that Mike mentioned is "Generally, corruption is caused by
> hardware faults".
> now that you solved the immediate issue of data\table corruption. The next
> step is to figure out "WHY".
> If you dont do this, your data is likely going to become corrupt again
very
> soon.
> I suspect a disk is going haywire on you or your RAID Controller is
kicking
> the bucket.
> I just went through this with two different customers. One turned out to
be
> disk, hte other turned out to be RAID Controller.
>
> cheers
>
> Greg Jackson
> PDX, Oregon
>