471,571 Members | 1,002 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,571 software developers and data experts.

Where to find the the allowed users of SQL2000


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.developersdex.com ***
Aug 24 '05 #1
2 1353
See sp_helplogins in Books Online. But that error can be caused by
other issues too:

http://support.microsoft.com/default...06&Product=sql

Simon

Aug 24 '05 #2
Ger Eielts (ge*@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, es****@sommarskog.se

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

Aug 24 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by LizP | last post: by
3 posts views Thread by Robby | last post: by
12 posts views Thread by Robert Bravery | last post: by
2 posts views Thread by PointMan | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.