Connecting SQL 2000 Server Remotely

I installed SQL 2000 server on my PC (OS: XP Professional). I wrote a Visual
Basic application that retrieves data from the SQL server that is installed
on my PC. When I start this application at my computer, it works. When I
start this application at another computer in the same network, it fails. It
returns me the following error message:
The application attempted to perform an operation not allowed by the
security policy. The operation required the SecurityException. To grant this
application the required permission please contact your system administrator
,
or use the Microsoft .NET security policy administration tool.
If you click Continue, the application will ignore this error and attempt to
continue. If you click Quit, the application will be shut down immediately.
Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data,
Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed
How do I configure my computer, the SQL server or the application so that I
can connect from another computer in the same network? By the way, I tried t
o
ping the IP address of my computer from the other computer on the same
network, but it fails too. What should I do?
Thank you.there is many things you need to check it before reconfgiure SQL Server:
1) Check Windows Firewall (if there is Service Pack 2 installed -SP2-).
2) Check that you installed SQL Server SP3 *Slammer Worm*.
3) Check the Framework Security in the Administrative Tools (Microsoft .NET
Framework 1.1 Configuration).
"wrytat" wrote:

> I installed SQL 2000 server on my PC (OS: XP Professional). I wrote a Visu
al
> Basic application that retrieves data from the SQL server that is installe
d
> on my PC. When I start this application at my computer, it works. When I
> start this application at another computer in the same network, it fails.
It
> returns me the following error message:
> The application attempted to perform an operation not allowed by the
> security policy. The operation required the SecurityException. To grant th
is
> application the required permission please contact your system administrat
or,
> or use the Microsoft .NET security policy administration tool.
> If you click Continue, the application will ignore this error and attempt
to
> continue. If you click Quit, the application will be shut down immediately
.
> Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data,
> Version=1.0.5000.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089 failed
> How do I configure my computer, the SQL server or the application so that
I
> can connect from another computer in the same network? By the way, I tried
to
> ping the IP address of my computer from the other computer on the same
> network, but it fails too. What should I do?
> Thank you.