can't start sql 2005 service

Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!

can't see print messages during the running a of stored procedure

I have a stored procedure running from Query Analyzer that runs for a long
time and would like to have status messages print out during the procedure.
They all seem to come when the procedure is complete - is there any way to
have them print while it is running. I 've actually tried having the main
SP call a smaller SP with prints, but they don't come out till the end as
well.
Help to a new Transact SQL writer,
Thanks
TW
TW,
I don't know how to do just what you want, but you could try pumping your
messages into a trace table. Then you could query that table while the
long-running stored procedure continues. Transaction isolation levels would
affect how this works for you.
Russell Fields
"Weave" <tweaver60@.suscom.net> wrote in message
news:10apu6dm256v76@.corp.supernews.com...
> I have a stored procedure running from Query Analyzer that runs for a long
> time and would like to have status messages print out during the
procedure.
> They all seem to come when the procedure is complete - is there any way to
> have them print while it is running. I 've actually tried having the main
> SP call a smaller SP with prints, but they don't come out till the end as
> well.
> Help to a new Transact SQL writer,
> Thanks
> TW
>
|||You could use RAISERROR and the NOWAIT option instead of PRINT.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Weave" <tweaver60@.suscom.net> wrote in message news:10apu6dm256v76@.corp.supernews.com...
> I have a stored procedure running from Query Analyzer that runs for a long
> time and would like to have status messages print out during the procedure.
> They all seem to come when the procedure is complete - is there any way to
> have them print while it is running. I 've actually tried having the main
> SP call a smaller SP with prints, but they don't come out till the end as
> well.
> Help to a new Transact SQL writer,
> Thanks
> TW
>

Can't receive messages on second server instance

Hi all!

Help, please!

I am trying to send messages between 2 different server instances. I am getting the following errors in Profiler:

"This message could not be delivered because the user with ID 0 in database ID 14 does not have permission to send to the service. Service name: 'TestService1'."

"The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied."

The scripts for object creation and messaging is following at the first server instance:

USE master
GO
CREATE ENDPOINT SBroker
STATE = STARTED
AS TCP ( LISTENER_PORT = 1212 )
FOR SERVICE_BROKER (
ENCRYPTION = DISABLED
);
GO

USE Test
GO
CREATE QUEUE TestQueue
WITH STATUS=ON

CREATE SERVICE TestService
AUTHORIZATION dbo
ON QUEUE TestQueue

CREATE ROUTE TestRoute
WITH
SERVICE_NAME = 'TestService1',
BROKER_INSTANCE ='2B7CE76A-9804-46F3-9AE8-0AE59313613A',
ADDRESS = 'TCP://10.17.11.17:4037' ;

// send message script:

DECLARE @.dh UNIQUEIDENTIFIER;

BEGIN DIALOG CONVERSATION @.dh
FROM SERVICE [TestService]
TO SERVICE 'TestService1','2B7CE76A-9804-46F3-9AE8-0AE59313613A'
ON CONTRACT [DEFAULT]
WITH ENCRYPTION = OFF;

SEND ON CONVERSATION @.dh MESSAGE TYPE [DEFAULT] ('this is message1');

DECLARE @.status nvarchar(1024);
SELECT status = GET_TRANSMISSION_STATUS(@.dh);

END CONVERSATION @.dh;

on second server instance:

use master
GO
CREATE ENDPOINT SBroker2
STATE = STARTED
AS TCP ( LISTENER_PORT = 1212 )
FOR SERVICE_BROKER (
ENCRYPTION = DISABLED
);
GO

in first server, in sys.transmission_queue transmission_status is empty

Both servers in the same domain, and databases on this server has the same owner.

on both servers, select @.@.version:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Thanks a lot for help and explanation!

Sveta.

When you begin a dialog with encryption = off and there is no remote service binding for the target service in the initiator database, the inbound dialog at the target side will appear to be coming from user public (i.e. database principal 0). You will therefore need to grant send permission on the target service to user public. Of course, doing so means anyone can send messages to the target service.

If you want to authenticate the initiator, you will need to export the initiator service owner's certificate, create a user in the target database, import the certificate and make it owned by this user, and grant send permission for target service to this user. You could use Remus' Service Listings tool, which greatly simplied this process.

|||

Thank you for help,

after granting permission :

grant send on service::TestService1 to public

all messages received in second server.

can't post replies to messages

I'm having issues trying to post replies to messages in this newsgroup all of a sudden, anyone else having an issue?
when I click on post I get the "we're sorry we did not receive your post please try again later" message.
grrrrrrrrrrrrr...!
Use a newsreader.
http://www.aspfaq.com/5007
http://www.aspfaq.com/
(Reverse address to reply.)
"bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> I'm having issues trying to post replies to messages in this newsgroup all
of a sudden, anyone else having an issue?
> when I click on post I get the "we're sorry we did not receive your post
please try again later" message.
> grrrrrrrrrrrrr...!
|||thks for the url..looks interesting. In checking my original thread I now see my posts were posted.
So I'm getting "false negatives" of the errors that my posts are not being received.
bill
"Aaron [SQL Server MVP]" wrote:

> Use a newsreader.
> http://www.aspfaq.com/5007
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
> news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> of a sudden, anyone else having an issue?
> please try again later" message.
>
>

can't post replies to messages

I'm having issues trying to post replies to messages in this newsgroup all o
f a sudden, anyone else having an issue?
when I click on post I get the "we're sorry we did not receive your post ple
ase try again later" message.
grrrrrrrrrrrrr...!Use a newsreader.
http://www.aspfaq.com/5007
http://www.aspfaq.com/
(Reverse address to reply.)
"bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> I'm having issues trying to post replies to messages in this newsgroup all
of a sudden, anyone else having an issue?
> when I click on post I get the "we're sorry we did not receive your post
please try again later" message.
> grrrrrrrrrrrrr...!|||thks for the url..looks interesting. In checking my original thread I now s
ee my posts were posted.
So I'm getting "false negatives" of the errors that my posts are not being r
eceived.
bill
"Aaron [SQL Server MVP]" wrote:

> Use a newsreader.
> http://www.aspfaq.com/5007
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
> news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> of a sudden, anyone else having an issue?
> please try again later" message.
>
>