Client Installation && Configuration Automation

Jul 16, 2007

Hello!



I am looking to automate the rollout of the SQL Native client to our workstations. What I would like to do is use our login script to initiate an unattended install on the workstation. I will create the unattended file using the one that comes with SQL Server 2005 as a guide. This seems pretty straightforward.



More importantly, the other task I want to tackle is adding server aliases to the workstations. I am thinking of creating an alias for each of our applications and pushing the changes out by merging a registry key(maybe WMI? I dont know...). This way, should we need to move application databases to a different instance, we can just push an updated list of aliases to the workstations. The actual storage location remains transparent to the applications and users, (ie no configuration changes).



Has anyone done this or have any ideas? Are there any pros/cons that I have not thought of?



Thanks for any input!



Chris G

View 2 Replies


ADVERTISEMENT

SQL 7.0 Client Configuration's Problem

Mar 6, 2000

I setup SQL 7.0 server on NT Server and SQL 7.0 client on NT workstation. I wrote a VC++ program using ODBC to connect
database and set ODBC Data Source Administrator as follow:

- Add a new User DSN
- setup name, description, server, of User DSN
- enter Login ID and psw
- Change the default database to "Test" which I've already built on server (leave other options remain)
- didn't change any settings in the next page
- Test Data Souce successfully.

But when I run the VC++ program, it comes out an error message like this:

SQL Error State:01000, Native Error Code: 1645, ODBC Error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Changed database context to 'Test'.
SQL Error State:01000, Native Error Code: 1647, ODBC Error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.

Can anyone tell me what are these error codes means? Are there any settings on the SQL server that I forgot to set?

Thanks

View 1 Replies View Related

Client Configuration Utility

Jul 20, 1998

Could someone please explain to me the client configuration utility in plain English please.

I have VB applications installed on the sales force`s laptops that log onto SQL Server through RAS and an ODBC connection. The client configuration utility is not installed on their machines, but everything works fine.
The BOL say that when installing utilities, the user is given the option of selecting the net-library to use. I am not, when installing it on my NT Workstation, or W95 Operating system.
The BOL also state that the control panel has an entry to allow selecting which protocol to use. I cannot see it

Who needs the client configuration utility installed, obviously not the clients, is it just the people who want enterprise manager on their desktops ?

I am completely confused by this application
This is the one area of SQL Server where I am lost, help !

View 2 Replies View Related

Client Configuration Button Does Not Work...PLEASE HELP!!

Jul 25, 2000

Hello all,

Maybe someone can help mewith this...
Im running NT 4 SP5 on a compaq proliant 3000 server. Trying to create a DSN to connect with my remote SQL 7.0 server. When I click on the client configuration button (to set to TCPIP sockets), nothing happens. So now all DSN's default to named pipes...

Please help!!!!

thanks
Tom

View 2 Replies View Related

Installation Will Only Allow Client.

Feb 5, 2001

View 1 Replies View Related

Installation Will Only Allow Client.

Feb 5, 2001

I had SQLServer 7 installed when my machine (using Windows 98)was hit by a virus. This necessitated running the original setup disk. When I did this, I found a number of existing files had been deleted (history files for a credit card program, Windows dial-up connections ) including some needed for the SQLServer. I eventually uninstalled SQLServer and attempted to reinstall it. When I do, I get a message saying that this disk can only install the client version. I originally installed it from this disk so why can't I install it again?

View 1 Replies View Related

RTM Will Only Allow Client Installation

Jan 5, 1999

When installing the RTM version of SQL Server 7.0 it only lets me install the client tools. It will not let me install the Enterprise edition or Standard edition. Has anyone else run into this problem.

Thanks

Tom

View 1 Replies View Related

SQL 7 Client Installation

Apr 14, 1999

Can I installed Enterprise Manager from my workstation PC or any ways to remotely access the Enterprise Manager(SQL Server 7.0) at the server end and other utilities. I have installed the client network utility but do not know how to configure.

I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.


Anyone knows where to source out for SQLSERVER7.0 RESOURCE KIT?

Thanks in advance.

View 1 Replies View Related

SQL Server Client Installation

Apr 12, 2001

Hi!
Is there a separate set of files in the installation CD of MS SQL Server 7 which can be used to install a SQL Server Client installation?
Thanks in advance!
Bye!

View 1 Replies View Related

SQL Native Client Configuration Or Remote Connections Problem

Dec 7, 2006

If I look under SQL native client configuration | Client protocols, I have no entries and no ability to look at the properties of SQL Native client Configuration. Something is missing which I think is related to an error when connecting to my local server.

sqlcmd -E -S .devmain, 1064

I get error :

Encryption not support
sqlcmd: Error: microsoft SQL native Client : Client unable to establish connection

An error has occurred while establish 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..

In comparison to other machines here at work, it appears my remote connections are configured. But I have no Client Protocols under sql native client configuration, how can I get them in there?

Thanks, in advance.

View 5 Replies View Related

SQL Native Client Installation Failed

Feb 8, 2008

All,

I was trying to install SQL Server 2005 on Windows 2003 Server and it failed on installing one of the components "SQL native Client",

the Error message is

The Installation Package of the Product Microsoft SQL Server Native Client cana not be found. Try the Installation again using the Valid copy of the installtion package "sqlncli.msi"

Thx

View 2 Replies View Related

SQL Server Client Tools Installation

Jul 23, 2005

I'm trying to install SQL Server 2000 client tools on an XP workstation.MSDE already exists on the workstation. During the install I am neverprompted for a location to install to. I want to install to my D drive. Theinstall defaults to my C drive.Any thoughts?

View 2 Replies View Related

Stand Alone Client Tools Installation

Jul 23, 2005

Hi,I'm looking for stand alone installation for SQL server Client tools,or the files required for creating such an installation. I would liketo include this installation as part of the setup for my ownSQL-dependant app. Any assistance would be greatly appreciated.

View 3 Replies View Related

Need Help Sql Server 2005 Client Installation

Sep 11, 2006

Hi ,

Iam a new bee to sql server.I have Installed sql server 2005 ( trail software ) in my Server.I like to install sql server 2005 clinet in another system. Where can i download sql server 2005 client??

My requirement is , i should access sql server database from my client...



Regs,

Priya

View 2 Replies View Related

Force Protocol Encryption In SQL2005 Client Configuration Doesn't...

Feb 5, 2007

I am accessing a SQL2005 Express SP1 Server via TCP/IP (all machines fully up to date with windows update). For ease of configuration the Server IP is mapped to an Alias in Native Client Configuration Manager. On the Client Force Protocol Encryption is set to Yes and Trust Server Certificate is set to No. The clients are accessing the DB via SQL 2005 Management studio express and Ms Access 2003 (an access adp front end to the sql database).

As a test i turned off force encryption on the server. A Network trace shows no encryption! Turning on force encryption on the server corrects this.

As a further test I configured the server with a certificate the client doesn't trust. No error is generated by the un-trusted certificate! The only way to generate the certificate error is to enable encryption in the connection properties of each application. Why isn't the Native Client Configuration Manager utility enforcing this???

This brings me on to a second (off-topic problem). In my access adp file, if I enable €śuse encryption for data€? advanced option under the database connection dialog all works as expected (encryption + certificate verification). However, I am programmatically updating the connection in VBA

Application.CurrentProject.OpenConnection "Provider=SQLOLEDB.1;Data Source=AliasName;Use Encryption for Data=True;..."

If I do this no encryption is enabled!!! Access seems to just ignore the encryption statement.

Has anybody got any ideas as to why either of these issues are occurring or if there are any workarounds?

Thanks

Stuart



View 3 Replies View Related

SQl 2005 Reporting Services - Installation && Configuration - Need Help!!!

Jun 20, 2007

Hi,



I've encountered this error when opening up http://localhost/ReportServer/



The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.

Here is the log info:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__06_20_2007_10_08_12.log</Path>
<SystemName>CSD060266</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 57106 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: SQM timer timer enabled: Next Event: 60706 seconds. Cycle: 86400 seconds
ReportingServicesService!library!e!6/20/2007-10:08:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
ReportingServicesService!library!e!6/20/2007-10:08:44:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
ReportingServicesService!library!e!6/20/2007-10:08:44:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!e!6/20/2007-10:08:44:: Attempting to start service again...




I've been doing all I could think of: reinstall the whole SQL server and its services; stop and restart SQL server service and Reporting service.



It could be my SQL version has a problem...not sure....

I could not think of anything else.



If you have any thoughts about it, please do reply.



Any suggestion is highly appreciated. Thank you...

View 3 Replies View Related

Installation Wizard &&amp; XML Configuration File Location

Jan 15, 2008

Hi,

I am using SQL Server configuration indirectly with the connection to it configured in an XML configuration file with the location of the XML file and the connections all being different between development and production. I deploy to the file system using the SSIS Deployment Manifest/Package Installation Wizard.

It seems that sometimes the path to the XML config file is updated in the deployed packages and sometimes it is not.


When the path is updated, all connection strings (as displayed in the Connection Managers section of the Execute Package Utility) are displaying the new values as well.


When it is not, it looks for the XML file in the development location and since it cannot find it all configurations still point to the development connections.


Does anyone know of any conditions when the location of the XML config does not get updated and when it doesn't?

Thanks,
Sven

View 6 Replies View Related

DB Engine :: Extract Configuration To Replicate Installation

Apr 26, 2015

Say I inherit from an undocumented installation of SQL server.  Is there a way to extract all features, configurations and such to apply them on a different installation?For instance, if the setup was executed multiple times, can I generate a configuration.ini file contains the culmination of every setup executed?

View 3 Replies View Related

Sql Server Configuration Manager Installation Not Found

May 22, 2008

I cannot find sql server configuration manager installed in cluster. but the installation is complete. what should i do

View 4 Replies View Related

MSSQL 2005 Express Client Installation

Mar 18, 2008

I need to install the 'MSSQL 2005 Express Client' on a computer that will be hosting a copy of an MSSQL 2005 Standard Edition database.
Question: Should I install both the DataBase Services feature and the Client Components feature?

Many thanks, for your help on this.

View 4 Replies View Related

Windows 2003 Server And Client Installation

Apr 30, 2008

hello,

i have a windows 2003 server up and running and a client workstation connected via a crossoever cable. they both can ping each other.

my next step, i would like to replicate a "real world" scenario where i have the database engine and the sample databases on the server and i would like to be able to write to and from the cleint to main database which is going to be on the server.

so my question is, do i need a full install on both machines?

View 1 Replies View Related

SQL Server System Configuration Checker - Installation Error

Jan 3, 2007

hello,

I downloaded SQL Server 2005 from Microsoft's website and tried to install.

First I downloaded and installed filename "dotnetfx.exe" according to the install guide. Installed without any issues.

Then i tried to install filename: "SQLEXPR.exe"- the main SQL Server software- which I also downloaded from Microsoft. I get the error below and here is how i got it.

------------------
ERROR:
The SQL Server system configuration Checker cannot be executed due to WMI configuration on the machine YOUR-07NFK16HDF Error:2147749896(0x80041008)
--------------------

I clicked on the executable file SQLEXPR.exe, then,
after extracting the file,

after the end user license agreement...

the next screen says "installing prerequisites Microsoft SQL server 2005 setup support files, the required components were installed successfully"

then i hit "next", then I see the screen with message (below:

"system configuration check....SQL server setup is scannong your computers configuration".
During this process(system configuration check), this is when I get the error ERROR- above. The pop-up error screen has a help icon.

clicking on help gives me the info below and says i must send it across the internet

Link ID = 20476
Product Name = Microsoft SQL server
Product version = 9.00.2047.00
message source = setup.rll
messageID = 70342

the resulting information says that there is no such information about message source in the knowledge database.

-----
pls what is the problem. Is it with the downloaded file(I got it from Microsoft's SQL Server home page)...and pls what is the WMI configuration on my machine?

Im using a Toshiba Satellite Pro Laptop, WIn XP with SP2.

thanks
El_N

View 4 Replies View Related

Walk-through Of A Distributed SSRS Environment Installation/configuration?

Apr 30, 2008

I'm using Virtual PC on my WinXP PC, with two W2K3 environments runnings as Virtual PC guests. My goal is to use these virtual servers to emulate a distributed SSRS environment--prior to setting up a similar environment on physical servers.

One of the W2K3 guests is my database server; the other W2K3 guest is my report server. Just like with a physical SSRS environment, there are many choices that need to be made during the installation and configuration--any one of which, it seems, can prevent the environment from working properly.

Currently, I'm struggling with getting my virtual distributed SSRS environment to work. I could go into the details, but I figured I'd ask a basic question first: Is anyone aware of a book, magazine article, blog, etc. that goes through a distributed SSRS installation--listing the requirements, discussing the choices, considering the implications, etc.?

Off the top of my head, such a walk-through would ideally cover networking configuration issues (Virtual PC or otherwise), Active Directory considerations, Windows Firewall settings between the servers, SSRS-related service account selections, authentication between the servers, etc.

If no one has produced such a walk-through (!), I'd be happy to write one so that others don't have to deal with the same struggles I'm currently dealing with....but I'd need your help.

View 8 Replies View Related

Reporting Services :: ReportServer And ReportManager Directories Missing After Installation And Configuration

Aug 24, 2015

I contact you because we installed Report Services 2012 and after configuring werb service URL, database, Report Manager URLs... the URLs linked to the Report server + Report Manager does not work.After searching in IIS, it seems that even if virtual directories are created, they are linked to directories which does not exist :- c:Program FilesMicrosoft SQL ServerMSRS11.ReportReporting Services does contain only LogFiles and RSTempFiles directories.

View 7 Replies View Related

Force Client Components Using A Commmand Line Installation To Diffrent Location

Jan 12, 2007

Is it possible to force the SLQ 2005 Client Components to be installed into a diffrent location other than the default location?


What I'm trying to do is run the setup command though the command line to create an unattended client installation with all the client componets to a diffrent location that

Thanks, Any information or examples would be great!

View 1 Replies View Related

Setup And Upgrade :: Extract Only Client Installation Folder From Complete Media

Sep 8, 2015

Is there a way to extract only installation files to install SQL 2012 client tools from complete media set. I'm interested in SQL MGMT Studio/Profiler/Data Quality services/Configuration tools.

View 2 Replies View Related

SQL Server 2005 Installation Woes For Workstation Components And Client Tools

Apr 27, 2008


Hello,

I have installed successfully Microsoft SQL server 2005 in MSCS.

However the set up did not install Workstation components (client tools - SSMS etc).

I have successfully installed workstation components in one node of cluster.

However setup is giving following error while installing workstation components on other node. (From this node MS SQL server 2005 was installed).

Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup

There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.

I did "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, /setup".

It executed but no error, no output.

Any gues, help in isolating issue?

Any more information required.(Media is ok. Setup has been tried after reboot. There is enough disk space.)

Regards.

Mahesh
===========
Setup

1) Microsoft Cluster of two nodes.
2) Hardare - HP Blade servers
3) OS - Windows 2003 EE with SP2
4) SQL Server 2005 Standard Edition with SP2.

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

MSI (s) (B0:7C) [17:40:20:390]: Note: 1: 1722 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup
MSI (s) (B0:7C) [17:47:23:609]: Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup


MSI (s) (B0:7C) [17:47:35:921]: Note: 1: 1729
MSI (s) (B0:7C) [17:47:35:921]: Product: Microsoft SQL Server 2005 Tools -- Configuration failed.

MSI (s) (B0:7C) [17:47:35:953]: Cleaning up uninstalled install packages, if any exist
MSI (s) (B0:7C) [17:47:35:953]: MainEngineThread is returning 1603
MSI (s) (B0:A0) [17:47:36:062]: Destroying RemoteAPI object.
MSI (s) (B0:80) [17:47:36:062]: Custom Action Manager thread ending.

View 1 Replies View Related

Configuring SQL Express During Installation And Attaching Smart Client DB / Silent Install For One Click?

Oct 9, 2006



Hey all,

Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.

Thanks in advance,

Bill

View 7 Replies View Related

SQL Server 2008 Installation - Server Configuration Problem

May 18, 2008

I have got problems with installation of a default instance on SQL Server 2008 on Vista Home Premium. During the step of Server Configuration you should enter UserName and password for each service. I do not know what user name to type. I tried every possible combination but the outcome is always the same - after typing usernames and passwords, installation suddenly fails without casting any exception. I'm not sure if I do something wrong (wrong User Name or Password) or is it a problem with installation application or with OS. Please, help.

View 4 Replies View Related

Automation

Dec 1, 2007

 Is there a way to automation SQL on an SQL Server to perform
impports and exports at a certain of the night.  The server is
always running. Thank Dee 

View 6 Replies View Related

DTS Automation

Feb 5, 2001

I'm trying to bring down a file from the AS/400 to update a SQL database table. Either thru the configuration limitations on the SQL server or ??? I cannot reach the as/400 from my SQL box so I'm running the data down to a Citrix server to a text file via client access.
I need to automate the DTS package run on the SQL box to pull the data from the Citrix server over to the SQL box.
How do I set up the DTS package to run on a schedule?

View 2 Replies View Related

Ole Automation.

Apr 30, 2008

One of my developers needs on enable Ole Automation on production? What security loop holes we are creating, by enabling this feature in SQL2K5?



------------------------
I think, therefore I am - Rene Descartes

View 5 Replies View Related

Automation

Dec 3, 2007



How can I import an xml file to SQL 2005 at the same time every night? I
will need to create a new database first via the import after that I will be
appending to the dataabase. Then I will need to xport the data into a
different xml file and upload to my hosting system which is yahoo. All so the
original xml file is on the yahoo. store server.

I have SQL 2005 standard install on my personal work stations. When I iron
the bugs out I will be running this from our SQl 2005 Enterprise server.


Thank you
Dee

View 11 Replies View Related







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