Start Backup Of An Sql Db From A Client Machine

Apr 22, 2006

Hi nice forum you have here.

Please point me to a link on this forum if I’ve missed something but I could not find an answer to this question yet.

I am new to sql and am looking at running random backups of an sql database. Regular backups are running nightly using maintenance jobs in enterprise manager. These random backups would be started at a point in time just before a specific procedure was run. There will be a user assigned the task of running these backups who has no privilege to log onto the sql server machine (nor will he ever get this privilege).
I would be interested to know if there is a way to script this so that this user could simply start a backup from his workstation. The backup could be a repeat of the scheduled nightly backup storing to the same place or a new backup. The db in question is only 150 +/- MB so time involved in completing this job is minimal (the scheduled backup of this db completes in under a minute).

System is SQL 2000 sp4 on a Win 2003 server with XPpro sp2 clients.

Thanks for any tips, hints or detailed descriptions.

Regards

HT

View 4 Replies


ADVERTISEMENT

GetDate() - From Server Machine Or Client Machine ?

Oct 23, 2006

Hi,

If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?

From "ServerMachine" or from "ClientMachine"

Thanks

View 3 Replies View Related

Copy Dts To Client Machine

Dec 12, 2007

hi for all...
i've create a dts using MSsql2000 and finish it my question how could i download the dts to client machine i don't want recreate it in my hand if i could create a setup for the dts it will be great or if there is a command using osql for that
it will be nice
notice : i save it as structered storage file if it could help

thx for help

View 1 Replies View Related

Installing Sql 6.5 Client On 2000 Machine

Mar 26, 2001

i am trying to install SQL 6.5 client on 2000 box. but the installation wants to install an SQL 6.5 SERVER on it. Is there something im forgetting?
is there a way and if so how? if not, is there a workaround with out upgrading the sql 6.5 server.

Thank you in advance

View 1 Replies View Related

How To Install Reports On Client Machine

Aug 9, 2007

Hi
I am developing a Report Project ,that contains some reports
using VS.Net ,My task is to install these reports on client Machine.
Is there any option to add a "Set Up Project" to the Report Project solution, so that client may run this setup project(.exe) to install the reports in his server.

My Main requirement is , client can install these reports into his machine by executing a set up file.
Is this possible?, Please suggest me a good solution

View 1 Replies View Related

Execute Windows On Client Machine

Jul 23, 2005

Hello.How to execute add users window, backup wizard and other windows fromEnterprice Manager on client machine? Does MDAC or sth is able to do this?bye...--__ __|__\ | || |_// / \ \_// FreeBSD: The Power To Serve|__// |__|| | \ \__// / \ +------------------------------++[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+

View 1 Replies View Related

Could Not Connect Server From Client Machine

Dec 12, 2006

Hi all

I m a new member to this forum. Im a hardware engineer who rectify aome software related issues. Now our employees having problem with connecting their XP prof based clients to 2003 server from SQL query analyzer. I tried refresh sql server manager in server and tried restarting the server machine many times. sometimes it the client machine connects and disconnects immediately. i aslo tried changing the poll interval , but no use.

waiting for a speedy solutin... i know this is as easy query.



View 4 Replies View Related

Client Machine Accesing Sqlexpress

Oct 3, 2006

This may a silly question but....

I wrote a vb 2005 application that access sqlexpress for data using sqlconnection (.NET). The program works fine. When I run debug on my code that is in my laptop, it access my xp server box with sqlexpress running and I see all my data in my application. My question is..When I compile this program and install it on a client machine that has no sqlexpress tools, no SQLCMD etc....will the application run and access the xp server box, or do I have to install something on the client machine.

thanks

View 1 Replies View Related

SQL Server Failed To Start After Changing The Machine Name

Jan 30, 2004

hi all,
i am using SQL Server 7.0 . After changing the machine name the sqlserver is not starting. if i changed the machine name to the old name the server starts as usual. is there a solution for this problem. where can i change the machine name in the sql server configuration. so as to start it correctly...
thanks...
jinujose

View 2 Replies View Related

How To Set Client Machine Name When Using ADO To Connect To SQL Server 2000?

