MSSQLSERVER Service Shuts down

For the past few days, our SQL Server 2005 SP2 has been shutting down. The
Exchange and IIS services are still running. Restarting the service works,
but there are no events recorded in the event log. The SQL server is
hosting a single, small database that supports the navigation controls for a
developmental web-site and other than the security updates released last
week, no changes have been made to SQL Server itself.
Mike Ober.Hi
Is it open to internet ? What is an account that MSSQLSERVER run under?
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uhVm38reHHA.4704@.TK2MSFTNGP06.phx.gbl...
> For the past few days, our SQL Server 2005 SP2 has been shutting down.
> The Exchange and IIS services are still running. Restarting the service
> works, but there are no events recorded in the event log. The SQL server
> is hosting a single, small database that supports the navigation controls
> for a developmental web-site and other than the security updates released
> last week, no changes have been made to SQL Server itself.
> Mike Ober.
>

MSSQLSERVER Service Shuts down

For the past few days, our SQL Server 2005 SP2 has been shutting down. The
Exchange and IIS services are still running. Restarting the service works,
but there are no events recorded in the event log. The SQL server is
hosting a single, small database that supports the navigation controls for a
developmental web-site and other than the security updates released last
week, no changes have been made to SQL Server itself.
Mike Ober.
Hi
Is it open to internet ? What is an account that MSSQLSERVER run under?
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uhVm38reHHA.4704@.TK2MSFTNGP06.phx.gbl...
> For the past few days, our SQL Server 2005 SP2 has been shutting down.
> The Exchange and IIS services are still running. Restarting the service
> works, but there are no events recorded in the event log. The SQL server
> is hosting a single, small database that supports the navigation controls
> for a developmental web-site and other than the security updates released
> last week, no changes have been made to SQL Server itself.
> Mike Ober.
>

MSSQLSERVER Service Shuts down

For the past few days, our SQL Server 2005 SP2 has been shutting down. The
Exchange and IIS services are still running. Restarting the service works,
but there are no events recorded in the event log. The SQL server is
hosting a single, small database that supports the navigation controls for a
developmental web-site and other than the security updates released last
week, no changes have been made to SQL Server itself.
Mike Ober.Hi
Is it open to internet ? What is an account that MSSQLSERVER run under?
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uhVm38reHHA.4704@.TK2MSFTNGP06.phx.gbl...
> For the past few days, our SQL Server 2005 SP2 has been shutting down.
> The Exchange and IIS services are still running. Restarting the service
> works, but there are no events recorded in the event log. The SQL server
> is hosting a single, small database that supports the navigation controls
> for a developmental web-site and other than the security updates released
> last week, no changes have been made to SQL Server itself.
> Mike Ober.
>

MSSQL Slow Queries on One Database only all others fine.

Hello Everyone,

I have a strange problem that I cannot seem to solve. I have two server running Windows 2003 MSSQL on one IIS on the other.

Out of the blue I have slow queries that cause asp script timeouts and I cannot figure it out. I have moved some test code to other sites on the server and still have these long delays.

I have tried dropping the tables, then the database entirely and restoring and still slow. I run the same code on my test server at home running both iis and sql on the same server and it is a little slow but not too bad and the test server is a duron 1.6.

Here it is:
Code: ( text )

