SqlMail With Outlook On Win2k

Oct 9, 2001

Does anyone know the 'trick' in getting sqlmail (sqlserver 7.0) to work with Outlook 2000 on a windows 2000 server machine. I've setup a mail profile on Outlook, but it is not listed in the dropdown menu in the sqlmail properties.
Outlook communicates with my smtp/pop3 mail server - no problem. I can't get sqlmail to interface with outlook. Basically it is telling me that it cannot find ANY profiles on the server.

View 1 Replies


ADVERTISEMENT

Email Report In Outlook 2007 Not The Same As Outlook 2003

Feb 7, 2007

I have a Reporting Services 2005 report that is emailed to users.  I created/formatted  the report based on how it looked in Outlook 2003 which all of our users had at that time.  The report is wide, but just fit in the email window when it was full size.   Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced. 

The report is:

Delivered by: Report Server E-mail

Include Report is checked

Render Format is Web archive

Any ideas on how I can fix this?

Thanks in advance.

View 23 Replies View Related

Help With Sql In Win2k

Jul 10, 2006

Hi All          Can I install sqlserver2000 as a desktop version in win2k professional ?
Please Help

View 2 Replies View Related

Win2k And SQL7

Apr 3, 2000

Starting with Win2k you are not suppossed to have to install MDAC, as it comes with the OS. What about when I install SQL7 and it automatically installs MDAC. Do I have to reinstall MDAC in this case?

View 2 Replies View Related

SQL 2000 Sp2 And Win2k Sp2

Dec 27, 2001

I have heard that when installing Win2K sp2 and SQL 2000 sp2 they should be done in a certain order. Does anyone know anything about this?

Thanks!
JJ

View 1 Replies View Related

Does SQL7 Work Well On Win2K?

Aug 14, 2000

My shop is thinking of migrating from NT4 to Win2K. Is anyone running SQL7 on Windows 2000 (which edition?)? How's you're experience been? Anyone hear any anecdotes of particular things that don't work (well)?

Thanks for your input.

View 2 Replies View Related

Admin Pack For Win2k

Sep 27, 2002

does anyone know where I can get the admin pack for win2k. thanks

View 1 Replies View Related

Upgrade Server To Win2k

Jan 21, 2003

I am planning to upgrade our SQL Server 2000 box from Win NT to Windows 2000. Have anyone done the same thing and has encounter problems? Thank you.

View 2 Replies View Related

How To Installing MSDE In Win2K Pro

Jul 20, 2005

I am new to MSDE and want to deploy it in my company (because it is free).However, when I install it in a W2K professional machine, there is a messagebox saying that a "strong SA password is required". How can I solve theproblem?Arthur Cheung(The MSDE engine was downloaded from the microsoft sql server web page)

View 1 Replies View Related

How To Backup Up Win2K And SQL Server

Jul 20, 2005

Hi,I am new to Win2k and SQL server and need to back up everything each night.I used the supplied NT backup utility to schedule a backup but this missedsome files that were open or in use.I am more used to Unix/Informix where I could backup everything whether itwas in use or not.How or what would you recommend I use to do my backups?Thanks.

View 2 Replies View Related

SQLMAIL

Nov 20, 2000

Is there a way to change the FROM in sqlmail (recipient) from the mailbox account to read a user-defined from. Currently our FROM has the SQL mail account name that was created during the sqlmail setup and we would like to put a user defined name in this variable.

View 1 Replies View Related

SQLMail

Mar 5, 2001

For the life of me, I cannot get SQL Mail Support Services started on one of my SQL Server 7.0 SP3 boxes. It works fine on other machines of mine. I have a mail profile created using proper accounts who have access to email box. I have configured SQL Server to use that mail profile.

ERRORLOG shows the following each time I try and start the SQL Mail Support Services:

2001-03-05 10:23:48.98 ods Starting SQL Mail session...
2001-03-05 10:23:50.20 ods Error: 17903, Severity: 18, State: 1
2001-03-05 10:23:50.20 ods MAPI login failure..
2001-03-05 10:23:50.20 ods Error: 17951, Severity: 18, State: 1
2001-03-05 10:23:50.20 ods Failed to start SQL Mail session..

