MS SQL Server :: Problem Stopping And Starting Services.

Problem Remotely Stopping And Starting Services In SQL Server 2005

Sep 11, 2007

Hi guys

I've been dealing with a few problems with SQL Server 2005.

We don't want to give our DBA's local administrator access to the servers so we had a problem with SSIS which I managed to resolve by adding their global group into the local DCOm group and modifying the security properties of MsDtsServer.

Another problem I've come across is when you log into Management Studio as an account that has local administrator access to the server you have the Green symbol next to the registered server, you can then right click and Stop, Restart services etc.

If I log into Management Studio with an account that has full SQL sysadmin rights but not local administrator rights to the server then the Green symbol doesn't appear and the Stop, restart options are all greyed out - all other functionality appears okay, they just seem to lose the ability to remotely stop and start services.

All of the above is with Windows Firewall turned off, if the user has local administrator rights but the SQL Server has the Windows Firewall switched on they are unable to remotely stop and restart services.

Port 1433 is open on the firewall and program execptions are there for sqlbrowse.exe

Anyone come across this particular problem before?

Any help would be appreciated.

Cheers

Hanley

View 2 Replies View Related

Difference In Starting Rep Service Vs. Stopping And Starting The Rep Job?

Feb 1, 2007

When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service. Are there any differences between these two methods? Does restarting the service inherit any changes made to the job's attributes?

Thanks!

View 1 Replies View Related

Stopping And Starting Mirroring

Jul 25, 2007

My problem is primarily with SQL backup but the instant question is with mirroring in SQL 2005. I have a log file that is out of control and I need to do a backup with truncate_only, but this is command is evidently disallowed while mirroring is enabled. Is it possible to temporarily deactivate or remove mirroring in order to get the backup log under control? Is it possible to do that and then 'resume' mirroring?

A secondary issue is that I don't think mirroring is actually working at this point in time anyway. In the Mirroring section of the database properties the Status window says "No connection: cannot connect to the mirror server instance," so the question of stopping and restarting may be moot.

How does one reestablish mirroring if the connection is lost?

Lots of questions, I know... I'm reading up on it, but I'm obviously not the guy who set it up in the first place! Thanks in advance for any help...

CB

View 4 Replies View Related

Stopping And Starting SQL Server Nightly

Feb 9, 1999

Does anyone see any negative consequences to stopping and starting SQL Server nightly?

View 2 Replies View Related

Stopping And Starting SQL Service On A Cluster

Apr 24, 2008

hello everyone,

I wonder if you can help me with a problem I have trying to support a web based application that uses SQL 2005.

The problem is that the application developers tell me that it is neccessary to stop and restart the SQL service as part of the troubleshooting process when their application stops working. Unfortunately, the customer has our application database on a clustered SQL instance that is used by other applications so they cannot just stop and restart the SQL service because this will have a major impact on all the other instances...

Is there another way that would effectively do the same thing as stopping and restarting the SQL service? I have read that dettaching and re-attaching might do the same but application developers say onlt stopping/restarting services is sufficient to break the connection with the application.

Any advice would be really welcome as I am completely new to SQL and struggling with this!

Many thanks, Nick.

View 5 Replies View Related

Stopping And Starting Pull Subscription

Feb 1, 2007

Say we need to replicate between 2 databases using transactional replication

So we create a publication on the first server and initialse the publication agent so that it takes a snapshot and starts the log reader to capture the transactions being keyed into it.

Then say we create a pull subscription from the second database but lets say we assume we already have the data from thepublication database already in it so no need to app,ly a snapshot over it, when the pull subscription starts we assume that only transactions in the log reader that occured AFTER the pull subscription was started would be applied. Is this correct?

Then say we need to stop the pull subscription for a short period then start it again (let say so that we can take a back up of the subscriber database and restore the database somewhere else and replication set up between these 2 with no chance of data being althered before the restore had finished) can someone confirm when we start the pull subscription again all the transactions that occurred during the stopped period will be applied when it is started again OR will it be the case that only the transactions since the pull subscription was restarted will be applied

Cheers

Matt

View 1 Replies View Related

Starting && Stopping SQL Server From Command Line

Nov 10, 2005

