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

Wednesday, March 7, 2012

Can SQL Server 2005 Evaluation be used to upgrade a system?

I have multiple development SQL Servers running Enterprise edition that I want to upgrade for application testing before upgrading our production system. All of the servers meet the hardware and software requirements for SQL Server 2005 Enterprise edition. However, when I try to install to use the SQL Server 2005 Evaluation Edition to upgrade the servers in place, I get the blocked upgrade message:

Name: Microsoft SQL Server 2000 Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Can the Evaluation Edition be used to upgrade these servers or do you need the full blown version?

thanks

Sorry, upgrades are prohibited *to* the Eval edition.|||I am getting this error now myself and I don't know why. I installed the trial SQL Server Express for my boss. He then asked if I would install the trial SQL Server 2005 becuase it has more capabilities he would like to try out. So I installed 2005. He noticed that there was no management studio installed and needed. So I uninstalled it and am trying to reinstall it and am getting this error. I haven't even used the software yet! I don't know what to do!|||

I was able to continue the installation but just before I click OK to install, I see this in a window

The following components that you selected will not be changed:

Client Components

that might be why I had my original problem. That problem was the Management Studio was never installed which prompted me to reinstall the system alltogether thinking I must have not checked that installation option.

Ahh!!!

Can SQL Server 2005 Evaluation be used to upgrade a system?

I have multiple development SQL Servers running Enterprise edition that I want to upgrade for application testing before upgrading our production system. All of the servers meet the hardware and software requirements for SQL Server 2005 Enterprise edition. However, when I try to install to use the SQL Server 2005 Evaluation Edition to upgrade the servers in place, I get the blocked upgrade message:

Name: Microsoft SQL Server 2000

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Can the Evaluation Edition be used to upgrade these servers or do you need the full blown version?

thanks

Sorry, upgrades are prohibited *to* the Eval edition.|||I am getting this error now myself and I don't know why. I installed the trial SQL Server Express for my boss. He then asked if I would install the trial SQL Server 2005 becuase it has more capabilities he would like to try out. So I installed 2005. He noticed that there was no management studio installed and needed. So I uninstalled it and am trying to reinstall it and am getting this error. I haven't even used the software yet! I don't know what to do!|||

I was able to continue the installation but just before I click OK to install, I see this in a window

The following components that you selected will not be changed:

Client Components

that might be why I had my original problem. That problem was the Management Studio was never installed which prompted me to reinstall the system alltogether thinking I must have not checked that installation option.

Ahh!!!

Can SQL server 2000 Enterprise Edition run in Windows XP?

Please help me here...I am a new user of sql server 2000 and a beginner in asp...We are making a web application and I have some problems with sql server 2000 in my windows XP.

1. I'm not connected in a network.
2. When I try to connect to sql server 2000 using this code:
<%
Dim CN
Dim RS
Set CN=Server.CreateObject("ADODB.Connection")
CN.Open "Provider=SQLOLEDB.1;uid=sa;Initial Catalog=Planetchow;"
Set RS = CN.Execute ("SELECT Restaurant_Id FROM RestaurantInfo")

While Not RS.EOF
Response.Write "<TR>"
Response.Write "<TD>" & RS.Fields("Restaurant_Id") & "</TD>"
Response.Write"</TR>"
RS.MoveNext
Wend
%>

I get this error message:

"Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."

3. How come? What configurations do I have to make to be able to avoid this...

4. How do I connect to SQL server 2000 in ASP vbscript code?

Please I really need some help here...thank you!Go to enterprise manager and right click on the server and select properties then go to the tab that says security and make sure "SQL Server and Windows" is checked.

Saturday, February 25, 2012

Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?

Hi,
I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
would like to install SQL 2005 native client (Mgnt Studio etc) on the same PC.
Can they be coexisted and both can be used ? OR
I have to uninstall 2000 client first.
Regards,
Johnny
Hello,
They can co-exist. Make sure you installl the software in seperate
directory.
Thanks
Hari
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:F553693B-19D1-4EA7-9EEC-062287EE1628@.microsoft.com...
> Hi,
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
> would like to install SQL 2005 native client (Mgnt Studio etc) on the same
> PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
> Regards,
> Johnny
|||Johnny (Johnny@.discussions.microsoft.com) writes:
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC.
> I would like to install SQL 2005 native client (Mgnt Studio etc) on the
> same PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
They can co-exist as Hari said.
I just like to make a clafication: SQL Native Client is a single DLL
which contains an updated ODBC driver and an updated OLE DB provider
for SQL 2005. SQL Native is a redistributable component. SQL Native is
about the first which is installed when you run the SQL Server installation.
You are apparently thinking of the Workstation components, of which some
may use SQL Native Client, but far from all do. Management Studio, for
instance, uses SqlClient, a .Net provider. ("Native" in SQL Native Client
refers to that it is in native code, as opposed to the managed code of
..Net.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Can someone provide some insight on this?

http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
So is this saying I can purchase one license of SQL Enterprise 2005 and run
it on as many vm installs as I want? Example, I create 5 windows 2003 servers
running on vmware and install SQL on each of them, am I'm still legal?
Agreed. We haven't even started our SQL on VMWare testing yet, so we
certainly won't be loading up a bunch of them any time soon.
""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%236cU7mEXHHA.496@.TK2MSFTNGP06.phx.gbl...
> ChrisR wrote:
> I think you're correct. We are also running a number of our servers on
> VMWare, so I'll also keep this change in mind. How much it's worth though
> is another question, since running SQL server on VMWare isn't always the
> best choice. We have some SQL servers on VMWare and some on physical
> machines and generally the ones on physical machines runs better, so I'd
> be hesitant running to many SQL servers on the same VMWare box.
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator

Can someone provide some insight on this?

http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
So is this saying I can purchase one license of SQL Enterprise 2005 and run
it on as many vm installs as I want? Example, I create 5 windows 2003 servers
running on vmware and install SQL on each of them, am I'm still legal?ChrisR wrote:
> http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
> So is this saying I can purchase one license of SQL Enterprise 2005 and run
> it on as many vm installs as I want? Example, I create 5 windows 2003 servers
> running on vmware and install SQL on each of them, am I'm still legal?
>
I think you're correct. We are also running a number of our servers on
VMWare, so I'll also keep this change in mind. How much it's worth
though is another question, since running SQL server on VMWare isn't
always the best choice. We have some SQL servers on VMWare and some on
physical machines and generally the ones on physical machines runs
better, so I'd be hesitant running to many SQL servers on the same
VMWare box.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Agreed. We haven't even started our SQL on VMWare testing yet, so we
certainly won't be loading up a bunch of them any time soon.
""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%236cU7mEXHHA.496@.TK2MSFTNGP06.phx.gbl...
> ChrisR wrote:
>> http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
>> So is this saying I can purchase one license of SQL Enterprise 2005 and
>> run it on as many vm installs as I want? Example, I create 5 windows 2003
>> servers running on vmware and install SQL on each of them, am I'm still
>> legal?
> I think you're correct. We are also running a number of our servers on
> VMWare, so I'll also keep this change in mind. How much it's worth though
> is another question, since running SQL server on VMWare isn't always the
> best choice. We have some SQL servers on VMWare and some on physical
> machines and generally the ones on physical machines runs better, so I'd
> be hesitant running to many SQL servers on the same VMWare box.
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator

Sunday, February 19, 2012

can see sql2k sp3, but cannot connect?

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can al
so
see that port 1433 is open.
But, when I try to connect to it, I get the connection could not be
estiablished.
sql server does not exist or access denied.
I have pretty much all the port except for 1433 tcp and udp blocked.
How can I troubleshoot getting this connected. It is located on my local
network - so it is not a connection problem.
--
Thanks in advance, Les CaudleI think it was a name resolution problem, with so few ports open.
When I created a registration by ip address rather than name, it connected
immediately.
Confusing that the name showed up in Enterprise Manager. Would be nice if i
t
would automatically try to use just the ip (which it must know, as it can se
e
it).
On Wed, 18 Aug 2004 19:17:14 -0500, Les Caudle <very@.tiredofspam.com> wrote:

>With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can a
lso
>see that port 1433 is open.
>But, when I try to connect to it, I get the connection could not be
>estiablished.
>sql server does not exist or access denied.
>I have pretty much all the port except for 1433 tcp and udp blocked.
>How can I troubleshoot getting this connected. It is located on my local
>network - so it is not a connection problem.

can see sql2k sp3, but cannot connect?

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also
see that port 1433 is open.
But, when I try to connect to it, I get the connection could not be
estiablished.
sql server does not exist or access denied.
I have pretty much all the port except for 1433 tcp and udp blocked.
How can I troubleshoot getting this connected. It is located on my local
network - so it is not a connection problem.
Thanks in advance, Les Caudle
I think it was a name resolution problem, with so few ports open.
When I created a registration by ip address rather than name, it connected
immediately.
Confusing that the name showed up in Enterprise Manager. Would be nice if it
would automatically try to use just the ip (which it must know, as it can see
it).
On Wed, 18 Aug 2004 19:17:14 -0500, Les Caudle <very@.tiredofspam.com> wrote:

>With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also
>see that port 1433 is open.
>But, when I try to connect to it, I get the connection could not be
>estiablished.
>sql server does not exist or access denied.
>I have pretty much all the port except for 1433 tcp and udp blocked.
>How can I troubleshoot getting this connected. It is located on my local
>network - so it is not a connection problem.

Thursday, February 16, 2012

can pocpet pc direct connect to sql server 2005?

i plan to upgrade sql express to sql 2005 enterprise.

if i upgrade to enterprise can

i direct connect to sql server 2005, is it need to install other

software on pocket pc or on my server?

thank you

if you are creating a .NET Compact Framework application for your mobile device, then yes, you can use the System.Data.SqlClient namespace to execute queries directly against SQL Server 2005 Enterprise.

Darren

Sunday, February 12, 2012

Can not start server after setting open objects to 2147483647

SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to 0.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> > SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> >
> > I set open objects to 2147483647 for research purpose. After I did it, I can
> > not start the server any more, nor can I set open objects to a smaller value.
> > The error message I got was:
> > [Shared Memory]SQL Server does not exist or access denied.
> > [Shared Memory]ConnectionOpen (Connect()).
> >
> > What should I do to be able to start the server again?
> >
> > Thank you,
> > Tammy
>

Can not start server after setting open objects to 2147483647

SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
Tammy
Try starting the server using the -f option, then change this value back to 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy
|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:

> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>

Can not start server after setting open objects to 2147483647

SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value
.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to
0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I c
an
> not start the server any more, nor can I set open objects to a smaller val
ue.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:

> Try starting the server using the -f option, then change this value back t
o 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florence
Hi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>
|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

Can not save sql view in Enterprise Mgr of data on a linked oracle

I have a sql server that has a linked server set up which is an Oracle
database. I can start the process of creating a SQL view of the needed data
in the Oracle database as follows:
SELECT * FROM OPENQUERY(cadtelbase, 'select * from cadtel_data_724.E356_S0
where ATTR964 = ''V01-03-00108''') If I execute the view I get the expected
results, but as soon as I try to save the view I receive the following SQL
Server Enterprise Manager error message.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation
could not be performed because the OLE DB provider â'OraOLEDB.Oracleâ' was
unable to begin a distributed transaction. [Microsoft][ODBC SQL Server
Driver][SQL Server][OLE/DB provider returned message: New transaction cannot
enlist in the specified transaction coordinator. ] [Micorsoft][ODBC SQL
Server Driver][SQL Server][OLE DB error trace [OLE/DB Provider
â'OraOLEDB.Oracleâ' ITransactionJoi JoinTransaction returned 0x8004d00a].
Any help on this would greatly be appreciated.
Thanks!
JackieNever mind. I found the solution. Simply can not create the view using
Enterprise Manager view designer, must create the view using query analyzer!
"Wishing I was skiing mom" wrote:
> I have a sql server that has a linked server set up which is an Oracle
> database. I can start the process of creating a SQL view of the needed data
> in the Oracle database as follows:
> SELECT * FROM OPENQUERY(cadtelbase, 'select * from cadtel_data_724.E356_S0
> where ATTR964 = ''V01-03-00108''') If I execute the view I get the expected
> results, but as soon as I try to save the view I receive the following SQL
> Server Enterprise Manager error message.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation
> could not be performed because the OLE DB provider â'OraOLEDB.Oracleâ' was
> unable to begin a distributed transaction. [Microsoft][ODBC SQL Server
> Driver][SQL Server][OLE/DB provider returned message: New transaction cannot
> enlist in the specified transaction coordinator. ] [Micorsoft][ODBC SQL
> Server Driver][SQL Server][OLE DB error trace [OLE/DB Provider
> â'OraOLEDB.Oracleâ' ITransactionJoi JoinTransaction returned 0x8004d00a].
> Any help on this would greatly be appreciated.
> Thanks!
> Jackie
>

Can not run DBCC Checkdb on database

SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
Can not run DBCC Checkdb on database because receiving the following error
messages:
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database
snapshot could not be created and the database or table could not be locked.
We have tried running this command on other databases on this same instance
of SQL Server and the DBCC Checkdb process runs. In several databases the
snapshot cannot be created, but the process does run successfully directly
on the database, and on other databases the whole process runs as designed.
This database that is erroring is also copied to another server running SQL
Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can successfully
run DBCC Checkdb on that database on that 32 bit server.
*side note- both databases were on the same release and the error was
already occuring on the 64 bit version
Any suggested remedies appreciated.Hello,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: the following error message is received when attempting to run the
"DBCC Checkdb" command on a SQL Server 2005 64
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively
locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database
snapshot could not be created and the database or table could not be
locked. See Books Online for details of when this behavior is expected and
what workarounds exist. Also see previous errors for more details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If I have misunderstood about your concern, feel free to let me know.
Based on my experience and knowledge, this behavior can be caused by one of
the following factors.
1. The SQL Server startup account does not have sufficient permission on
the SQL Server data folder.
2. At least one other connection is using the database against which you
run the DBCC CHECK command.
3. The database contains at least one file group that is marked as
read-only.
For more information regarding this issue, please refer tot the following
KB article:
Error message when you run any of the DBCC CHECKDB commands in SQL Server
2005: "The database could not be exclusively locked to perform the
operation"
http://support.microsoft.com/?id=928518
At this point, to troubleshoot the issue, I suggest we try the following
suggestion.
Suggestion 1: Change the startup account of SQL Server service to Local
System account
=======================================
1. Open SQL Server Configuration Manager
2. Highlight "SQL Server 2005 services", double click SQL Server
(MSSQLSERVER) in the right panel.
3. On the open window, please set "Built-in account" to "Local System" and
click OK.
4. System will prompt us to restart the service. Click Yes to continue.
After that, let's run the DBCC CHECKDB command again. If the issue stays,
let's move on to the next suggestion.
Suggestion 2: Manually create the database snapshot
========================================
1. Create a database snapshot of the database for which you want to perform
the checks.
For more information about how to create a database snapshot, see the "How
to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
Books Online at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
994c5230.htm
2. Run the DBCC CHECK command against the database snapshot.
3. Drop the database snapshot after the DBCC CHECK command is completed.
Please let me know the results at your earliest convenience. If anything is
unclear in my reply, please don't hesitate to let me know and I will be
glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE 2000, MCDBA
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Russell" <Clarksville@.nospam.nospam>
| Subject: Can not run DBCC Checkdb on database
| Date: Wed, 2 May 2007 10:29:16 -0500
| Lines: 28
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
|
| Can not run DBCC Checkdb on database because receiving the following
error
| messages:
| Msg 5030, Level 16, State 12, Line 1
| The database could not be exclusively locked to perform the operation.
| Msg 7926, Level 16, State 1, Line 1
| Check statement aborted. The database could not be checked as a database
| snapshot could not be created and the database or table could not be
locked.
| We have tried running this command on other databases on this same
instance
| of SQL Server and the DBCC Checkdb process runs. In several databases the
| snapshot cannot be created, but the process does run successfully
directly
| on the database, and on other databases the whole process runs as
designed.
|
| This database that is erroring is also copied to another server running
SQL
| Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
successfully
| run DBCC Checkdb on that database on that 32 bit server.
|
| *side note- both databases were on the same release and the error was
| already occuring on the 64 bit version
|
| Any suggested remedies appreciated.
|
|
|
|
|
|
||||Hello,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a great day!
Best regards,
Adams Qu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
==============
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
| X-Tomcat-ID: 77322427
| References: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 03 May 2007 05:25:56 GMT
| Subject: RE: Can not run DBCC Checkdb on database
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <6tj5KOUjHHA.3352@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 136
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14652
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hello,
|
| Thank you for posting here.
|
| From the problem description of the post you submitted, my understanding
| is: the following error message is received when attempting to run the
| "DBCC Checkdb" command on a SQL Server 2005 64
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Msg 5030, Level 16, State 12, Line 1 The database could not be
exclusively
| locked to perform the operation.
| Msg 7926, Level 16, State 1, Line 1
| Check statement aborted. The database could not be checked as a database
| snapshot could not be created and the database or table could not be
| locked. See Books Online for details of when this behavior is expected
and
| what workarounds exist. Also see previous errors for more details.
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| If I have misunderstood about your concern, feel free to let me know.
|
| Based on my experience and knowledge, this behavior can be caused by one
of
| the following factors.
|
| 1. The SQL Server startup account does not have sufficient permission on
| the SQL Server data folder.
| 2. At least one other connection is using the database against which you
| run the DBCC CHECK command.
| 3. The database contains at least one file group that is marked as
| read-only.
|
| For more information regarding this issue, please refer tot the following
| KB article:
|
| Error message when you run any of the DBCC CHECKDB commands in SQL Server
| 2005: "The database could not be exclusively locked to perform the
| operation"
| http://support.microsoft.com/?id=928518
|
| At this point, to troubleshoot the issue, I suggest we try the following
| suggestion.
|
| Suggestion 1: Change the startup account of SQL Server service to Local
| System account
| =======================================
| 1. Open SQL Server Configuration Manager
| 2. Highlight "SQL Server 2005 services", double click SQL Server
| (MSSQLSERVER) in the right panel.
| 3. On the open window, please set "Built-in account" to "Local System"
and
| click OK.
| 4. System will prompt us to restart the service. Click Yes to continue.
|
| After that, let's run the DBCC CHECKDB command again. If the issue stays,
| let's move on to the next suggestion.
|
| Suggestion 2: Manually create the database snapshot
| ========================================
| 1. Create a database snapshot of the database for which you want to
perform
| the checks.
|
| For more information about how to create a database snapshot, see the
"How
| to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
| Books Online at
|
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
| 994c5230.htm
|
| 2. Run the DBCC CHECK command against the database snapshot.
| 3. Drop the database snapshot after the DBCC CHECK command is completed.
|
| Please let me know the results at your earliest convenience. If anything
is
| unclear in my reply, please don't hesitate to let me know and I will be
| glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE 2000, MCDBA
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ========================================
=============
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ========================================
=============
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --
| | From: "Russell" <Clarksville@.nospam.nospam>
| | Subject: Can not run DBCC Checkdb on database
| | Date: Wed, 2 May 2007 10:29:16 -0500
| | Lines: 28
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
| |
| | Can not run DBCC Checkdb on database because receiving the following
| error
| | messages:
| | Msg 5030, Level 16, State 12, Line 1
| | The database could not be exclusively locked to perform the operation.
| | Msg 7926, Level 16, State 1, Line 1
| | Check statement aborted. The database could not be checked as a
database
| | snapshot could not be created and the database or table could not be
| locked.
| | We have tried running this command on other databases on this same
| instance
| | of SQL Server and the DBCC Checkdb process runs. In several databases
the
| | snapshot cannot be created, but the process does run successfully
| directly
| | on the database, and on other databases the whole process runs as
| designed.
| |
| | This database that is erroring is also copied to another server running
| SQL
| | Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
| successfully
| | run DBCC Checkdb on that database on that 32 bit server.
| |
| | *side note- both databases were on the same release and the error was
| | already occuring on the 64 bit version
| |
| | Any suggested remedies appreciated.
| |
| |
| |
| |
| |
| |
| |
|
|

Can not run DBCC Checkdb on database

SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
Can not run DBCC Checkdb on database because receiving the following error
messages:
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database
snapshot could not be created and the database or table could not be locked.
We have tried running this command on other databases on this same instance
of SQL Server and the DBCC Checkdb process runs. In several databases the
snapshot cannot be created, but the process does run successfully directly
on the database, and on other databases the whole process runs as designed.
This database that is erroring is also copied to another server running SQL
Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can successfully
run DBCC Checkdb on that database on that 32 bit server.
*side note- both databases were on the same release and the error was
already occuring on the 64 bit version
Any suggested remedies appreciated.
Hello,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: the following error message is received when attempting to run the
"DBCC Checkdb" command on a SQL Server 2005 64
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively
locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database
snapshot could not be created and the database or table could not be
locked. See Books Online for details of when this behavior is expected and
what workarounds exist. Also see previous errors for more details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If I have misunderstood about your concern, feel free to let me know.
Based on my experience and knowledge, this behavior can be caused by one of
the following factors.
1. The SQL Server startup account does not have sufficient permission on
the SQL Server data folder.
2. At least one other connection is using the database against which you
run the DBCC CHECK command.
3. The database contains at least one file group that is marked as
read-only.
For more information regarding this issue, please refer tot the following
KB article:
Error message when you run any of the DBCC CHECKDB commands in SQL Server
2005: "The database could not be exclusively locked to perform the
operation"
http://support.microsoft.com/?id=928518
At this point, to troubleshoot the issue, I suggest we try the following
suggestion.
Suggestion 1: Change the startup account of SQL Server service to Local
System account
=======================================
1. Open SQL Server Configuration Manager
2. Highlight "SQL Server 2005 services", double click SQL Server
(MSSQLSERVER) in the right panel.
3. On the open window, please set "Built-in account" to "Local System" and
click OK.
4. System will prompt us to restart the service. Click Yes to continue.
After that, let's run the DBCC CHECKDB command again. If the issue stays,
let's move on to the next suggestion.
Suggestion 2: Manually create the database snapshot
========================================
1. Create a database snapshot of the database for which you want to perform
the checks.
For more information about how to create a database snapshot, see the "How
to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
Books Online at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
994c5230.htm
2. Run the DBCC CHECK command against the database snapshot.
3. Drop the database snapshot after the DBCC CHECK command is completed.
Please let me know the results at your earliest convenience. If anything is
unclear in my reply, please don't hesitate to let me know and I will be
glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE 2000, MCDBA
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Russell" <Clarksville@.nospam.nospam>
| Subject: Can not run DBCC Checkdb on database
| Date: Wed, 2 May 2007 10:29:16 -0500
| Lines: 28
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
|
| Can not run DBCC Checkdb on database because receiving the following
error
| messages:
| Msg 5030, Level 16, State 12, Line 1
| The database could not be exclusively locked to perform the operation.
| Msg 7926, Level 16, State 1, Line 1
| Check statement aborted. The database could not be checked as a database
| snapshot could not be created and the database or table could not be
locked.
| We have tried running this command on other databases on this same
instance
| of SQL Server and the DBCC Checkdb process runs. In several databases the
| snapshot cannot be created, but the process does run successfully
directly
| on the database, and on other databases the whole process runs as
designed.
|
| This database that is erroring is also copied to another server running
SQL
| Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
successfully
| run DBCC Checkdb on that database on that 32 bit server.
|
| *side note- both databases were on the same release and the error was
| already occuring on the 64 bit version
|
| Any suggested remedies appreciated.
|
|
|
|
|
|
|
|||Hello,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a great day!
Best regards,
Adams Qu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ====
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
| X-Tomcat-ID: 77322427
| References: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 03 May 2007 05:25:56 GMT
| Subject: RE: Can not run DBCC Checkdb on database
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <6tj5KOUjHHA.3352@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 136
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14652
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hello,
|
| Thank you for posting here.
|
| From the problem description of the post you submitted, my understanding
| is: the following error message is received when attempting to run the
| "DBCC Checkdb" command on a SQL Server 2005 64
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Msg 5030, Level 16, State 12, Line 1 The database could not be
exclusively
| locked to perform the operation.
| Msg 7926, Level 16, State 1, Line 1
| Check statement aborted. The database could not be checked as a database
| snapshot could not be created and the database or table could not be
| locked. See Books Online for details of when this behavior is expected
and
| what workarounds exist. Also see previous errors for more details.
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| If I have misunderstood about your concern, feel free to let me know.
|
| Based on my experience and knowledge, this behavior can be caused by one
of
| the following factors.
|
| 1. The SQL Server startup account does not have sufficient permission on
| the SQL Server data folder.
| 2. At least one other connection is using the database against which you
| run the DBCC CHECK command.
| 3. The database contains at least one file group that is marked as
| read-only.
|
| For more information regarding this issue, please refer tot the following
| KB article:
|
| Error message when you run any of the DBCC CHECKDB commands in SQL Server
| 2005: "The database could not be exclusively locked to perform the
| operation"
| http://support.microsoft.com/?id=928518
|
| At this point, to troubleshoot the issue, I suggest we try the following
| suggestion.
|
| Suggestion 1: Change the startup account of SQL Server service to Local
| System account
| =======================================
| 1. Open SQL Server Configuration Manager
| 2. Highlight "SQL Server 2005 services", double click SQL Server
| (MSSQLSERVER) in the right panel.
| 3. On the open window, please set "Built-in account" to "Local System"
and
| click OK.
| 4. System will prompt us to restart the service. Click Yes to continue.
|
| After that, let's run the DBCC CHECKDB command again. If the issue stays,
| let's move on to the next suggestion.
|
| Suggestion 2: Manually create the database snapshot
| ========================================
| 1. Create a database snapshot of the database for which you want to
perform
| the checks.
|
| For more information about how to create a database snapshot, see the
"How
| to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
| Books Online at
|
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
| 994c5230.htm
|
| 2. Run the DBCC CHECK command against the database snapshot.
| 3. Drop the database snapshot after the DBCC CHECK command is completed.
|
| Please let me know the results at your earliest convenience. If anything
is
| unclear in my reply, please don't hesitate to let me know and I will be
| glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE 2000, MCDBA
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --
| | From: "Russell" <Clarksville@.nospam.nospam>
| | Subject: Can not run DBCC Checkdb on database
| | Date: Wed, 2 May 2007 10:29:16 -0500
| | Lines: 28
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
| |
| | Can not run DBCC Checkdb on database because receiving the following
| error
| | messages:
| | Msg 5030, Level 16, State 12, Line 1
| | The database could not be exclusively locked to perform the operation.
| | Msg 7926, Level 16, State 1, Line 1
| | Check statement aborted. The database could not be checked as a
database
| | snapshot could not be created and the database or table could not be
| locked.
| | We have tried running this command on other databases on this same
| instance
| | of SQL Server and the DBCC Checkdb process runs. In several databases
the
| | snapshot cannot be created, but the process does run successfully
| directly
| | on the database, and on other databases the whole process runs as
| designed.
| |
| | This database that is erroring is also copied to another server running
| SQL
| | Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
| successfully
| | run DBCC Checkdb on that database on that 32 bit server.
| |
| | *side note- both databases were on the same release and the error was
| | already occuring on the 64 bit version
| |
| | Any suggested remedies appreciated.
| |
| |
| |
| |
| |
| |
| |
|
|

Can not run DBCC Checkdb on database

SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
Can not run DBCC Checkdb on database because receiving the following error
messages:
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database
snapshot could not be created and the database or table could not be locked.
We have tried running this command on other databases on this same instance
of SQL Server and the DBCC Checkdb process runs. In several databases the
snapshot cannot be created, but the process does run successfully directly
on the database, and on other databases the whole process runs as designed.
This database that is erroring is also copied to another server running SQL
Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can successfully
run DBCC Checkdb on that database on that 32 bit server.
*side note- both databases were on the same release and the error was
already occuring on the 64 bit version
Any suggested remedies appreciated.Hello,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: the following error message is received when attempting to run the
"DBCC Checkdb" command on a SQL Server 2005 64
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively
locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database
snapshot could not be created and the database or table could not be
locked. See Books Online for details of when this behavior is expected and
what workarounds exist. Also see previous errors for more details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If I have misunderstood about your concern, feel free to let me know.
Based on my experience and knowledge, this behavior can be caused by one of
the following factors.
1. The SQL Server startup account does not have sufficient permission on
the SQL Server data folder.
2. At least one other connection is using the database against which you
run the DBCC CHECK command.
3. The database contains at least one file group that is marked as
read-only.
For more information regarding this issue, please refer tot the following
KB article:
Error message when you run any of the DBCC CHECKDB commands in SQL Server
2005: "The database could not be exclusively locked to perform the
operation"
http://support.microsoft.com/?id=928518
At this point, to troubleshoot the issue, I suggest we try the following
suggestion.
Suggestion 1: Change the startup account of SQL Server service to Local
System account
=======================================1. Open SQL Server Configuration Manager
2. Highlight "SQL Server 2005 services", double click SQL Server
(MSSQLSERVER) in the right panel.
3. On the open window, please set "Built-in account" to "Local System" and
click OK.
4. System will prompt us to restart the service. Click Yes to continue.
After that, let's run the DBCC CHECKDB command again. If the issue stays,
let's move on to the next suggestion.
Suggestion 2: Manually create the database snapshot
========================================1. Create a database snapshot of the database for which you want to perform
the checks.
For more information about how to create a database snapshot, see the "How
to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
Books Online at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
994c5230.htm
2. Run the DBCC CHECK command against the database snapshot.
3. Drop the database snapshot after the DBCC CHECK command is completed.
Please let me know the results at your earliest convenience. If anything is
unclear in my reply, please don't hesitate to let me know and I will be
glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE 2000, MCDBA
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "Russell" <Clarksville@.nospam.nospam>
| Subject: Can not run DBCC Checkdb on database
| Date: Wed, 2 May 2007 10:29:16 -0500
| Lines: 28
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
|
| Can not run DBCC Checkdb on database because receiving the following
error
| messages:
| Msg 5030, Level 16, State 12, Line 1
| The database could not be exclusively locked to perform the operation.
| Msg 7926, Level 16, State 1, Line 1
| Check statement aborted. The database could not be checked as a database
| snapshot could not be created and the database or table could not be
locked.
| We have tried running this command on other databases on this same
instance
| of SQL Server and the DBCC Checkdb process runs. In several databases the
| snapshot cannot be created, but the process does run successfully
directly
| on the database, and on other databases the whole process runs as
designed.
|
| This database that is erroring is also copied to another server running
SQL
| Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
successfully
| run DBCC Checkdb on that database on that 32 bit server.
|
| *side note- both databases were on the same release and the error was
| already occuring on the 64 bit version
|
| Any suggested remedies appreciated.
|
|
|
|
|
|
||||Hello,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a great day!
Best regards,
Adams Qu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
======================================================PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================| X-Tomcat-ID: 77322427
| References: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 03 May 2007 05:25:56 GMT
| Subject: RE: Can not run DBCC Checkdb on database
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <6tj5KOUjHHA.3352@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 136
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14652
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hello,
|
| Thank you for posting here.
|
| From the problem description of the post you submitted, my understanding
| is: the following error message is received when attempting to run the
| "DBCC Checkdb" command on a SQL Server 2005 64
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Msg 5030, Level 16, State 12, Line 1 The database could not be
exclusively
| locked to perform the operation.
| Msg 7926, Level 16, State 1, Line 1
| Check statement aborted. The database could not be checked as a database
| snapshot could not be created and the database or table could not be
| locked. See Books Online for details of when this behavior is expected
and
| what workarounds exist. Also see previous errors for more details.
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| If I have misunderstood about your concern, feel free to let me know.
|
| Based on my experience and knowledge, this behavior can be caused by one
of
| the following factors.
|
| 1. The SQL Server startup account does not have sufficient permission on
| the SQL Server data folder.
| 2. At least one other connection is using the database against which you
| run the DBCC CHECK command.
| 3. The database contains at least one file group that is marked as
| read-only.
|
| For more information regarding this issue, please refer tot the following
| KB article:
|
| Error message when you run any of the DBCC CHECKDB commands in SQL Server
| 2005: "The database could not be exclusively locked to perform the
| operation"
| http://support.microsoft.com/?id=928518
|
| At this point, to troubleshoot the issue, I suggest we try the following
| suggestion.
|
| Suggestion 1: Change the startup account of SQL Server service to Local
| System account
| =======================================| 1. Open SQL Server Configuration Manager
| 2. Highlight "SQL Server 2005 services", double click SQL Server
| (MSSQLSERVER) in the right panel.
| 3. On the open window, please set "Built-in account" to "Local System"
and
| click OK.
| 4. System will prompt us to restart the service. Click Yes to continue.
|
| After that, let's run the DBCC CHECKDB command again. If the issue stays,
| let's move on to the next suggestion.
|
| Suggestion 2: Manually create the database snapshot
| ========================================| 1. Create a database snapshot of the database for which you want to
perform
| the checks.
|
| For more information about how to create a database snapshot, see the
"How
| to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
| Books Online at
|
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
| 994c5230.htm
|
| 2. Run the DBCC CHECK command against the database snapshot.
| 3. Drop the database snapshot after the DBCC CHECK command is completed.
|
| Please let me know the results at your earliest convenience. If anything
is
| unclear in my reply, please don't hesitate to let me know and I will be
| glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE 2000, MCDBA
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| =====================================================| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| =====================================================| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --
| | From: "Russell" <Clarksville@.nospam.nospam>
| | Subject: Can not run DBCC Checkdb on database
| | Date: Wed, 2 May 2007 10:29:16 -0500
| | Lines: 28
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
| |
| | Can not run DBCC Checkdb on database because receiving the following
| error
| | messages:
| | Msg 5030, Level 16, State 12, Line 1
| | The database could not be exclusively locked to perform the operation.
| | Msg 7926, Level 16, State 1, Line 1
| | Check statement aborted. The database could not be checked as a
database
| | snapshot could not be created and the database or table could not be
| locked.
| | We have tried running this command on other databases on this same
| instance
| | of SQL Server and the DBCC Checkdb process runs. In several databases
the
| | snapshot cannot be created, but the process does run successfully
| directly
| | on the database, and on other databases the whole process runs as
| designed.
| |
| | This database that is erroring is also copied to another server running
| SQL
| | Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
| successfully
| | run DBCC Checkdb on that database on that 32 bit server.
| |
| | *side note- both databases were on the same release and the error was
| | already occuring on the 64 bit version
| |
| | Any suggested remedies appreciated.
| |
| |
| |
| |
| |
| |
| |
|
|

Friday, February 10, 2012

Can not registre SQL in Enterprise Manager

Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 and
work wuth tables fine !!!
Using the Enterprise Manager from the W2003 server, we have checked
the following:
-Network Configuration button on the General tab
Is TCP/IP enabled?
-In the Connections tab, the Query time-out value is not set too low (600
seconds)
-There is not a maximum concurrent user connections value set
(unlimited).
Also, we can register others remote servers and work fine.
Any idea ?
Thank you very much !
Charles.It's the login timeout you want to try increasing. See my
reply to your post in .connect for steps to do this.
-Sue
On Sat, 17 Apr 2004 12:20:44 +0200, "Charles"
<ccolell@.softeng.es> wrote:

>Hello,
>I try to register a remote SQL Server 2000 installed in a W2003, but it
>doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
>In that network , there is not any firewall and port 1433 is open in the
>router. What it really surpises me, is that
>I can connect via ODBC to any database of that remote SQL Server2000 and
>work wuth tables fine !!!
>Using the Enterprise Manager from the W2003 server, we have checked
>the following:
> -Network Configuration button on the General tab
> Is TCP/IP enabled?
> -In the Connections tab, the Query time-out value is not set too low (60
0
>seconds)
> -There is not a maximum concurrent user connections value set
>(unlimited).
>Also, we can register others remote servers and work fine.
>Any idea ?
>Thank you very much !
>Charles.
>