SQL Web Services

[sqlnerd]

I Need help with accessing an SQL server from a web method.

Trying to connect from localhost to ms sql server 2000 sp1 and get the
error:
System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
access denied.
at System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )
at System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction )
at System.Data.Sql Client.SqlConne ction.Open()
at WebService2.Ser vice1.GetPass(S tring name) in
c:\inetpub\wwwr oot\webservice2 \service1.asmx. cs:line 65

Using windows authentication.
CONFUSED!!!!
Help pls!

[Simon Hayes]

Re: SQL Web Services


"sqlnerd" <mattscott45@ho tmail.com> wrote in message
news:4f39fde3.0 404280512.64440 a89@posting.goo gle.com...[color=blue]
> I Need help with accessing an SQL server from a web method.
>
> Trying to connect from localhost to ms sql server 2000 sp1 and get the
> error:
> System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
> access denied.
> at System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction )
> at[/color]
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString[color=blue]
> options, Boolean& isInTransaction )
> at System.Data.Sql Client.SqlConne ction.Open()
> at WebService2.Ser vice1.GetPass(S tring name) in
> c:\inetpub\wwwr oot\webservice2 \service1.asmx. cs:line 65
>
> Using windows authentication.
> CONFUSED!!!!
> Help pls![/color]

It's not clear from your post if the web service and MSSQL are on the same
server or not, but you can check the MSSQL error log to see if there is a
failed login from your web service account (assuming you have enabled this
logging). If so, then the problem is probably that the web service account
has not been granted login rights in MSSQL, or perhaps that the password is
incorrect. If there is no failed login attempt in the log, then you should
look at name resolution, and if the web service is connecting with the
correct protocol and/or to the correct port. You can use osql.exe to check
basic connectivity.

Simon