Log on problem

Why I can't make change account from Log on tab in properties MSSQLSERVER
service?
Regardless of account, I gett this error: "Could not start the MSSQLSERVER
service on Local Computer.
Error 1096: The service did not start to a logon failure."
SQL Server does work only with Local system account?!
Thanks
(MS SQLserver 2000 , WinXP SP2)
You should never change the account directly thru the service. You need to
use Enterprise Manager instead as it sets other rights and properties that
the service panel does not.
Andrew J. Kelly SQL MVP
"ER" <vladoer@.email.t-com.hr> wrote in message
news:dufrvi$rlq$1@.ss405.t-com.hr...
> Why I can't make change account from Log on tab in properties MSSQLSERVER
> service?
> Regardless of account, I gett this error: "Could not start the MSSQLSERVER
> service on Local Computer.
> Error 1096: The service did not start to a logon failure."
> SQL Server does work only with Local system account?!
> Thanks
> (MS SQLserver 2000 , WinXP SP2)
>
|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%235vQSLSQGHA.564@.TK2MSFTNGP12.phx.gbl...
> You should never change the account directly thru the service. You need to
> use Enterprise Manager instead as it sets other rights and properties that
> the service panel does not.
> --
> Andrew J. Kelly SQL MVP
I gett error all the same
|||Are there any msgs in the event logs? Does it work with the local admin
account?
Andrew J. Kelly SQL MVP
"ER" <vladoer@.email.t-com.hr> wrote in message
news:duihmd$ru9$1@.ss405.t-com.hr...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%235vQSLSQGHA.564@.TK2MSFTNGP12.phx.gbl...
> I gett error all the same
>
|||Andrew J. Kelly wrote:
> You should never change the account directly thru the service. You need to
> use Enterprise Manager instead as it sets other rights and properties that
> the service panel does not.
>
Just curious - which right is it that's being applied though EM and not
in the services panel?
I normally handle all changes to services from the services panel and I
don't recall that I've ever had problems with that.
Regards
Steen
|||It depends upon the permissions configured for the new account. For instance
if you use the service panel to change a SQL Server service to run using
some administrator account, you probably won't have a problem. But if you
use the service panel to change a SQL Server service to to run under a low
priveledged user, then SQL Server might not be able to access sqlservr.exe
on the file system (and a bunch of other stuff). But if you use the SQL
Server tools, the tools will check to make sure the new account has adequate
access.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:uHsEWEsQGHA.336@.TK2MSFTNGP12.phx.gbl...
> Andrew J. Kelly wrote:
> Just curious - which right is it that's being applied though EM and not in
> the services panel?
> I normally handle all changes to services from the services panel and I
> don't recall that I've ever had problems with that.
> Regards
> Steen
|||I have solved the problem. The difficulty was that I had a User Account
without password in my machine.
Thanks for your answer.
|||Rick Byham [MS] wrote:
> It depends upon the permissions configured for the new account. For instance
> if you use the service panel to change a SQL Server service to run using
> some administrator account, you probably won't have a problem. But if you
> use the service panel to change a SQL Server service to to run under a low
> priveledged user, then SQL Server might not be able to access sqlservr.exe
> on the file system (and a bunch of other stuff). But if you use the SQL
> Server tools, the tools will check to make sure the new account has adequate
> access.
Ok - that makes sense.
Regards
Steen

log in failed for user [servername]\ASPNET

can anyone help me with this error message, i follow the instruction of someone in other forum, but i cant find where the SQL Server Enterprise manager is, i am using MSDE.One way To see SQL Server Enterprise manager is to install SQL server :)|||If you don't have Enterprise Manage, you can use the command-line utility OSQL that comes with SQL Server.

Go to the command prompt and type in:

osql -S [servername]\instancename -E -q

You will have a 1> prompt.

use yourdatabasename
go
EXEC sp_grantlogin '[servername]\ASPNET'
go
EXEC sp_grantdbaccess '[servername]\ASPNET''
go

You can also read this post by David Wier:Error Using Trusted Connection in DB Connection String. I don't recommend adding the ASPNET account as a db_owner, however, so I'd leave off that command at the end.

Terri

Log file won't Shrink in Simple Recovery Mode

Ok, I know there are a TON of threads out there on this but I still can't find exactly what I am looking for.
I have a 4GB DB with a 1GB log file. Backups are done nightly and written to a NAS via UNC path. When I went home on Friday the log was 200MB -- this morning it was 1GB. As I stated the recovery model is set to simple so it should just reuse itself. I
issued a DBCC loginfo to see that each part of the log was a status 2. I then tried a backup log... with truncate_only and backup log...with no_log. This did not reclaim any space.
I have exhausted what I THOUGHT I knew about simple recovery. If anyone else has an idea, please post!
It has always been my understanding that
If there are a lot of VLF's with a status of 2 that means you have
uncommitted transactions in them. What does DBCC OPENTRAN() say?
Andrew J. Kelly SQL MVP
"Dave Harper" <Dave Harper@.discussions.microsoft.com> wrote in message
news:5F3AE072-8C13-444B-9C0B-E21BA3C7F717@.microsoft.com...
> Ok, I know there are a TON of threads out there on this but I still can't
find exactly what I am looking for.
> I have a 4GB DB with a 1GB log file. Backups are done nightly and written
to a NAS via UNC path. When I went home on Friday the log was 200MB -- this
morning it was 1GB. As I stated the recovery model is set to simple so it
should just reuse itself. I issued a DBCC loginfo to see that each part of
the log was a status 2. I then tried a backup log... with truncate_only and
backup log...with no_log. This did not reclaim any space.
> I have exhausted what I THOUGHT I knew about simple recovery. If anyone
else has an idea, please post!
> It has always been my understanding that
|||Is there any open transaction? DBCC OPENTRAN.
Was there any replication properties set on for this database?
"Dave Harper" <Dave Harper@.discussions.microsoft.com> wrote in message
news:5F3AE072-8C13-444B-9C0B-E21BA3C7F717@.microsoft.com...
> Ok, I know there are a TON of threads out there on this but I still can't
find exactly what I am looking for.
> I have a 4GB DB with a 1GB log file. Backups are done nightly and written
to a NAS via UNC path. When I went home on Friday the log was 200MB -- this
morning it was 1GB. As I stated the recovery model is set to simple so it
should just reuse itself. I issued a DBCC loginfo to see that each part of
the log was a status 2. I then tried a backup log... with truncate_only and
backup log...with no_log. This did not reclaim any space.
> I have exhausted what I THOUGHT I knew about simple recovery. If anyone
else has an idea, please post!
> It has always been my understanding that
|||There were 10 open trans in the DB
"Andrew J. Kelly" wrote:

> If there are a lot of VLF's with a status of 2 that means you have
> uncommitted transactions in them. What does DBCC OPENTRAN() say?
> --
> Andrew J. Kelly SQL MVP
>
> "Dave Harper" <Dave Harper@.discussions.microsoft.com> wrote in message
> news:5F3AE072-8C13-444B-9C0B-E21BA3C7F717@.microsoft.com...
> find exactly what I am looking for.
> to a NAS via UNC path. When I went home on Friday the log was 200MB -- this
> morning it was 1GB. As I stated the recovery model is set to simple so it
> should just reuse itself. I issued a DBCC loginfo to see that each part of
> the log was a status 2. I then tried a backup log... with truncate_only and
> backup log...with no_log. This did not reclaim any space.
> else has an idea, please post!
>
>
|||Well that will sure do it<g>.
Andrew J. Kelly SQL MVP
"Dave Harper" <DaveHarper@.discussions.microsoft.com> wrote in message
news:9DA36206-3F23-4464-AD81-EABEF886FB82@.microsoft.com...[vbcol=seagreen]
> There were 10 open trans in the DB
> "Andrew J. Kelly" wrote:
can't[vbcol=seagreen]
written[vbcol=seagreen]
this[vbcol=seagreen]
it[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
anyone[vbcol=seagreen]
|||There were 10 open.
"Richard Ding" wrote:

> Is there any open transaction? DBCC OPENTRAN.
> Was there any replication properties set on for this database?
> "Dave Harper" <Dave Harper@.discussions.microsoft.com> wrote in message
> news:5F3AE072-8C13-444B-9C0B-E21BA3C7F717@.microsoft.com...
> find exactly what I am looking for.
> to a NAS via UNC path. When I went home on Friday the log was 200MB -- this
> morning it was 1GB. As I stated the recovery model is set to simple so it
> should just reuse itself. I issued a DBCC loginfo to see that each part of
> the log was a status 2. I then tried a backup log... with truncate_only and
> backup log...with no_log. This did not reclaim any space.
> else has an idea, please post!
>
>
|||Yes and no...(I think)
Even if there are open transactions; shouldn't sql be able to reclaim the space that was before the LSN of those transactions? I understand that that portion of the log can't be reclaimed, but shouldn't the older?
The only other thing I can think of is would have I a transaction that say starts now and runs for 12 hours, just holding a resource open and not allowing that portion of the log to be 'checkpointed'?
Would I just cancel the SPIDS submitting those transactions so that there are NO transactions occuring? Also why would sql care if it is in simple recovery mode?
Thanks for all you help.
"Andrew J. Kelly" wrote:

> Well that will sure do it<g>.
> --
> Andrew J. Kelly SQL MVP
>
> "Dave Harper" <DaveHarper@.discussions.microsoft.com> wrote in message
> news:9DA36206-3F23-4464-AD81-EABEF886FB82@.microsoft.com...
> can't
> written
> this
> it
> of
> and
> anyone
>
>
|||Dave,
A log file works in a round robin format. It starts adding transactions
sequentially from the beginning to the end. Once it gets to the end it will
wrap around only if the first VLF is free and has no uncommitted
transactions. Otherwise it will grow the log and continue on. If you have
an open tran for 12 hours you have some serious issues with your app. A
transaction should ideally be open for seconds at the very most. You
absolutely need to find out who is keeping these trans open and why.
Whether you kill them or not is up to you but you have to either commit them
or roll them back.
Andrew J. Kelly SQL MVP
"Dave Harper" <DaveHarper@.discussions.microsoft.com> wrote in message
news:DD934F0C-13B9-4E67-876E-DB027E285BAF@.microsoft.com...
> Yes and no...(I think)
> Even if there are open transactions; shouldn't sql be able to reclaim the
space that was before the LSN of those transactions? I understand that that
portion of the log can't be reclaimed, but shouldn't the older?
> The only other thing I can think of is would have I a transaction that say
starts now and runs for 12 hours, just holding a resource open and not
allowing that portion of the log to be 'checkpointed'?
> Would I just cancel the SPIDS submitting those transactions so that there
are NO transactions occuring? Also why would sql care if it is in simple
recovery mode?[vbcol=seagreen]
> Thanks for all you help.
> "Andrew J. Kelly" wrote:
message[vbcol=seagreen]
still[vbcol=seagreen]
200MB --[vbcol=seagreen]
so[vbcol=seagreen]
part[vbcol=seagreen]
truncate_only[vbcol=seagreen]

Log file is too large

Hi
I want to clean up my log file (LDF extension) cause is ocupying much space
from the computer server. I'm using 2000 version and can't erase it using
DELETE
button from properties of the database.
What should I do? Is that possible?
Thanks in advance
Hi,
Backup the trasnaction log and shrink the transaction log file.
Have a look into the below article,
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default...b;en-us;272318
http://www.support.microsoft.com/?id=315512
Thanks
Hari
SQL Server MVP
"Katty" <Katty@.discussions.microsoft.com> wrote in message
news:A366CB5F-DF6E-4E16-B374-D452C2599C1C@.microsoft.com...
> Hi
> I want to clean up my log file (LDF extension) cause is ocupying much
> space
> from the computer server. I'm using 2000 version and can't erase it using
> DELETE
> button from properties of the database.
> What should I do? Is that possible?
> Thanks in advance
sql

Log file cant acquire connection while working offline

hi

As I trun Work offline - true, my connection manager for log file says-it cant acquire connection while work offline is true.Where as other oledb connections work fine.

Even it tried to get around by putting DelayValidation as true, but didnt work.

Is there is anyother setting that has be set.

Thanks and Regards

Rahul Kumar

Hello, are you referring to messages you see when you open the package with 'Work Offline'=true?

When you say "work fine" do you mean you can open the package and do not see any messages related to the OLEDB connections?

Thank you

|||

Are there any tasks using the connection managers that apparently don't throw any errors?

-Jamie

|||

I think this thread is related... I think the error is received while executing the package:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1005760&SiteID=1

|||

Hi Craig,

I mean, when i run the package without having log file connection(which uses file connection) and work offline-true,delayvalidation-true with oledb connections, package returns no error and does the purpose.

Where as if i use log file with file connectin manager with above conditions as true,this file connection manager throws the error that it cant acquire connection.

Now if oledb connections can acquire connection,why does file connection manager fails.

Thanks and Regards

Rahul Kumar

|||

hi jamie

yes other which donot throw errors are olddb connections for my source and destination.

Thanks and regards

Rahul Kumar

|||

yes Rafaels

Both are on similar lines.But fact is problem still exists and i have given it many tests.

Log file cant acquire connection while working offline

hi

As I trun Work offline - true, my connection manager for log file says-it cant acquire connection while work offline is true.Where as other oledb connections work fine.

Even it tried to get around by putting DelayValidation as true, but didnt work.

Is there is anyother setting that has be set.

Thanks and Regards

Rahul Kumar

Hello, are you referring to messages you see when you open the package with 'Work Offline'=true?

When you say "work fine" do you mean you can open the package and do not see any messages related to the OLEDB connections?

Thank you

|||

Are there any tasks using the connection managers that apparently don't throw any errors?

-Jamie

|||

I think this thread is related... I think the error is received while executing the package:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1005760&SiteID=1

|||

Hi Craig,

I mean, when i run the package without having log file connection(which uses file connection) and work offline-true,delayvalidation-true with oledb connections, package returns no error and does the purpose.

Where as if i use log file with file connectin manager with above conditions as true,this file connection manager throws the error that it cant acquire connection.

Now if oledb connections can acquire connection,why does file connection manager fails.

Thanks and Regards

Rahul Kumar

|||

hi jamie

yes other which donot throw errors are olddb connections for my source and destination.

Thanks and regards

Rahul Kumar

|||

yes Rafaels

Both are on similar lines.But fact is problem still exists and i have given it many tests.