Multi connection problem

Hi all,
In my accounting application if one user tries to execute a long report that
my take several minutes, the other users who are entering invoices almost
hang, and the process of enter products into the invoices or the saving the
invoices slow down significantly.
I'm using VC++ 2003, ODBC, SQL 2000 Ent.
Any body know how to overcome this problem.
Thanks in advance.You could try running the report query inside a transaction with READ
UNCOMMITTED isolation level.
The next time the report runs, take a look at the locks in the database. If
there are a lot of locks, running the report under READ UNCOMMITTED should
help.
"ATS967" wrote:

> Hi all,
> In my accounting application if one user tries to execute a long report th
at
> my take several minutes, the other users who are entering invoices almost
> hang, and the process of enter products into the invoices or the saving th
e
> invoices slow down significantly.
> I'm using VC++ 2003, ODBC, SQL 2000 Ent.
> Any body know how to overcome this problem.
> Thanks in advance.|||A seperate reporting database would solve this. A simple solution is to
restore a backup of the production db with a different name on a nightly
basis. Data is a day old but that's usually OK for reporting. If you mark th
e
reporting db read-only it will speed up those reports too.
"ATS967" wrote:

> Hi all,
> In my accounting application if one user tries to execute a long report th
at
> my take several minutes, the other users who are entering invoices almost
> hang, and the process of enter products into the invoices or the saving th
e
> invoices slow down significantly.
> I'm using VC++ 2003, ODBC, SQL 2000 Ent.
> Any body know how to overcome this problem.
> Thanks in advance.

MSSQLSERVER Service cannot start [SQL 2000]

Hi All,
MSSQLSERVER Service is not started, when I try to start it, it tries to
start then it remains not started.
What are the possible causes of this issue?
What are the possible solutions other than reinstalling the SQL software?
Thank you.
BishoyTake a look at the SQL Server error log for the cause. The default location
for the logs is folder C:\Program Files\Microsoft SQL Server\MSSQL\LOG. The
most current file is ERRORLOG with no extention. There may also be related
messages in the event log.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||There are many possible causes, open a command window and navigate to where
the binary is and then issue the following
sqlservr -Con
This will start sql server up in a console and you can see the error
message.
You can find the Sql 2000 binary at
C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn
or
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Your best bet for SQL 2005 is to check the event log or open up the error
log (it is plain text) and you can find it at
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG
You can also start it at the command prompt like this
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\binn\sqlservr.exe -m -f
where x is your instance number
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||This is a multi-part message in MIME format.
--050904070208030402070600
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Bishoy napisaÅ?(a):
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
Hi chceck server service
regards
SW
--050904070208030402070600
Content-Type: text/x-vcard; charset=utf-8;
name="sebwax.vcf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="sebwax.vcf"
YmVnaW46dmNhcmQNCmZuOlMgVw0KbjpXO1MNCmVtYWlsO2ludGVybmV0OnNlYndheChub3Nw
YW0pQGludGVyaWEucGwNCnZlcnNpb246Mi4xDQplbmQ6dmNhcmQNCg0K
--050904070208030402070600--|||Hi,
Chk the Error log files and event viewer log files,
Chk for password if password is changed for service log on account.
Amol Lembhe
"SW" wrote:
> Bishoy napisaÅ?(a):
> > Hi All,
> >
> > MSSQLSERVER Service is not started, when I try to start it, it tries to
> > start then it remains not started.
> >
> > What are the possible causes of this issue?
> >
> > What are the possible solutions other than reinstalling the SQL software?
> >
> > Thank you.
> >
> > Bishoy
> Hi chceck server service
> regards
> SW
>

MSSQLSERVER Service cannot start [SQL 2000]

Hi All,

MSSQLSERVER Service is not started, when I try to start it, it tries to start then it remains not started.

What are the possible causes of this issue?

What are the possible solutions other than reinstalling the SQL software?

Thank you.

Bishoy

Check your system and application event log for error messages from sql server. You find event log viewer in Start->Control Panel->Administrative Tools->Event viewer or by starting "eventvwr" from Start->Run...

Do you see any messages from MSSQLServer or Service Control Manager?

--
SvenC

|||

Hi Bishoy,

The most elementary test which you can do is that verify that in the Service Manager, the login details are correct. Possible cause : Change in Domain account password.

If you are using SP3 or lower update, download latest Service Pack (SP4) from the microsoft download site. There is a KB article on it and this bug has been fixed in SP4 (http://support.microsoft.com/kb/840856)

Let me know if you are not able to resolve the issue.

Regards,

Rajesh

MSSQLSERVER Service cannot start [SQL 2000]

Hi All,
MSSQLSERVER Service is not started, when I try to start it, it tries to
start then it remains not started.
What are the possible causes of this issue?
What are the possible solutions other than reinstalling the SQL software?
Thank you.
Bishoy
Take a look at the SQL Server error log for the cause. The default location
for the logs is folder C:\Program Files\Microsoft SQL Server\MSSQL\LOG. The
most current file is ERRORLOG with no extention. There may also be related
messages in the event log.
Hope this helps.
Dan Guzman
SQL Server MVP
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
|||There are many possible causes, open a command window and navigate to where
the binary is and then issue the following
sqlservr -Con
This will start sql server up in a console and you can see the error
message.
You can find the Sql 2000 binary at
C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn
or
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Your best bet for SQL 2005 is to check the event log or open up the error
log (it is plain text) and you can find it at
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG
You can also start it at the command prompt like this
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\binn\sqlservr.exe -m -f
where x is your instance number
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
|||Hi,
Chk the Error log files and event viewer log files,
Chk for password if password is changed for service log on account.
Amol Lembhe
"SW" wrote:

> Bishoy napisa?(a):
> Hi chceck server service
> regards
> SW
>

MSSQLSERVER Service cannot start [SQL 2000]

Hi All,
MSSQLSERVER Service is not started, when I try to start it, it tries to
start then it remains not started.
What are the possible causes of this issue?
What are the possible solutions other than reinstalling the SQL software?
Thank you.
BishoyTake a look at the SQL Server error log for the cause. The default location
for the logs is folder C:\Program Files\Microsoft SQL Server\MSSQL\LOG. The
most current file is ERRORLOG with no extention. There may also be related
messages in the event log.
Hope this helps.
Dan Guzman
SQL Server MVP
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||There are many possible causes, open a command window and navigate to where
the binary is and then issue the following
sqlservr -Con
This will start sql server up in a console and you can see the error
message.
You can find the Sql 2000 binary at
C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn
or
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Your best bet for SQL 2005 is to check the event log or open up the error
log (it is plain text) and you can find it at
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG
You can also start it at the command prompt like this
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\binn\sqlservr.exe -m -f
where x is your instance number
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||Bishoy napisa?(a):
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
Hi chceck server service
regards
SW|||Hi,
Chk the Error log files and event viewer log files,
Chk for password if password is changed for service log on account.
Amol Lembhe
"SW" wrote:

> Bishoy napisa?(a):
> Hi chceck server service
> regards
> SW
>