Thursday, March 29, 2012
Error 925 DB already open when i refresh current activity
When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
Then start EM and refresh current activity I get an
Error 925: Database DB1 already open and can only have one user at a time.
I cannot see anything except (no items).
On other servers i set single user and i can view and refresh the current
activity
I don't get it why can't i view current activity on other databases?
Thanks for your helpAlex,
Try closing the connection via Query Analyzer and try again.
HTH
Jerry
"alex sadykov" <alexsadykov@.gmail.com> wrote in message
news:%239FX%23tMgGHA.5088@.TK2MSFTNGP02.phx.gbl...
>I have 20 DB's on my server.
> When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
> Then start EM and refresh current activity I get an
> Error 925: Database DB1 already open and can only have one user at a time.
>
> I cannot see anything except (no items).
> On other servers i set single user and i can view and refresh the current
> activity
> I don't get it why can't i view current activity on other databases?
> Thanks for your help
>|||Also you could try running sp_who to check the current users and processes
accessing the database.
Hope this helps
Vishal Gandhi
Error 925 DB already open when i refresh current activity
When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
Then start EM and refresh current activity I get an
Error 925: Database DB1 already open and can only have one user at a time.
I cannot see anything except (no items).
On other servers i set single user and i can view and refresh the current
activity
I don't get it why can't i view current activity on other databases?
Thanks for your helpAlex,
Try closing the connection via Query Analyzer and try again.
HTH
Jerry
"alex sadykov" <alexsadykov@.gmail.com> wrote in message
news:%239FX%23tMgGHA.5088@.TK2MSFTNGP02.phx.gbl...
>I have 20 DB's on my server.
> When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
> Then start EM and refresh current activity I get an
> Error 925: Database DB1 already open and can only have one user at a time.
>
> I cannot see anything except (no items).
> On other servers i set single user and i can view and refresh the current
> activity
> I don't get it why can't i view current activity on other databases?
> Thanks for your help
>|||Also you could try running sp_who to check the current users and processes
accessing the database.
Hope this helps
Vishal Gandhi
Wednesday, March 21, 2012
Error 7405 with a linked server and stored procedure
Everytime I try to save the procedure I get "error 7405: Heterogenous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection."
I've checked everywhere and set these options on, yet it still doesn't work.
Any ideas?
It's a simple procedure and when I type the sql into query analyzer it works.
HELP?
Here is the procedure.
===============================
CREATE PROCEDURE [dbo].[stpDKLink] AS
select * from openquery(dk, 'select * from pub.invoice')
GO
===============================Yes, SQLServer error message is a bit misleading in this case. Try this out:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[stpDKLink] AS
select * from openquery(dk, 'select * from pub.invoice')
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOsql
Sunday, February 26, 2012
Error 3271
during a backup of a database with the following command I get an error:
backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck'
Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1
Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'.
Server: Nachr.-Nr. 3013, Schweregrad 16, Status 1, Zeile 1
BACKUP DATABASE is terminating abnormally.
What can I do to repair the database files ?
Best regards
Axel LanserHi,
See SQL Server error log and Event viewer logs for more informations on this
error.
Run a DBCC CHECKDB on the database to make sure that it doesnt have any
consistency or allocation errors. It is most likely there will be errorr.
In that case you see the DBCC Checkdb with repair options in Books online.
If the database have errors and if it is difficult to solve using repair
options, Best option will be is to RESTORE from last
healthy backup or contact MS Product support.
Thanks
Hari
SQL Server MVP
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:B471FEE1-F07D-44F5-9150-ABF4C5BF630B@.microsoft.com...
> Hi,
> during a backup of a database with the following command I get an error:
> backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck'
> Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1
> Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'.
> Server: Nachr.-Nr. 3013, Schweregrad 16, Status 1, Zeile 1
> BACKUP DATABASE is terminating abnormally.
> What can I do to repair the database files ?
> Best regards
> Axel Lanser
Error 3271
during a backup of a database with the following command I get an error:
backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck'
Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1
Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'.
Server: Nachr.-Nr. 3013, Schweregrad 16, Status 1, Zeile 1
BACKUP DATABASE is terminating abnormally.
What can I do to repair the database files ?
Best regards
Axel Lanser
Hi,
See SQL Server error log and Event viewer logs for more informations on this
error.
Run a DBCC CHECKDB on the database to make sure that it doesnt have any
consistency or allocation errors. It is most likely there will be errorr.
In that case you see the DBCC Checkdb with repair options in Books online.
If the database have errors and if it is difficult to solve using repair
options, Best option will be is to RESTORE from last
healthy backup or contact MS Product support.
Thanks
Hari
SQL Server MVP
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:B471FEE1-F07D-44F5-9150-ABF4C5BF630B@.microsoft.com...
> Hi,
> during a backup of a database with the following command I get an error:
> backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck'
> Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1
> Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'.
> Server: Nachr.-Nr. 3013, Schweregrad 16, Status 1, Zeile 1
> BACKUP DATABASE is terminating abnormally.
> What can I do to repair the database files ?
> Best regards
> Axel Lanser
Error 3271
during a backup of a database with the following command I get an error:
backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck'
Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1
Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'.
Server: Nachr.-Nr. 3013, Schweregrad 16, Status 1, Zeile 1
BACKUP DATABASE is terminating abnormally.
What can I do to repair the database files ?
Best regards
Axel LanserHi,
See SQL Server error log and Event viewer logs for more informations on this
error.
Run a DBCC CHECKDB on the database to make sure that it doesnt have any
consistency or allocation errors. It is most likely there will be errorr.
In that case you see the DBCC Checkdb with repair options in Books online.
If the database have errors and if it is difficult to solve using repair
options, Best option will be is to RESTORE from last
healthy backup or contact MS Product support.
Thanks
Hari
SQL Server MVP
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:B471FEE1-F07D-44F5-9150-ABF4C5BF630B@.microsoft.com...
> Hi,
> during a backup of a database with the following command I get an error:
> backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck'
> Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1
> Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'.
> Server: Nachr.-Nr. 3013, Schweregrad 16, Status 1, Zeile 1
> BACKUP DATABASE is terminating abnormally.
> What can I do to repair the database files ?
> Best regards
> Axel Lanser
Friday, February 24, 2012
Error 28092 when upgrading from Express to Workgroup Edition
Hello,
when I try to upgrade SQL Server 2005 using this command line:
setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SQLACCOUNT=NT-AUTORIT?T\SYSTEM SECURITYMODE=SQL SAPWD=XXXXXX
I get error 28092 (administrator rights needed).
It seems like the upgrade tries to use Windows authentification although I've told it to use SQL Server authentification. Or did I miss a parameter in my command line?
If I do the upgrade manually it works without needing Windows authentification.
can you goto %program files%\microsoft sql server\90\setup bootstrap\log folder, and search for the error code, and share out the log content near/around the error?|||The file SQLSetup0008_Z1TESTVISTA_SQL.log contains:
Attempt to start service when it is already running
SQL service MSSQL$Z1 started successfully waiting for SQL service to accept client connections
Loaded DLL:
C:\Windows\system32\Odbc32.dll
Version:
6.0.6000.16386
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Der Datenbankkontext wurde auf 'master' ge?ndert.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Die Spracheneinstellung wurde auf Deutsch ge?ndert.
Error Code: 0x80076dbc (28092)
Windows Error Text: Source File Name: sqlca\upgradesql.cpp
Compiler Timestamp: Thu Aug 11 01:12:02 2005
Function Name: sqls::UpgradeSql::validateDatabases
Source Line Number: 187
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 28092
MSI (s) (38!74) [17:34:44:691]: Produkt: Microsoft SQL Server 2005 -- Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Thu Feb 01 17:34:44 2007
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Attempt to start service when it is already running
SQL service MSSQL$Z1 started successfully waiting for SQL service to accept client connections
Loaded DLL:
C:\Windows\system32\Odbc32.dll
Version:
6.0.6000.16386
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Der Datenbankkontext wurde auf 'master' ge?ndert.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Die Spracheneinstellung wurde auf Deutsch ge?ndert.
Error Code: 0x80076dbc (28092)
Windows Error Text: Source File Name: sqlca\upgradesql.cpp
Compiler Timestamp: Thu Aug 11 01:12:02 2005
Function Name: sqls::UpgradeSql::validateDatabases
Source Line Number: 187
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 28092
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 2504 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3304 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 2040 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3548 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3172 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3996 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3664 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 1456 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3848 could not be cancelled. Error: 1168
MSI (s) (38!74) [17:34:46:863]: Produkt: Microsoft SQL Server 2005 -- Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
<Failure Type='Fatal' Error='28092'>
<EndFunc Name='LaunchFunction' Return='28092' GetLastError='203'>
Aktion beendet um 17:34:46: ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Rückgabewert 3.
Aktion beendet um 17:34:46: INSTALL. Rückgabewert 3.
And the file SQLSetup0008_Z1TESTVISTA_Core(Patched).log:
Installing: sql on target: Z1TESTVISTA
Failed to install package
Schwerwiegender Fehler bei der Installation.
Setting package return code to: 28092
Complete: InstallSqlAction at: 2007/1/1 17:34:48, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
two questions:
1) were you running a admin on the box?
2) your express was ENU (English) or not? What language SKU it is? The same quesstion for the WorkGroup Edition?
|||1) Yes, but on Vista with UAC enabled. Vista asks for admin evelation and I allow it.
May this be the problem? Shall I try under Windows XP?
2) Both are the German versions.
Maybe this is a similar problem like in
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084672&SiteID=1
|||This error means that the user who is running the setup is not sysadmin in the SQL instance. It makes sense this happens on Vista because of AUC the user is not recognize as NT administrator. You need to add yourself as sysadmin to SQL. From elevated application connect to SLQ and run:
EXEC sys.sp_grantlogin N'YourAccount'
EXEC sys.sp_addsrvrolemember N'[YourAccount]', N'sysadmin'
|||
Sorry, but this doesn't answer my question:
Why does this error not occur if I do the upgrade manually?
And how do I have to change my command line above to get the same result?
|||So; after trying the same under Windows XP and experiencing the same problems again, I compared the log files created by the working manual upgrade with the ones from the aborting automatic upgrade.
I discovered some undocumented property names, especially "UPGRADEUSER" and "UPGRADEPWD". After changing my command line to
setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=XXXXXX
the automatic upgrade works now (with one exception).
THANK YOU VERY MUCH MICROSOFT FOR YOUR INCOMPLETE DOCUMENTATIONS!!!
The remaining problem now is, that the upgrade deletes Tools_Legacy even if I add
ADDLOCAL=Tools_Legacy
to the command line above. Any idea?
|||I've found the solution for the last problem. So my (hopefully) final command line is:
setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine ADDLOCAL=SQL_BC_DEP INSTANCENAME=Z1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=XXXXXX
Wednesday, February 15, 2012
error 20534
I am trying to print crystal reports from my VB
program. I have this command in my VB program
CrystalReports1.Action=1. My program is breaking
right here. It is gving me error , Error Detected by
database DLL. Err Msg: 20534. I searched this error
> code in google and saw that I can bypass this errror
> by writing
#Const fDebug = true
Dim logon as integer
On Error GoTo traperror:
With CrystalReport1
.ReportFileName = <path to report file>
logon = .LogOnServer("pdsodbc.dll","<Your
DSN>","","","")
.Action = 1
End With
Traperror:
#If fDebug = true then
If Err.Number = 20534 Then
CrystalReport1.Action = 1
End If
#End If
My program goes in this statement but breaks again
at crystalreport1.action=1. It breaks inside the
trap error label. Please anyone let me know what can
I do to avoid this error.
Any help will be greatly appreciated.
Thanks.Can be caused by a number of things...like ODBC Text Driver in VB6 SP3, like using subreport in your report and not passing login info to subreport, like incorrectly formned parameters, etc.
Given previous experience, I'd bet on a subreport, an incorrectly formed statement passed to .LogonServer, or a dodgy ODBC driver.
You should be using PDB*.DLL for standard (non-SQL) databases, and PDS*.DLL for SQL/ODBC databases....
Dave