Hello All...
I am new to this forum (and new to SQL for that matter), so I hope this isn't a stupid question. I tried searching for the answer but couldn't find it here.
I am trying to start & stop SQL server through the command line so I can start & stop it as a scheduled task. Are there any switches for sqlmangr.exe I can use? Maybe another way?

Thanks....Dave S. <majordis@weco-group.com>

View 2 Replies View Related

SQL 2012 :: DTSX Package - Starting And Stopping A Job

Feb 26, 2015

I have a job that runs a dtsx package (containing an infinite loop). What I want to do is set up a schedule to start the job at 8am and stop it at 5pm. The scheduling GUI doesn't give this kind of option (caveat: that I can see).

View 3 Replies View Related

Stopping/starting Sql Server With Commandlinecommands In Batch To Free Up Idle Connections?

Oct 21, 1999

Hello:

We have a new sales force automation application for sales rep to log their contacts, etc. It runs on mssql 6.5, sp 4.

They log in and leave their connections on without logging off or leave their coonections idle .

We set the user connections fiarly high but we are concerned that the max amount of user connections weill be consumed and the sql serve becomes locked.

My questions are:

1) Is there any parameter in the sql server configuration that will log off idle users have a certain time and dsiconnect them?

2) A backup of the database will be made each night. If there is no parameter, would it be a good idea to stop and start the sql server every night to release the idle connections?

3) If so, how to stop sql server from the commadn and start it with a command line command and do this in a batch file as a scheduled task?

4) Is there any other way to release these idle connections each night?

Any information you can supply will be appreciated. THanks.

David Spaisman

View 1 Replies View Related

Generate Values Between A Starting And Stopping Point (time Values).

Apr 23, 2007

[RS 2005]

Given the starting and stopping points (time values), how do I generate values between these points.

For example, if I have 08 (representing Hour) as a starting point and 12 as a stopping point.

From this I would like to generate a data sequence like 08, 09, 10, 11, and 12.

So how do I accomplish this? In SQL or in the RS?

The only thing I can think of is using a WHILE loop and a temporary table in SQL (not to keen on doing this).

//Håkan

View 7 Replies View Related

Stopping SQL Server Services

Dec 13, 2001

Anyone got any "gotchas" or "nightmares" they want to share out of experience where the services have been shutdown without the proper forethought?

I'm trying to put a case in for a SQL DBA to be paged and to be in charge of shutting down the services and/or put together a checklist of things to verify first.

While I realize shutting down the services is supposed to be a graceful shutdown process I'm willing to bet there are a host of considerations.

Appreciate any Input.

Regards

View 1 Replies View Related

Problem With Stopping SQL Services

Oct 26, 2000

Recently upgraded a 6.5 server to a 7.0 server. (same server)
When we try to stop the 6.5 service, the 7.0 service stops too.
Why is this happening? Aren't the 6.5 and 7.0 installations supposed to be independent of each other once the upgrade is done.

Further we would like to uninstall the 6.5 server from the machine as it is no longer being used. What considerations need be taken into account in our scenario.

Thanks

View 1 Replies View Related

Stopping SQL Services Affects Users ?

Oct 12, 1999

If I stop MSSQLServer service on my SQL7 server using net stop and then restart it seconds later with net start, how will this affect my users ? Will they notice this ? Gets disconnected ?

The reson is to memory recycle my server.

..Harold

View 6 Replies View Related

SQL Server Services Stopping After System Reboot (URGENT)

Jun 3, 2002

Hello,
SQL Server 2000 services getting stoped automatically when system get reboot. When system reboot they started and after 5 minutes they were getting stoped.
I went through the event log file and found that an error is occuring in sql server with number 17148.

And I also observed that there is a file called "C : P r o g r a m F i l e s V E R I T A S B a c k u p E x e c N T b e n g i n e . e x e" is executing during the maintenance process,which is stopping the sql server services(agent and olap)

This problem is generating error in sql server with above mentioned number.

regards,
vnk.

View 1 Replies View Related

Stopping Cancelling Report Execution Reporting Services Ssrs 2005 Using The Web Service Api

Mar 23, 2008

Hello,
How can I stop a report I started by using:
ReportExecutionService rs = new ReportExecutionService()
.
.
.
rs.Render(...)

I need to stop the report when a user clicks a button in my aspx page.

TIA
gad

View 1 Replies View Related

