Authentication Error with HTTP EndPoints

Hello!
I'm unable to use a webservice exposed on a Sql Server 2005 by using
the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
is to write a function for a Excel Sheet wich resolves some
identifiers to strings by using a SQL Server 2005. I thougt to use web
services but end up with errors, as you can read furthre down.
If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
wrong, I would be very happy if some one could advise me.
The exception in VBA is about '... access denied...'. The SQL Server
logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
The Endpoint I want to use is as follows:
CREATE ENDPOINT SQLEP_gmd
STATE = STARTED
AS HTTP
(
PATH = '/gmd',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '2003dellp285002'
)
FOR SOAP
(
WEBMETHOD 'getNextReferenceSubstanceIdentifier'
(NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'metabolomics',
NAMESPACE = 'http://2003dellp285002'
)
The stored procedure is very simple, has no input parameters and
returns a string to simplify matters.
Any commnt is apreciated very much!
With kind regardsHi,
If I remember correctly, you will need to specify the user and password as
part of the URL you used to initialize the MSSoap.SoapClient object. If that
isn't possible, I recommend creating the data connection using the normal SQL
database method.
Please also make sure that you have granted access to the Endpoint and the
Stored Procedure for the user you wish to connect with.
Jimmy
"jahu" wrote:
> Hello!
> I'm unable to use a webservice exposed on a Sql Server 2005 by using
> the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
> is to write a function for a Excel Sheet wich resolves some
> identifiers to strings by using a SQL Server 2005. I thougt to use web
> services but end up with errors, as you can read furthre down.
> If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
> wrong, I would be very happy if some one could advise me.
> The exception in VBA is about '... access denied...'. The SQL Server
> logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
> The Endpoint I want to use is as follows:
> CREATE ENDPOINT SQLEP_gmd
> STATE = STARTED
> AS HTTP
> (
> PATH = '/gmd',
> AUTHENTICATION = (INTEGRATED),
> PORTS = (CLEAR),
> SITE = '2003dellp285002'
> )
> FOR SOAP
> (
> WEBMETHOD 'getNextReferenceSubstanceIdentifier'
> (NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
> BATCHES = DISABLED,
> WSDL = DEFAULT,
> DATABASE = 'metabolomics',
> NAMESPACE = 'http://2003dellp285002'
> )
>
> The stored procedure is very simple, has no input parameters and
> returns a string to simplify matters.
> Any commnt is apreciated very much!
> With kind regards
>|||Dig up some more details. You can specify the user credentials on the
SoapClient object. The following is a sample:
SoapClient.connectorProperty("AuthUser") = "userName"
SoapClient.connectorProperty("AuthPassword") = "PASSWORD"
// Set Auth scheme
// digest 0x8
// negotiate 0x10
// ntlm 0x2
// basic 0x1
SoapClient.connectorProperty("WinHTTPAuthScheme") = 0x2
Jimmy
"Jimmy Wu [MSFT]" wrote:
> Hi,
> If I remember correctly, you will need to specify the user and password as
> part of the URL you used to initialize the MSSoap.SoapClient object. If that
> isn't possible, I recommend creating the data connection using the normal SQL
> database method.
> Please also make sure that you have granted access to the Endpoint and the
> Stored Procedure for the user you wish to connect with.
> Jimmy
> "jahu" wrote:
> > Hello!
> >
> > I'm unable to use a webservice exposed on a Sql Server 2005 by using
> > the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
> > is to write a function for a Excel Sheet wich resolves some
> > identifiers to strings by using a SQL Server 2005. I thougt to use web
> > services but end up with errors, as you can read furthre down.
> >
> > If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
> > wrong, I would be very happy if some one could advise me.
> >
> > The exception in VBA is about '... access denied...'. The SQL Server
> > logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
> >
> > The Endpoint I want to use is as follows:
> > CREATE ENDPOINT SQLEP_gmd
> > STATE = STARTED
> > AS HTTP
> > (
> > PATH = '/gmd',
> > AUTHENTICATION = (INTEGRATED),
> > PORTS = (CLEAR),
> > SITE = '2003dellp285002'
> > )
> > FOR SOAP
> > (
> > WEBMETHOD 'getNextReferenceSubstanceIdentifier'
> > (NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
> > BATCHES = DISABLED,
> > WSDL = DEFAULT,
> > DATABASE = 'metabolomics',
> > NAMESPACE = 'http://2003dellp285002'
> > )
> >
> >
> > The stored procedure is very simple, has no input parameters and
> > returns a string to simplify matters.
> >
> > Any commnt is apreciated very much!
> >
> > With kind regards
> >
> >

Auditing tables

Hi ,
I am trying trigger for after delete /insert and update .
using below trigger , unable to insert data in myaudittable ..
Pls suggest , what changes should I make ?
Regards
"swati" <swati.zingade@.ugamsolutions.com> wrote in message news:...
> Thanks!! It works properly .
>
> Regards,
> Swati
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ebvGMQ1uEHA.4084@.TK2MSFTNGP10.phx.gbl...
> > swati
> > create trigger tru_MyTable on MyTable after update
> > as
> >
> > if @.@.ROWCOUNT = 0
> > return
> >
> > insert MyAuditTable
> > select
> > i.ID
> > , d.MyColumn
> > , i.MyColumn
> > from
> > inserted i
> > join
> > deleted d on d.ID = o.Id
> > go
> >
> > "swati" <swati.zingade@.ugamsolutions.com> wrote in message
> > news:uNbsEK1uEHA.1308@.TK2MSFTNGP09.phx.gbl...
> > > HI!
> > >
> > > I want to audit some collumns of one of my huge table . I wrote a
> trigger
> > > for copying updated data and original data in audit table.
> > > But when I try to update multiple rows , it gives error of "cannot
> > update
> > > multiple rows. "
> > >
> > > Is there any easy way of auditing tables without using triggers . I
> donot
> > > want to use C2-audit .
> > >
> > > Regards,
> > > Swati
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>What error are you getting? Please post your actual trigger code and table
DDL.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:O$InOPAvEHA.1520@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> I am trying trigger for after delete /insert and update .
> using below trigger , unable to insert data in myaudittable ..
> Pls suggest , what changes should I make ?
> Regards
>
> "swati" <swati.zingade@.ugamsolutions.com> wrote in message news:...
>> Thanks!! It works properly .
>> Regards,
>> Swati
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ebvGMQ1uEHA.4084@.TK2MSFTNGP10.phx.gbl...
>> > swati
>> > create trigger tru_MyTable on MyTable after update
>> > as
>> >
>> > if @.@.ROWCOUNT = 0
>> > return
>> >
>> > insert MyAuditTable
>> > select
>> > i.ID
>> > , d.MyColumn
>> > , i.MyColumn
>> > from
>> > inserted i
>> > join
>> > deleted d on d.ID = o.Id
>> > go
>> >
>> > "swati" <swati.zingade@.ugamsolutions.com> wrote in message
>> > news:uNbsEK1uEHA.1308@.TK2MSFTNGP09.phx.gbl...
>> > > HI!
>> > >
>> > > I want to audit some collumns of one of my huge table . I wrote a
>> trigger
>> > > for copying updated data and original data in audit table.
>> > > But when I try to update multiple rows , it gives error of "cannot
>> > update
>> > > multiple rows. "
>> > >
>> > > Is there any easy way of auditing tables without using triggers . I
>> donot
>> > > want to use C2-audit .
>> > >
>> > > Regards,
>> > > Swati
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>>
>|||Thanks dan . There was some silly mistake I did in coding . Instead of using
full outer joins ,I was using normal joins ,so was not able to get the
deleted records .Now it's working fine.
regards,
Swati.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ulLkEBCvEHA.2196@.TK2MSFTNGP14.phx.gbl...
> What error are you getting? Please post your actual trigger code and
table
> DDL.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "swati" <swati.zingade@.ugamsolutions.com> wrote in message
> news:O$InOPAvEHA.1520@.TK2MSFTNGP11.phx.gbl...
> > Hi ,
> > I am trying trigger for after delete /insert and update .
> > using below trigger , unable to insert data in myaudittable ..
> > Pls suggest , what changes should I make ?
> >
> > Regards
> >
> >
> > "swati" <swati.zingade@.ugamsolutions.com> wrote in message news:...
> >> Thanks!! It works properly .
> >>
> >> Regards,
> >> Swati
> >>
> >> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> >> news:ebvGMQ1uEHA.4084@.TK2MSFTNGP10.phx.gbl...
> >> > swati
> >> > create trigger tru_MyTable on MyTable after update
> >> > as
> >> >
> >> > if @.@.ROWCOUNT = 0
> >> > return
> >> >
> >> > insert MyAuditTable
> >> > select
> >> > i.ID
> >> > , d.MyColumn
> >> > , i.MyColumn
> >> > from
> >> > inserted i
> >> > join
> >> > deleted d on d.ID = o.Id
> >> > go
> >> >
> >> > "swati" <swati.zingade@.ugamsolutions.com> wrote in message
> >> > news:uNbsEK1uEHA.1308@.TK2MSFTNGP09.phx.gbl...
> >> > > HI!
> >> > >
> >> > > I want to audit some collumns of one of my huge table . I wrote a
> >> trigger
> >> > > for copying updated data and original data in audit table.
> >> > > But when I try to update multiple rows , it gives error of
"cannot
> >> > update
> >> > > multiple rows. "
> >> > >
> >> > > Is there any easy way of auditing tables without using triggers . I
> >> donot
> >> > > want to use C2-audit .
> >> > >
> >> > > Regards,
> >> > > Swati
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>

attempts to attach db are locking up the server...

Hi,
I had a similar post before, and got some good
suggestions on this, but so far I'm still unable to
retrieve my database. Unfortunately, I made the mistake
of not detaching my database when I was having some
problems, and it got physically moved instead. I have
tried several different options to get it back, but they
either don't work or end up locking the system.
What would cause something to lock up like that? I've
tried to kill everything, so I don't see anything going
on there.
Any ideas on how I could get this db back, and why it
might be locking up when I try to attach it?
Thanks!
Rick
Hi,
What do you meant by Locking while attach? Are you getting any errors while
attaching ? See the SQL server error log for any errors.
Thanks
Hari
MCDBA
"Rick" <rmemmer@.carolina.rr.com> wrote in message
news:783701c48423$2fd35f80$a601280a@.phx.gbl...
> Hi,
> I had a similar post before, and got some good
> suggestions on this, but so far I'm still unable to
> retrieve my database. Unfortunately, I made the mistake
> of not detaching my database when I was having some
> problems, and it got physically moved instead. I have
> tried several different options to get it back, but they
> either don't work or end up locking the system.
> What would cause something to lock up like that? I've
> tried to kill everything, so I don't see anything going
> on there.
> Any ideas on how I could get this db back, and why it
> might be locking up when I try to attach it?
> Thanks!
>
> Rick
|||Hi,
Thanks for your reply. Actually, I had two different
timing out issues. One was happening due to an update
that needed an index in order to update millions of
rows. It would time out and just sit there racking up
memory resources, but after I put the index on the join
field... it worked just fine. The same thing was
happening to the database I was trying to attach, but it
looks as though there was no way this was ever going to
work. It needed to be repaired first, but I had not
found anything that would work (prior to my post).
Anyway, I found this article that you might be interested
in for future reference:
Search "experts exchange Q_21020424" in Google to get
this article... the link won't bring you directly in, so
that's why you need to search on it. I was able to run a
few procedures and then repair the database (which took
about 40 minutes for a very large file), and after that I
was ready to go.
So, I'm all fine now. Of course, I'm still not sure what
to do in order to kill a process that seemingly doesn't
want to be killed. It would be nice to find that out for
future reference, so that the memory doesn't climb to the
point where you have to shut it down.
Thanks for your help!
Rick

>--Original Message--
>Hi,
>What do you meant by Locking while attach? Are you
getting any errors while[vbcol=seagreen]
>attaching ? See the SQL server error log for any errors.
>Thanks
>Hari
>MCDBA
>"Rick" <rmemmer@.carolina.rr.com> wrote in message
>news:783701c48423$2fd35f80$a601280a@.phx.gbl...
mistake[vbcol=seagreen]
they
>
>.
>

attempts to attach db are locking up the server...

Hi,
I had a similar post before, and got some good
suggestions on this, but so far I'm still unable to
retrieve my database. Unfortunately, I made the mistake
of not detaching my database when I was having some
problems, and it got physically moved instead. I have
tried several different options to get it back, but they
either don't work or end up locking the system.
What would cause something to lock up like that? I've
tried to kill everything, so I don't see anything going
on there.
Any ideas on how I could get this db back, and why it
might be locking up when I try to attach it?
Thanks!
RickHi,
What do you meant by Locking while attach? Are you getting any errors while
attaching ? See the SQL server error log for any errors.
Thanks
Hari
MCDBA
"Rick" <rmemmer@.carolina.rr.com> wrote in message
news:783701c48423$2fd35f80$a601280a@.phx.gbl...
> Hi,
> I had a similar post before, and got some good
> suggestions on this, but so far I'm still unable to
> retrieve my database. Unfortunately, I made the mistake
> of not detaching my database when I was having some
> problems, and it got physically moved instead. I have
> tried several different options to get it back, but they
> either don't work or end up locking the system.
> What would cause something to lock up like that? I've
> tried to kill everything, so I don't see anything going
> on there.
> Any ideas on how I could get this db back, and why it
> might be locking up when I try to attach it?
> Thanks!
>
> Rick|||Hi,
Thanks for your reply. Actually, I had two different
timing out issues. One was happening due to an update
that needed an index in order to update millions of
rows. It would time out and just sit there racking up
memory resources, but after I put the index on the join
field... it worked just fine. The same thing was
happening to the database I was trying to attach, but it
looks as though there was no way this was ever going to
work. It needed to be repaired first, but I had not
found anything that would work (prior to my post).
Anyway, I found this article that you might be interested
in for future reference:
Search "experts exchange Q_21020424" in Google to get
this article... the link won't bring you directly in, so
that's why you need to search on it. I was able to run a
few procedures and then repair the database (which took
about 40 minutes for a very large file), and after that I
was ready to go.
So, I'm all fine now. Of course, I'm still not sure what
to do in order to kill a process that seemingly doesn't
want to be killed. It would be nice to find that out for
future reference, so that the memory doesn't climb to the
point where you have to shut it down.
Thanks for your help!
Rick

>--Original Message--
>Hi,
>What do you meant by Locking while attach? Are you
getting any errors while
>attaching ? See the SQL server error log for any errors.
>Thanks
>Hari
>MCDBA
>"Rick" <rmemmer@.carolina.rr.com> wrote in message
>news:783701c48423$2fd35f80$a601280a@.phx.gbl...
mistake[vbcol=seagreen]
they[vbcol=seagreen]
>
>.
>

Attaching SQL 2000 database (.mdf) with missing (.ldf) file

Hello

Please can anyone help me

I've been given a .mdf file from sql server 2000 which i need to attach but we do not have the .ldf file

I am unable to recover the old .ldf file

I have tried the attach single file command but obvioulsy this still looks for the old .ldf file path which no longer exists

any help would be mostly appriciated

many thanks

Martin

sp_attach_single_file_db only works if the database was appropiatly closed and concistent. If the procedure does not work, you will either need to have the ldf file or a valid backup.

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Unfortunatly we do not have the ldf file or a valid backup

we only have the mdf file

is there no way of getting round this or recreating a log so i can access the data of the mdf

regards

Martin

|||Hi, I'm in exactly the same situation where a server failure has lost us the LDF but we still have an MDF..

Weve tried the various attach etc but still no luck so if anyone has any advice I'd sure appreciate it as well please...........

regards
PeterSm|||Unfortunately, the tools mentioned are the only ones.

Jens K. Suessmeyer.

http://www.sqlserver2005.de