I have recently installed MS Office 2003 on a new machine running as a
storage machine on a peer to peer XP Professional network. I followed all
the instructioons and allowed only the login password to be changed.
I am now hoping to connect to the SQL Server instance from a desktop PC
(i.e. remotely). I have installed SQL Server2000 developer edition on my
local machine and have tried to conncet through the login presented as part
of the query analyser.
I can see the remote SQL Server instance in the drop down box and am
entering my loginID and password. I am assuming that my login ID should be
"sa" (default) and my password should match that which I set when I installed
the MSDE SQL Server on the remote machine.
When I go to connect a dialogue box pops up for about 30 secs informing that
the computer is attenmpting connection before I get an error message (Msg No.
17, Level 16, State 1: SQL Server does not exist or access denied).
I am logged on as adminsiatrator on both machines, and as far as I can tell
I should be able to connect. Is there anything I am missing?
hi Andrew,
andrew wrote:
> I have recently installed MS Office 2003 on a new machine running as a
> storage machine on a peer to peer XP Professional network. I
> followed all the instructioons and allowed only the login password to
> be changed.
> I am now hoping to connect to the SQL Server instance from a desktop
> PC (i.e. remotely). I have installed SQL Server2000 developer
> edition on my local machine and have tried to conncet through the
> login presented as part of the query analyser.
> I can see the remote SQL Server instance in the drop down box and am
> entering my loginID and password. I am assuming that my login ID
> should be "sa" (default) and my password should match that which I
> set when I installed the MSDE SQL Server on the remote machine.
> When I go to connect a dialogue box pops up for about 30 secs
> informing that the computer is attenmpting connection before I get an
> error message (Msg No. 17, Level 16, State 1: SQL Server does not
> exist or access denied).
> I am logged on as adminsiatrator on both machines, and as far as I
> can tell I should be able to connect. Is there anything I am missing?
this kind of excpetion is a generic MDAC exception, as reported in
http://support.microsoft.com/default...06&Product=sql
chances are you installed MSDE on the remote pc without enabling it's
network protocols (default behavior for MSDE installations) or the remote
WinXP is protected by WinXP sp2 Windows Firewall...
for the protoccols case, please verify via the Server Network Utility
(svrnetcn.exe) the desired protocol is enable...
for Windows Firewall,
http://support.microsoft.com/default.aspx?kbid=841249
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label professional. Show all posts
Showing posts with label professional. Show all posts
Thursday, March 8, 2012
Friday, February 24, 2012
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.
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.
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 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.
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 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 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.
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 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.
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 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 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.
Connecting MSDE using ADO over TCPIP, XP
Gurus,
I've installed MSDE on an XP Professional server - to be used by the public
as part of a forum I'm building.
I can connect locally but fails when I connect locally using the option:
Network Library=dbmssocn
Please help me out here, I'm not a network/XP person and I'd like to get it
so that anyone can connect for testing and discussion purposes.
(I did manage to at least figure out how to enable connections to the web
server on the same machine where the forum is hosted but can't find any
switches for SQLServer..')
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
http://www.adoanywhere.com/forumCheck your NT Application Event log and verify that SQL Server is listening
on TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Micke
1. Open up the Client Network Utility, located at:
c:\Windows\system32\cliconfg.exe
2. Click n the Alias Tab, make sure you add an Alias to access your MSDE
from either TCP/IP or Named Pipes.
We also use the same network library, and we have had to add the Name Pipes
Alias. This name can be any name you choose.
Peace in Christ
Marco Napoli
http://www.ourlovingmother.org
"Mike Collier" <mike@.adoanywhere.com> wrote in message
news:unqOqW52DHA.3224@.tk2msftngp13.phx.gbl...
I've installed MSDE on an XP Professional server - to be used by the public
as part of a forum I'm building.
I can connect locally but fails when I connect locally using the option:
Network Library=dbmssocn
Please help me out here, I'm not a network/XP person and I'd like to get it
so that anyone can connect for testing and discussion purposes.
(I did manage to at least figure out how to enable connections to the web
server on the same machine where the forum is hosted but can't find any
switches for SQLServer..')
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
http://www.adoanywhere.com/forumCheck your NT Application Event log and verify that SQL Server is listening
on TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Micke
1. Open up the Client Network Utility, located at:
c:\Windows\system32\cliconfg.exe
2. Click n the Alias Tab, make sure you add an Alias to access your MSDE
from either TCP/IP or Named Pipes.
We also use the same network library, and we have had to add the Name Pipes
Alias. This name can be any name you choose.
Peace in Christ
Marco Napoli
http://www.ourlovingmother.org
"Mike Collier" <mike@.adoanywhere.com> wrote in message
news:unqOqW52DHA.3224@.tk2msftngp13.phx.gbl...
quote:
> Gurus,
> I've installed MSDE on an XP Professional server - to be used by the
> public
> as part of a forum I'm building.
> I can connect locally but fails when I connect locally using the option:
> Network Library=dbmssocn
> Please help me out here, I'm not a network/XP person and I'd like to get
> it
> so that anyone can connect for testing and discussion purposes.
> (I did manage to at least figure out how to enable connections to the web
> server on the same machine where the forum is hosted but can't find any
> switches for SQLServer..')
> --
> Mike Collier BSc( Hons) Comp Sci
> Get a copy of AdoAnywhere Browser FREE if you register for the forum
> quickly...
> http://www.adoanywhere.com/forum
>
>
Subscribe to:
Posts (Atom)