I am trying to connect to SQL Server 2005 from my computer using Remote
Desktop but keep getting this error:
"An error has occurred while establishing a connection to the server.
When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 28 - Server doesn't support
requested protocol) (Microsoft SQL Server, Error: -1)"
I checked the server settings, and it is allow remote connections.
Anything
that I missed here?
Re: TS vs VPN ... Using TS, w/o VPN... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ... (microsoft.public.windows.terminal_services)
Re: Remote Database Connection with PocketPC/MSAccess Front End ... If you want to allow direct remote access for your Access data, I'd suggest writing a web service which your remote apps could use. ... The general problem with mobile access to remote data of any kind (including SQL Server which Windows Mobile devices can access directly remotely) is that sometimes the connection just isn't there. ... Generally the easiest backend data store to use for this local cache is going to be SQL Server Compact, which supports several sync strategies including the Access Sync Services that your question isn't about. ... (microsoft.public.pocketpc.developer)
RE: Login failed for user (null). ... used at signon to authenticate in SQL Server.... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ... (microsoft.public.dotnet.framework.aspnet.security)
Re: smo create database object ... create a new sql server database with sql server 2005 express? ... debugger complains that remote operations are not allowed with the ... I've tried the surface area configuration tool, but the database engine... Yes it does show a 'remote connections' line but enabling this option didn't ... (microsoft.public.dotnet.languages.csharp)
RE: CTP3 Failure - Creating a Remote Distributor (error during decrypt ... with changes in the SQL Server service account after replication has been set ... Are the remote distributor and the publisher machines in the same domain? ... Are the distributor and publisher SQL Server Service running under domain ... (microsoft.public.sqlserver.replication)
