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.
| Author |
Topic |
|
Pruffty
Starting Member
14 Posts |
 Posted - 2012-07-03 : 11:49:44
|
| I have a website with info stored in a SQL database. Users are suddenly not able to perform search and also not able to access the website. What sort of things should I be looking for in the SQL database?Thanks, |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-07-03 : 12:07:21
|
| I would also like a query to check connectivity from the database to the DC beyond pinging the DC. Ping works just fine by the way. |
 |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-07-12 : 05:32:23
|
| -- You can use profiler if this is SQL SERVER and check if hit are comming on database and check you SP if there was any change in SP and table structure.-- Check SQL login user name pass in web.config-- Check CHeck permission for user in sql server |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-07-12 : 10:22:48
|
| >>and also not able to access the websitesounds like the problem may be on your site rather than sql server. But the profiler is a good suggestion to see if (and what specifically) is making it to the database server.Be One with the OptimizerTG |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-07-12 : 13:39:55
|
| First step - get the error that the users are encountering when trying to search. Once you have that, you will have a direction to start your troubleshooting. |
|
|
|
|
|
|
Search term not working