SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Mail Connection problems

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Mail Connection problems
Author Message
Marrs



Joined: 06 Nov 2008
Posts: 3
Country: United States

Post DB Mail Connection problems Reply with quote
I am running SQL 2005 on Win serv 2003 and have localy installed DB mail on our SQL srv after running the install i tried to run the database setup but kept getting the DBMS MSS error so i skiped and created ODBC. After configuring DB Mail it looked as tough it connected but then received the following. What am i missing. I am currently using the trial and if i can get this to work i will be purchasing.

Select error: SQLSTATE = S0002
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'master.dbmail.pipe'.

Thanks
________
How To Make A Vaporizer


Last edited by Marrs on Fri Feb 25, 2011 4:16 am; edited 1 time in total
Thu Nov 06, 2008 5:10 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
It sounds like you didn't install the required tables and procedures in the database.
See DB Mail Quick Start Guide http://www.softtreetech.com/dbmail/db_mail25_start.pdf chapter "What you need to install" -> "Back-end installation" -> "Microsoft SQL Server" This should guide you through the DB Mail installation process, which is quite simple.
Thu Nov 06, 2008 5:31 pm View user's profile Send private message
Marrs



Joined: 06 Nov 2008
Posts: 3
Country: United States

Post Reply with quote
I tried but keep getting

Unable to locate component
NTWDBLIB.dll was not found

and then

Error connecting to database.
DBMS MSS is not supported in your current installation.

I copied the xp_dbmail.dll to its appropriate folder and when i hit next i get the above.
________
Sell Vaporizers


Last edited by Marrs on Fri Feb 25, 2011 4:17 am; edited 1 time in total
Thu Nov 06, 2008 5:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Please change the connection to ODBC and pick an ODBC profile for the database server you want to connect to. After you successfully connect, finish the required installation steps.
Thu Nov 06, 2008 6:52 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.