May 15, 2007

When you connect to SQL Server using SQLConnection, how to set client machine name(or IP address) so that you can monitor the process on Server side using Enterprise Manager?

View 2 Replies View Related

Installing SQL 6.5 And 2000 Client Utilities On The Same Machine

Aug 24, 2004

Can I install the client utilities for Microsoft SQL versions 6.5 and 2000 in the same machine?

Please, provide me with any information or links in this matter.

View 5 Replies View Related

Local Storage In Client's Machine In .sdf File

Apr 2, 2008



How to create a db in clients local machine with sql server ce and .net?Is any sample applications available?so,that later i can sync the data to the sql server db.
Please help.I am new to sql server ce.

View 3 Replies View Related

Accessing Report Builder From Client Machine??

May 14, 2007

Accessing report builder from client machine in which there is no sql server with the url http://<server name>>/reports. The report builder tab is not getting displayed.
when accessing from http://<server name>/reportserver/reportbuilder/reportbuilder.application it gets connected to the report model but when we are running the report it say the user doesnt have sufficient permissions or database can not be processed.

The permission is given to the user on the data source. For admin permission the report is running fine.

Do anybody know the procedure to run adhoc reports from client machine??

Urgent!!

View 2 Replies View Related

Cant Get Access Database Synchronizer Set Up On Client Machine

Apr 17, 2007



I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.



His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"



However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".



There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".



His current config.xml file looks like this.



<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:Program FilesNOAA Release LoggerNOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>Program FilesNOAA Release LoggerNOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:</WinDir>
</SystemNode>



He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error



"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"



I dont know what else to try! Anybody have any suggestions?

View 5 Replies View Related

Restoring Backupfile Residing In A Client Machine

Oct 11, 2007

hi all,

Is it possible to restore a SQL server Backup file residing in a client machine?. I dont have network access to the Server's
drives to copy the backup file, eventhough I am having SA privilege on the SQL server instance.Can anybody help me?

Thanks in advance,
Sanoj

View 1 Replies View Related

My First Experience Distributing The New-built Sql Db Onto Client Machine?

Dec 14, 2005

hi i am new to mssql db stuff. I just developed my first VB.NET application and it uses a mssql database which is hosted locally on my development machine. I built the deployment msi file for my application which can be installed easily on client machine, but have no idea how to move the mssql db with it.

View 1 Replies View Related

Unable To Start Reporting Services On Local Machine

Apr 6, 2008

I am new to SQL Server 2005 Reporting Services and I€™m having problems starting the service. I am running a Windows XP SP2 with SQL Server 2005 and reporting services but the service will not start. My SQL Server instance logs on using €˜Windows Authentication€™ using a username sysadm with no password

I have installed IIS and made sure that ASP.net is running.

I have opened up the Report Services Configuration Manager and amended the settings but I€™m unable to get the service started!!!

Theses are my settings

i) Report Server Virtual Directory OK
Name: ReportServer1
Website: Default Web Site

ii) Report Manager Virtual Directory
Name: Reports1
Website: Default Web Site

iii) Windows Service Identity
Service name: ReportServer
Service Account: NT AuthorityLocal Service

Iv Web Service Identity (NOT WORKING)


v) Database Setup
Servername €“ Nameofmyserver
Database name - ReportServer1
Credential Type Server Credentials


When I click on start no error message appears, it just seems to time out.

View 5 Replies View Related

Not Able To 'Step Into' The Procedure Code In SQL Debugger From Client Machine.

Jul 25, 2003

Hi,

I am working on SQL-Server 2000 (developer edition) with SP3 on Win 2000 and Clients are Win98/Win XP.

I am not able to 'Step Into' my SQL Procedure code in Debug mode, executed from Query Analyzer from a client machine. As soon as I select the 'Execute' button after inserting all the parameters value, the whole procedure gets executed. But I'm able to do the same (i.e 'step into') from the Server itself.

Do I need any additional configuration settings in the client machine ??

I shall be greatful if anyone can help me to solve the above problem.

Thanx in advance.

Surajit

View 2 Replies View Related

DTS Execution From Client Machine Fails Connecting To Oracle

Jul 20, 2005

I have created a DTS package that pulls data in from Oracle into SQLServer. When I run it directly on the server (from EnterpriseManager), it works fine. When I run it from Enterprise Manager on aclient machine that does not have the Oracle client software, it doesnot run, giving me the error: "The Oracle client and networkingcomponents were not found...". I was hoping I wouldn't need to havethe client software installed on a machine other than the server whereSql Server is running. The problem here is that there are a number ofmachines from where I would like to execute this DTS package that I donot want to install/configure the Oracle client software. I don'tquite understand why the configuration of the client is importanthere. In my mind, when I am using enterprise manager from a clientmachine, I am using it sort of like a terminal services client toconnect to the server. I guess there is a lot more happening in thebackground.Thanks for any feedback,Marcus

View 2 Replies View Related

Login Failed For User 'sa'. [CLIENT: &&<local Machine&&>]

Jan 23, 2008

One of my co-worker changed the sa password today. After that we are getting this error. The SA account gets locked every time. Even within few seconds of unlocking the SA account, it gets locked again. Error message is not clear as what session still using old password and causing the SA account to get locked? Any of our application does not use SA user to connect to databases. We have Tivoli installed on the same system and the GUI of tivoli has the correct password.

Shailesh

View 3 Replies View Related

How To Insert Record To SQL Server Which Is On The Other Machine From Client Computer?

Jan 14, 2007

I want to write simple sql database project that that works in the network. and i need to insert record from a client to a server that is on the other machine.

View 1 Replies View Related

SQL2005 Cluster Install Fails - Task Did Not Appear To Start On Machine

May 3, 2007

On a multi node Win2003 x64 R2.

When preforming install for 2nd SQL instance. Setup fails with log entries



Task did not appear to start on machine NODE2 : 267013

Task did not appear to start on machine NODE3 : 267013



Note: first install worked fine - after getting over MSDTC issues...

Also have confirm task scheduler service is running on all nodes.



Anyone with some insights?



Regards

View 3 Replies View Related

Auto Start Mail Client

Nov 4, 1998

We currently have SQL Server 6.5 installed on 2 servers and did not
specify to automatically start the mail client. When I display the Server
Configuration/Options screen in Enterprise Manager, the Auto Start Mail
Client check box option is grayed out. How can I change these servers to
automatically start the mail client at startup?

Thanks in advance!

View 3 Replies View Related

Executing SSIS Packages From Client Machine Using SQL Express Engine

May 26, 2006

I have few DTSX packages on my SQL server 2005. These packages are supposed to transfer data and stored procedures from server to client Express engine. The scenario is that when user connects with the server he should run some kind of utility or any other way to run those SSIS packages so that the data could be transfered.

Remember the user machine has only SQL Express Engine and the packages are in SQL server 2005 machine.

Can any one help me out how to achive this scenario?

Regards...

View 4 Replies View Related

Reportviewer In Vb.net App Rendering Black Squares In Textbox On Client Machine

Apr 8, 2008



I have a simple text box in a table in the body of a report. This renders fine via IE on both my dev box and the client.

However when rendered within a Reportviewer control on the client, the box show the text followed by lots of black squares. Running the app on my dev box is also fine - no black boxes at all.


The report resides on the server, and the server is fully patched.


Any ideas greatly appreciated!

View 1 Replies View Related

Problem In Accessing The Database(Sqlserver 2005) From Client Machine

Apr 25, 2007

Hi



We have upgraded sql server 2000 to sqlserver 2005 on the development server.

To access the database server, we installed the sql server management studio on the client PC with Admin Account. The .Net framework and sqlserver management studio were installed and I am able to access the database from the client PC using Admin Login. Then we logged off and tried to login as user account on the client PC. From the user account login we are unable to open the sql server management studio. The error is as follows
€œThe proper type library could not be found in system registry€?

The client PC configuration : windows 2000 Professional ( sp4)

Regards,
K.S.Subba Rao

View 1 Replies View Related

Login Failed For User 'TESTadministrator'. [CLIENT: &&<local Machine&&>]

Nov 6, 2006

Hi Friends,

I am getting the below error while installing CSF DevLite edition on

Following is the breif Info

Server Is : Win2003

SQL SERVER 2005 Installed on Same PC

Domain Name is : Test

User : Administrator he is a build in Admin,

PLEASE HELP ME!!!! Thanking in advance.

EVENT LOG 1:

Login failed for user 'TESTadministrator'. [CLIENT: <local machine>]

EVENT LOG 2:

The description for Event ID ( 11609 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Product: Microsoft Connected Services Framework 3.0 Developer Edition Lite -- Error 1609.An error occurred while applying security settings. Power Users is not a valid user or group. This could be a problem with the package, or a problem connecting to a domain controller on the network. Check your network connection and click Retry, or Cancel to end the install. Unable to locate the user's SID, system error 1332, (NULL), (NULL), (NULL).

View 7 Replies View Related

Installting Sqlserver 2005 On The Client Machine For Windows Application

Oct 24, 2006

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

View 3 Replies View Related

How To Launch Package From Client Machine, Display Progress And Finally Results?

Oct 4, 2006

Please help. I'm completely new to SSIS, and I was hoping someone could point me in the right direction(s).

I am developing a winforms client app, and I need to be able to provide the user with the ability to import data in CSV format into our application's database.

I'd like to use SSIS if possible, as long as what I am trying to do isn't near impossible.

I'm thinking of a UI where the user can specify a flat file (CSV) to upload and be processed by an SSIS package on a remote database server.

This package will be responsible for validating the CSV file and inserting data into the database as appropriate.

Is there a way I can:

launch an SSIS package remotely, from a winforms app on the client machine that is not running SQL server (preferably asynchronously) -- and pass it some parameters, including the import file itself
(optionally) provide progress feedback to the client pc to let them know it is being processed
display a nice SSRS report on the client upon completion that tells them exactly what the success/failure of the import was (how many rows processed, which ones failed and why, etc)

Any helpful examples, links, etc would be most appreciated.



Thanks in advance!

View 1 Replies View Related

Execute SSIS Package Stored In Remote SQL Server From A Client Machine.

Mar 3, 2006

I have written a VB component to execute a SSIS package stored in SQL server.

I am using the Microsoft.sqlserver.dts.dtsclient, dtsconnection/dtscommand

and executereader and everything works perfect on the local machine. This is descibed in a msdn site .

But my customer have a remote SQL server and want no extra BI clients/SQL server clients etc on the client machine, only an ordinary windows client and network connection to the SQL server.

My question is: Can you still use dtsclient or do you have to do in some other way?

rose-marie

View 4 Replies View Related

MSSQLSERVER Login Failed For User 'MACHINEuser'. [CLIENT: &&<local Machine&&>]

Jul 29, 2006

I just did a fresh install of SQL Server 2005 Developer Edition and SP1. I elected Windows auth during install. After rebooting I get 2 errors in my Application Event Log: MSSQLSERVER Login failed for user 'COMPUTERuser'. [CLIENT: <local machine>] (event ID 18456) and Report Server Windows Service (MSSQLSERVER) (event 107) which says: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. In the data section it says it can't connect to the machines "master" database. I can manually login. How can I fix the problem and get rid of these messages? Thanks. Mark

View 11 Replies View Related

Maintenance Plan Failing With Login Failed For User 'sa'. [CLIENT: &&<local Machine&&>]

Nov 28, 2007

Maintenance plan for bakcup is failing with "Login failed for user 'sa'. [CLIENT: <local machine>]"

I went to the Maintenance Plan and opened the Subplan. I clicked the "Manage Connections"

It has three tabs:

Name: Local Server Connection
Server: prod
Authentication: SQL Server Authentication

I clicked the Edit and it shows the Connection Properties:

It says: Enter information to logon to the server. "Use a specific Username and Password" is checked. Username is set as "sa" while the password is empty. I typed in the correct password and pressed Ok. When I go back again, the password still shows empty. I tried to run the plan and it again fails. Do you know why it is not showing the password as blank even if I try to save the password.

View 1 Replies View Related

Backup To Different Machine

Aug 4, 2000

i want to a backup a database on a different machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.

any suggestions plz!

thanks.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved