Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to use Database mail feature in SQL Server 2000


How to use Database mail feature in SQL Server 2000

Author
Message
danskisanjar
danskisanjar
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 51
Thank you for taking the time to reply. I am not sure why I use my email for this. On my 2005 servers, I have that account set up so it goes to mine and another persons inbox, using sqlaccount@mycompany.com.

But first thing is first. I can't even connect to this server. It tells me that the server doesn't exist or that the account is not valid, when the account is valid and is a sys admin on the 2005 server and has dbowner priveledges to the msdb database.

I am going from a SQL 2000 SP3 machine to SQL 2005 SPS x86. The 2000 machine is sitting on a 2003 x86 VM. Both machines are members of the domain.

Any hints? Thanks again.
M&M
M&M
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2595 Visits: 3898
Did you set up the linked server on SQL Server 2000 successfully?

M&M
danskisanjar
danskisanjar
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 51
I don't know.

When I try to connect I get this error.

Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.

That is using for

@server='ServerName, i.e. computername ',
and
@datasrc='default instance name i.e. MSSQLSERVER'
-------------------------------------------

If I change
@datasrc='computername'

I get a different error.

Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'domain\useraccount'.


If I change
@datasrc='computername\MSSQLSERVER'

I get a different error.

Server: Msg 14, Level 16, State 1, Line 1
Invalid connection.

-------------------------------------------

Named pipes is not enabled on SQL 2005 machine, only TCP/IP is enabled. Does named pipes have to be enabled?

------------------------------------------

Also I am using a windows account that is a sqldomainadmin account and DOES have
owner rights to the database on 2005.

Any help is appreciated.
M&M
M&M
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2595 Visits: 3898
First, go to SQL Server 2005 management studio and type
select @@servername

Then go to SQL Server 2000 Query Analyser and replace the above result in @server and @datasrc parameters for the sp_addlinkedserver procedure.

Then try validating if you configured linked server correctly.

M&M
danskisanjar
danskisanjar
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 51
Thank you for you help. I double checked and did what you said, and I did already tried this. This is the one that gave me this
result.

If I change
@datasrc='computername' = what you told me to do which was 'select @@servername'

which gave me what's below using the test query select * from 'servername'.msdb.dbo.sysjobs

Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'domain\useraccount'.

I don't get it. I triple checked the login and made sure that the account 'domain\domain account' is owner of all databases including the msdb, is a sysadmin on both machines.

Thank you for all your help.
danskisanjar
danskisanjar
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 51
I couldn't figure out why it kept saying the login was failing and I was logged in to both machines as that same user, so I change it from BE MADE USING THIS SECURITY CONTEXT and putting the account in there to

BE MADE USING THE LOGIN'S CURRENT SECURITY CONTEXT and it started working with the query, so I ran the "failing backup job" and it emailed me!

So, now I just have to tweak this thing.


Thank you so very much for your help! It is much appreciated!
M&M
M&M
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2595 Visits: 3898
Nice to know setup is working fine Hehe

M&M
danskisanjar
danskisanjar
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 51
Could I ask one more question?

I have about 10 SQL2000 servers. I have this working on about half of them now, but I ran into this.

I have two SQL2000 servers, ServerA and ServerB.

ServerA has under Enterprise management, both information from Server A and ServerB. On ServerB there is only information for
ServerB.

I added SQL2005 server to the linked server in both ServerA and and ServerB. SQL 2005 shows up in the linked servers area of them both. I can actually see the tables and views in the linked servers area on both ServerA and ServerB (I have data access temporarily enabled for testing purposes.) But when I run query analyzer (the test query) on both ServerA and ServerB, it fails and returns this.

Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'Server_2005' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

But I did execute just like I did on the other servers and it shows up like the others.

The 'failed backup' doesn't email me on these two servers as well. Do you or anyone else have any ideas on this? It would be appreciated.
M&M
M&M
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2595 Visits: 3898
Did you query sysservers to find out if 'Server_2005' exists srvname column

M&M
danskisanjar
danskisanjar
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 51
Yes. I even opened that table and the same table of a different server that works, side by side and went through every column. They matched up exactly.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search