Do you have any thoughts or where I may turn for support, other that Microsoft's pay-per issue support?

Thank you,
Brian Kilby

View 2 Replies View Related

SQLMail

Sep 23, 1999

Hello sir,

I want to configure SQLMail; I use Eudora.
how can-I do that?

Please advice me..

View 1 Replies View Related

SQLMAIL

Jul 14, 1999

Dear people,

We have tried to get sqlmail (SQL SERVER 6.5) working on windows NT 4.0. However when we start sqlmail through the enterprise manager we get an error:
"error 17952 sqlserver failed to start sql mail session". MSmail client works ok on the NT machine. The profile in nt mail is the same as the profile name in de configuration of sqlmail. What could be wrong?

Thanks for reading

Michel Landman

View 1 Replies View Related

SQLMAIL

Jul 30, 1998

I have installed MS exchange client on my NT 4.0 server.
and installed SQL server 6.5 on same.I have marked MSSQL server service as log on as service and also map correct profile in exchange.I am able to start
sql mail service but when i am trying to send a mail by xp_sendmail i am getting error:
Msg 17914,level 18,state 1
Unknown recipient: Parameter `@recipients`,recipient `devendrar`.

where `devendrar` is profile name

and what i am trying to do is :
xp_sendmail `devendrar`,`msg to send`

can u pls help me to solve this problem.


Devendra Rane.

View 1 Replies View Related

SQLMail

Mar 10, 2005

Is there any other way to send emails without using SQLMail or xp_sendmail?
without a mail client ?

View 1 Replies View Related

Can Install MS SQLServer2000 On Win2k Profestional?

Aug 13, 2004

I only can install client-side of SQLServer2000 on Win2kProfestional
But i need to set up server-side, so can i?

View 2 Replies View Related

Problem Installing On Win2K Server

Feb 7, 2002

Hiya!
I'm having a problem installing SQL Server 7 Enterprise Edition (no service pack)on a Windows 2000 Server SP 2 machine (256 MB RAM,40 GB drive) off an original MSDN CD. Only the client components get installed. This is the output from the SQLStp.log file:
15:19:51 Begin Setup
15:19:51 7.00.623
15:19:51 Mode=Normal
15:19:51 ModeType=NORMAL
15:19:51 ValueFTS returned: 1
15:19:51 ValuePID returned: 1
15:19:51 ValueLic returned: 1
15:19:51 GetDefinitionEx returned: 0, Extended: 0xf000000
15:19:51 System: Windows NT Server
15:19:51 SQL Server ProductType: Enterprise Edition [0x3]
15:19:51 Begin Action: SetupInitialize
15:19:51 End Action SetupInitialize
15:19:52 Fixed install: 0
15:19:52 Begin Action: CheckRequirements
15:19:52 Platform ID: 0xf0000000
15:19:52 Version: 5.0.2195
15:19:52 Processor Architecture: x86 (Pentium)
15:19:52 File Version - C:NTSRVRSystem32shdocvw.dll: 5.0.3315.2879
15:19:52 ComputerName: SERVER-5IQ8359Z
15:19:52 User Name: Administrator
15:19:52 IsAllAccessAllowed returned: 1
15:19:52 C:NTSRVRTEMP\_ISTMP44.DIRscm.exe -Silent 1 -Action 6 -Timeout 5000 -Service MSSQLServer
15:19:57 Process Exit Code: (0)
15:19:57 OS Language: 0x409
15:19:57 End Action CheckRequirements
15:19:57 Begin Action: Detection
15:19:57 End Action Detection
15:19:57 Begin Action: ODBCLocked
15:19:57 End Action ODBCLocked
15:19:57 This combination of Package and Operating System allows a client install only.
15:19:59 The Enterprise Edition server component cannot be installed on Windows NT Server using this CD. Only client components will be available for installation.

