Problem in SQl Server - SQL Server Forums

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."

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

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."

vedjha
Posting Yak Master

228 Posts

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

yes

Ved

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources