Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Problem in SQl Server

Author  Topic 

vedjha
Posting Yak Master

228 Posts

Posted - 2009-12-09 : 12:36:39
I have a database in x drive and i kept tempdb database in y drive.
using alter command. after some time , i have stioed SQL server.
after some time as i connect to SQL server then it says:

The request failed or the service did not respond in a timely fashion.
consult the event log or other applicable error logs for details

Log Details:



Log Name: System
Source: Service Control Manager
Date: 12/9/2009 10:41:21 PM
Event ID: 7003
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: user-PC
Description:
The SQL Server FullText Search (SQL05) service depends the following service: NTLMSSP. This service might not be installed.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="49152">7003</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8080000000000000</Keywords>
<TimeCreated SystemTime="2009-12-10T06:41:21.363883800Z" />
<EventRecordID>16406</EventRecordID>
<Correlation />
<Execution ProcessID="512" ThreadID="516" />
<Channel>System</Channel>
<Computer>user-PC</Computer>
<Security />
</System>
<EventData>
<Data Name="param1">SQL Server FullText Search (SQL05)</Data>
<Data Name="param2">NTLMSSP</Data>
</EventData>
</Event>

Thank you

Ved

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-09 : 12:52:49
What alter command did you run?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2009-12-09 : 12:57:37
use master

alter database tempdb modify file
(
name=tempdev,filename='I:\Ved\Database Backup\tempdb.mdf'
)

alter database tempdb modify file
(
name=templog,filename='I:\Ved\Database Backup\templog.ldf'
)

Ved
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-09 : 13:02:58
Do those paths exist?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2009-12-09 : 13:14:50
yes

Ved
Go to Top of Page
   

- Advertisement -