How Can Combine 2 DataBase(one From Configuration And Another Sql Server)
Jan 6, 2008hi
please help me
how ican combine Between 2 DB (one from configuration used for login by wizard and another sql server use BC (my project needed)
ADVERTISEMENT
Server & Database Configuration
Jul 20, 2000Is there a way that anyone knows of that I can get a
printout of my server and database configuration?
I don't want 'Generate Scripts'. I'm looking for a
stored procedure or something that will give me a
text document listing the configuration.
I'm running SQL 7 with sp1 on most servers and sp2
on a few.
I would appreciate any info.
Thanks!
Toni
SQL Server 2005 Configuration Database
May 31, 2007
I am working on creating a configeration database based on the information pulled from a large number (over 40) of servers. I am newly out of college and don't have a lot of experience with things like this, but I am trying to create a configuration database. I need to know the best way to create a connection to all of the SQL servers on my network and then automate the pulling of data from these SQL servers. The types of data I would need are things like Instance ID, DBMS Version, Database Properties, Database Name, Modification Date, Last full backup, last transaction log backup, etc. I have been pointed towards either working with OSQL/SQL CMD, in which case could someone please point me towards a guide, and SSIS, I am reposting this thread in the SSIS area. I need to take all of the gathered data and place it into a central repository database after formatting it. Any help is greatly appreciated.
-Kyle Schlapkohl
Sql Server Setup Could Not Connect To The Database Service For Server Configuration
Jan 2, 2008hi all
i get the following message error when installing sql server 2005 express :
<< sql server setup could not connect to the database service for server configuration the error was :[microsoft][gestionnaire de pilotes odbc] source de données introuvable et nom de pilote non spécifié >>
is there any help
thanks and best regards
SQL Server Setup Could Not Connect To The Database Service For Server Configuration
Jun 4, 2006OS: XP-SP2
Not able to install SQL Express 2005.
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x80090325
Needles to say, above link is useless..
I had managed to install previously, but ran into problems while trying to upsize an MS-Access database, I've tried everything from creating certificate to hacking away at the registry...Log-on with a different account, etc...Anybody knows how to get around this?
Here's part of the log file:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sat Jun 03 20:09:53 2006
Machine : YANICK
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )
Sep 22, 2007I 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,
SQL Configuration Manager And SQL Server Surface Area Configuration Tools
May 2, 2007I 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)]
===================================
SQL Server 2008 :: Database Mail - Yahoo SMTP Configuration
May 5, 2014I'm having trouble in configuring Yahoo's SMTP for Database Mail. Here is my current settings:
Email Address: xxx@yahoo.com
Server Name: smtp.mail.yahoo.com
Port Number: 465
This server requires a secure connection (SSL) - check
Basic Authentication
Username: xxx@yahoo.com
Password: xxx
When I tried sending a test email, it didn't work. But when I changed my SMTP to use Gmail, it worked!
Combine Two Database
Apr 15, 2006I have a two databse say DB1 and DB2 in sql server 2005 developer edition.
Both Databases are completely different in structure(i.e nothing common)
Both Databases contains Important Data.
I want's to combine them into a new database named dbcombined.{provided that data remains intact}.
How can I do That?
Then Also I have to deploy that db in other system what I have to do?
SQL Server Admin 2014 :: Configuration Of Maintenance Plan For Full Database And Log Back Up
Jul 9, 2015I was trying to configure maintenance plan to take nightly full database backup and Log backup. I was trying to configure it like in attached file. Any links that i can follow and configure as in attached file.
View 7 Replies View RelatedCombine Aspnetdb With The Application's Database
Sep 19, 2006I have tried to find all the threads related to this topic. At this point I would like to find out what the best practices are for doing this. I plan to use Membership, Roles, and the login controls to handle my authentication and permissions issues. I want to use the same database for my application data as for Application Services, using a standard SQL Server. So far, the easiest way to set this up that I can think of is to:1. Use aspnet_regsql.exe to create the Application Services Database schema2. Edit the "LocalSqlServer" entry in <connectionStrings> to point to the above database3. Add the tables, views, stored procedures, etc., that I need for my application into the database created in step 1Is there any more configuration I need to do to get Membership and Roles working? When I did the Walkthrough, step 2 seemed to be the only requirement for getting Membership and Roles to work.Will I run into any trouble using LocalSqlServer for my application data updates?I would be interested in any other approaches to setting up a combined database, including opinions why and why not to do it.
View 1 Replies View RelatedSQL Server 2012 :: Combine One Value To Equal Two Values
Feb 13, 2015I have a report that I am running in visual studio 2010, that gets its data from a few different stored procedures in a SQL 2012 Database. The variables are Date and Office Code. We currently have 6 different office codes. One of the Stored Procedures gets call information for each office. With the report we can select any single office or any combination of offices to compile data.
The problem I have is two of these share phone information, so when you select either one or both of them the same data gets returned. So for example we have office codes of AAAAA, BBBBB, CCCCC, DDDDD, EEEEE, and FFFFF. Now AAAAA, and BBBBB share phone information so if you select office code AAAAA, the phone info that is returned is for AAAAA, and BBBBB, and visa versa. So I am not sure how to accomplish that either in the report or in the stored procedure.
SQL Server 2012 :: Combine Functionality Of IN And LIKE In WHERE Clause
May 8, 2015I would like to be able to combine the functionality of IN and LIKE in a WHERE clause. Although the simple AdventureWorks2012 example below illustrates the concept with 3 search criteria, the real-world example I need to apply the concept to has a couple dozen. This returns 50 rows, but requires multiple OR ... LIKE functions:
SELECT DISTINCT c.Name
FROM Sales.Store c
WHERE c.Name LIKE '% sports %'
OR c.Name LIKE '% exercise %'
OR c.Name LIKE '%toy%'
What I would like to do is something like this, which doesn't work:
SELECT DISTINCT c.Name
FROM Sales.Store c
WHERE c.Name IN(LIKE '% sports %', LIKE '% exercise %', LIKE '%toy%')
I could load up a cursor and loop through it, but the syntax is more cumbersome than the multiple LIKE statements, not to mention most SQL programmers are horrified at the mention of the abominable word 'cursor' for performance reasons.
Database Configuration Problems
Jan 18, 2006I am trying to learn ASP.NET using Visual Basic Standard Edition 2003 and an MSDE database. I am having problems configuring the login. Is this a workable configuration? Are there instructions somewhere for setting up this configuration? I have no problem using Access 2003, but I would like to use MSDE.
View 1 Replies View RelatedRemote Database Configuration
Aug 15, 2000Please excuse me as although I have lots of database design & development experience I'm not database administrator and I'm new to SQL Server.
I have a SQL server 7 database on a remote web server which I can access over the Internet.
I have SQL server 7 installed on my local network server and I use Enterprise Manager to administer and configure the databases on the server.
Can I use Enterprise Manager to administer and configure the remote database?
If I can't then how do I make changes to the remote database? Do I need to FTP objects or use RAS?
Any help would be very much appreciated?
Finding Out Database Configuration
Jun 12, 2003Hi,
I'm new to SQL 2000 administration and would like to know how to find out what the existing SQL Server Database configurations and what installation options has been installed / selected.
Thanks
Murras68
Database Mail Configuration?
Jan 30, 2008
Hi Friends,
I am finding an error in SQL Server Agent log which is related to database mail configuration. Can any one please guide me how to configure the database mail configuration to transfer the data from SQL CE to SQL server.
Thanks in Advance
Configuration Of Database Mail
Aug 17, 2005Has anyone been able to configure Database Mail and successfully send an email message? I set it up this afternoon, but all my messages are sitting in the sys_mailitems table of the msdb database.
View 5 Replies View RelatedSQL Server 2012 :: How To Combine Data From Different Tables Using A Query
Dec 17, 2013I have a set of tables that look like what I have shown below. How I can achieve the desired output ?
CREATE TABLE #ABC([Year] INT, [Month] INT,Customer Varchar(10), SalesofProductA INT);
CREATE TABLE #DEF([Year] INT, [Month] INT,Customer Varchar(10), SalesofProductB INT);
CREATE TABLE #GHI([Year] INT, [Month] INT,Customer Varchar(10), SalesofProductC INT);
INSERT #ABC VALUES (2013,1,'PPP',1);
INSERT #ABC VALUES (2013,1,'QQQ',2);
INSERT #ABC VALUES (2013,2,'PPP',3);
[Code] ....
I have a query currently that looks like this . @Month and @Year are supplied as parameters
SELECT
-- select the sum for each year/month combination using a correlated subquery (each result from the main query causes another data retrieval operation to be run)
(SELECT SUM(SalesofProductA) FROM #ABC WHERE [Year]=T.[Year] AND [Month]=T.[Month]) AS [Sum_SalesofProductA]
[Code] ...
Right now I see an output like this : for a particular value of @Month and @Year
SalesofProductA, SalesofProductB, SalesofProductC What I would like to see is :
[Customer],SalesofProductA, SalesofProductB, SalesofProductC
How it can be done ?
SQL Server 2014 :: Combine Data From Historical Table?
Aug 13, 2014Recently, I partitioned one of my largest tables into multiple monthly field groups. For the current month, it is attached to my "Active' table. The older records are kept in the "historical" table. I need an efficient way to pull records when have a date range that can be spread across both tables.
View 9 Replies View RelatedSQL Server 2008 :: Combine Multiple Rows To Single Row?
May 24, 2015How to combine multiple rows to single rows for the below sql query.
SELECT dbo.AccessLog.RCDID, dbo.AccessLog.EMPLOYEEID, dbo.AccessLog.LOGDATE, LEFT(dbo.AccessLog.LOGTIME, 5) AS LOGTIME,
dbo.AccessLog.INOUT
FROM dbo.AccessLog LEFT OUTER JOIN
dbo.LogType ON dbo.AccessLog.INOUT = dbo.LogType.INOUT LEFT OUTER JOIN
dbo.viwEmployee ON dbo.AccessLog.EMPLOYEEID = dbo.viwEmployee.Employee_ID
WHERE dbo.AccessLog.EMPLOYEEID='10763' AND (dbo.AccessLog.LOGDATE BETWEEN '01/04/2015' AND '01/04/2015')
ORDER BY dbo.AccessLog.EMPLOYEEID
The reult for the above query is:
RCDID | EmployeeID | LOGDATE | LOGTIME | INOUT
1 10763 01/04/2015 08:00 0
1 10763 01/04/2015 19:46 1
I need the result like the below
RCDID | EmployeeID | LOGDATE | IN | OUT
1 10763 01/04/2015 08:00 19:46
Disk Configuration For Replicated Database
Jan 25, 2008We are going to implement either a replicated database or use log shipping to another database to support our reporting needs. Basically we are moving reporting over data off our transactional database.
With this in mind, I have several questions:
Are there any special configurations in terms of disks for a database in this situation?What are the recommended raid types?
Also, we currently store our data in one filegroup and indexes in another so obviously I'll want those on 2 separate physical disks other than the C:. What about the log files? Do I care where they go (on C: or another physical drive separate from C:, data filegroup drive and index filegroup drive)?
Thanks!
How To Get A List Of Configuration Settings For A Database
Jul 20, 2005Hi,I would like to know how to get a list of configuration settings for adatabase.Is there a table that I can select this info from?Or a file (perhaps an ini file?) of some kind?Things like timeout settings, rollback space, table space, etc.Thanks
View 2 Replies View RelatedExample Code For Database Configuration(MSDE)
Jul 20, 2005Does anyone know where I can find example code for VB.NET that I can useto create an application that attaches and detaches databases to MSDE usingosql scipts.(I think SQL-DMO is typically used)Thanks in advance
View 10 Replies View RelatedProblem Getting Security For Configuration Database
Jul 24, 2007Below is what I have put into an execute sql task container. When I try to run it I have output open and have posted the output. The code runs fine when I have the configuration database set up to only check one server. However, when I add anymore to it, the package will get the security from the first db and then error out. Below is the error output and script. Any help with my problem is greatly appreciated.
**********Begin script*******************
declare @dbname varchar(200)
declare @mSql1 varchar(8000)
DECLARE DBName_Cursor CURSOR FOR
select name
from master.dbo.sysdatabases
where name not in ('mssecurity','tempdb')
Order by name
OPEN DBName_Cursor
FETCH NEXT FROM DBName_Cursor INTO @dbname
WHILE @@FETCH_STATUS = 0
BEGIN
Set @mSQL1 = ' Insert into [tempdb].[dbo].[DBROLES] ( DBName, UserName, db_owner, db_accessadmin,
db_securityadmin, db_ddladmin, db_datareader, db_datawriter,
db_denydatareader, db_denydatawriter )
SELECT '+''''+@dbName +''''+ ' as DBName ,UserName, '+char(13)+ '
Max(CASE RoleName WHEN ''db_owner'' THEN ''Yes'' ELSE ''No'' END) AS db_owner,
Max(CASE RoleName WHEN ''db_accessadmin '' THEN ''Yes'' ELSE ''No'' END) AS db_accessadmin ,
Max(CASE RoleName WHEN ''db_securityadmin'' THEN ''Yes'' ELSE ''No'' END) AS db_securityadmin,
Max(CASE RoleName WHEN ''db_ddladmin'' THEN ''Yes'' ELSE ''No'' END) AS db_ddladmin,
Max(CASE RoleName WHEN ''db_datareader'' THEN ''Yes'' ELSE ''No'' END) AS db_datareader,
Max(CASE RoleName WHEN ''db_datawriter'' THEN ''Yes'' ELSE ''No'' END) AS db_datawriter,
Max(CASE RoleName WHEN ''db_denydatareader'' THEN ''Yes'' ELSE ''No'' END) AS db_denydatareader,
Max(CASE RoleName WHEN ''db_denydatawriter'' THEN ''Yes'' ELSE ''No'' END) AS db_denydatawriter
from (
select b.name as USERName, c.name as RoleName
from ' + @dbName+'.dbo.sysmembers a '+char(13)+
' join '+ @dbName+'.dbo.sysusers b '+char(13)+
' on a.memberuid = b.uid join '+@dbName +'.dbo.sysusers c
on a.groupuid = c.uid )s
Group by USERName
order by UserName'
--Print @mSql1
Execute (@mSql1)
FETCH NEXT FROM DBName_Cursor INTO @dbname
END
CLOSE DBName_Cursor
DEALLOCATE DBName_Cursor
Go
****************End Script***********************
****************Begin Error Output********************
[Execute SQL Task] Error: Executing the query "declare @dbname varchar(200) declare @mSql1 varchar(8000) DECLARE DBName_Cursor CURSOR FOR select name from master.dbo.sysdatabases where name not in ('mssecurity','tempdb') Order by name OPEN DBName_Cursor FETCH NEXT FROM DBName_Cursor INTO @dbname WHILE @@FETCH_STATUS = 0 BEGIN Set @mSQL1 = ' Insert into [tempdb].[dbo].[DBROLES] ( DBName, UserName, db_owner, db_accessadmin, db_securityadmin, db_ddladmin, db_datareader, db_datawriter, db_denydatareader, db_denydatawriter ) SELECT '+''''+@dbName +''''+ ' as DBName ,UserName, '+char(13)+ ' Max(CASE RoleName WHEN ''db_owner'' THEN ''Yes'' ELSE ''No'' END) AS db_owner, Max(CASE RoleName WHEN ''db_accessadmin '' THEN ''Yes'' ELSE ''No'' END) AS db_accessadmin , Max(CASE RoleName WHEN ''db_securityadmin'' THEN ''Yes'' ELSE ''No'' END) AS db_securityadmin, Max(CASE RoleName WHEN ''db_ddladmin'' THEN ''Yes'' ELSE ''No'' END) AS db_ddladmin, Max(CASE RoleName WHEN ''db_datareader'' THEN ''Yes'' ELSE ''No'' END) AS db_datareader, Max(CASE RoleName WHEN ''db_datawriter'' THEN ''Yes'' ELSE ''No'' END) AS db_datawriter, Max(CASE RoleName WHEN ''db_denydatareader'' THEN ''Yes'' ELSE ''No'' END) AS db_denydatareader, Max(CASE RoleName WHEN ''db_denydatawriter'' THEN ''Yes'' ELSE ''No'' END) AS db_denydatawriter from ( select b.name as USERName, c.name as RoleName from ' + @dbName+'.dbo.sysmembers a '+char(13)+ ' join '+ @dbName+'.dbo.sysusers b '+char(13)+ ' on a.memberuid = b.uid join '+@dbName +'.dbo.sysusers c on a.groupuid = c.uid )s Group by USERName order by UserName' --Print @mSql1 Execute (@mSql1) FETCH NEXT FROM DBName_Cursor INTO @dbname END CLOSE DBName_Cursor DEALLOCATE DBName_Cursor " failed with the following error: "Line 15: Incorrect syntax near '-'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
**************End Error Output**************
DB Engine :: Cannot Connect To Configuration Database
Aug 10, 2015When trying to open the sharepoint webpage I'm getting this error - cannot connect to the configuration database sharepoint 2010.Database is on SQL server 2008.Tried opening the site on server - got the same error.Googled and tried to start the mssqlserver services (browser and sql server) but they fail to start with error code 17058.
Googled what this error was about and some solutions led me to check the error log in event viewer. For mssqlserver I got following message in the event proverties window -Â Could not open error log file <path of log file> ''. Operating system error = 5 (access denied).When I tried to login on the sql server management studio, it does not let me login and gives error -Â
I got to know that this can happen due to unexpected reboot of server. I checked my server and it had actually restarted unexpectedly.URL...
SQL Server 2014 :: Query To Combine Two Tables Based Third Table
Feb 18, 2015I have three tables A, B, C respectively. Table C is used to map table A and B. Three tables are below:
Table A:
Table B:
Table C:
So what query do I need write to have table like below?
Table D
Package Configuration Wizard:-SQL Configurations Configuration Filter Not Working
May 23, 2006Hi --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]
Database Engine Tuning Advisor Configuration?
Nov 29, 2007I was trying to get some indexing recommendations from the Database Engine Tuning Advisor by consuming a trace file with known indexing issues. After several minutes all it did was create a report or two which list existing indexes. Not very useful. I must be doing something wrong.
A message displays that "75% of the consumed workload has syntax errors." I guess it can't take a regular trace (.trc) file?
I am conderned that the trace file I used did not contain what the Advisor needs. Do I need to setup the trace a special way to support the Advisor?
Also, what does "Database for workload analysis" mean? I chose tempdb but there is no Help, and BOL is a maze of small uninformative snippets . . .
Thanks,
Michael
Local Database XXYYZZ Is Not Defined In Configuration
Jun 25, 2007I'm quite addicted to Patterns-&-Practices Enterprise.Library.Data module, but I can't get it to access a SQL Server Express Database. I've tried several different .CONFIG files and a unch of different settings and I keep getting:
The local database "XXYYZZ" is not defined in configuration.
I'm using Visual Studio 2005 C# in a WinForms application.
Can Microsoft.Practices.EnterpriseLibrary.Data access SQL Server Express Database????
Reporting Services Configuration (Database Connection)
Nov 9, 2006Hi,
I want to configure my Reporting Service.
And if I want to configure the Database Connection I the action
"Create a Grants Rights Script" fails.
I tried all credential types by it doesn't work.
Does anybody have an idea? Thanks for your help!
Jo-Jo
Reporting Services :: Database Configuration Query
Sep 2, 2015I have SQL 2008 R2 instance and would like to install SSRS 2012. I have below query related to database configuration...Is there any performance impact while using SQL 2008R2 instance?Once configured SSRS database on 2008 R2, Will there any issue if we move our SQL instance from 2008R2 to SQL 2012 in future?
View 3 Replies View RelatedDatabase Mail && Surface Area Configuration
Feb 5, 2008I 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