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 |
|
alejandrozb
Starting Member
3 Posts |
 Posted - 2014-10-13 : 15:39:13
|
| I'll apreciate any help you can give.This is my headache:I've developed a report that used two complex SP. In developing mode (Visual Studio 2008) runs ok, about 45 seg but when I deploy to the server and try it after few seconds my SQL Server and SQL server agent service goes down.The only error message I get is that the reporting service is unable open a conexion to the Reporting service Database, obiously because for some reason the sql server service had gone down..Alejandro ZB |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-13 : 16:00:21
|
| Check the SQL Server Error Log and Application Log in Event Viewer to determine what happened. You might see an access violation/memory dump/similar. If you do, you'll want to check your build version as these are often times bugs in the database engine. Install the latest service pack AND cumulative update package. If you are using SQL Server 2008 R2, you can install service pack 3 which was just recently released and contains all hotfixes.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-14 : 09:15:12
|
| FWIW, it is NOT obvious that the "sql server service had gone down". It is just as likely that the connection string you are using is incorrect. |
|
|
|
alejandrozb
Starting Member
3 Posts |
Posted - 2014-10-14 : 10:53:15
|
| Tara thank you, I'll try apply the SP.Alejandro ZB |
|
|
|
alejandrozb
Starting Member
3 Posts |
Posted - 2014-10-14 : 11:07:28
|
| gbritton, Thanks for your response.Maybe I was not clear enough, I'll try again: when I run the report from the reporting service web page, the sql service goes down, I mean the all SQL server stop working. Just in case I've already test the conexion before, I do have more than 350 reports runing ok with the same connection.Tara: The only message I get on Event Viewer is "Report Server (MSSQLSERVER) cannot connect to the report server database."I'm going crazy, please help!!!Alejandro ZB |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-14 : 12:09:28
|
quote:
Originally posted by alejandrozb
gbritton, Thanks for your response.Maybe I was not clear enough, I'll try again: when I run the report from the reporting service web page, the sql service goes down, I mean the all SQL server stop working. Just in case I've already test the conexion before, I do have more than 350 reports runing ok with the same connection.Tara: The only message I get on Event Viewer is "Report Server (MSSQLSERVER) cannot connect to the report server database."I'm going crazy, please help!!!
I'm confused now. Given your last reply, the SQL Server did NOT go down. Please check the services, error log, application log on the database server itself and NOT on the report server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Report drop SQL service