Can't complete SQL Server 2005 installation!!!

An err occurs when the installation of SQL Server 2005 ,"failed to start" SQL Server , the err msg asks me to query online menually,includes "SQL Server 2005 Setup Log Files and Starting SQL Server Manually." but I don't know what is the problem. Can you help me?

You first need to look at the SQL Server summary log file located at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\summary.txt. This should direct you to which component is failing and the log file for that component. When looking at the component log files you can easily locate the trouble area by searching the file for "value 3" - this will jump you to the area of the log file that contains the error. Reply back with the section of the log file that contains the error.

If this log file doesn't specify a particular component you need to look at the core log file located at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files\*core*.log. You should find the error at the bottom of this log file. If there error is in this log file please reply back with the section of the log file that contains the error.

Thanks,

Dan

|||Hello,Dan：
I found the two files, and i knew that what component is failing, but I don't know clearly you mean "value 3."

this is the failing component in summary.txt
--
Machine : PROJECTTEAM
Product : Microsoft SQL Server 2005 CTP
Product Version : 9.00.1116
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0013_PROJECTTEAM_SQL.log
Error Number : 2147944003

The file is the component log file,I don't know how to find the
cause of error,can you help me?
http://ms.ntcb.edu.tw/~s8856094/SQL/SQLSetup0013_PROJECTTEAM_SQL.log
Thank you..|||Okay, the service is failing to start. I need to direct you to yet another log file. In the middle of setup you will find a log file for the SQL Server DB Engine under the installation folder for this component. If you are installing on a clean machine it will be under c:\program files\microsoft sql server\mssql.1\log. This file will specify why the service couldn't start up.

Dan

p.s. "Value 3" is nothing special other than the MSI return code for failures. It's an easy thing to search on to find the actual text of the error message in the log. In your case it pointed me to the following error:

Error 29523. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067)|||I'm going to close out this thread since there hasn't been a response to my question in three weeks.
Dan|||Most of the above applies to my case as well.
The best clue I have to the failure is this event log item:
Event Type: Warning
Event Source: WinMgmt
Event Category: None
Event ID: 5603
Date: 8/10/2005
Time: 8:16:07 AM
User: WINGS\rheitzman
Computer: PC3090-060
Description:
A provider, SQLServerEventProvider, has been registered in the WMI namespace, root\Microsoft\SqlServer\ServerEvents\SQLEXPRESS, but did not specify the HostingModel property. This provider will be run using the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests. Ensure that provider has been reviewed for security behavior and update the HostingModel property of the provider registration to an account with the least privileges possible for the required functionality.
The SQLExpress install proceeds OK to the midpoint of installing the Database Services that halts with the message that began this thread.
I tried to restart the service beore canceling the install to no avail. Canceling the install backs out the install so the directions to start manually are bogus since the service(s) is removed.
Beta 1 was installed and the removal tool has been used; serveral times.
SQL Server 2000 reporting services was installed at one time and was also problematic. It was removed via add/remove.
Any help would be appreciated!

Can't access SQL Server Reporting Services URL anymore

