Where to find the the allowed users of SQL2000

[Ger Eielts]

Hi all, I am brandnew with SQL2000, so sorry in advance for
stupidities....

SQL2000, SP3, running on a SBS2003-server with WindowsSharePoi nt
Services.

I want to make a dataconnection (from within the LAN with InfoPath) from
a client to this server. I got the error that whether the server doesnot
exists (it does) or no permission. Where can I find (in SQL2000) which
users have access to the databases ???

Help is appreciated, Ger.



*** Sent via Developersdex http://www.developersdex.com ***

[Simon Hayes]

Re: Where to find the the allowed users of SQL2000

See sp_helplogins in Books Online. But that error can be caused by
other issues too:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql

Simon

[Erland Sommarskog]

Re: Where to find the the allowed users of SQL2000

Ger Eielts (ger@eielts.nl) writes:[color=blue]
> I want to make a dataconnection (from within the LAN with InfoPath) from
> a client to this server. I got the error that whether the server doesnot
> exists (it does) or no permission. Where can I find (in SQL2000) which
> users have access to the databases ???[/color]

That error message "SQL does not exist or access denied" means that
you are not able to even reach SQL Server on the network.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp