Suddenly SQL Server 6.5 Stops Responding For 4 Minutes

Help - Server Stops Responding To Connections, Stops Accepting Connections
I've been having the same problem for 2 weeks now. If anyone has anyideas, I'd love to hear them. We are using both SQL and WindowsAuthentication. I was running a Profiler Trace at the time, and amgoing through it now but have not seen anything yet.Thanks in advance.About once a week, at no fixed time (but so far, between 8am and11am), my SQL Server 2000 on Windows 2000 (8.00.679) will stopresponding. New connections will at first take forever to connect,then an error message about the PreLoginHandshake(). We have to killthe service (read below) to stop it, but it comes back withoutproblems.The very first time this happened, I got buf latch errors in the SQLError Log, but not this time. (However, the first time we waited forabout 5 minutes after it stopped responding , and then the buf latcherror message showed up. This time we restarted the services before 5minutes had passed.)The SQL log shows nothing abnormal. The SQL Agent log shows nothingabnormal. The Event Log shows nothing abnormal. Stopping the servicethrough the SQL Service Manager doesn't work - we have to go into theServices control panel, stop the Agent then stop the service, and whenthe service says that it cannot be killed, we then run the "kill"command on it (from the resource kit, I believe) and it stopsimmediately. Once this occurs, we can use the SQL Service manager tostart everything up successfully, with no problems in the logs.Note: we have not rebooted the server yet, juststopped/killed/restarted the services. We plan on rebooting thisweekend.Timeline:10:20 - an openquery job runs successfully - as far as I know,everything is okay at this point.10:22 - for some reason, a transaction log backup job does not run(ran successfully at 10:02, runs every 20 minutes.). That timedoesn't show up at all in the Job History for that job, nor is there alog file, nor was a report txt file generated.10:29 - openquery job 1 fails to run. Connections are sluggish, butopen connections can run queries.10:30 - openquery job 2 fails to run. (not the same query as 1 or 3)Connections are sluggish, but open connections can run queries.10:30-10:40 Enterprise Manager cannot connect - stuck duringconnection. This is the case on multiple machines, as well as on theserver. My Enterprise Manager doesn't respond, and I cannot start anew instance. "Select getdate()" can take several seconds to run, andI get a "Lost connection" error.10:40 - openquery job 3 fails to run. Profiler shows my openquery jobwas the last thing run - no further profile messages for the next 2-3minutes.10:43 - We start shutting down the server.

View Replies !   View Related

---

SQL Server Management Studio Express 2005 Suddenly Stops Working?
Hello,

 

I am using SQL Server Express 2005 with VS2005.

Initially, I have installed SQL Server Express 2005 along with SQL Server Management Studio Express, and then as and when Service packs released I have installed all of them. My current version is SQL Server 2005 Express SP2 and SP2 Update.

 

I used this for about 15 days, then suddenly SQL Server Management Studio Stopped working! without any reason. When I try to run SSMSEE (Sql Server Management Studio Express Edition), hard disk light flickers for a while and then nothing.

 

To rectify this problem, I tried to repair the installation of SSMSEE through Add/Remove program, it went off successfully and now, SSMSEE ran perfectly, BUT, as soon as I restarted the computer and when I tried to run SSMSEE, same problem started again i.e. hard disk light flicker for a while and then nothing!

 

So, I uninstalled  SQL Server Express Edition along with all its baggage, and reinstalled the same. Again SSMSEE ran perfectly until I restart the computer. As soon as I restart and try to run the SQL SERVER MANAGEMENT STUDIO, it wont run.

 

One more thing, only SSMSEE stops working , SQL Server is working perfectly.

 

 I am at my wits end. I can't understand what to do? Has anybody encountered this probelm? please help me?

 

View Replies !   View Related

---

My Exchange Server Stops Responding To Clients.
 
Hi All,
I am having exchange server 2003.
With following details.
 
1.Operating System 2003 standerd with sp2.
2.Exchange server 2003. Service pack don't know ( How to check)
 
From last 2 months, every two days my exchange server stops responding to clients.
 
When I check the services, all the Exchange related services are ON. ( they are running fine).
 
Then I use to Restart All excahnge related services, i.e  Microsoft Exchange Information Store & Ms Exchange System Attended service and things starts working fine again.
 
This I have to do every 2 days.
 
I don't know why this is happening.
 
Can anyone assist me to resolve as it is getting critical day-by-day.
Also How can I check which service pack of exchange is installed.
 
Many Thanks
 
Muzaffar
Network Admin.
Carrier - Saudi Arabia.

View Replies !   View Related

---

Web IIS Stops Responding After BCP Job.
It appears that our web server (IIS 4) stopped responding after running
some BCP jobs. Anyone know why BCP would interfere with IIS.

SQL and IIS are on the same server. Anyone had problems with IIS/SQL getting along?

After the problem showed up, SQL responds fine in ISQLw, but the Web service goes out to lunch.

View Replies !   View Related

---

Process Stops Responding
Hi Everyone

After running the following query, the process stops responding. sp_who2 shows the process having a status of RUNNING and command COMMIT TRANSACTION.
running the KILL command doesn't cancel the process. The only way I have been able to stop the process is by stopping SQL service. On starting SQL again the database doesn't recover properly and is marked suspect. The reason the the commit is this code is part of a larger stored procedure.(which also stops responding). If I remove the COMMIT TRANSACTION from the query it finishes successfully

I am running SQL 7 sp 1. the other server being accessed is SQL 6.5 sp 5a.

/******************** **********************/
Begin Transaction
select *
into AmbCommit
from openrowset
(
'SQLOLEDB'
,'DRIVER={SQL Server};SERVER=omrsql201;UID=magnify;PWD=magnify'
,'select * from omega.dbo.tblmember Where memname = ''bake'' '
)

Print @@error

If @@error = 0
Begin
Print 'Success'
Commit Transaction
End
/***************** ********************/


Thanks

Martin

View Replies !   View Related

---

Sql 2000 Srever Stops Responding
Hello,
I have 2 servers with the same software (win2k, sql 2000 sp3) and the same data on them. The older server is working fine, but the new one that I am trying to use will run fine for a various amount of time and then stop responding. I am confused because when it does this I can pull up the task manager and see that there is plenty of memory and cpu left, and there are no error messages up on the screen. The only way that I can get the server to respond again is to restart the system. The problem never happens at the same time of day and it doesn't matter how long it has been since the last reboot, could be 5 minutes, could be 5 hours. If anyone has any ideas on what could be causing this, any replies are appreciated. The new system is a dell 2600, 2G Ram, Xeon processor, win2k.

Thanks for any ideas,
Brian

View Replies !   View Related

---

Query Notification Stops Working After 10 Minutes
Hi All

We built a Cache component that take advantage of the SQL Server 2005 query notification mechanism, all went well , we tested the component in a console application , and notifications kept coming for as long time as the console application ran.

When we initiate our Cache Component in our web service global.asx application start event , the query notification works for a few minutes , but if we came after 10 minutes or so , we stoped getting notifications from sql, the SQL Server queue is empty , and all is showing that there is nothing wrong on the DB side...

Our Cache component is a Singleton class , that perform all registrations ,catch the notification events and resubscribe for notifications.

What can be the problem? is our Cache component object are being collected by GC?

Does IIS disposes the SQL Connection that the Query notification uses?

We are on a crisis...

Thanks in advance.

 

 

 

View Replies !   View Related

---

Clustered Sql Server 2005 Restarted Suddenly
Hi EveryOne,

WIndows 2003 sp2 and sqlserver 2005 standard edition -sp2.

Found following erors in The cluster and event logs.

error: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect
failed

error: [sqsrvres] OnlineThread: QP is not online.

error: [sqsrvres] printODBCError: sqlstate = HYT00;
native error = 0; message = [Microsoft][ODBC SQL Server
Driver]Timeout expired

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

[sqagtres] SvcStop: service did not stop; giving up.
[sqsrvres] OnlineThread: asked to terminate while waiting for QP.


SQL Server is terminating in response to a 'stop' request from Service Control Manager



Earlier we had sudden Sql agent restart but this time sql server services were restarted .

What could be he reasons for this.

This machine has 64 GB ram and sql server has been alloted 30 Gb.
I found 30 Gb Usage in the dump file of Sqlserver

Can a memory Starved sql server could be a rason why sql server would have restarted

Thanks,
Gautham.R

View Replies !   View Related

---

Oracle 9i -&&> SQL Server 2005: Snapshot Agent Aborts Suddenly Uninterrupted
Hi - I hope some of you can help me with this problem.

I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below.

Message
2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied)
2006-06-14 05:34:12.57 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57300000 total rows copied)
2006-06-14 05:34:51.23 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57400000 total rows copied)
2006-06-14 05:35:29.99 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57500000 total rows copied)
2006-06-14 05:36:09.82 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57600000 total rows copied)
2006-06-14 05:36:49.38 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57700000 total rows copied)
2006-06-14 05:37:28.56 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57800000 total rows copied)
2006-06-14 05:37:35.36 [89%] The replication agent was shut down in response to an abort request.


Does anyone know what is causing this error and how I can possibly solve it?

Best Regards,
JB Plum

View Replies !   View Related

---