Hi all,
We've had a Reporting Services installation for nearly 6 months now with no
problems. Reporting Services is installed on a Windows 2003 machine which is
connecting to SQL Server 2000 databases.
This morning, it was reporting that the URL to access the report server
(http://server/reports) is returning the following error message:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Not sure where to go from here. Nothing has changed as far as we can tell.
Thanks,
JasonThere's also an error in the event log of the Reporting Services machine that
states:
Report Server cannot connect to the report server database.
How do I re-establish this connection? The database still resides on the
same server, same name as before. I am not sure how this happened.
"Jason" wrote:
> Hi all,
> We've had a Reporting Services installation for nearly 6 months now with no
> problems. Reporting Services is installed on a Windows 2003 machine which is
> connecting to SQL Server 2000 databases.
> This morning, it was reporting that the URL to access the report server
> (http://server/reports) is returning the following error message:
>
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> Not sure where to go from here. Nothing has changed as far as we can tell.
> Thanks,
> Jason
>

can't access named instance by it's name

Hi,

I have sql2005 sp1 active-active installation.

I've fixed the named instance port.

I can't reach it from clients with i'ts name (servername\instancename) .

I manage to rech it only by using servername, ip-port.

The sql browser has the following error:

"The configuration of the AdminConnection\TCP protocol in the SQL instance GILBOACL is not valid."

your help is appreciated!

Shahar

1. Is UPD port 1434 open?
2. Does the browser service account have access to the registry key? See the following article for more info.
http://support.microsoft.com/kb/905618

Can't access msde installation from network

I've installed a msde copy on a Win2000 pro computer, but when I try to
connect to it from another computer, it doesn't allow me to log on. Is it a
internal limit?
MSDE doesn't by default have network connectivity turned on. Enable using svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hawz" <ohawz@.hotmail.com> wrote in message news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> I've installed a msde copy on a Win2000 pro computer, but when I try to
> connect to it from another computer, it doesn't allow me to log on. Is it a
> internal limit?
>
|||I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
connected. It says "General network error. Please check network document
ConnectionOpen (PreLoginHandshake()"
And I also can't use telnet to connect to 1433 port.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> MSDE doesn't by default have network connectivity turned on. Enable using
svrnetcn.exe.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Hawz" <ohawz@.hotmail.com> wrote in message
news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
it a
>
|||Perhaps there's a firewall in between?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hawz" <ohawz@.hotmail.com> wrote in message news:%2324RZQ7NEHA.644@.tk2msftngp13.phx.gbl...
> I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
> connected. It says "General network error. Please check network document
> ConnectionOpen (PreLoginHandshake()"
> And I also can't use telnet to connect to 1433 port.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> svrnetcn.exe.
> news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> it a
>
|||This might help:
http://support.microsoft.com/default...b;en-us;826829
-oj
http://www.rac4sql.net
"Hawz" <ohawz@.hotmail.com> wrote in message
news:%2324RZQ7NEHA.644@.tk2msftngp13.phx.gbl...
> I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
> connected. It says "General network error. Please check network document
> ConnectionOpen (PreLoginHandshake()"
> And I also can't use telnet to connect to 1433 port.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> svrnetcn.exe.
> news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> it a
>

Cann't uninstall an instance

I once tried to uninstall a single default instance of sql2000, using
the installation CD. Unfortunately, it was taking forever and I killed
the process. After I rebooted the server and tried to uninstall again, I
got the error, saying uninstall file could not be found, or something
was missing...
I tried to re-install the default instance to correct it. However, I
could not get the default instance back. As a result, I could not
re-install it and I could not uninstall it.
How can I manually uninstall the instance?
Thank you.
I found myself an article and will go from there...
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/default...290991&sd=tech
Jluo wrote:
> I once tried to uninstall a single default instance of sql2000, using
> the installation CD. Unfortunately, it was taking forever and I killed
> the process. After I rebooted the server and tried to uninstall again, I
> got the error, saying uninstall file could not be found, or something
> was missing...
> I tried to re-install the default instance to correct it. However, I
> could not get the default instance back. As a result, I could not
> re-install it and I could not uninstall it.
> How can I manually uninstall the instance?
> Thank you.
>

Cann't uninstall an instance

I once tried to uninstall a single default instance of sql2000, using
the installation CD. Unfortunately, it was taking forever and I killed
the process. After I rebooted the server and tried to uninstall again, I
got the error, saying uninstall file could not be found, or something
was missing...
I tried to re-install the default instance to correct it. However, I
could not get the default instance back. As a result, I could not
re-install it and I could not uninstall it.
How can I manually uninstall the instance?
Thank you.I found myself an article and will go from there...
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/defaul...;290991&sd=tech
Jluo wrote:
> I once tried to uninstall a single default instance of sql2000, using
> the installation CD. Unfortunately, it was taking forever and I killed
> the process. After I rebooted the server and tried to uninstall again, I
> got the error, saying uninstall file could not be found, or something
> was missing...
> I tried to re-install the default instance to correct it. However, I
> could not get the default instance back. As a result, I could not
> re-install it and I could not uninstall it.
> How can I manually uninstall the instance?
> Thank you.
>

Cann't uninstall an instance

I once tried to uninstall a single default instance of sql2000, using
the installation CD. Unfortunately, it was taking forever and I killed
the process. After I rebooted the server and tried to uninstall again, I
got the error, saying uninstall file could not be found, or something
was missing...
I tried to re-install the default instance to correct it. However, I
could not get the default instance back. As a result, I could not
re-install it and I could not uninstall it.
How can I manually uninstall the instance?
Thank you.I found myself an article and will go from there...
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991&sd=tech
Jluo wrote:
> I once tried to uninstall a single default instance of sql2000, using
> the installation CD. Unfortunately, it was taking forever and I killed
> the process. After I rebooted the server and tried to uninstall again, I
> got the error, saying uninstall file could not be found, or something
> was missing...
> I tried to re-install the default instance to correct it. However, I
> could not get the default instance back. As a result, I could not
> re-install it and I could not uninstall it.
> How can I manually uninstall the instance?
> Thank you.
>

cannot view job properties. i keep getting "new job" dialog box.

In my installation of sql server 2005, i cannot view any job properties. when i doubble click on a job, i just get the "new job" dialog box. when i right click on a job and select properties, i also get the "new job" dialog box. i have reinstalled sql server workstation components and restarted but it did not fix the issue. anyone ever have this issue

post back the Service Pack in this box

Madhu

|||

i reinstalled sql server completely and it works now. pitty i had to waste so much time doing that. have no idea why it would do what it done. no updates or serivce packs added in weeks and it has worked fine for the last ages.|||

I've seen this error a few times. It has to do with one of the Visual Studio installs or service packs on the PC you are using to view the job properties. Applying SQL Server service pack 2 fixes the problem.

-Sue

|||

Also it may be issue with client tools on this machine, see whether you can reproduce from another machine with similar tools.

|||

Exact same scenario here. I was hoping for a nice clean fix but I guess this one is going to be painful.

|||What service pack of the tools do you have? Did it just start happening or is it an ongoing problem? Did anything change on the server or client?

|||It just started happening. I did install sp2 for sql but that was many weeks ago and it had been working fine. it was just a sudden thing. i was using it one morning and it was fine, and that afternoon it all went pear shaped.
|||Hmmm, nothing in the error log for the machine? And re-applying sp2 to the tools didn't fix it? (i.e. it wasn't a broken DLL somewhere)?

|||

I have the same problem:

SQL Server 2005 sp2 X64 clustered. There are no messages in any of the error logs. I did find this when I traced the server when I tired to view the properties of a job.

Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission.

I am a sysadmin. I just set this server up.

Thanks,

|||I reinstalled SQL Server SP 2 twice and it seemed to fix the problem

|||

You need to reapply SP2. Just having SP2 installed doesn't mean it's protected from this issue. I've dealt with this one a few times - One of the dlls gets overwritten. I've seen it when SP2 was already installed and reapplying the service pack fixes the issue.

-Sue

|||

I had this same problem and I had to install SQL Server 2005 SP 2 twice and that seem to fix the problem.

Cannot Upgrade MSDE 2000 Sp3 to SP4

Hi!

Here's the scenario:

I have a MSDE 2000 installation running, already patched to SP3. Instancename is "STO". I've downloaded SQL2000.MSDE-KB884525-SP4-X86-ENU.exe and extracted the archive to C:\SQL2KSP4.

After starting setup from the command prompt with "setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*V C:\MSDELog.log" i get a message box, telling me "The product is not installed". This happens even if I specify the exact instancename and supply the sa user and pwd!

Any ideas?`

Thanks in advance and regards

Clemens

In your command line, you need to specify the instance name and sa pass word. Would you try the following command line?

start /wait setup.exe /qb INSTANCENAME=sto SAPWD="<sa pass word>" SECURITYMODE=SQL

|||

Thx for your reply, but if you look at my post above, you'll see that i also tried that! ;-)

Quote:

"This happens even if I specify the exact instancename and supply the sa user and pwd!"

Rgds

Clemens

|||In your command line, you do not specify the instance name. It is required for an upgrading. Would you check and try?

Cannot shrink transaction log of a SQL Server 2005 db

I have a SQL Server 2005 db for a Navision installation.
I have tried to execute DBCC Shrinkfile on the related transaction log after
the running of backup log. I have had this error:
"Cannot shrink log file 2 (...) because all logical log files are in use".
The transaction log is of 15 GB!
I know that it is possible to reduce the space of the log while the db is in
use.
How can I solve this issue?
Many thanksOpen transaction? Check using DBCC OPENTRAN.
Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>I have a SQL Server 2005 db for a Navision installation.
> I have tried to execute DBCC Shrinkfile on the related transaction log after
> the running of backup log. I have had this error:
> "Cannot shrink log file 2 (...) because all logical log files are in use".
> The transaction log is of 15 GB!
> I know that it is possible to reduce the space of the log while the db is in
> use.
> How can I solve this issue?
> Many thanks
>|||I have executed DBCC OPENTRAN(MyDB) and
there aren't any active transactions.
The DBCC SQLPERF(LOGSPACE) return 4% used for the log.
"Tibor Karaszi" wrote:
> Open transaction? Check using DBCC OPENTRAN.
> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
> >I have a SQL Server 2005 db for a Navision installation.
> > I have tried to execute DBCC Shrinkfile on the related transaction log after
> > the running of backup log. I have had this error:
> > "Cannot shrink log file 2 (...) because all logical log files are in use".
> > The transaction log is of 15 GB!
> > I know that it is possible to reduce the space of the log while the db is in
> > use.
> >
> > How can I solve this issue?
> >
> > Many thanks
> >
>|||I have executed a complete backup of the db after logging out of the users
from Navision. So I have executed first the backup log (copy and truncate)
and then the dbcc shrinkfile for three times.
I have obtained a log of 320 MB from 15 GB, but I have always the same error:
"Cannot shrink log file 2 (..._Log) because all logical log files are in use".
Do you have any suggests to understand this error?
Thanks
"Tibor Karaszi" wrote:
> Open transaction? Check using DBCC OPENTRAN.
> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
> >I have a SQL Server 2005 db for a Navision installation.
> > I have tried to execute DBCC Shrinkfile on the related transaction log after
> > the running of backup log. I have had this error:
> > "Cannot shrink log file 2 (...) because all logical log files are in use".
> > The transaction log is of 15 GB!
> > I know that it is possible to reduce the space of the log while the db is in
> > use.
> >
> > How can I solve this issue?
> >
> > Many thanks
> >
>|||Did you investigate the virtual log file layout as suggested i my article?
Also, are you saying that you got it down to 320 MB, and want to shrink it further? If so, why? See
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/02/25/leaking-roof-and-file-shrinking.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:A3FEF114-AB29-41E5-A260-6B451C39706D@.microsoft.com...
>I have executed a complete backup of the db after logging out of the users
> from Navision. So I have executed first the backup log (copy and truncate)
> and then the dbcc shrinkfile for three times.
> I have obtained a log of 320 MB from 15 GB, but I have always the same error:
> "Cannot shrink log file 2 (..._Log) because all logical log files are in use".
> Do you have any suggests to understand this error?
> Thanks
>
> "Tibor Karaszi" wrote:
>> Open transaction? Check using DBCC OPENTRAN.
>> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>> >I have a SQL Server 2005 db for a Navision installation.
>> > I have tried to execute DBCC Shrinkfile on the related transaction log after
>> > the running of backup log. I have had this error:
>> > "Cannot shrink log file 2 (...) because all logical log files are in use".
>> > The transaction log is of 15 GB!
>> > I know that it is possible to reduce the space of the log while the db is in
>> > use.
>> >
>> > How can I solve this issue?
>> >
>> > Many thanks
>> >
>>|||320 MB for the log is enough for me, absolutely!
I want to underline that I have still the error every time that I shrink the
log.
"Tibor Karaszi" wrote:
> Did you investigate the virtual log file layout as suggested i my article?
> Also, are you saying that you got it down to 320 MB, and want to shrink it further? If so, why? See
> http://sqlblog.com/blogs/tibor_karaszi/archive/2007/02/25/leaking-roof-and-file-shrinking.aspx
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:A3FEF114-AB29-41E5-A260-6B451C39706D@.microsoft.com...
> >I have executed a complete backup of the db after logging out of the users
> > from Navision. So I have executed first the backup log (copy and truncate)
> > and then the dbcc shrinkfile for three times.
> > I have obtained a log of 320 MB from 15 GB, but I have always the same error:
> > "Cannot shrink log file 2 (..._Log) because all logical log files are in use".
> >
> > Do you have any suggests to understand this error?
> >
> > Thanks
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> Open transaction? Check using DBCC OPENTRAN.
> >>
> >> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
> >> >I have a SQL Server 2005 db for a Navision installation.
> >> > I have tried to execute DBCC Shrinkfile on the related transaction log after
> >> > the running of backup log. I have had this error:
> >> > "Cannot shrink log file 2 (...) because all logical log files are in use".
> >> > The transaction log is of 15 GB!
> >> > I know that it is possible to reduce the space of the log while the db is in
> >> > use.
> >> >
> >> > How can I solve this issue?
> >> >
> >> > Many thanks
> >> >
> >>
> >>
>|||As I stated twice before, the answer is in the virtual log file layout. Also, minimum number of
virtual log files is 2 or 4 (I don't remember).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:37F476C6-F5C1-4C15-8AD1-39ED6C5275D9@.microsoft.com...
> 320 MB for the log is enough for me, absolutely!
> I want to underline that I have still the error every time that I shrink the
> log.
>
> "Tibor Karaszi" wrote:
>> Did you investigate the virtual log file layout as suggested i my article?
>> Also, are you saying that you got it down to 320 MB, and want to shrink it further? If so, why?
>> See
>> http://sqlblog.com/blogs/tibor_karaszi/archive/2007/02/25/leaking-roof-and-file-shrinking.aspx
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:A3FEF114-AB29-41E5-A260-6B451C39706D@.microsoft.com...
>> >I have executed a complete backup of the db after logging out of the users
>> > from Navision. So I have executed first the backup log (copy and truncate)
>> > and then the dbcc shrinkfile for three times.
>> > I have obtained a log of 320 MB from 15 GB, but I have always the same error:
>> > "Cannot shrink log file 2 (..._Log) because all logical log files are in use".
>> >
>> > Do you have any suggests to understand this error?
>> >
>> > Thanks
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> Open transaction? Check using DBCC OPENTRAN.
>> >>
>> >> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://sqlblog.com/blogs/tibor_karaszi
>> >>
>> >>
>> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> >> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>> >> >I have a SQL Server 2005 db for a Navision installation.
>> >> > I have tried to execute DBCC Shrinkfile on the related transaction log after
>> >> > the running of backup log. I have had this error:
>> >> > "Cannot shrink log file 2 (...) because all logical log files are in use".
>> >> > The transaction log is of 15 GB!
>> >> > I know that it is possible to reduce the space of the log while the db is in
>> >> > use.
>> >> >
>> >> > How can I solve this issue?
>> >> >
>> >> > Many thanks
>> >> >
>> >>
>> >>
>>|||I'm not sure if this helps but, below is what I do to shrink and clean the
tlogs.
USE [mydb];
GO
BACKUP LOG [mydb] WITH TRUNCATE_ONLY;
GO
DBCC SHRINKFILE (mydb_Log, EMPTYFILE);
GO
DBCC SHRINKDATABASE('mydb')
GO
"Pasquale" wrote:
> I have a SQL Server 2005 db for a Navision installation.
> I have tried to execute DBCC Shrinkfile on the related transaction log after
> the running of backup log. I have had this error:
> "Cannot shrink log file 2 (...) because all logical log files are in use".
> The transaction log is of 15 GB!
> I know that it is possible to reduce the space of the log while the db is in
> use.
> How can I solve this issue?
> Many thanks
>

Cannot shrink transaction log of a SQL Server 2005 db

I have a SQL Server 2005 db for a Navision installation.
I have tried to execute DBCC Shrinkfile on the related transaction log after
the running of backup log. I have had this error:
"Cannot shrink log file 2 (...) because all logical log files are in use".
The transaction log is of 15 GB!
I know that it is possible to reduce the space of the log while the db is in
use.
How can I solve this issue?
Many thanks
I have executed DBCC OPENTRAN(MyDB) and
there aren't any active transactions.
The DBCC SQLPERF(LOGSPACE) return 4% used for the log.
"Tibor Karaszi" wrote:

> Open transaction? Check using DBCC OPENTRAN.
> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>
|||I have executed a complete backup of the db after logging out of the users
from Navision. So I have executed first the backup log (copy and truncate)
and then the dbcc shrinkfile for three times.
I have obtained a log of 320 MB from 15 GB, but I have always the same error:
"Cannot shrink log file 2 (..._Log) because all logical log files are in use".
Do you have any suggests to understand this error?
Thanks
"Tibor Karaszi" wrote:

> Open transaction? Check using DBCC OPENTRAN.
> Also, details on shrinking found at http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>
|||320 MB for the log is enough for me, absolutely!
I want to underline that I have still the error every time that I shrink the
log.
"Tibor Karaszi" wrote:

> Did you investigate the virtual log file layout as suggested i my article?
> Also, are you saying that you got it down to 320 MB, and want to shrink it further? If so, why? See
> http://sqlblog.com/blogs/tibor_karaszi/archive/2007/02/25/leaking-roof-and-file-shrinking.aspx
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:A3FEF114-AB29-41E5-A260-6B451C39706D@.microsoft.com...
>
|||I'm not sure if this helps but, below is what I do to shrink and clean the
tlogs.
USE [mydb];
GO
BACKUP LOG [mydb] WITH TRUNCATE_ONLY;
GO
DBCC SHRINKFILE (mydb_Log, EMPTYFILE);
GO
DBCC SHRINKDATABASE('mydb')
GO
"Pasquale" wrote:

> I have a SQL Server 2005 db for a Navision installation.
> I have tried to execute DBCC Shrinkfile on the related transaction log after
> the running of backup log. I have had this error:
> "Cannot shrink log file 2 (...) because all logical log files are in use".
> The transaction log is of 15 GB!
> I know that it is possible to reduce the space of the log while the db is in
> use.
> How can I solve this issue?
> Many thanks
>

Cannot shrink transaction log of a SQL Server 2005 db

I have a SQL Server 2005 db for a Navision installation.
I have tried to execute DBCC Shrinkfile on the related transaction log after
the running of backup log. I have had this error:
"Cannot shrink log file 2 (...) because all logical log files are in use".
The transaction log is of 15 GB!
I know that it is possible to reduce the space of the log while the db is in
use.
How can I solve this issue?
Many thanksOpen transaction? Check using DBCC OPENTRAN.
Also, details on shrinking found at http://www.karaszi.com/SQLServer/in...
ink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>I have a SQL Server 2005 db for a Navision installation.
> I have tried to execute DBCC Shrinkfile on the related transaction log aft
er
> the running of backup log. I have had this error:
> "Cannot shrink log file 2 (...) because all logical log files are in use".
> The transaction log is of 15 GB!
> I know that it is possible to reduce the space of the log while the db is
in
> use.
> How can I solve this issue?
> Many thanks
>|||I have executed DBCC OPENTRAN(MyDB) and
there aren't any active transactions.
The DBCC SQLPERF(LOGSPACE) return 4% used for the log.
"Tibor Karaszi" wrote:

> Open transaction? Check using DBCC OPENTRAN.
> Also, details on shrinking found at http://www.karaszi.com/SQLServer/in...r />
hrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:BF7E5E86-D439-47DA-B469-68526A22A19F@.microsoft.com...
>|||I'm not sure if this helps but, below is what I do to shrink and clean the
tlogs.
USE [mydb];
GO
BACKUP LOG [mydb] WITH TRUNCATE_ONLY;
GO
DBCC SHRINKFILE (mydb_Log, EMPTYFILE);
GO
DBCC SHRINKDATABASE('mydb')
GO
"Pasquale" wrote:

> I have a SQL Server 2005 db for a Navision installation.
> I have tried to execute DBCC Shrinkfile on the related transaction log aft
er
> the running of backup log. I have had this error:
> "Cannot shrink log file 2 (...) because all logical log files are in use".
> The transaction log is of 15 GB!
> I know that it is possible to reduce the space of the log while the db is
in
> use.
> How can I solve this issue?
> Many thanks
>

cannot setup SQL server 2000 service account during installation

Hi, i tried to install MS SQL server 2000 in my XP system but during the setup service account installation, i tried to use a domain user account but it cannot validate my user name and password. I used my windows administrator logon account and password. Please help..thank you.

Thanks : :confused:If you successfully installed SQL Server 2000, now you may change the user of the service accounts in the services (My Computer->Services and Applications->Services).

Paulo|||Thank you for your reply but this happened during the installation and i do not wish to install SQL server using the local system account for the service account as i need it to work over the network, SQL mail, backup and etc.

Thanks|||Thank you for your reply but this happened during the installation and i do not wish to install SQL server using the local system account for the service account as i need it to work over the network, SQL mail, backup and etc.

Thanks

The use of the Local System Account for the service account makes sure that no matter what, the SQL Server will be running. Even if the Domain/AD/Network is down the SQL server will be running.

Using the Local System Account for the system account does/should not affect whether or not the server is visable over the network. Enable TCP/IP, named pipes, etc. as a server communication protocol and it will be visable and then determine how you want people to authenticate to the server(Windows or SQL Server authentication)

Have Fun...

Cannot run apparently successful installation of SQL Server Express

I am completely new to SQL Server, and have downloaded and installed Visual Web Developer and Visual Basic Express without problems
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.

No doubt this is a very simple error or series of errors by me, but I would appreciate help.

Many thanks.

Nick

I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.

1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.

2. Alternatively, try to start it from command line by:

net start mssql$sqlexpress

|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick

Cannot run apparently successful installation of SQL Server Express

I am completely new to SQL Server, and have downloaded and installed Visual Web Developer and Visual Basic Express without problems
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.

No doubt this is a very simple error or series of errors by me, but I would appreciate help.

Many thanks.

Nick

I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.

1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.

2. Alternatively, try to start it from command line by:

net start mssql$sqlexpress

|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick