Admins, Surface Area Configuration

Apr 16, 2008

Up til now i've been working with Access, i have only got a few weeks experience with SQL, so dont eat me.

I set up a SQL Database, and placed it into my site, etc, set up all the connection strings. It connects fine, but cannot log in.  It tells me;

Cannot open database "C:USERSJAREDDESKTOPSTYXSTYX - BUILD 2APP_DATASTYXDB.MDF" requested by the login. The login failed.
Login failed for user 'Webdev01Jared'.

I'm running Vista (x86), and SQL Server 2005 Express SP2, and i'm aware that Vista by default does not automatically enable remote access in SQLExpress for local admins.

 So i go into Surface Area Configuration. I've read about it, and it's two steps, Click "Add New Administrator", then select the priveleges in the left box and click the button to put them in the right box. Simple enough, and it works, sure, click the button, it moves across, done.

But. Hit OK. It's done nothing, i still cant connect, and the cherry on top; open up the SAC again to check and there is nothing in the right box. It's exactly how it was before i changed it. The problem is definitely this, and not the account, as i can log in for SQL Management Studio just fine, with the same windows authentication credentials.

 Thanks in advance.

View 3 Replies


ADVERTISEMENT

SQL Configuration Manager And SQL Server Surface Area Configuration Tools

May 2, 2007

I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.

===================================



The following components are installed on this server

DEV

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Reporting Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

QA

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Common components

Integration Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Notification Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Workstation Components

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

===================================

View 1 Replies View Related

Surface Area Configuration

Apr 14, 2008

Dear All,
i'm trying to publish a maintenance plan in sql server 2005.

but soon after right click and selecting a new maintenance plan, it is displaying an alert with "AgentXP's component" is turned off.


please let me know how to ON those services. i've read and followed the instructions but i was unable to find where exactly to start.


please guide me in this regard

my version of OS is sql server 2000 professional

my version of sql server is :Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Surface Area Configuration

Feb 28, 2007

Hi, we are having a strange problem when trying to configure the surface area of my sql server 2005. When we open the tool the only nodes that appears are: Reporting Services and Integration Services. But the Database Engine node is not showing. What do we have to do to access the Database Engine node and configure Remote Connection.



Any help would be extremely appreciated...

View 12 Replies View Related

Surface Area Configuration Error Message

Dec 14, 2006

Hi Dear

I have been trying to add SQL database to my web application and have to configure the SQL to allow remote accee.

I would like to start the Database Engine Service when I click on start button to start the service it dissplay following message:

An error occurred while performing this operation

Severa; time I restart the computer still, When I try it is same problem.



thank for yout help.

View 3 Replies View Related

Problems Using The SQL Server Surface Area Configuration

Jul 19, 2007

I am currently running a Windows Vista Enterprise OS platform using SQL Express, whenever i add a user to the administrator group using the SQL Server Surface Area Configuration UI, each time i click on the link to add New Administrator, the previous administrator i just added still appears on the left - just as if i never added this user previously.

Is there a way around this issue? or is this a SQL Express problem, because i also tried doing it with SQL Server Enterprise edition on a Win2K3 SP2 box and it gives the same results.

Feedback is greatly appreciated.

Thanks

View 1 Replies View Related

~ Regarding SQL Server 2005 Surface Area Configuration ~

Nov 9, 2006

Sorry for the annoying. I would like to the configuration settings for the surface area. There's an option which able to let us change computer (whether is local computer or remote computer). Let say I put my own computer's name (Hans as example) for configuration as the remote compute, it's work fine to me. However, if I put my remote computer's name, it displays this error message to me.

Error :

Computer Tomato does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.


I am sure that the remote computer is working since I am able to ping the remote computer and test on telnet as well. But why it seems that surface area can't detect my remote computer. Hope can get some resistance from everyone here. Thanx alot.

Best Regards,

Hans

View 1 Replies View Related

Database Mail && Surface Area Configuration

Feb 5, 2008

I want to send mails from SQL Server 2005 Management Studio Express for which I referred to the article at http://www.databasejournal.com/features/mssql/article.php/3626056. I could successfully do the steps from step 1 to step 6 listed at the above URL. In fact, when I sent a test mail (as cited in step 6), SQL Server displays the message Mail queued though the mail didn't get delivered. The mail server address I am using is smtp.mail.yahoo.co.uk.

But when I expand the Management node in the Management Studio Express GUI, I don't find Database Mail as a child node. In fact, there are only 2 child nodes under the Management node - SQL Server Logs & Activity Monitor.

Why isn't Database Mail listed under the Management node? What am I missing here?

Also when I open Surface Area Configuration & then click Surface Area Configuration for Services and Connections, the following error gets generated:

Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

Additional Information:


The type initializer 'System.Management.ManagementPath' threw an exception. (System.Management)
Unable to cast COM object of type 'System.Management.WbemDefPath' to interface type 'System.Management.IWbemPath'. The operation failed because the QueryInterface call on the COM component for the interface with IID '(38C15AF2-736C-477E-9E51-238AF8667DCC)' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (System.Management)
When I click Surface Area Configuration for Features, it generates the error cited above but from the first bulleted list.


How do I overcome this error? I confirmed that Windows Management Instrumentation is running by opening Services from Control Panel ---> Administrative Tools.

I am on WinXP Pro SP2. Please note that I also have SQL Server 7.0 installed in my machine which is a standalone m/c.

Thanks

View 1 Replies View Related

Failed To Connect To Localhost When Trying To Use Surface Area Configuration

Feb 13, 2008



Hello all, I hope someone can help me with this.

This is a new SQL Server 2005 cluster that we just installed for the first time, with SP2. I am trying to use a stored procedure with xp_cmdshell to run a script to backup the databases. I get the following error: locked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.

So I started Surface Area Configuration on the local SQL Server itself, and clicked on "Surface Area Configuration for Features". I then got the following error:
"Failed to connect to localhost. (Mirosoft.SqlServer.ConnectionInfo)
Additional information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I am logged onto the server as a user with Admin privs; I installed SQL Server using that id. I am logged in via remote connection, so I know it allows remote connections... and I am logged into the server itself when I try to run the tool, so I don't understand why it's saying that it's trying to connect remotely.

Has anyone else ever experienced this problem? Thanks for any help you can give.

Best, Amy

View 13 Replies View Related

Missing Some Components In SQL Server 2005 Surface Area Configuration

Feb 29, 2008

I was studying the SQL Server 2005 Surface Area Configuration tool to see how i could increase security.

I cannot find some of the components in “Surface area Configuration of Features�.

For example DAC appears to be missing. This is a dedicated administrator connection that allows an administrator to connect to a server.

Is this because I have SQL 2005 express instead of the professional version or could it even be to do with the operating system (XP home)

Only the following components are listed under "Database Engine":

Ad Hoc Remote Queries
CLR Integration
Native XML Web Services
OLE Automation
Service Broker
Xp_cmdshell


Thanks

View 1 Replies View Related

I Can't Find Database Engine Under MSSQLSERVER From Surface Area Configuration

Jun 8, 2008

The operation system is windows xp, and before i installed the SQL SERVER2005 the SQL SERVER2000 had installed.
the course of installing the SQL SERVER2005 has no error at all.
but i can not find the Database Engine under MSSQLSERVER from surface area configuration
==============
thank you in advance for any help

View 2 Replies View Related

Alter Failed Trying To Modify Surface Area Configuration Xp_cmdshell - Help Needed

May 9, 2007

I installed SQL Server 2005 Enterprise Edition (64-bit) and then applied SQL SP2. When I launch the "SQL Server 2005 Surface Area Configuration" and choose "Surface Area Configuration for Features" I'm trying to enable xp_cmdshell.

After ticking the checkbox, and clicking Apply, I receive the error below. Anyone have any ideas on how to fix this?







===================================

Alter failed. (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Configuration&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean overrideValueChecking)
at Microsoft.SqlSac.Public.Smo.SetSetting(Credentials credentials, DatabaseFeature feature, Int32 value)
at Microsoft.SqlSac.MainPanel.UserControlSSxp_cmdshell.ProcessOK(HashKey givenKey, String machineName)
at Microsoft.SqlSac.MainPanel.FormFeatures.commitDBChanges()
at Microsoft.SqlSac.MainPanel.FormFeatures.commitChanges()

===================================

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd)
at Microsoft.SqlServer.Management.Smo.ConfigurationBase.DoAlter(Boolean overrideValueChecking)
at Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean overrideValueChecking)

View 7 Replies View Related

Sql Server 2005 Sql Server Surface Area Configuration Classical Problem

Feb 18, 2008

hi ; everybody
i have almost installed sql server 2005 enterprise edition on windows xp sp2 and i havent connected to any server .i have taken error:40 with my all attempts.tcp/ip protocol have been enabled on sql server configuration manager.i have tried to start sql server surface area configuration but every my attempt have been resulted a fault which is below.
[No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)]
i dont suppose that i did something wrong when i setupped.because i read every article on the internet about how to make setup.also; i setupped numbers of times on my pc.
but i didnt accomplished.
i thank for any help.please; give your solution explicitly.

View 8 Replies View Related

Connecting Surface Area Configuration To Server On Clustered Server

May 8, 2006

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhostinstancename, but reports the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

View 3 Replies View Related

Surface Area For Features Not Connecting