15:19:59 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesD ir ...
15:19:59 CommonFilesDir=C:Program FilesCommon Files
15:19:59 Windows Directory=C:NTSRVR15:19:59 Begin Action: ShowDialogs
15:19:59 Begin Action: DialogShowSdWelcome
15:20:00 End Action DialogShowSdWelcome
15:20:00 Begin Action: DialogShowSdLicense
15:20:01 End Action DialogShowSdLicense
15:20:01 Begin Action: DialogShowSdRegisterUserEx
15:20:06 End Action DialogShowSdRegisterUserEx
15:20:06 Begin Action: DialogShowCdKey
15:20:06 End Action DialogShowCdKey
15:20:06 Begin Action: DialogShowPID
15:20:06 End Action DialogShowPID
15:20:06 Begin Action: DialogShowSdSetupType
15:20:10 [SetupTypeSQL]
15:20:10 szDir=C:MSSQL7
15:20:10 Result=303
15:20:10 szDataDir=C:MSSQL7
15:20:10 End Action DialogShowSdSetupType
15:20:10 Begin Action: DialogShowSdComponentMult
15:20:10 basesys=0, baseinst=0,basedata=0
15:20:19 SQL program folder: C:MSSQL7
15:20:19 SQL data folder: C:MSSQL7
15:20:19 Windows system folder: C:NTSRVRSystem3215:20:19 Prog req: 46703, Data req: 0, Sys req: 24971
15:20:19 Prog avail: 2147483, Data avail: 2147483, Sys avail: 2147483
15:20:19 Prog req vs. avail, 71674, 2147483
15:20:19 Data req vs. avail, 0, 2147483
15:20:19 Sys req vs. avail, 24971, 2147483
15:20:19 DisplaySystemPreReq
15:20:19 [SQLComponentMult]
15:20:19 Component=
15:20:19 Result=1
15:20:19 End Action DialogShowSdComponentMult
15:20:19 Begin Action: DialogShowSdStartCopy
15:20:38 End Action DialogShowSdStartCopy
15:20:38 Begin Action: DlgCPLLicense
15:20:38 End Action DlgCPLLicense
15:20:38 End Action ShowDialogs
15:20:38 Begin Action ProcessBeforeDataMove:
15:20:38 DeinstallStart returned (C:MSSQL7): -1
15:20:38 DeinstallStart returned (C:MSSQL7): 0
15:20:38 End Action ProcessBeforeDataMove:
15:20:38 Begin Action ProcessComponentSelection:
15:20:38 End Action ProcessComponentSelection
15:20:38 Begin Action LogSelectedComponents:
15:20:38 MgtTool
15:20:38 MgtToolSEM
15:20:38 MgtToolSEMHTML
15:20:38 MgtToolSEMMSD98
15:20:38 MgtToolSEMMSD98SYS
15:20:38 MgtToolSEMMSD98Res
15:20:38 MgtToolSEMMSD98Hlp
15:20:38 MgtToolSEMHelp
15:20:38 MgtToolSEMSEMSys
15:20:38 MgtToolSEMRes1033
15:20:38 MgtToolSEMResIntl
15:20:38 MgtToolSEMMSD98RsI
15:20:38 MgtToolProfiler
15:20:38 MgtToolProfilerHelp
15:20:38 MgtToolProfilerRes1033
15:20:38 MgtToolProfilerResIntl
15:20:38 MgtToolQryanlz
15:20:38 MgtToolQryanlzHelp
15:20:38 MgtToolQryanlzRes1033
15:20:38 MgtToolQryanlzResIntl
15:20:38 MgtToolDTCCLi
15:20:38 MgtToolWzcnflct
15:20:38 MgtToolWzcnflctWzcnsys
15:20:38 MgtToolWzcnflctWzcnHlp
15:20:38 MgtToolUtilSys
15:20:38 MgtToolUtilBinn
15:20:38 Connect
15:20:38 ConnectConnSys
15:20:38 ConnectConn9x
15:20:38 ConnectConnNT
15:20:38 Books
15:20:38 BooksBookso
15:20:38 DevTools
15:20:38 DevToolsHeaders and Libraries
15:20:38 DevToolsHeaders and LibrariesInclude
15:20:38 DevToolsHeaders and LibrariesLibx86
15:20:38 DevToolsHeaders and LibrariesLibAlpha
15:20:38 DevToolsHeaders and LibrariesESQLC
15:20:38 DevToolsMDAC SDK
15:20:38 DevToolsVDI
15:20:38 DevToolsVDIInc
15:20:38 DevToolsVDISamples
15:20:38 DevToolsDbg Int
15:20:38 DevToolsDbg IntDbg Int Common
15:20:38 DevToolsDbg IntEXE
15:20:38 Samples
15:20:38 SamplesADO
15:20:38 SamplesDBLIB
15:20:38 SamplesDTS
15:20:38 SamplesESQLC
15:20:38 SamplesMSDTC
15:20:38 SamplesODBC
15:20:38 SamplesODS
15:20:38 SamplesOLEAut
15:20:38 SamplesRepl
15:20:38 SamplesSQLDMO
15:20:38 SamplesSQLNS
15:20:38 Core
15:20:38 CoreSys
15:20:38 ODBC
15:20:38 OLEDB
15:20:38 Repostry
15:20:38 RepstSys
15:20:38 CoreMisc
15:20:38 Monarch
15:20:38 Jet
15:20:38 NetCore
15:20:38 NetExt
15:20:38 SFExt
15:20:38 ReplExt
15:20:38 Core1033
15:20:38 CoreIntl
15:20:38 CrMi1033
15:20:38 CrMiIntl
15:20:38 Monr1033
15:20:38 MonrIntl
15:20:38 SFEx1033
15:20:38 SFExIntl
15:20:38 RpEx1033
15:20:38 RpExIntl
15:20:38 SysCore
15:20:38 VOLEDB
15:20:38 VODBC
15:20:38 MiscCore
15:20:38 MCHlp
15:20:38 MC1033
15:20:38 MCIntl
15:20:38 CnctBinn
15:20:38 CrRepCom
15:20:38 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
15:20:38 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
15:20:38 End Action LogSelectedComponents
15:20:38 Begin Action MoveFileData:
15:21:11 End Action MoveFileData
15:21:11 Begin Action ProcessAfterDataMove:
15:21:11 DeinstallSetReference (C:MSSQL7sqlservr.exe) returned: 0
15:21:11 End Action ProcessAfterDataMove
15:21:11 Begin Action InstallPkgs:
15:21:11 Setup is installing Microsoft Management Console (MMC) ...
15:21:11 D:x86Otherinstmmc.exe /Q
15:21:35 Process Exit Code: (0)
15:21:35 Setup is installing HTML Help ...
15:21:36 HTML Help installer exit code: 0
15:21:36 End Action InstallPkgs
15:21:36 Path successfully updated.
15:21:36 %SystemRoot%system32;%SystemRoot%;%SystemRoot%syst em32WBEM;C:Program FilesSymantecpcAnywhere;C:MSSQL7BINN
15:21:36 Begin Action SelfRegister
15:23:39 Return code: 0
15:23:39 End Action SelfRegister
15:23:39 Begin Action SetupRegistry:
15:23:39 End Action SetupRegistry
15:23:39 Begin Action PostSetupRegistry:
15:23:39 C:MSSQL7BINNdcomscm.exe /RegServer
15:23:39 Process Exit Code: (0)
15:23:39 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1sqldbreg.exe -RegServer
15:23:39 Process Exit Code: (-2147312566) Error loading type library/DLL.

15:23:40 C:PROGRA~1COMMON~1MICROS~1DATABA~1wzcnflct.exe /RegServer
15:23:40 Process Exit Code: (0)
15:23:40 End Action PostSetupRegistry
15:23:40 Begin Action SetupFolders:
15:23:40 Microsoft SQL Server 7.0 Folder refreshed.
15:23:40 End Action SetupFolders
15:23:40 Action CleanUpInstall:
15:23:40 Uninstall command: C:NTSRVRIsUninst.exe -fC:MSSQL7Uninst.isu -c"C:MSSQL7sqlsun.dll" -msql70.mif
15:23:40 SetTracking: {E07FDDA8-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDA9-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAA-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAB-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAC-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAD-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAF-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB0-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB1-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB2-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB3-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB4-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB5-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB6-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB7-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB8-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB9-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBA-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBB-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBB-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBD-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
15:23:40 Installation Succeeded

Thanks,
Sarah

View 1 Replies View Related

Cluster Install.on Sql2k/win2k

Aug 7, 2002

Hello all,

There are have 2 nodes.Both on cluster and on a test_domain.Test domain is a active directory domain.

Node_A & node_B has C and D drives.D drive will have programs.

There is one common drive E - where data will go.

Now,I have to install SQL2000 on it.Can anyone tell me in layman's way how to install it.Do I have to have D drive in shared mode?When I give remote connection what should I give here?

Win 2000 clustered was installed by a NT expert and is working fine.

I am assuming drive_D will hold the SQl programs.

I tried one article posted here from Sqlserver preformance side but nothing worked.

Does it matter as both the nodes are on a Active Directory?

Any hint may help.
thanks!

View 1 Replies View Related

Painful Installation Of RS 2005 On Win2K

Jul 13, 2007

Ok I'm am going through a rather painful experience of installing Reporting Services on:



Windows 2000 SP4

MDAC 2.8

.Net Framework 2.0

IIS 5.0

SQL Server 2005 Developer



I have installed RS 2005 on Windows 2003, and seen it installed on XP no problems. However this is a nightmare.



RS goes ahead and installs - note that there is no Network/Local service option on the service accounts just Local system or the domain account option. I have tried using the Local system and tried using the NT AUTHORITY/SYSTEM.



After the installation I go to the Reporting Services Configuration Tool, where I have crosses on:

- Server Status

- Report Server Virtual Directory

- Report Manager Virtual Directory

- Web Service Identity

- Database Setup

I- nitialization



So I go to report server/manager and click on "New.." on each to create the virtual directories and check "apply default settings" and click "Apply", all goes well



Web Service Identity I cannot change so I go to:

C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
sreportserver.config



and change the web service account to:

<WebServiceAccount><<MACHINE NAME>>ASPNET</WebServiceAccount>

When I restart the reporting services service I no longer see a warning in the reporting services log file about the WebServiceAccount



I go back to the Reporting Services Config Tool, where I have crosses on the following:

Web Service Identity

Database Setup

Initialization



The Web Service Identity stays greyed out...



I go to Database Setup:

connect to the server

select the reportingserver database

leave it set as service credentials

Click "Apply"



and I get the most vague of all error messages:

"There was a failure applying your change

A virtual directory must first be created before performing this operation"



What virtual directory, where???



I look in the log files..nothing. I look in the event viewer...and...nothing.



I look on here...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=628231&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682492&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=493194&SiteID=1



Either unanswered or there is the one answer but it is not relevant in this case.



Can someone please provide some advice before I lose my sanity?



Thanks in advance

View 1 Replies View Related

SQLMail Won&#39;t Start Help !!!

Feb 27, 2001

I have the following error when trying to test EMail from SQL.

I have logged onto the server and sent EMail using the SQLServer Service Account and the Profile is correct. This tells me that Outlook is working OK and the Exchange Server is sending OK. However, lookin on TechNet Q274330
mentions the error number but it's description is about Emailing an open file. I am not Emailing an open file.

Here's the error message.

xp_startmail 'eweb02mail'

Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040106

Or right clicking on SQLMail and click on Test

xp_test_mapi_mail 0x80040106

View 1 Replies View Related

Sqlmail Problem

Dec 28, 1998

Hi all.

I'm having problems with sqlmail. SOMETIME when I try to send a message the server replies "Could not find the function xp_sendMail in sqlmap60.dll". or ISQW don't finish the query never.

Sqlmail is running. I'm using Outlook express as a simple mapi client.

Sorry my english.

Any help will be appreciate a lot.

Thanks in advance.

Armando Marrero
Armando@Novell2.get.cma.net

View 2 Replies View Related

Groupewise And SQLMail

Jan 21, 2002

Does anyone know how set up SQLMail and SQLAgentMail (SQL 7/2000) to send email to Groupwise 5.5? Or is it possible at all? Any feedback will be very much appreciated.

View 1 Replies View Related

Can&#39;t Start SQLMail

May 24, 2002

The start / stop options on the SQL Mail support service are not there.

I'm running with SQL 2000 on Server 2000, with MS Outlook 2000 as the MAPI Client. The client is configured and sending just fine. The SQL Mail properties Test button was able start/stop a mapi session. The profile name on the general tab is "Microsoft Outlook Internet Settings".

Suggestions appreciated.

View 1 Replies View Related

Groupwise 5.5 And SQLmail

Feb 1, 2001

Has anyone successfully integrated Groupwise 5.5 with SQLServer 2000? Any suggestions would be appreciated.

Thank you.

View 1 Replies View Related

SQLMail Does Not Start

Jul 23, 2005

I am using SQLServer2000 with sp3.The SQLServer logs on as user Test on the local computer. I am loggedon as user Test on the local computer.I have created a Exchange Profile and tested that it can send andreceive mail.When I go to Enterprise Manager to set-up this profile for SQL Mail.There is nothing in the drop-down list box.Any ideas?ThanksM

View 1 Replies View Related

SQLMail Woes !

Jul 20, 2005

Trying to get my jobs to send mail when job fails. Should be easy butit's giving me headacheHad a whole slew of issues. Outlook is installed with a n outlookmail profile set up that can send mail in outlook. I can create aSendMail DTS and execute it to send mailEmail works in these scenarios1. I create a DTS package in SQL Server with just SendMail with thesame Profile "ABC" and click Execute and it sends2. I can send using Outlook with the same profile "ABC"3. I can run DTSRun with command prompt calliing the DTS package andit sends fineHowever it wont send in these 3 scenarios (where I need it!):1. I go to Operator, and put my Profile "ABC" in the Email Name,click Test and I get this error "Error 22022: SQLServerAgent Error:The SQLSErverAgent mails ession is not running; check the mail profileand/or the SQLServerAgent service startup account in theSQLSErverAGent PropertiessQLServer Agent is running2. If I add the DTS Package "EmailTest" to one of my jobs as a stepto go to if the 1st step fails, nothing gets sent3. In JObs -- Notificatioin, If I set the E-maill operator to myoperator, nothing gets sentI set the Mail Profile to the Mail Profile (in SQL Server AGent'properties)However when I click Test, I get this error:Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs itreferencesI am usingSQLServer Version 8.00.194,OS Windows 2003Help!

View 3 Replies View Related

Installing Sql7 On Win2K Server...issues?

Aug 16, 2000

I have been asked to install Sql 7 on a Win2K server. I am looking for White papers, articles, postings etc which identify potential issues or known issues. I have looked through MSDN, Win2K, Microsoft Sql7 and TechNet for specifics. Any suggestions?

Thank you,
Troy

View 1 Replies View Related

Win2K Users Cannot Connect To SQL2005 Database

Feb 5, 2007

Hi,

I recently migrated our database from Access to SQL Server 2005. All the WinXP users can connect to the new SQL2005 database. But all the Win2K machines fail to log on. To diagnose the problem, I tried to connect from a Wind2K machine using an .udl file. The connection failed because "a provider failed to initialize".

The SQL2005 server is residing on a WinXP machine. Users log on via SQL Server authentication layer using a dedicated login that only has read/write privileges to one specific database.

Does anyone know a solution? Thanks in adance.

Regards,

Vladislav

View 3 Replies View Related

Error In Sql Server 2005 Setup On Win2k Sp4

Feb 14, 2007

error msg in summary.txt


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows 2000 Server Service Pack 4 (Build 2195)
Time : Wed Feb 14 03:31:27 2007

LDINTSQL1 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.


SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time : Wed Feb 14 03:39:30 2007


List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Support.log


error msg in C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Core.log


Microsoft SQL Server 2005 Setup beginning at Wed Feb 14 03:31:27 2007
Process ID : 2176
\ldnas1msdn versionsServer ApplicationsSQL Server 2005 stdServerssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/14 3:31:27
Complete: LoadResourcesAction at: 2007/1/14 3:31:27, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/14 3:31:27
Loaded DLL:\ldnas1msdn versionsServer ApplicationsSQL Server 2005 stdServersxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/14 3:31:27, returned true
Running: ValidateWinNTAction at: 2007/1/14 3:31:27
Complete: ValidateWinNTAction at: 2007/1/14 3:31:27, returned true
Running: ValidateMinOSAction at: 2007/1/14 3:31:27
Complete: ValidateMinOSAction at: 2007/1/14 3:31:27, returned true
Running: PerformSCCAction at: 2007/1/14 3:31:27
Complete: PerformSCCAction at: 2007/1/14 3:31:27, returned true
Running: ActivateLoggingAction at: 2007/1/14 3:31:27
Complete: ActivateLoggingAction at: 2007/1/14 3:31:27, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2176" returned false.
Running: PerformSCCAction2 at: 2007/1/14 3:31:27
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2007/1/14 3:31:27, returned true
Running: PerformDotNetCheck at: 2007/1/14 3:31:27
Complete: PerformDotNetCheck at: 2007/1/14 3:31:27, returned true
Running: ComponentUpdateAction at: 2007/1/14 3:31:27
Complete: ComponentUpdateAction at: 2007/1/14 3:31:54, returned true
Delay load of action "DetectLocalBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchLocalBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchLocalBootstrap__2176" returned false.
Running: PerformDotNetCheck2 at: 2007/1/14 3:31:54
Complete: PerformDotNetCheck2 at: 2007/1/14 3:31:54, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/14 3:31:54
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Failed to determine path to bootstrap files : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: setupsqlsetupactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:04 2005
Function Name: sqls::InvokeSqlSetupDllAction::perform
Source Line Number: 1663



any ideas?

thanks

View 1 Replies View Related

SQLMail Does Not Work On 7.0 Cluster

Jul 16, 2001

I recently set up a SQL 7.0 cluster (active/passive) on a pair of Win2K boxes. I noticed that the SQLServerAgent would refuse to send system alerts to my e-mail account, yet net sent messages worked fine. I know I've set everything up properly, so I paid the $245 to speak with Microsoft.

The answer was found; their response follows:
{redacted}
CAUSE:
============
On a cluster an undocumented stored procedure is called by the Operator to send email and this causes it to fail. SQL Mail is not supported on SQL 7.0 clusters and any features depending on it will also fail.

RESOLUTION:
============
SQL 2000 does support SQL Mail on clusters with MS Office 2000 and up.
In SQL 2000 Books Online do a search for the following topics and include the quotes:
“Using SQL Server Tools with Failover Clustering”

Also you can workaround the problem by using a job that uses xp_sendmail to send the alert instead.
{END}

Now is that lame or what? Of all the functions you would expect to work in a failover cluster, you would think that e-mailing the operator in the event of a failure would be high on the list. Apparently, not so. Their official answer was to upgrade to SQL2000. Anybody care to guess the price on doing a dual CPU dual box cluster upgrade?

Now my question is this: The tech person was right, xp_sendmail does work fine. What I have wanting to do, and have been unable to do, is to write a TRIGGER that would fire whenever an error is logged by the SQL server. I have looked around, but could find no documentation on what table it is that receives error logs.

Does anybody know which table receives error messages? I'm wanting to write a trigger that exec's xp_sendmail so I get error alerts.

View 1 Replies View Related

SQLMail, MAPI Profile

Aug 7, 2000

I created a new MAPI profile on the server, and it seems to work fine with Outlook. I also dropped the previous default MAPI profile.

Now, when I go to the EM SQLAgent Properties, the only MAP profile offered in the SQLMail drop-down is the old, deleted profile. Also, only the old profile comes up with xp_get_MAPI_profiles.

How can I get SQLAgent to recognize that I've set up a new mail profile?

View 1 Replies View Related

Send SQLMail Thru Notes

Aug 15, 2000

I need to set up SQLMail togheter with Notes, We have SMTP server and profiles but I can´t get it to work. SQL sends the mail but it disappears into the cyberspace.. Someone help me pls...

View 1 Replies View Related







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