<!-- #include file="adovbs.inc" --> <% response.write("<table width=100% border=0>") response.write("<tr><td align=left>") Set dbconn = Server.CreateObject("ADODB.Connection") dbconn.Open database_three dbconn.CommandTimeout = 0 Set group_master = Server.CreateObject("ADODB.Recordset") Set section_master = Server.CreateObject("ADODB.Recordset") Set document_master = Server.CreateObject("ADODB.Recordset") group_master.open "SELECT * FROM group_master",dbconn,adOpenForwardOnly,adLockReadOnly Do while not group_master.EOF group_number = clng(group_master("group_number")) group_title = group_master("group_title") group_description = group_master("group_description") group_stat = group_master("group_status") response.write("<table width=100% border=0>") If group_stat = "A" Then response.write("<tr><td align=left colspan=3 CLASS=activegroup>" & group_title & "</td></tr>") If group_stat = "O" Then response.write("<tr><td align=left colspan=3 CLASS=obsoletegroup>" & group_title & "</td></tr>") response.write("<tr><td align=justify colspan=3 CLASS=groupdescription>" & group_description & "</td></tr>") section_master.open "SELECT * FROM section_master where group_number=" & group_number,dbconn,adOpenForwardOnly,adLockReadOn ly If not section_master.EOF Then Do while not section_master.EOF sec_no = clng(section_master("section_number")) If section_master("section_status") = "A" Then response.write("<tr><td></td><td align=left colspan=2 class=activesection><font color=black><strong>" & x & ".</strong></font> " & section_master("section_title") & "</td></tr>") If section_master("section_status") = "O" Then response.write("<tr><td></td><td align=left colspan=2 class=obsoletesection><font color=black><strong>" & x & ".</strong></font> " & section_master("section_title") & "</td></tr>") response.write("<tr><td></td><td align=justify colspan=2 class=sectiondescription><font color=white><strong>" & x & ".</strong></font> " & section_master("section_description") & "</td></tr>") document_master.open "SELECT * FROM document_master where group_number=" & group_number & " and section_number=" & sec_no & " ORDER BY document_seq",dbconn,adOpenForwardOnly,adLockReadOnly If not document_master.EOF Then Do while not document_master.EOF If document_master("document_status") = "A" Then response.write("<tr><td></td><td></td><td align=left CLASS=activedocument><font color=black><strong>" & formatnumber(document_master("document_seq"),2) & "</strong></font> " & document_master("document_title") & "</td></tr>") If document_master("document_status") = "O" Then response.write("<tr><td></td><td></td><td align=left CLASS=obsoletedocument><font color=black><strong>" & formatnumber(document_master("document_seq"),2) & "</strong></font> " & document_master("document_title") & "</td></tr>") response.write("<tr><td></td><td></td><td align=left CLASS=documentdescirption><font color=white><strong>" & formatnumber(document_master("document_seq"),2) & "</strong></font> " & document_master("document_details") & "</td></tr>") document_master.MoveNext Loop document_master.Close Else document_master.close End If ' Make sure there are documents to loop thru. section_master.MoveNext Loop section_master.Close Else section_master.Close End If ' Make sure there was sections to look at. group_master.MoveNext Loopresponse.write("</td></tr></table></td></tr></table>") dbconn.Close Set dbconn = Nothing Set group_master = Nothing Set section_master = Nothing Set document_master = Nothing %>

Keep in mind nothing about my code has changed so it must be something on the server like maybe a security setting or routing issue, I just can't figure out what could have MAGICALLY changed. I am not the only admin on the servers but everyone says they changed nothing. Any help would be GREATLY appreciated.Is it possible that you just have more data then before?
Do you have indexes on your tables?|||Yeah I do have index's. I also ran the optimizer.

The data has not changed, it is only updated as we add documents and none have been added for a couple of months.

Its not really that much data.

MSSQL Server 2000 - PHP - Windows 2003 server - IIS 6.0

Hi friends...
can anyone help about how can use this combo..
MSSQL Server 2000 - PHP - Windows 2003 server - IIS 6.0?
can i use like this ?
please reply if anyone know
Regards..
NavvinYou could do following tasks:
1. Install PHP
2. Config MSSQL extension in php.ini
3. Config ISS 6.0 with PHP interface
4. Using php adodb library to connect with MSSQL (http://adodb.sourceforge.net/)

MSSQL over IIS 5

I'm having troble with MSSQL 2k and IIS 5
a textarea field (text), can't post more then 150 chars, If I try, the text
recorded are something like "üh3", and no sight of my typed text!!
What's hapen? this does not occurs over Sambar or Xitami.The SQL Server will only store what you ask it to store. Suggest running a
SQL Profiler trace to see exactly what is being passed to the SQL Server.
--
HTH
Ryan Waight, MCDBA, MCSE
"Feijó" <feijo@.x.suply.com> wrote in message
news:%23Vh52VmjDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I'm having troble with MSSQL 2k and IIS 5
> a textarea field (text), can't post more then 150 chars, If I try, the
text
> recorded are something like "üh3", and no sight of my typed text!!
> What's hapen? this does not occurs over Sambar or Xitami.
>|||Ok, I will use the profiler to get some hint
the version is 7.0, any bugs on it?
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> escreveu na mensagem
news:u08KWamjDHA.2676@.TK2MSFTNGP11.phx.gbl...
> The SQL Server will only store what you ask it to store. Suggest running a
> SQL Profiler trace to see exactly what is being passed to the SQL Server.
> --
> HTH
> Ryan Waight, MCDBA, MCSE|||There were but they've been rectified with Service Packs. Ensure you are
running the latest Service Pack. For SQL 7 it's 7.00.1063, SELECT @.@.VERSION
will show which version you are running.
--
HTH
Ryan Waight, MCDBA, MCSE
"Feijó" <feijo@.x.suply.com> wrote in message
news:OFX1alojDHA.1656@.tk2msftngp13.phx.gbl...
> Ok, I will use the profiler to get some hint
> the version is 7.0, any bugs on it?
>
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> escreveu na mensagem
> news:u08KWamjDHA.2676@.TK2MSFTNGP11.phx.gbl...
> > The SQL Server will only store what you ask it to store. Suggest running
a
> > SQL Profiler trace to see exactly what is being passed to the SQL
Server.
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
>