Oct 4, 2005

Hello, I've installed SQLServer2k5 Sept CTP with the following config:  W2K SP4 Pro, SQL2K5 Std Sept CTP complete clean install.  Everything works except SAC for features.  I get the error below when trying to start it.  SAC for Services & Connections connects without problem and has local & remote connections via both TCP/IP and Named Pipes enabled for the server, and local & remote connections enabled for analysis services.  All SQL2K5 components & services are started in the Services control panel.  I've looked at port useage, wondering if some other process is using the port that SAC for features is pinging, but since SAC for Services & Connections works fine that doesn't seem to be culprit. 
I also get an error when running the Tuning Advisor, saying it can't connect, but demoted that to just a warning by closing some extraneous connections to the servere (had >10 open).  Still get a warning, but it doesn't prevent the Tuning Advisor from completing.
I've tried turning on and off various services, from Remote Registry Service to IIS, but no luck.  Anyone know what else I chould check to troubleshoot this?  Thanks!
Failed to connect to server localhost

View 1 Replies View Related

Cannot Access Surface Area Config

Jan 26, 2007

Hi,

I'm posting this in the Setup forum as I think the problem relates to my SQL Server Configuration. Being new to server management pls ask for more info if I don't explain this clearly enough, I'm running out of idea.

Here's the set up:

Windows Server 2003 Web Edition SP2
SQL Server 2005 Enterprise Edition SP1

When I try to run apps I get the following message:

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I've found some great notes on the TechNet forums explaining this error and how to resolve it by configuring the Surface Area Tool... remote connections etc

But, this is where I draw a blank as I cannot access the Surafce Area Configuartion for Services and Connections because certain components are not installed, or I do not have admin rights. I definitly have the admin rights, but have no idea where to start looking for aforementioned components.

During the SQL Server install I recevied the warning:

SQL Service Edition System Compatibility - Some components of this edition of SQL Server are not supported on this Op system.

It sounds pretty generic and doesn't offer anymore details, but could this be effecting it?

I've also noticed that when I open SQL Server Configuration Manager and click on SQL Server 2005 Services nothing appears in the right-hand panel???  I'm sure there should be???

I've been all over TechNet & Books online and cannot find any reference for what I'm experiencing.

Any help or guidance will be greatly appreciated!

 Thanks!

View 1 Replies View Related

Surface Area Config Problem . . .

Jun 29, 2007

Being very new to SQL Server, I have to ask - when I try to connect to SQL Server 2005 using TCP/IP I cannot. To accomplish this I was directed to use the Surface Area Configuration utility.



When I do this, I do not see the Database Engine the docks reffer to - any help/comments/suggestions?



Thanks,



Chris

View 1 Replies View Related

Sql2005 Sp2 64 Bit Surface Area Error When Rying To Access It Locally On Op Sys 2003 R Sp2 64bit

Mar 18, 2008

I get this problem when tryoing to connect to the surface area configuration for services & connections
As well as for features.
However I can connect via another computer and change the options accordingly but I just can't do it locally from the server ?
Does any one know why please, the links in the message don't help ?

===================================
An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ProcessRequest(Request req)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiSmoObject.EnumChildren(String childTypeName, WmiCollectionBase coll)
at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.InitializeChildCollection()
at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.get_Count()
at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm)
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
===================================
------------------------------
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildDataTable(ManagementObjectCollection listManagementObject)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildResult(ManagementObjectCollection listManagementObject)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)

Hmm A tad strange.

View 3 Replies View Related

Too Many Admins

Jul 20, 2005

I need to make a tigger on some tables that diffrent ppl have Adminaccess to themusing Ent-Manger.is there a way to store the current windows login user-name in to alog Table ??the problem is all our IT dep have admin access to this database and Inoticed that some tables are missing some info and I want to trackthis !the user-group's server roll on this server is "system Admins" and onthe database is Public and db_owner.thanksDon

View 2 Replies View Related

NT Group For SQL Admins?

Mar 1, 2001

I have an NT local user group called DOMAINSQL_Admins. I have created the SQL account for this group but when I try to execute sp_changedbowner 'DOMAINSQL_Admins' to make it the dbo of one of my user db's I get an error saying 'The login 'NORDAMSQL_Admins' does not exist.' This group is a member of the sysadmin server role. What else do I need to do to it? Do I need to specify any special access rights in NT?

View 1 Replies View Related

Admins. How Do You Configure More Memory.

May 14, 2002

I had a SQL server 7.0 with 1 gb of RAM.
I just added more memory and now I have 4 gb of RAM. How can I canfigure SQL to take advantage of this.

View 2 Replies View Related

Locking Down Windows Admins

Sep 27, 2007

