Example Code For Database Configuration(MSDE)

Jul 20, 2005

Does anyone know where I can find example code for VB.NET that I can use
to create an application that attaches and detaches databases to MSDE using
osql scipts.
(I think SQL-DMO is typically used)

Thanks in advance

View 10 Replies


ADVERTISEMENT

MSDE Configuration Help

Jun 10, 2004

Hi, folks.

I need help with a new install of MSDE, which I'm hoping to use with learning ASP.NET.

I downloaded and installed the latest MSDE. The Service Manager is now running...and after a few hours of poking around I figured out my server name by looking in the log files (\computernameNETSDK). LOL So, it's running and the three services are available, with SQL Server as the default.

Now, I am having problems launching OSQL and I think it has something to do with the username. I do recall part of the install process that I was asked to supply a password. I am using that password in this situation. I tried the following, where "administrator" is the local workstation's administrator account. For kicks, I tried "sa" as a username. No luck. Here's the output:

D:Temp>osql -U administrator
Password:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

D:Temp>osql -U sa
Password:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

D:Temp>

Where do I go from here so I can start playing with MSDE? Also, I find it odd that there is no MS SQL Server in my Program Groups (XP). Is there no GUI for administering the database(es)?

TIA,

Bob

View 6 Replies View Related

Cannot Connect To MSDE From C# Code

Dec 23, 2004

Hello everybody and happy holidays to all.
I'm new to C#, and I appologize for this basic question.
I am trying to connect to an SQL database from a very short C# program, which I found on the Microsoft site, demonstrating this subject.
Here is my setup:
Windows 2000 Professional
dotNET Framework 1.1 with sp1 installed
MSDE 2000
Note: I do not own nor do I have Visual Studio.NET of any kind installed.

Now, here is what works:
osql -E -S localhostvsdotnet
1>
And I can create and populate a database, which I called mydb.

Now, in my simple C# demo program I have this line

SqlConnection mycon = new SqlConnection("server=localhost;database=mydb;trusted_connection=true");

And the program compiles OK using "csc" command. But when I run it, I get this message:
Couldn't Open Connection to server=localhost;database=mydb;trusted_connection=true

Could anybody comment on what am I missing?
Thanks.

View 1 Replies View Related

Are There Any MSDE T-SQL Code Limitations?

Jul 20, 2005

I am writing a database app which will run under MSDE on the user's systems.Other than limitations as to the number of concurrent users, are there anyissues that I need to be aware of when programming the database using SQLServer 2000? i.e., are there T-SQL programming statements that will rununder SQL Server 2000 as part of my development enviornemnt that won't rununder MSDE on the end users machines, or will MSDE handle anything that SQLServer can from the database engine standpoint?Thanks!

View 1 Replies View Related

SQL Server Express Code On MSDE/SQL Server 2000

Jun 21, 2005

hi - I am developing locally using .Net 2.0/Access but just recently started trying out SQL Server Express. I have deployed my application to a host who provides 2.0 but as would be expected only MSDE/SQL server 2000. Now if I'd switch completely to SSE, would my SQL queries (which are pretty simple) work on MSDE or SQL server 2000? The only thing I see as more sophisticated sql queries would be the built-in 2.0 Roles/Membership functions... Do you think they would run smoothly on MSDE/SQL 2000?Finally... since the database is already done locally, is there any way (a stored procedure for example) to copy it's scheme if I'd create a new DB on my host's SQL server?

View 2 Replies View Related

Migrating From Sql2000 MSDE Database To Sql2005 Express - Attach Database Errors

Apr 23, 2006

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:


Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.


Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them.  But I should still be able to switch over to sql 2005?!?!?!?


Or... is there a way to attach the databases to SQLExpress manually?

Help pls?

View 1 Replies View Related

Transferring Data From MSDE Database To SQL 2000 Database

Jul 23, 2005

Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott

View 1 Replies View Related

Attach Database To SQL2005 From Old MSDE Database

Apr 22, 2006

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:


Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.

Or... is there a way to attach the databases to SQLExpress manually?

Help pls?

View 3 Replies View Related

Right Code Statements Of SqlConnection && ConnectionString For Connecting A Database In Database Explorer Of VB 2005 Express?

Feb 14, 2008

Hi all,

In the VB 2005 Express, I can get the SqlConnection and ConnectionString of a Database "shcDB" in the Object Explorer of SQL Server Management Studio Express (SSMSE) by the following set of code:
///--CallshcSpAdoNetVB2005.vb--////

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Public Class Form1

Public Sub InsertNewFriend()

Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;"

Dim connection As SqlConnection = New SqlConnection(connectionString)

Try

connection.Open()

Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)

command.CommandType = CommandType.StoredProcedure
.......................................
etc.
///////////////////////////////////////////////////////
If the Database "shcDB" and the Stored Procedure "sp_inertNewRecord" are in the Database Explorer of VB 2005 Express, I plan to use "Data Source=local" in the following code statements to get the SqlConnection and ConnectionString:
.........................
........................

Dim connectionString As String = "Data Source=local;Initial Catalog=shcDB;Integrated Security=SSPI;"

Dim connection As SqlConnection = New SqlConnection(connectionString)

Try

connection.Open()

Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)

command.CommandType = CommandType.StoredProcedure
........................
etc.

Is the "Data Source=local" statement right for this case? If not, what is the right code statement for my case?

Please help and advise.

Thanks,
Scott Chang

View 6 Replies View Related

Database Configuration Problems

Jan 18, 2006

I 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 Related

Server & Database Configuration

Jul 20, 2000

Is 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

View 1 Replies View Related

Remote Database Configuration

Aug 15, 2000

Please 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?

View 1 Replies View Related

Finding Out Database Configuration

Jun 12, 2003

Hi,

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

View 1 Replies View Related

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

View 1 Replies View Related

Configuration Of Database Mail

Aug 17, 2005

Has 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 Related

How Can Combine 2 DataBase(one From Configuration And Another Sql Server)

Jan 6, 2008

hi
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)

View 1 Replies View Related

Disk Configuration For Replicated Database

Jan 25, 2008

We 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!

View 3 Replies View Related

How To Get A List Of Configuration Settings For A Database

Jul 20, 2005

Hi,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 Related

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

View 3 Replies View Related

Problem Getting Security For Configuration Database

Jul 24, 2007

Below 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**************

View 11 Replies View Related

DB Engine :: Cannot Connect To Configuration Database

Aug 10, 2015

When 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...

View 13 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

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

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

Database Engine Tuning Advisor Configuration?

Nov 29, 2007

I 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

View 3 Replies View Related

Local Database XXYYZZ Is Not Defined In Configuration

Jun 25, 2007

I'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????

View 3 Replies View Related

Reporting Services Configuration (Database Connection)

Nov 9, 2006

Hi,

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

View 3 Replies View Related

Reporting Services :: Database Configuration Query

Sep 2, 2015

I 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 Related

Database Mail &&amp; 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

Disconection Of Database Users In Mirror Configuration

Mar 21, 2007

On the machine DBSP01 we have the TEST database running. In the SQL environment we created the user Test. This user was set up to be the database owner of the TEST database. To make a connection to the Test database, the user Test was used and everything works perfect.
On the machine DBSP02 we also created a database called TEST and a user called Test, who was database owner of the TEST database. Again we where able to connect to the database by using the user Test.
Now we set up a so called mirror configuration. This means that we have one active database, called the principal database, and a standby database, called the mirror. The active database is used to communicate to the outside, while the standby database is copying every change from the active database. This way the principal database and the mirror database contain always the same data. When one of the databases is acting as a mirror database, this database cannot be reached from the outside.
After a while it can happen that the principal database fails for some reason. The database is not capable to run properly, so it stops. The mirror database will become the principal database and the outside can connect to the new principal database. Here we have a problem: the user Test is no longer the database owner of the TEST database. For some reason the user Test is disconnected as database owner of the TEST database when the database is acting as mirror. I can€™t find the reason for this problem and I can also not find a solution for this problem.

View 1 Replies View Related

Sharepoint Services 3.0 Can't Connect To Configuration Database

Dec 4, 2006

When i try to connected to existing configuration database it's only shows NT AUTHORITYNETWORK SERVICE as my login user for database access , when i type another user , error message " you must specifay the same user account as your farm server you wish to join  " how i can change it.

please help me how i can change the configuration user and password for my singel farm server

 

Thanks , i fixed it ??

View 1 Replies View Related

How Do I Upload A MSDE Database

Sep 26, 2006

Downloaded and installed MSDE and just finished creating a
website using the Community Starter Kit.  I'm used to working with Access
Databases and this is my first experience with anything SQL.  Can someone
provide my with some guidance as to what I need to do to upload the MSDE
Database to a server.  Can I just upload the files like an Access Database
or is this more involved.  Thanks for you help.

View 5 Replies View Related

MSDE Database Connections

Nov 13, 2003

I'm using Visual Studio.Net enviroment, i have SQL desktop Engine installed and everything is working great. I have a problem that whenever i create a new database connections i can NOT delete it. I know that i have to select the node containing the connection and then press the DEL Key, but it seems that the delete option is not valid!

Any Suggestion?

View 3 Replies View Related







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