SQL Server Not Responding
Hello everyone,

 
I've noticed some strange behavior on my SQL Server.  A little background first:

 
This server is strictly used for SQL Server
Active/Passive cluster
Windows Server 2003 Enterprise w/ SP1
SQL 2005 Enterprise w/ SP2
8GB of total memory in the server, SQL Server has min: 4GB, max: 6GB
Disk drives are on a SAN
4 hyperthreaded, Xeon 1.4GHz proccessors

 
Now, the issue I'm seeing...

 
Every once in a while, my users will start to complain about application slowness and we'll start getting application timeouts.  I'll look at my SQL server and my server stops responding for a time period of 8-9 seconds.  One minute after the server 'wakes up', the process starts again where it will not respond for 8-9 seconds.  The clock on the server stops refreshing then will jump to the current time, and in perfmon, there is an actual break in the counters.  This does not happen at all times throughout the day, but I do need to find out a solution for this behavior.

 
During this 8-9 seconds, all processing is put on hold and continues when the server 'wakes up'.  Any new connections to the server are accepted during this timeframe, but have to wait through this 'dead' time as well.

 
Any and all comments, suggestions, concerns, or things I could be looking at are appreciated.

 
Jarret

View Replies !   View Related

---

HELP! - The Report Server Is Not Responding
Hi,

RS 2005 (sql 2005 SP1) on Windows 2003 SP1

The report server was running ok until this morning. Its just giving  a "The report server is not responding. Verify that the report server is running and can be accessed from this computer." message when trying to open the report manager.

Any ideas?

In the SQLDUMPER_ERRORLog.log file there is this..

05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 328
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x47405860
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>
05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesSQLDmpr0001.mdmp
05/22/06 12:53:37, ACTION,                  w3wp.exe, Watson Invoke: No

View Replies !   View Related

---

The Report Server Is Not Responding..
When I am browsing the http://localhost/reports i am getting the errr
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
 
This error came when i just in the IIS in reports(Right Click) application change the asp.net(Edit Configuration) on tab authentication from WINDOWS to FORM while though i reverted back mine changes to windows its stated giving me the above exception
 
Please provide me the solution .All the reports are stopped due to mine adventure..

 
 

View Replies !   View Related

---

SQL Server Stops Working
I have had my site running for several months now. My pages retrieve data from the SQL Server on the same machine. Today my users are are getting the message "SQL Server does not exist or access denied"

I have made sure that the credentials are correct. I can use those credentials to create a DSN on the server. So I don't know where to look for the problem. Help please!

View Replies !   View Related

---

SQL Server Stops Unknowingly
Hi there!!!
We got problem on sql server 2k,
Sql server stops unknowingly, and all user database has marked as Suspect/Offline,
and later on, after sql server stops, all user database has been detached.
what is going on????

View Replies !   View Related

---

Sql Server 2005 Stop Responding
Hi, This is my firs time in this forum, we are getting this error and my sql server stop responding to users,
we have upgraded our server from sql 2000 to sql 2005 in jan 2008 and since jan it waz working f9 but from last month we are facing this problem,
we have Windows 2003 32bit and sql 2005 on HP Proliant server with RAID.
Is this a hardware problem or something wrong with sql server 2005.
followin the msg from sql log
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F: empdbdata empdb.mdf] in database [tempdb] (2).  The OS file handle is 0x00000A20.  The offset of the latest long I/O is: 0x000000097a0000
-masroor

View Replies !   View Related

---

My Server Stop Responding Every Few Weeks
Hi,
i've this phenomenon that my SQL SERVER 2005 SP2 Build 3042 (W2K3 STD SP2) stop responding to connections.
when i make stop and start to the sql server service it's back to life.
when i observer the windows event log and sql events i see those errors
 
from windows eventvs

AppDomain 24 (system.dbo[runtime].24) is marked for unload due to memory pressure.
 

AppDomain 24 (system.dbo[runtime].24) unloaded.
 

SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 10.165.2.173]

 
from SQL events
 

SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 10.165.2.173]
 

Could not connect because the maximum number of '1' dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by logging off or ending the process. [CLIENT: 127.0.0.1]
 
SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: <local machine>]
 
Unsafe assembly 'hebfilts, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 28 (system.dbo[runtime].28).
 
Plz help me
 
Thx

View Replies !   View Related

---

SQL Server Agent 2000 Job Never Stops
Hello,

I've got a couple of jobs who have a odbc connection to a AS400 machine. But when these jobs run they won't stop anymore. I've got to stop these jobs manually so that the next day the jobs can start again as scheduled. The jobs did run all the packages succesfully. Does somebody know how this is possible? It did work fine but since a couple of weeks they just won't stop anymore. I hope you can help me! :S

View Replies !   View Related

---

Replication Stops After Server Reboot????
Hi,

I have transactional replication set up between two dedicated servers. Server A is the PDC and Server B is a BDC (they are both Win2000 boxes). Both the servers are brand new, and replaced the two that were running like clock work (replication wise) for the last 12 months. I never had this problem with the old servers....