Starting With Integration Services

Apr 16, 2008

Hi guys,

I'm a .NET developer. Now I'm getting more involved with DB and I need to rune some scheduled jobs that involve mostly data.
They have to retrieve data from several sources, work with it and then wrap it together and insert the result into a table.
A lot of logic (code) is needed in the process.

For what I can see the best way could be using Integration Services, am I right?

Where could I start looking how it works and how can I use code and several things?

Thanks a lot.

Edit: Also, is it possible to use .NET assemblies in some way?

View 1 Replies View Related

SQL Server 2005 Reporting Services Not Starting

Oct 11, 2007

Service cannot be started. System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Library.Global' threw an exception. ---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file. (C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinReportingServicesService.exe.config line 5)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
--- End of inner exception stack trace ---
at System.Configuration.ClientConfigurationSystem.EnsureInit(String con...

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any tips would hugely help. I checked this config file and have not seen this info in the file.

View 1 Replies View Related

Timeout Error When Starting Sql Server And Other Services

Jan 9, 2008

Hi,

I am trying to start Sql server, anlysis services and other things through Configuration manager and iam getting time out error every time.

I was able to start and stop earlier. Please suggest a solution. I am using Sql server 2008 Nov CTP on XP machine.

View 9 Replies View Related

Error Starting Reporting Services In SQL Server 2005

Jun 21, 2007

Hi ,

I am trying to connect to Reporting Services through SSMS using the following parameters:

Server_Type: Reporting Services

Server Name : <Server_Name>

Authentication: Windows Authentication

Got the following error message:

TITLE: Connect to Server
------------------------------

Cannot connect to <Server_Name>

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<html><head><title>Server Application Error</title></head>
<body>
<h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request.
Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html>
--. (Microsoft.SqlServer.Management.UI.RSClient)

Any help would be deeply appreciated,

Thanks a lot for your Time,

Regards,

Sundar

View 6 Replies View Related

I Had Set My Windows Service's Startup Type As Automatic But It Is Not Starting Up Automatically When The System Is Starting.

May 18, 2007

Hello,

I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.

View 3 Replies View Related

Reporting Services :: How To Build Sum Field Starting From Constant Initial Value

Oct 9, 2015

I am using sql server 2012 and report builder 3.0 for building my report

I have a querry which produce the following output

Is there a way directly in report builder to add a new column field which need to produce the following output :

RUNNING STOCK
8          (calculated from ProductTotalWeight - StockBalance)
10       (calculated from Previous row value + StockBalance)
8        (calculated from Previous row value + StockBalance)
10      ....
8
10
8

Can this be achieved?

View 6 Replies View Related

SQL Agent Is In Starting Status - But Not Starting

Mar 6, 2002

We have SQL 2000 (SP2) , Our SQL server agent showing green light as started from EM , It is succussfully restarting from NT Services too . But When I open the properties of the jobs from EM its gives error message SQL DMO error " SQl Agent is starting , try later " . And in EM Next run Date & Time not available .

MDDB database is accessable & in Log file its recovered fully

Thankx in Advance

Sha

View 1 Replies View Related

Stopping A Runaway Job

Oct 16, 2001

I would like to create a job that wakes up every 5 minutes or so and stops any job that has been running for, say, more than an hour.

Alternatively, when it is a jobs scheduled time to run, if the job is already running, I would like it to stop the previous execution and start over.

Thanks

View 1 Replies View Related

Stopping Replication

Dec 3, 2002

Hi, I am unsure whether i can delete some system created tables from a database.

I was testing replication and then used the wizard to disable it all. I am however left with three tables that are replication based that have not been deleted. they are :
MSreplication_subscriptions
MSsubscriptions_agents
MSsubscriptions_properties

these tables are causing problems with some third party software due to the length of their names. I have tried to 'Exec sp_rename' but i get an error saying the objects are not valid for this operation.

Can i just delete them or will this cause problems if i want to start up replication in the future?

View 2 Replies View Related

Stopping Execution

Jul 13, 2004

Quick question...
I was under the impression that RAISERROR stopped excution in my DTS SQL Task, but it really just passes right over it.

For example:
RAISERROR('test error',19,1) WITH LOG
CREATE TABLE delete_me (data int)

Even though I rasie the error, the table still gets created. Any ideas on how I stop the task from going to the next line?

View 1 Replies View Related

Stopping Job If Running After 7 A.m.

Mar 31, 2008

I'm trying to stop a SQL Server Agent Backup job if it is running past 7 a.m. Can you reply with your ideas.

Thanks.

Deb Dawicki
Sansum Clinic
System Administrator III
805-692-6422

View 1 Replies View Related

Stopping A Script

Jul 23, 2005

In query analyser, I can stop a script with the "return" statement butif the script contains multiple batches (separated by GO) then thereturn statement only stops the current batch.Is there a way to stop the whole script?

View 2 Replies View Related

Procedure Stopping

Jul 20, 2005

Hi,Please look at the code at the bottom of this procedure (UPDATECOVENANT PRINT DATE). When I put it at the tope of this section, itdoes the update and fails to return the SELECT results. When I put itat the bottom, the SELECT returns results and the UPDATE fails.Can anyone suggest what might be causing my problem?Thanks/************ SPECIFIC PROGRAM SEARCH ************************/IF @PRG_ID != 0 -- PRG_ID suppliedBEGINSET @strWHERE = 'WHERE PRG.PRG_ID = ' + cast(@PRG_ID as varchar(15))EXECUTE (@strSELECT + ' ' + @strFROM + ' ' + @strWHERE + ' ' +@strORDERBY)RETURN(0)END/************ NON-SPECIFIC PROGRAM SEARCH ************************/IF @ORG_ID != 0 -- Add ORG_ID to whereIF @intAND = 0BEGINSET @strWHERE = @strWHERE + 'ORG.ORG_ID = ' + cast(@ORG_ID asvarchar(15))SET @intAND = 1ENDELSEBEGINSET @strWHERE = @strWHERE + ' AND ORG.ORG_ID = ' + cast(@ORG_ID asvarchar(15))ENDIF @PRG_Closed != 2 -- Add PRG_Closed to whereIF @intAND = 0BEGINSET @strWHERE = @strWHERE + 'PRG.PRG_Closed = ' + cast(@PRG_Closedas varchar(15))SET @intAND = 1ENDELSEBEGINSET @strWHERE = @strWHERE + ' AND PRG.PRG_Closed = ' +cast(@PRG_Closed as varchar(15))ENDIF @strWHERE != 'WHERE '-- if some parameters supplied..BEGIN-- Execute searchEXECUTE (@strSELECT + ' ' + @strFROM + ' ' + @strWHERE + ' ' +@strORDERBY)RETURN(0)END/************ UPDATE COVENANT PRINT DATE ************************/-- Added by JSHAW 02/25/2004IF @PRG_Covenant != 0 -- PRG_Covenant suppliedBEGIN--SET @ORD_Date = GETDATE()UPDATE PROGRAMSSET Covenant_Printed = convert(char(10),@ORD_Date,101)WHEREPRG_ID = cast(@PRG_ID as varchar(15))ENDGO

View 1 Replies View Related

Stopping Insert Duplicates

Oct 16, 2006

Hi Forum, I want to stop insert data if value already entered in Column, Im used to .mdb and am new to .mdf much thanks Paul

View 14 Replies View Related

Stopping A Service In A Script

May 29, 2002

How do you start/stop a service within a sql script?

View 2 Replies View Related

Server Stopping In Sudden

Oct 31, 2000

hi,
i am having sql7 with sp2.
Recently our server got bounced back. No body stopped the server, there are no work load at that time. Server suddenly stopped and started.
It is weired.
Can anyone have any clues , how it happened and why it happened.
Thanks!

__kavira

View 3 Replies View Related

Schedule Task Not Stopping

Jan 16, 2001

I've been running SQL Server for 5 years now and have not seen the following.

We have a scheduled night run task where we do various maintenance functions as well as print out the issued insurance policies for the day. All indications are that the run completed except that I did not get an email notification of success or failure.

When I went to enterprise manager, under jobs the night run seems to be stuck in the mode of "Performing completion actions". I cannot get it our of this mode back to "Not running". Trying to stop the task has no effect.

Any ideas/suggestions??

Thanks in advance.

Cheers,
Mike Byrd
Information Systems Manager
Texas Windstorm Insurance Association
Austin, Texas

View 6 Replies View Related