PackageVariable Setting Does Not Work In Another Environment

Aug 23, 2006

hi

I have this variable setting in C# in my self developement project works fine.

but when i implement it in actual project does not work.

/Set \package.Variables[User::ArchiveExcelFileConnectSt].Properties[Value];"" + xlspath + ""

when i test it in SQl query analyzer i need to replace // with / and works fine. but when i implement in c# it does not in my actual project. both have different Database.

Do i need to turn on some thing in my Actual Databas that my project points too or is there some thing else.

Thanks,

Jasmien

View 3 Replies

Setting Up Log Shipping In A Clustered Environment

Jun 27, 2006

Hi can anyone help with a step by step instructions on how to set up log shipping in a clustered envionment?

I aware that your need to set up a clutered share but am looking for as much details as possible.

Thank your for your help in advance.

View 2 Replies View Related

SQL 2012 :: Setting Log Shipping In AlwaysOn Environment

Jan 23, 2013

We have 4 Servers which have SQL SERVER 2012 and "AlwaysOn" have been enabled on all 4 servers:

Server1,Server2,Server3,Server4

Server1 is the Primary node and thr rest are secondaries. There is a Sync relation between Server1 and Server2 and also there is aSync relation between Server1 and Server3 & Server4.

Is it possible to setup log shipping from Server2 & Server3(secondaries) to two new servers?

View 9 Replies View Related

Setting Environment Variables For SSIS Packages

Feb 29, 2008

Hi all,

We're just in the middle of performing our first release of SSIS packages through various environments.

The way we are set up currently is the developer will check the package(s) and related config files out of source control, develop on their own machine and check everything in again. Then we deploy the packages consecutively to the Dev, Tst and Prd servers.