When the servers are shut down (as the case was a couple of weeks back with a power failure) or just recently when they were move to another room. Both servers boot up at the same time. Server B (which is the server holding the db being replicated) boots quicker and as a result replication fails and is then 'sucessfully stopped'. Unless I am aware of the server being rebooted and can monitor this potential problem, within 2 days the logfile grows to large and everything comes to a crashing halt.

I just remove replication, truncate and shrink the log, reset replication and we're away.... BUT I really need to know why it is happening in the first place. I figure there must be a setting that I have forgotten about or something.

Both servers are Win2000 (SP4) and SQL2000(SP3a).

Any help would be appreciated.

Thanks
Casper

View Replies !   View Related

---

SQL Server Agent Starts And Then Stops
 

SQL Server 2005 installed on Windows Vista Ultimate

When I try to start the agent, it return with the message that the service started and then stopped.  On investigation I found that the Windows Event Log service won't start, returning the error:

"error 4201: the instance name passed was not recognized as valid by a WMI
data provider"


(I have posted this on Windows Vista forums but had no response).


Thanks for your help

 

View Replies !   View Related

---

SQL Server Service Starts Then Stops
I have just installed SQL Server 2005.  The machine had an expired version of SQL Express on it which I removed.  Now when i go to open the Management Studio it says it can't connect.  When I check the service, it is set to automatic using the local account but is not running.  When I start it, it throws an error stating that it started and then stopped.  The first error record in the log file states:
 
Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.
 
Could this be causing the problem?  How do I check to see what is using 1433?  In general, what the heck did I do wrong during the install?  One article said something about the new installation thinking it was still the expired version.  Could there be something left in the registry from the old version of Express causing this?
 
Thanks in advance for the help

View Replies !   View Related

---

SQL Server Express Stops After Hibernate
 

I am looking into a problem where someone has reported their SQL Server Express has stopped working after the system goes into hibernation.
 
Has anyone heard of Windows Services not starting back up after hibernating or standby?
 
I have tested this numerous times and not run into the problem.

View Replies !   View Related

---

SQL Server Management Studio Express Not Responding
Can't figure this one out.  SSMSEE just stopped working.  It's been working fine for about a year.  All of a sudden I am getting a 'Not Responding' message and it hangs up.  I can still get to the database with other 3rd party tools, so I don't think anything is wrong with the database.  All the SQL Server services are still running.  I tried repairing the installation.  Didn't work.  I uninstalled it and then reinstalled it from scratch and it still doesn't work.  Anyone have any ideas how I can proceed from here to find out what's wrong?

View Replies !   View Related

---

SQL Server Management Studio Express Not Responding
 Can't figure this one out.  SSMSE just stopped working.  It's been working fine for about a year.  Now, I am getting a 'Not Responding' message and it hangs up. 
 
I can still get to the database with other 3rd party tools, so I don't think anything is wrong with the database.  All the SQL Server services are still running.  I restarted all the services and it didn't help.  I tried repairing the SSMSE installation and the problem is the same.  Didn't work.  I uninstalled it and then reinstalled it from scratch and it still doesn't work.  Anyone have any ideas how I can proceed from here to find out what's wrong?
 

View Replies !   View Related

---

Job Calling Xp_cmdshell Stops The Server (Urgent)
Hi

I created a job, which through a SP calls the xp_cmdshell. When I run the job all steps are executed until it executes xp_cmdshell and than it stops reacting. There are no errors logged and the job just stays on executing. What makes the whole thing even worse is the fact that no only stops the job reacting, but also the SQLServer service. You can't stop the service and if you try to start it says the service is already running. We have to reboot the system in order to get SQLserver working again.
Luckily we're still on a test server, but we need to roll out the procedure next week. Has anybody any idea what is causing this problem. Please tell me

Markus

View Replies !   View Related

---

Sql Server Agent Stops Executing Jobs
Hello everyone.  I'm having a problem with the sql server agent occasionally not executing its scheduled jobs, and unless the sql server agent is restarted they will not execute according to their schedule.  I've read many posts on people having problems with running a package manually and then not being able to run it in a job, although that is not my problem since these are jobs that have all run successfully historically, and only until the agent is restarted do they start working again.  It is the strangest thing.....we have many different jobs on this server and all of them will just mysteriously stop being executed.  Two other things of note, the agent and server processes both run on AD accounts, and we receive this error:

 

SQL Server Scheduled Job 'X' - Status: Failed - Invoked on: 2007-10-27 02:00:00 - Message: The job failed.  Unable to determine if the owner (ADadacct) of job 'X' has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs).

 

Any help would be greatly appreciated.
 
 
 

View Replies !   View Related

---

The Report Server Is Not Responding -- And A Dozen DCOM Errors.
I almost got Reporting Services 2005 working. Now it's worse.
I can't deploy anymore: "an internal error occured on the report server..." "...see the error log for more information."
A browser session trying to access Reports/Pages/Folder gives the message "the report server is not responding. Verify that the report server is running and can be accessed from this computer."

Running the Reporting Services Configuration Manager, everything looks OK (Windows Service Identify is NT AuthorityLocalService, Built-in Account "Local Service", I turned off the Execution Account; Database Connection is (LOCAL)MYSERVER, Database name is there and Credentials Type is now "Service Credentials". I backed up my Encryption Keys and left Execution Account Blank (after trying my userid and password, which didn't work).

Looking in the event viewer (after getting "Report Server (MYSERVER) cannot connect to the report server database"), I now see that the service started successfully, the RSReportServer.config file has been modified (twice), the key used for encrypting was successfully extracted, the service stopped and started "successfully".

However, the System Events tell a different story: 15 DCOM errors one minute after "The SQL Server Reporting Services service entered the running state. All the same:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {blah-blah-blah} to the user NT AuthorityNETWORK SERVICE SID (blab). This security permission can be modified using the Component Servcies administrative tool.

EDIT - Saturday:

Re-ran Reporting Services Configuration Manager and Rebooted. The DCOM errors have gone away. Now I get the following:


Server Error in '/Reports$servername' Application.
Access to the path 'G:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportManagerin' is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path 'G:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportManagerin' is denied.

I checked authorizations, and it all looks OK. I suspect a configuration mis-step somewhere. Any suggestions where I might look and in what order?

TIA!




 

View Replies !   View Related

---

Reporting Services Error 500 -- Report Server Not Responding
 

For a week now, I have been reading every fix I can find for the infamous Reporting Services error(s) and none of the fixes have worked for me.  I have checked permissions and memberships of the reporting services groups, removed xmlns as mentioned, made sure that the Classic App Pool was being used, started, stopped, reinstalled, made sure the RSWebApplication.config had the URL or not, either way nothing is working for me. 
 
Is there some place where all of the various fixes are consolidated?  Can anyone  help me?  I'm dying over here.  It worked on a previous image and I rebuilt it and can't get it to work.  I have SQL 2005 sp2 on Vista...all of the IIS requirements are met and the RS configuration utility reports that everything is fine. 
 
Thanks,
 
Eric

View Replies !   View Related

---

ADO Script Stops Working After Switch To SQL Server From Access
 

I was trying to migrate an ASP application from Access to SQL Server 2005 express, and found surprisingly that some code stops working which would seem to be independent of the data source.  For example:
 
qtext = "SELECT MainText, TextType FROM MessageText WHERE [etc. etc. -- the query is OK]"
rsMain.open qtext, dbcon, , , adCmdText
if not (rsMain.BOF and rsMain.EOF) then

rsMain.MoveFirst
do while not rsMain.EOF

select case rsMain.fields(1).value

case 1

session("headline") = rsMain.fields(0).value
case 2

introtext = rsMain.fields(0).value
case 6

helptext = rsMain.fields(0).value
end select
rsMain.MoveNext
loop
end if
rsMain.Close

 
"rsMain" is an ADO recorset which defaults to a forward-only cursor as opened above; dbcon is an ADO database connection.  Nothing fancy; and it has been working for years as expected with Access.  But the recordset seems to behave differently when SQL Server is the data source (even though the whole point of ADO is to provide a level of abstraction, and I expected it not to change.)  In the code above, checking the value of "rsMain.Fields(1).value" causes "rsMain.Fields(0).value" to disappear or become inaccessible.  As a simple debug exercise, I tried response.writing "rsMain.Fields(0).value", a block of text, prior to the select case block, and it works fine once (as long as rsMain.Fields(1).value has not been accessed), but then a second write comes up empty.

 
Is it reasonable to expect that ADO recordsets and cursors function differently if SQL server is the data source vs. Access?  Is this documented anywhere? 

View Replies !   View Related

---

Report Server Windows Service Stops Running.
I have a test server running both 2000 and 2005 Reporting Services. Each day I have to restart the Report Server Windows service for the 2005 Report Server. This is the error I get when I try to access the Report Manager

The Report Server Windows service 'ReportServer$TSQL4' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) Get Online Help

After I start the Report Server Windows service using the Report Services Configuration tool I can access the 2005 Report Manager without errors.  The windows service start up type is set to automatic.

I can not find why the 2005 version keeps going down.

View Replies !   View Related

---

SQL Server Very Slow For 10 Minutes At A Time
We have an application that has about 100 users at a time. Roughly once a day, we experience a complete
slowdown on the server. All users notice it. The network seems fine because I can ping the server. Also,
I can attach to drives on the server quite fast so I don`t think it`s server resources. When I manage to
get in and do an sp_who, certain processes are blocking others. Talking to the users who were blocking,
they were not doing anything out of the ordinary - one was even doing just a select. The error log is full
of 17824 and 1608 errors. Is there some configuration setting that I should change? This is getting serious!

Thank you.

View Replies !   View Related

---

SQl Server Backup Takes 2 Hours To Run But 12 Minutes After A Server Reboot(?)
Sorry i think i may have posted this in the incorrect forum before - if i have done it again here can someone tell me where i should post this please, thanks:
 
Hi,
we are having problems with a server Intel RZeon 3ghz, 3gb ram running 2003 service pack 2 with a 70gb drive and and 400 gb drive all with adequate free space. There are 6 hard disks in total and i assume operating at least RAID 5. We have SQL2000 server with a few standard sized databases and a connection to one other server.
 
A few months ago the back up of SQL server databases started taking 4- 5 hours when before it took 20 minutes. We had actually lost one of our disks in the RAID array and it before this was spotted by our engineers we reindexed the sql databases and defragged both 70gbC: and D: 400gb drives hoping to correct this slow down. Unfortunately the new disk had not been correctly seated and this was why it was taking 4-5 hours. After fixing the disk the backups took 12 minutes again but then started taking 2-3 hours after a few days. 
 
The reindex/defrag did seem to improve the speed of the backups to 12 minutes (from 20 minutes) when the backup did function correctly (also the sql databases' performance improved). However the backups only take 12 minutes after a server reboot - this can last from only 2, up to 5 backups(days) in a row before a slow down to 2-3 hours and again only a reboot will sort out this problem.
 
NB this intermittent slowdown only occurred after the disk failure.
 
We have tried monitoring SQL server and can find no CPU/RAM intensive clashes or long running jobs interferring with the back up. Does anyone know what might be going on here? and if there are any server monitoring tools that may help us discover what is causing this problem ?
 
thanks for your help
best regards
kevin

View Replies !   View Related

---

RS2005: ReportManager And Forms Authentication : The Report Server Is Not Responding
Hi,

Sorry for the long post but I'll try to give a maximum of information.

I've tried to implement Form Authentication for Reporting Services.  Right now, just about everything works as I would hope for, i.e.:

When I try to access http://<server>/ReportServer$SQLSERVER_2005, I am redirected to the authentication form.
When successfully authenticated, I can access the report
I can display reports throught the ReportViewer Web control by passing the authentication cookie.
Etc.

(Note: My implementation of Form Authentication was inspired by http://www.devx.com/dotnet/Article/26759/0/page/1 which seems similar to Microsoft Sample)

(The $SQLSERVER_2005 suffix is because SQL Server 2000 is also installed on the server, but I don't think Reporting Services 2000 is installed)

There is one thing which does not work however and it is the Report Manager.

When I try to access http://<server>/Reports$SQLSERVER_2005, I would expect to be redirected to the /Pages/UILogon.aspx page.  Instead, I get an error page with the following message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

Both ReportServer and Reports are on the same server, both have the same security on the folder and in IIS (6.0), both have Anonymous security access "checked".

If I revert to the old .config files (prior to my modifications for Form Authentication) and remove Anonymous from IIS for both sites, everything works fine (like it did after the installation).

Here are excerpts from the config files I've modified in ReportManager:

RSWebApplication.config:

 <UI>
  <CustomAuthenticationUI>
   <loginUrl>/Pages/UILogon.aspx</loginUrl>
   <UseSSL>False</UseSSL>
  </CustomAuthenticationUI>
  <ReportServerUrl>http://<servername>/ReportServer$SQLSERVER_2005</ReportServerUrl>
 </UI>

rsmgrpolicy.config:

<CodeGroup 
  class="FirstMatchCodeGroup" 
  version="1" 
  PermissionSetName="FullTrust"
  Description="This code group grants MyComputer code Execution permission. ">
  <IMembershipCondition
    class="ZoneMembershipCondition"
    version="1"
    Zone="MyComputer" />

Web.config:

    <identity impersonate="false" />

Here is the content of the log ReportServerWebApp_*.log (see error in bold):

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Eastern Standard Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__11_10_2006_08_32_34.log</Path>
  <SystemName>MSCAPP02</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!5!11/10/2006-08:32:39:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!5!11/10/2006-08:32:39:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.

   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

   at System.EventHandler.Invoke(Object sender, EventArgs e)

   at System.Web.UI.Control.OnInit(EventArgs e)

   at System.Web.UI.Page.OnInit(EventArgs e)

   at System.Web.UI.Control.InitRecursive(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!11/10/2006-08:32:40:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)


So that's it.  Thanks for any help you can provide.

Nicolas

View Replies !   View Related

---

Can Not Setup SQL Server 2005, Progress Stops At 'setting File Security'
Dear Helpers,

 

I can not setup SQL server 2005 express and the full trial version as well.

 

The setup progress stops at "setting file security", and nothing happens. I dont even get an error message.

 

This is very annoying. I have local administrator access, so it should work.  Op system: Windows XP professional.

Machine:   Hp Compaq dc7700p, 1 GB RAM, 80 GB HDD

 

Thanks for your help in advance.

 

View Replies !   View Related

---

SQL Server 2000: The Agent Is Suspect. No Response Within 10 Minutes
Hi,

 

I have two servers, one production server and one backup server which have transactional replication with a pull subscription.

 

When I configure replication, it works fine during our test weekends testing production load. After tests, replication looks fine for a random number of days. Then, all of a sudden, an error message is displayed on one of the agents: "The agent is suspect, no response within 10 minutes."  This has happened a number o times. If I remove replication and configures it again, it always works. Sometimes it works by just updating one of the tables and the error message disappears. The last time (today) that did not work. Updating the database did not replicate and the error message remained.

 

Has anyone experienced this same problem and has a god solution. One thing that is common is that the error message appears after long times of inactivity on the servers, or perhaps after a restart but that I am not sure about.

 

Question 1: How can I prevent this error message?

 

Question 2: Are there any special things to think about when I need to restart the servers and replication is configured, e.g. after installing updates from Windows Update.

 

I would be very grateful for any answers regarding this.

 

Best,
  /M

View Replies !   View Related

---

Recurring Issue - OPENROWSET For Excel Query Stops Working , Cured By Restart Of SQL Server
Hi,
 
I am having a recurring issue that involves a stored proc using OPENROWSET to query an excel file. I used the surface area config to enable this on the server, and made sure that is still set. After an undetermined amount of time, the OPENROWSET query starts failing with this message:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

I corrected this previously by restarting the SQL server, but not before I checked permissions, the excel file itself, etc, and that was the last thing to try.

I am using SQL 2005 with SP1 installed - my primary approach to tackling this issue is to install the SP2, but I did not find this bug referenced in the fixes, and was wondering if anyone else had further insight.

Thanks,
Darrell Young

View Replies !   View Related

---

SQL Server Behind A Firewall Is Not Responding To MTS Server.
Hi all,
I am developing a 3-tier web app (IIS, MTS, SQLServer7). My problem is SQL Server 7 is not responding to MTS Server when there is a firewall in between.
However, when the firewall is removed, everything works fine, therefore I think the problem is not caused by the code.
I am very sure that port 1433 (the default port used by SQL7) is open in the firewall.

Please help because I am stuck with this problem for weeks and really stressed out.

Thanks in advance.
William

View Replies !   View Related

---

Same Problem As The Report Server Is Not Responding. Verify That The Report Server Is Running And Can Be Accessed From This Comp
do you mean first install SDK, then install IIS, then install report sever?
I have same problem.
any can help?
 

View Replies !   View Related

---

Suddenly Cannot Connect
I'm running SQL Server Express 2005 on Windows XP.

I've been using SQL Server Express for the past month or so, and I've always been able to connect. Now all of a sudden I can't connect, it's giving me error 26.

I've always used Windows authentication with no need for a password.

View Replies !   View Related

---

The Report Server Is Not Responding. Verify That The Report Server Is Running And Can Be Accessed From This Computer.
 

When I trying to configure Reposrting services in IIS & XP. It hsows me error
 "The report server is not responding. Verify that the report server is running and can be accessed from this computer."

 
I also configure with reposrting configuration tools which show all confuguration is perfect.
 
but when I try to open through IE http://localhost/Reports/Pages/Folder.aspx
 
or http://localhost/Reportserver
 
It shows error. I try all ways still not works ..Help me out
 
Thanks.
 
 
 
 

View Replies !   View Related

---

Suddenly Getting STRANGE Error...
I've been building a simple test application and things have been working all day. Suddenly, about a half an hour ago - I started getting this error every time I attempt to go to the main web page:
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have no idea what changed... Can someone help me figure this out please?
Thanks!~A~

View Replies !   View Related

---

SSIS Is Closed Suddenly
hi everyone,

From time to time I experience some issues when I redefining the lenght of a group or sequence container boxes from Control Flow space and I obtain this error (devenv.exe is raised in orde to debug...)

Unhandled exception at 0x54f15834 in devenv.exe: 0xC0000005: Access violation reading location 0x000008b7.

Does anyone know whether is a problem beyond of SSIS or on the contrary is some stuff already reported to MS.

TIA.

View Replies !   View Related

---

Connetion Fails Suddenly
I've had this connection used for months and months. The setupQL Express + VS2008. In that particular app I use only one DB Connection but there are about 10 other Sql Server Dbs that I connect to in other apps.
 
I am still in a development stage.
 
Today I've decided to connect also via the Server Explorer in VS2008. All connections were established easy. Immediately after that a connection.Open ( ) statement failed with the error message
 
System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
 
At the Open statement I did a break and with Ctrl + Alt + E got all exceptions. They are too numerous to show in here. One of the messages I found was that the failure occured in System.dll.
 
Any ideas as to why it happened?
 
I disconnected (deleted) the DB in question--no change. I deleted ALL DB connections from the server explorer in VS2008 - no change. I see the only option now and that is to reinstall the VS2008. I am kind of sick and tired of doing it.
 
Also I've been trying to move on to Linq and it is my understanding that in order to do Linq I have to establish connections via VS2008 not just connection strings. Is it right? Perhaps I am mistaken?
 
This particular connection is not that crutial. I can survice without it with this app but for others it would be impossible to continue development.
 
Any help will be appreciated.
 
Thanks.
 
P.S.
 
Some additional information has transpired. I checked Sql Server Object Explorer and immediately determined that the DB in question lost ALL its tables. There was just an empty shell: the name, no tables, no system tables, no Programmability, nothing.
 
I "deleted"  this DB and reconnected it. The connection with my app miraculously restored itself. Now I could run the app with no problem and the connection to this DB could be Opened in the app. However, when I tried to set up the connection again in the Server Explorer of VS2008 the same thing promptly happened. Now I got this exception back.
 
It is not the way VS2005 behaved. Is it normal?
 
Thanks.

View Replies !   View Related

---

SP Suddenly Started Timing Out
Simple (4 lines) stored procedure was working, now is timing out. 

Profiler shows hundreds of lines and a lot of time doing:

   EventClass:  SQLTransaction

   ObjectName:  Cache Coherency

What are these lines profiler is capturing?

Why is the server doing this, and how can I stop it?

 

Thanks!

 

 

View Replies !   View Related

---

All Replication Publications Suddenly Disappear
Hi:

Did you have any experience that all publications and their related jobs suddenly disappear?

I had a transactional pull replication between two servers, and distributor and subscriber in the same box; publisher was an AA cluster server.
The schedule of pulling was once a week.

Last Friday morning everything was working perfectly, but I found all publications and their related jobs disappear around 5pm

I checked with the sysadmin and he said nothing was changed on that period.

Did you have any idea about it?

Did you have any idea that I can prevent this happen again or any alert I can set up to monitor who drop it, when it was dropped and so on?

It is a SQL 2000 box and system table doest not take trigger.

Thanks in advance

Theresa

View Replies !   View Related

---

SQL Mail Stopped Suddenly !! Help Required.
Hi Everybody !!

I have a problem with SQL mail on SQL 6.5 with SP 5a . I have created a job called as mailtest and is scheduled to run every morning .
The task was running successfully till last week when suddenly it stopped responding on some of the SQL 6.5 Servers .

When i stop the SQL Mail and start again through the Enterprise Manager , and then run the task , it shows as successful .
Every morning i have to do it to check whether the mailtest is O.K .

But the automated mailtest task has stopped suddenly . I have checked the MAPI profile and is correct as the same is configured on other servers on which my mailtest runs successful.

Can somebody guess what the problem could be ?

Thanks for your help in advance .

Regards
Ashish.

View Replies !   View Related

---

Management Studio Is Missing Suddenly
Hi all,
 
This issue is on PRODUCTION.
 

The server is in use almost a year now, but suddenly this afternoon , i saw that Management Studio is missing in start --> Sql Server 2005 --> Management Studio is missing here. ( SQL Server 2005 , Standard Edition, 32-bit, SP1  )
 

Could somebody tell what could be the reason and how to fix it.
 

What i need to do , so that i get back the management studio & where should i go & investigate what file is missing.

 
Any help is greatly appreciated.
 

Thanks.

View Replies !   View Related

---

SQL 2005 - Why Do Databases Suddenly Think They Are Replicated?
 

Hello All
 
I hope somebody can help. This is the second time I've seen this issue.  The first time I thought it was a one off, but now I'm getting concerned.
 
I have two clients - one had Merge replication set up on a database that had a log log file that just grew and grew.  The database was set to SIMPLE recovery.  I could understand the log file growing if it was set up for transactional replication, but it wasn't transactional, just merge.  Looking in  sys.databasese the log_reuse column was set to REPLICATION. 
 
I ran the sp_repldone stored proc on this database and all was well - I could shrink the log file down to a reasonable size.  This server was SQL Server 2005, Service Pack 2.
 
Now I have yet another client who has a growing transaction log file.  Low and behold the log_reuse for the database is set to REPLICATION again.  This server has never had any type of replication set up at all!!!!  The log file is still growing and DBCC OPENTRAN indicates undistributed transcations.  This particular server is SQL Server 2005 Service Pack 1.
 
Can someone PLEASE shed some light on what's going on here?  Is there some kind of bug that I don't know about?  Searching Goolgle Groups seems to indicate that other people have had this problem, and they have have to set up replication and run sp_repldone to resolve it, but that's surely uncalled for on a database that has never seen replication?
 
Thanks
 
SQLGal2
 
 

View Replies !   View Related

---