RE: sql server on another computer

Hi,
My understanding of your issue is that:
Your .NET 2.0 application failed to connect to your remote SQL Server
within the same workgroup.
Your SQL Server has been configured to allow remote connections.
If I have misunderstood, please let me know.

From your description, I think that your SQL Server is 2005.
For one thing, I would like your checking what the protocols are enabled on
your SQL Server. You can check that by using SQL Server Configuration
Manager.
For TCP/IP protocol, please check the current using TCP port and see if you
can use telnet command to connect to the server on the port.
If you could not telnet the computer at the client side, please check if
the Windows firewall was enabled on your server by clicking Start->
Run->firewall.cpl.

For another thing, please add an alias by using cliconfg on your client
computer. If you decide to use Named Pipes protocol, add a server alias
with Named Pipes protocol; if you decide to use TCP/IP protocol, add a
server alias with TCP/IP protocol.
I would like to attach the following links for your reference:
How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by
using the client tools in the earlier version of SQL Server
http://support.microsoft.com/kb/265808/en-us

When you connect to the SQL Server 2005 database engine, you may experience
longer connection times
http://support.microsoft.com/kb/918478/en-us

Hope this helps.
If you have any other questions or concerns, please feel free to contact us.

Sincerely yours,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.

Relevant Pages

  • Re: Need helps with SQL Server Express
    ... In this case, you will have to make sure that TCP/IP is enabled (SQL Server Configuration Manager, SQL Server Network Configuration, Protocols --> TCP/IP). ... When SQL Server is installed and the TCP/IP protocol is enabled, the specific SQL Server instance will be visible on the network. ... I would recommend having different Windows Groups and assign specific access rights (i.e. server roles, database roles, etc) on these groups. ... I strongly disagree that whoever has Microsoft SQL Server Management Studio Express can go into the database and make changes to everything:) ...
    (microsoft.public.sqlserver.setup)
  • Re: An error about "[dbnmpntw]ConnectionOpen(CreateFile())".
    ... to create alias server name for the sql server using the TCP/IP protocol ... And use this Alias name to connect to SQL server using TCP/IP ... and the error message was ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server does not exist or access denied
    ... User SQL Server ... Configuration Manager to ensure that the TCP/IP protocol is enabled. ... can also verify the port setting while you are there. ...
    (microsoft.public.sqlserver.odbc)
  • Re: ADP (Write to local if loses connection to remote SQL Server?)
    ... Unlike MDB databases, there are no local table with ADP. ... are set to insert data from the form to a remote SQL Server by ...
    (microsoft.public.access.adp.sqlserver)
  • RE: connect to remote sql server in business Intelligence Developm
    ... You can send feedback directly to my manager at: ... connect to remote sql server in business Intelligence Developm ... I installed visual studio 2005 and sql ...
    (microsoft.public.vsnet.general)
Loading