We have some Windows admins that curently have complete access to our SQL Server 2000 and 2005 databases and are making the most of it. What I would like to do is either lock them out or at least clamp down on their permissions within the instance. They tell me that their application of system patches fails when they do not have the System Administrator Server Role. I would really like to revoke that from them since they are running amuck. Are there any best practices or even good practices about the BUILTINAdministrators login or on how to allow the Windows Admins to do their job yet keep them from interfering with mine?
Thanks for your help.
Bob

View 8 Replies View Related

Deactivating Admin And Domain-Admins

Sep 10, 2007

Hello,

is it possible to deactivate the groups admins and domain-admins in sql server without getting in trouble with the sql-server. For example when the system boots the program should start normally without any problems.

We want do deactivate the accounts because we have some critical information in sql server and dont want to give all admins the possibility to have a look at these data.

We just want to have sa within the role sysadmin.


Regards
Franz

View 4 Replies View Related

What Does VIEW SERVER STATE Give To Non-admins Over 2000?

Oct 4, 2007

Hello, without going into the politics of why I'm asking, does anyone have a compiled list of functionality that only sysadmin's could do in 2000 that VIEW SERVER STATE permission opens up in 2005?

From the documentation, so far I've found fn_get_sql (and it's dm view) but I'd really like a complete list.

View 5 Replies View Related

Referencing Surface Objects As This Or Me

Oct 23, 2007

Is there a way to refer to "current report item" using something like "this" or "me"? For example: I find myself often cutting and copying code to change the format or color of text boxes based on their value thoughout a report, and it seems like it'd be more efficient to write the formatting code once and then call it from each text box.

View 1 Replies View Related

Transact SQL :: Surface Some Access Data On Database?

Jun 22, 2015

surface some data stored in an Access database via SQL Server, ultimately to be consumed by SharePoint.  

I understand how to push existing tables to SQL Server as new tables.  In my case, what I am hoping to do is to link an Access query with a table in SQL Server, and have that table be updated each time the query is run (or even each time the database is updated).  

View 3 Replies View Related

Is Surface Chart Type Available In Reporting Services 2005?

Dec 28, 2007



Hi,



I am trying to create a report in report in reporting services.

The requirement is to display the data in a chart. A surface chart to be exact.

It appears that reporting services has most of the Excel type charts available to display the data but I do not see the Surface Chart type. Is this type available in SQL Server 2005 reporting services? If not, is there a 3rd party software available that integrates into BIDS?



Thanks

View 7 Replies View Related

SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )

Sep 22, 2007

I am getting following error when trying to install SQL express 2005 on XPSP2.


TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342


I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.


Do i need IIS installed? Its not installed on this box...

please suggest something... i am stuck...

Thanks,

View 3 Replies View Related

Package Configuration Wizard:-SQL Configurations Configuration Filter Not Working

May 23, 2006

Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do

thanks in advance Dave

Background:

SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go

http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx



Wizard results:

Name:
ETL

Type:
SQL Server

Connection name:
ETLConfiguration

Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.

Configuration table name:
[dbo].[SSIS Configurations]

Configuration filter:
PT_CUST_ABR

Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]





USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]

View 3 Replies View Related

Reporting Services :: Rdlc Print Layout Size Varies With Resolution On Surface Pro (Win 8.1 / Winforms)

Jul 17, 2014

We have a winforms application with local rdlc reports.  On Surface Windows 8 Pro devices only, reports render such that they are scaled down and don't fill the page.  If resolution is lowered on the device, the report scales up to fill the page.

 This affects the appearance in print layout and well as the actual printed size.

If we export to pdf, it renders to fill the page (as expected).  If you print to pdf or to printer, the scale is shrunken.

If we change the resolution settings so that "Make  text and other items larger or smaller" is set to small, the issue is resolved except the tablet is not very usable on this setting.Is this a bug?

View 10 Replies View Related

Configuration Manager - Which Configuration Type To Chose ?

Jan 14, 2006

It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.

Is this the preferable way of doing it ? I would like to hear some positive/negative comment of why chosing a configuration type instead of another.

It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)

Let's have some comments

View 3 Replies View Related

Storage Area Networks?

Sep 6, 2001

Does anyone know if SQL7 will work with Storage Area Networks(SAN's)? I've read that SQL2000 implements something called a Virtual Interface System Area Network (VI SAN) that allows communication with devices connected via a SAN.

My site is installing a SAN and I need to know if SQL7 can utilize those resources (Storage,etc) and how reliable if so.
Randy

View 1 Replies View Related

Need To Update Old Area Codes

Jan 29, 2004

I have files with area codes that are several years old. Everything I've seen about updating area codes deals with area codes that are current and are about to split in the near future. How would I go about bringing old area codes up to date?

View 8 Replies View Related







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