Is the Certificate based authentication the only way ?

1.On an virtual server two virtual machines of Windows 2003+sql server 2005 developer edition named VM1 and VM2

2.The VMs are not on a domain.

3.endpoint uses windows authentication

I get the following error

Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://x.x.x.x:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

and the log file contains the following

07/26/2007 19:21:22,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:19,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:17,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:14,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:12,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:10,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:09,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:08,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:06,spid25s,Unknown,Database mirroring connection error 5 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.' for 'TCP://x.x.x.x:5022'.
07/26/2007 19:21:06,spid25s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.
07/26/2007 19:21:06,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]

Is there anyway i can do mirroring without certificates,

guys any pointers?

i think the partners namely principal and mirror server shud have either standard or enterprise edition to configure mirroring..........but the error seems to be different........just check the ports using the command netstat -ano whether the port you specify is used somewhere........also try to give the fully qualified server name.........

|||

1. Developer edition supports

2.The specified port is not being used

3.Since the macine is not on a domain i cannot give the fully qualified path alternatively i have used ip.

|||

I don't know if this will make you feel better or not but let me tell you that I as well was looking into setting up mirroring with all sorts of tricks not to use certificate authentication.

But trust me, for 2 computers not in the same domain this is the best way. It saves you a lot of trouble with permissions and all sorts of *** errors.

Do it using transact sql commands following microsoft example and it will work! I got mine up and running ever since.

|||

I had the same error even after bringing the servers under a single domain.

The following is the change I made

Changed the Authentication type from Kerbrose to NTLM.

It all works fine when servers are under same domain.

Need to check when the servers are not under a Domain.

|||partners need to be either std or enterprise edition...refer,
http://msdn2.microsoft.com/en-us/library/ms366349.aspx

IS service won't start after installing SP1

I have just installed SP1 and now the IS service will not start at all. I have tried using the LocalSystem account and an account with domain admin rights that I use to run all the other SQL Server services.

Before the SP was applied the service was running fine.

I have tried starting it from the command prompt, services and configuration manager but none of them work, I get the following error message:

"The service did not respond to the start or control request in a timely fashion"

This message is also in in the System Event Viewer, but there are no messages in the Application Event Viewer for the IS Service so I am now officially stumped (not to mention frustrated)

Please help!

This issue is all voer the web: http://www.google.com/search?hl=en&lr=&q=ssis+%22The+service+did+not+respond+to+the+start+or+control+request+in+a+timely+fashion%22

Here for example: http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3877.aspx

-Jamie

|||

Thanks for the help Jamie, I have found the kb article (918644).

Now I have to install 5 separate fixes, that fix problems caused by a big bunch of fixes!! Wow

|||

bobbins wrote:

Thanks for the help Jamie, I have found the kb article (918644).

Now I have to install 5 separate fixes, that fix problems caused by a big bunch of fixes!! Wow

Err yeah, that's basically it!

|||

will keep me busy I suppose

I am tempted to take a trip to the feedback centre and it won't be pretty

Cheers again

Is SELECT...INTO a Linked Server possible?

SQL2K
SP3
Greetings. I can run this OK:
select top 100 * into [server.domain.com\des.dbaTest.dbo.t48]
from t48
But it actually creates/ inserts the table into the DB I run it from (with
the name "server.domain.com\des.dbaTest.dbo.t48"), NOT onto my Linked Server
as desired. Is this not possible? I have read that this should work:
select top 100 * into [server.domain.com\des].[dbaTest].[dbo].[t48]
from t48
but I get the message:
Server: Msg 117, Level 15, State 1, Line 2
The object name 'server.domain.com\des.dbaTest.dbo.' contains more than the
maximum number of prefixes. The maximum is 2.
TIA, ChrisRDoes this work for you ?
select top 100 * from [server.domain.com\des].[dbaTest].[dbo].[t48]
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:A8519D87-D753-44F9-B289-8680BE071186@.microsoft.com...
> SQL2K
> SP3
> Greetings. I can run this OK:
> select top 100 * into [server.domain.com\des.dbaTest.dbo.t48]
> from t48
> But it actually creates/ inserts the table into the DB I run it from (with
> the name "server.domain.com\des.dbaTest.dbo.t48"), NOT onto my Linked
> Server
> as desired. Is this not possible? I have read that this should work:
> select top 100 * into [server.domain.com\des].[dbaTest].[dbo].[t48]
> from t48
> but I get the message:
> Server: Msg 117, Level 15, State 1, Line 2
> The object name 'server.domain.com\des.dbaTest.dbo.' contains more than
> the
> maximum number of prefixes. The maximum is 2.
> TIA, ChrisR|||No, I get the message:
Server: Msg 117, Level 15, State 1, Line 2
The object name 'server.domain.com\des.dbaTest.dbo.' contains more than the
maximum number of prefixes. The maximum is 2.
"Hassan" <hassan@.hotmail.com> wrote in message
news:u6gNU99$HHA.3848@.TK2MSFTNGP05.phx.gbl...
> Does this work for you ?
> select top 100 * from [server.domain.com\des].[dbaTest].[dbo].[t48]
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:A8519D87-D753-44F9-B289-8680BE071186@.microsoft.com...
>> SQL2K
>> SP3
>> Greetings. I can run this OK:
>> select top 100 * into [server.domain.com\des.dbaTest.dbo.t48]
>> from t48
>> But it actually creates/ inserts the table into the DB I run it from
>> (with
>> the name "server.domain.com\des.dbaTest.dbo.t48"), NOT onto my Linked
>> Server
>> as desired. Is this not possible? I have read that this should work:
>> select top 100 * into [server.domain.com\des].[dbaTest].[dbo].[t48]
>> from t48
>> but I get the message:
>> Server: Msg 117, Level 15, State 1, Line 2
>> The object name 'server.domain.com\des.dbaTest.dbo.' contains more than
>> the
>> maximum number of prefixes. The maximum is 2.
>> TIA, ChrisR
>|||Hi Chris
What is your linked server called?
The new table created with the INTO clause does not support 4 part names.
You would need to create the table and then use INSERT..SELECT to populate it.
John
"ChrisR" wrote:
> No, I get the message:
> Server: Msg 117, Level 15, State 1, Line 2
> The object name 'server.domain.com\des.dbaTest.dbo.' contains more than the
> maximum number of prefixes. The maximum is 2.
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:u6gNU99$HHA.3848@.TK2MSFTNGP05.phx.gbl...
> > Does this work for you ?
> >
> > select top 100 * from [server.domain.com\des].[dbaTest].[dbo].[t48]
> >
> >
> > "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> > news:A8519D87-D753-44F9-B289-8680BE071186@.microsoft.com...
> >> SQL2K
> >> SP3
> >>
> >> Greetings. I can run this OK:
> >>
> >> select top 100 * into [server.domain.com\des.dbaTest.dbo.t48]
> >> from t48
> >>
> >> But it actually creates/ inserts the table into the DB I run it from
> >> (with
> >> the name "server.domain.com\des.dbaTest.dbo.t48"), NOT onto my Linked
> >> Server
> >> as desired. Is this not possible? I have read that this should work:
> >>
> >> select top 100 * into [server.domain.com\des].[dbaTest].[dbo].[t48]
> >> from t48
> >>
> >> but I get the message:
> >>
> >> Server: Msg 117, Level 15, State 1, Line 2
> >> The object name 'server.domain.com\des.dbaTest.dbo.' contains more than
> >> the
> >> maximum number of prefixes. The maximum is 2.
> >>
> >> TIA, ChrisR
> >
> >
>
>|||Thanks!
"John Bell" wrote:
> Hi Chris
> What is your linked server called?
> The new table created with the INTO clause does not support 4 part names.
> You would need to create the table and then use INSERT..SELECT to populate it.
> John
> "ChrisR" wrote:
> > No, I get the message:
> >
> > Server: Msg 117, Level 15, State 1, Line 2
> > The object name 'server.domain.com\des.dbaTest.dbo.' contains more than the
> > maximum number of prefixes. The maximum is 2.
> >
> >
> >
> > "Hassan" <hassan@.hotmail.com> wrote in message
> > news:u6gNU99$HHA.3848@.TK2MSFTNGP05.phx.gbl...
> > > Does this work for you ?
> > >
> > > select top 100 * from [server.domain.com\des].[dbaTest].[dbo].[t48]
> > >
> > >
> > > "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> > > news:A8519D87-D753-44F9-B289-8680BE071186@.microsoft.com...
> > >> SQL2K
> > >> SP3
> > >>
> > >> Greetings. I can run this OK:
> > >>
> > >> select top 100 * into [server.domain.com\des.dbaTest.dbo.t48]
> > >> from t48
> > >>
> > >> But it actually creates/ inserts the table into the DB I run it from
> > >> (with
> > >> the name "server.domain.com\des.dbaTest.dbo.t48"), NOT onto my Linked
> > >> Server
> > >> as desired. Is this not possible? I have read that this should work:
> > >>
> > >> select top 100 * into [server.domain.com\des].[dbaTest].[dbo].[t48]
> > >> from t48
> > >>
> > >> but I get the message:
> > >>
> > >> Server: Msg 117, Level 15, State 1, Line 2
> > >> The object name 'server.domain.com\des.dbaTest.dbo.' contains more than
> > >> the
> > >> maximum number of prefixes. The maximum is 2.
> > >>
> > >> TIA, ChrisR
> > >
> > >
> >
> >
> >