Home > Archive > Microsoft SQL Server forum > August 2005 > Where to find the the allowed users of SQL2000









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Where to find the the allowed users of SQL2000
Ger Eielts

2005-08-24, 7:24 am


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

SQL2000, SP3, running on a SBS2003-server with WindowsSharePoint
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.droptable.com ***
Simon Hayes

2005-08-24, 7:24 am

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

http://support.microsoft.com/defaul...306&Product=sql

Simon

Erland Sommarskog

2005-08-24, 9:23 am

Ger Eielts (ger@eielts.nl) writes:
> 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 ???


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@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com