SQL Server timeout..ASP.NET

I just configured a job board website on localhost. It was originally on a webserver. Since it was ocassionally timing out we decided to put it o locally on our intranet. I configured it and everything works fine. But the second i try tosearch for candidates , It waits for a minute and says SERVER timed out ....

ITS ON LOCALHOST.

why do you think the server times out..
LVL 8
isaackhaziAsked:
Who is Participating?
 
Anubis2005Commented:
You need to check your connection strings to your database, when moving it from the webserver it may have lost it's connection path.

Connection strings are usually saved in your web.config file.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Verify that the instance of SQL Server is listening correctly or not:

To verify that the instance of SQL Server is listening on named pipes, TCP/IP, or another protocol that you are using at the client application, open the current SQL Server error log file. The SQL Server error log file may contain entries that are similar to the following:

2009-02-11 11:55:36.17 server SQL server listening on TCP, Shared Memory, Named Pipes.
2009-02-11 11:55:36.17 server SQL server listening on 192.168.1.5:1433, 127.0.0.1:1433.
0
 
isaackhaziAuthor Commented:
I checked the log and i got this error from there everytime i tried to access a specific table. Any idea on how to fix it.

How do i fix it
A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is IFTS (id: 8); catalog name is MessageCatalog (id: 5); table name Messages (id: 2105058535). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

Open in new window

0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
isaackhaziAuthor Commented:
My connection stringgs are all fine since im able to login. Its just that the large SQl queries makes it timeout.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Change the owner of the SQL Full-text Filter service to the SQL Server service account.
This should fix the issue mentioned above.
0
 
isaackhaziAuthor Commented:
How do i do that??
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Go to Run, type Services.msc

You will find a service named SQL Server FullText Search.

Right Click it, Choose Properties and then Choose Log on Tab.

In that provide the credentials as provided in SQL Server service.
0
 
isaackhaziAuthor Commented:
I did that. But in logon i put in admin username and password same as SQL server service details.

But when the site is trying to acces the DB it logins throught a different account.


Will his make a difference??
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
I hope it wont.. You will not face any issues as everything works fine on the same instance.
0
 
isaackhaziAuthor Commented:
Tried all that but doesnt solve the issue...

im so frustated...........
0
 
Anubis2005Commented:
Can you post what is contained in the crawl log (as per your previous post: "Fix the errors that are logged in the full-text crawl log" was quoted); this might shed some more light on what is causing the issue.



0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.