We are going down the path of using one environment variable for every config file. some packages share config files (e.g. we've only one config file for each database or ftp connection etc.) and some config files are package specific (error log file connections and success/failure e-mail sources etc.).

What we want ideally is a script that we can check into source control that will create the environment variables on a server at deployment. The "set" command at the command line can be used to change the value of an environment variable, or to create a session-specific variable, but not to create environment variables.

So far the only method that we're using is manually typing in the environment variable names via control panel and copying and pasting the paths into the value fields. Given that we're deploying potentially hundreds of config files, it's obvious that this new-fangled GUI point-and-click and copy-and-paste method of deployment is absolutely foolproof and totaly not prone to any error whatsoever.

Please tell me there's a way to create and set environment variables without going through control panel. running a script or something to do it automatically will: Ensure that each environment is set up accurately and identically, eliminating human error. Ensure that when a developer checks out a package to their local drive, although they may have to change the variable values, he can at least create the relevant variables without having to type them in. Enable efficient migration to another new server (for example during Disaster Recovery).

Can anyone point me to some example scripts at all?

Kind Regards,
Andrew.

View 4 Replies View Related

Setting Up Transaction Log Shipping In Prod Environment

Aug 21, 2007

Hi,

I currently have a 2000 Ent. production server and a stand by server ready for transaction log shipping.

Is it possible to setup transaction log shipping on a live environment without any interruptions?

I'm currently backing up the log every 1 hour, I'd like to increase to 15 minutes.

Any help would greatly be appreciated.

Thanks,
- Gary

View 4 Replies View Related

Problem While Setting Up SQL 2005 STD Into The Cluster Environment.

Mar 5, 2008

Hi all,

Currently i faced a problem while setting up SQL 2005 STD into the Cluster Environment.

User has existing windows cluster purposely for Print Cluster usage.
We install SQL 2005 standard version into windows cluster.
After installed SQL 2005 cluster into windows cluster. All SQL services can be up correctly in Cluster.
Then we install Print Manager Plus software from vendor Softwareshelf.com into both cluster nodes.
Configure/add one additional resource as generic service with dependency with windows/system32/spooler.
Everything is working fine for that night.
Next day morning I install SQL 2005 Management Tools into both server.
User claim that one of the printers has 1 print queue cannot be deleted in Print Management software from Microsoft. We tried shutdown and unplug cable from that PC. That print queue also cannot be deleted.
That I check with Cluster Administration. Found Visual C++ runtime error. It is related with ��spoolsv.exe�?.

Existing environment: OS is windows 2003 Ent R2 SP2 x 2
Cluster has been setup for print management server.
Please help.

Thanks

Best Regards,
Chun Oon

View 1 Replies View Related

SQL 2012 :: Setting Up Transaction Replication In Test Environment From Production

Mar 3, 2015

Setting up Transaction Replication in test environment. I am willing to bet that most of you take a production backup (if so, how, and using what?), restoring the database to your test environment, then running a snapshot to your subscriber and away you go.

But perhaps you take a backup of your publisher and subscriber, if so, how do you know there are no inconsistences because there were transactions sitting on the distributor?

What do you do if you have additional indexes on the subscriber for reporting, that are not on the publisher?

Here at work we are having issues with getting consistent databases set up with T Rep, missing rows, duplicate keys at subscriber etc. How to avoid these issues.

View 0 Replies View Related

Issue In Setting Up The Database Mirrioring Environment For SQL Server 2005.

Jan 30, 2006

Environment:SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine
I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS.
I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.
I got the error message. Please find the Message below.
An error occured while starting mirroring.
additional Information:
:..>Alter failed for Database 'KQDB', (Microsoft SqlServer.Smo)
:..>An exception occured while executing a Transact-SQL statement or batch
[Microsoft SqlServer.Connection.info]
:..>Database mirroring Transport is disabled in the endpoint configuration.
[Microsft SQL Server,Error: 1486]

If anyone have a solution on how to setup a database mirroring environment.Please send.

View 10 Replies View Related

DB Engine :: Setup Backup Share Folder In Clustered Environment While Setting Up Logshipping?

Oct 25, 2015

I am trying to set up log shipping in a clustered server environment. I am pretty confused about the location of the shared folder to be created to put backup created by log shipping job. Which drive should I use either local or clustered shared drive to store the backups in primary server and to copy the same in secondary Server?

View 2 Replies View Related

Getting Replication To Work On Windows 2003 Server X64 Environment Using SQL 2000

Feb 28, 2006

I have a mobile device application using mobile sql 2005 replicating with sql 2000 in a x86 environment. This works fine!

I'm having issues getting this to work under Windows Server 2003 X64.

I've got all the components installed under the X64 environment including CLR 2.0 X64 and the mobile sql tools. the but when I run the Configure Web Synchronization Wizard I get the following error. SQL Server 2005 Mobile Edition Server Tools were not found on the IIS server. Run the SQL Server 2005 Mobile Edition Server Tools installer....

My question is: Were do I get the X64 version of these tools?

sqlce30setupen.msi
sql2Ken@P4.msi

The SQL environment is X86 as follows: SQL2000 SP4

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Any help would be much appreciated!

View 6 Replies View Related

SSIS &&<DTS:PackageVariable&&>

Sep 29, 2006

Just noticed I mis-posted this on public DTS forum so posting here.I'm building packages programmatically. I notice that if I open them in BIDS
after building them, then make a change, my package grows in size
trememdously. An example today went from 60k to 90k. The reason is that
when the package is resaved in BIDS a large section of XML is added with
<DTS:PackageVariable> info.

I read on http://sqljunkies.com/WebLog/knight_reign/archive/2005/1/13.aspx
why this info exists. My question is, since I'm not creating it
programmatically, do I need to? It seems that it doesn't have to be there
for the package to run correctly.

Am I safe creating packages that do not have this section of info?

Thanks!

View 1 Replies View Related

Setting ReportViewer URI And Path In Designer Works, C# Doesnt Work

Feb 26, 2008

in both vs2008 I added a ReportViewer control to my WinForm, intending to render an RS 2005 report remotely. In the design pane (Report Viewer Tasks Popup) I specify <server report>,
URL http://server name/reportserver$instance name
path /folder/report name

and everything is fine.

When I set these values in c# as

reportViewer1.ProcessingMode = ProcessingMode.Remote;

reportViewer1.ServerReport.ReportServerUrl = new Uri("http://server name/reportserver$instance name");

reportViewer1.ServerReport.ReportPath = "/folder/report name";

I started getting a msg saying "the source of the report definition has not been specified". If I hit refresh, the report renders. Before I started playing with the designer setting, and only had the c# stuff specified, I wouldnt even get the message, the control would appear with all RS buttons (eg page forward arrow etc) disabled.

Does anybody know why the message is appearing and how to get c#'s settings to work immediately like designer settings?

View 1 Replies View Related

How To Deploy Updated Database From Development Environment To Live Environment?

Nov 16, 2005

I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?

View 3 Replies View Related

QA Environment?

Jun 12, 2007

Good morning,

I am a DBA and my boss recently recommended that we change our QA environment so that we don't have any databases on it unless they are actively being tested. This would be to save hardware costs.

The only issue I can think of at this point is that promotion to our QA environment would take up to 2 hours for some of our larger databases if we have to restore production databases to qa for every QA run.

Is this a good idea? How do you run your QA (full or partial copy of prod)? Any input appreciated.

Thank you.

View 3 Replies View Related

SQL EE And SQL SE In The Same Environment

Dec 5, 2007

Hi!

I work on a company where we today have one SQL Server Standard Edition and Reporting Services (SSRS) and Analysis Services (SSAS) installed on the same server.

Now we want to install SQL Server Enterprise Edition, but still have the Standard Edition installed.
We are gonna invest in one more server.

I wonder if its possible to install the database engine for both versions on one server and then install instances of SSRS and SSAS on the other server?

Can Standars Edition have SSRS and SSAS on another server than the Database Engine?
And is it different versions of SSRS and SSAS between SQL SE and SQL EE, or does SSRS and SSAS get the SQL EE benefits if the database engine is SQL EE?

Thanks in advance!

View 3 Replies View Related

24 Hour Environment

Sep 29, 1999

I have about 23 SQL servers running 6.5 SP3 or SP5a in a 24 hour environment. Most of the activity takes place between 6am and 11pm, with few transaction after 11pm. What is best to do with the main DB's transaction log, have the truncate at checkpoint option checked OR back up the transaction log a couple times a week? The Database is backed up every 6-8 hours.

Thanks in advance for your opinions/help.

LN

View 3 Replies View Related

DTS Environment Variables

Nov 21, 2005

I have about 40 DTS packages that I want to run against three different databases on the same server. Can someone suggest an easy way to run these jobs and differentiate each time which SQL or INI file to use.

Thanks,

John Shaening

View 1 Replies View Related

The Database Environment

Jan 14, 2004

Hello, everyone:

What is difference between testing environment and product environments for MS SQL Server? Thanks a lot.

YTZ

View 1 Replies View Related

SQL In A Wireless Environment

Mar 12, 2007

Jimmy writes "We use a software that stores its database in SQL. We currently have a server box running Windows 2000 Server with SP4 and SQL Server 2005 with SP2 which holds the database. The server is wired in but we have several other stations that connect to the database wirelessly.

The problem is with our wireless stations.
When a wireless client travels from one access point to a repeater, it'll drop the connection for that moment. Once it picks up the wireless connection again, it requires closing out of the software and going back into it so it reestablishes the SQL connection to the server.

Is there a solution for a seamless reconnection with SQL for our wireless clients? Is this a problem with our software or SQL? Please advise. Thank you."

View 2 Replies View Related

SQL Developer Environment

Nov 6, 2007

Hi Guys,
Im new to SQL Server 2005.
In our organization, I was tasked to implement and maintain
MS SQL 2005 database.
We have several system developer and they are using MS SQL 2005
as a backend database.

Currenty, they are responsible for designing their own databases required by their application.
My concern is that I want to restrict access to my SQL server that only the DB administrator can access the
database server.

My question is that, how they can design their databases without accessing the database server. Is it
possible for them to access SQL Server with some restriction? I mean, I want to impose some security measures
that they can only access objects within their scope.

Our current scenario is that they have MS SQL Express version installed in their pc and from that terminal
they can design and test their application and after everything is in place, Its me who will migrate their
respective databases for production in MS SQL 2005 server.

Hoping you can provide me the best alterntive to this query.

Thanks a lot.

View 3 Replies View Related

Development Environment Needs?

Jul 20, 2005

Trying to figure out what development enviroment we need in order todo the following:- develop a non-native SQL server stored procedure;- call a web service or java program from the stored procedure;- return static values;- call the stored procedure from a view.How do I get a hold of the right tools and what do I need to put thepieces together?Obviously, I've not used SQL server and I'm looking for the basicstarting point.Thanks!

View 5 Replies View Related

RDA Setup Environment

Aug 23, 2007

Hi,

I'm currently using the setup below for my RDA testing. Is there any problem with this setup?

connected connected
Client Apps (SQLCE 3.0) -----------------> Windows Server 2003 (Web server) ----------------> Windows XP (SQL2005)

previously was using windows XP to act as web server and have SQL server reside inside the same machine but having 10 connection limitation from windows xp where only 10 client can connect to the machine. The current setup moves the web server out to windows server 2003 and i believe it solves the 10 concurrent connection limitation but how about the SQL server? is it limited to 10 connection from windows server 2003 also? (Windows XP is my testing server, Windows Server 2003 contains important test data for the whole company) . I tried with concurrent RDA pull for 40 client concurrently with 1 pc having 10 client apps but obtain not really satisfying results. Pulling one table (20Mb) needs 1 to 2 mins through LAN networks but pulling concurrently with 40 clients takes up to 20 - 30 mins.

Any advice? Thank you and have a nice day.

Regards,
Ben

View 1 Replies View Related

SQL Express Environment

May 5, 2006

Novice SQL Express User...

Now that I've installed SQL 2005 Express Advanced, shouldn't there be a DB Environment I can work with? There must be a configuration mistake because I can't see the "container?" Prior to SP1 I had SQL 2005 Express installed and I could open and use SQL; however, once I loaded SP1 that stopped. I thought if I load the "Advanced" I would be "back in business."

Thanks,

Tony

View 1 Replies View Related

SQL Hospital Environment

Sep 25, 2007

i am working in hospital environment. i am a novice in SQL. i have an urgent issue to answer which is around numbering the order of theatre event for the same patient based on the into theatre time. Patients can go to theatres several times in the single hospitalisation. we need to order as 1, 2, 3 and so on based on the into theatre time which is date/time format. your help is much appreciated. thanks.

View 5 Replies View Related

Environment Variable

Jul 17, 2006

hi,

can you show me how to get the value of an environment variable from a script task?
thanks!

View 3 Replies View Related

Confguring The Environment

Dec 12, 2007

Hi

I have a SSIS package. Right now its doing a data flow task from flat file to an OLEDB destination.

Now If i have to move to a new environment , I have the exactly the same tables but the server name is different.

Is there any way i can configure this from .NET CODE.

thanks

Sai

View 5 Replies View Related

User Environment Error

Nov 11, 2002

Do you guys know how to fix this error?

windows cannot find the local profile and is logging you on with a temp profile? how do you get around this? Thanks.

View 1 Replies View Related

Production And Test Environment

Jun 25, 2004

Sould one has a seperated environment for production and test system? How do you do it on a same server? Install two instance? How do you seperate test DBs from the production DBs?
Please advise...Thank you

View 2 Replies View Related

Creating A Test Environment

Mar 28, 2007

I just got my first job doing some DBA work (junior level) in a small company using SQL Server 2000.

I would like to make a copy of the production DB and use it for development of SP's, DTS packages and views.

What is the safest way for me to copy the entire production DB, to a new DB on the same server?

Should I create a new DB, and do a restore of the production backup?

Any help would be appreciated,
Thank you.

View 3 Replies View Related

Log Shipping Vs. Clustered Environment

Jun 20, 2007

I am embarking on a project to upgrade our SQL server environment. I'm curious for some opinions on the relative benefits of Log Shipping versus a Clustered environment and you have any experience that has helped form your opinion on the issue?

Thanks,

Marc

View 3 Replies View Related

SQL Server Express In A Lab Environment

Aug 18, 2005

I'd like to allow students in a lab to use the Express Manager and T-SQL to create their own databases. I think I've figured out just about everything - but the last step. Here's my thinking on how to do this:

1. Students are power users, not local admin
2. Created a login for the builtinpower users group as follows:
create login [BUILTINPower Users] from windows with default_database=[master]
go
exec master..sp_addsrvrolemember @loginame = N'BUILTINPower Users', @rolename = N'dbcreator'
go
3. Now students can start the Express Manager and connect to:
localhostsqlexpress using Windows Authentication
4. After they do, they can open and run a script creating a database and populating it with tables and records.
5. All good up to here... but when trying to access the new database using VB Express (file based, not a remote connection) access is denied.

The problem is in the NTFS file permissions being assigned to the new database mdf and ldf files. Local administrators and the builtin Network Service accounts have permissions, but the student who created the database gets nothing... So the student is denied access to the mdf and ldf files when trying to make a connection to them using VB Express.

I can go in with a different account having admin privileges are assign privileges to power users for the mdf/ldf files after they're created but this isn't what I need (students need to work whenever they want without waiting for an admin to fix the file permissions).

Maybe I'm going about this all wrong? If I have to I can insist on students always using VS 2005 instead of VB Express and use connections to a remote database (no problems doing this), but I'm still hoping for an express solution.

I'm new to this forum, so apologies if this is a dumb question (but even if it is - can anyone point me in the right direction?)

Thanks

Mike Morrison

View 1 Replies View Related

Dual Redundant Environment

Mar 15, 2007

any tutorial on how to setup SQL Server in a dual redundant environment ?

thanks

View 3 Replies View Related

SQL 2005 In Hosting Environment

May 2, 2007

Hello,

I want to offer a SQL 2005 server in back-end configuration for my hosting clients. Basically this means that they administer the DB with a webbased tool and the DB server it self is configured in the backend and has no direct connect to the internet. The DBs can only be access from the frontend web server.

- What security considerations should I take to use this server in a public hosting environment?
- We only allow webbased administration, no direct connect to the server are allow and possible.
- Multiple databases will exist on the same server from different customers.

I really would like to have as many information as possible. There is not much usefull information available on the web or in the books I own about SQL.

The question should actually be: what do you want to prevent from happing on your servers by authenticated users and ofcourse unwanted users. And how to do this.

View 6 Replies View Related