Re: Sharepoint under full SQL - Connection via SQL Enterprise

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ken-T wrote:

Hi,

on SBS Premium have upgraded Sharepoint to full SQL and installed SQL
service pack on the Sharepoint instance.
All is working fine and in SQL Enterprise on the server itself have added
the servername\SHAREPOINT instance with no problems.

From XP Pc however, logged in as a member of Dom Admin group, and using
local installation of SQL Enterprise tools, can add the Server SQL instance
with no problem - but adding the servername\SHAREPOINT instance fails totally.

Can this be done? Where may I be going wrong?

By default, the Sharepoint instance of MSDE is configured not to listen to the network for connections. Upgrading it to SQL probably hasn't changed this.

Use the Server Network Utility on the server to reconfigure the Sharepoint instance to listen on the network. You may need to make changes in ISA to allow access from the internal network (I can't recall off the top of my head what ISA allows from internal clients).

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
.

Relevant Pages

  • Re: Very strange behavior of SQLServer with connection from CGI
    ... this is not a default SQL instance. ... SQL clients use a UDP ... connection to port 1434 to resolve port numbers for named instances. ... You can use the SQL Server Network utility to lock ...
    (microsoft.public.sqlserver.connect)
  • Re: Very strange behavior of SQLServer with connection from CGI
    ... this is not a default SQL instance. ... SQL clients use a UDP ... connection to port 1434 to resolve port numbers for named instances. ... You can use the SQL Server Network utility to lock ...
    (microsoft.public.sqlserver.clustering)
  • Re: Very strange behavior of SQLServer with connection from CGI
    ... this is not a default SQL instance. ... SQL clients use a UDP ... connection to port 1434 to resolve port numbers for named instances. ... You can use the SQL Server Network utility to lock ...
    (microsoft.public.sqlserver.security)
  • Re: Connection from remote computer to network SQL Server
    ... by default connectin to SQL Express from the network is disabled ... There is no firewall on the W2K machine acting as the SQL server. ... connection works. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: NIC settings for SQL 2005 and windows 2003?
    ... believe the Microsoft SQL MVP's who have actually done performance testing ... Although maximizing throughput for network applications ... This option may limit memory available to SQL ... It also mentions "The Maximize data throughput for ...
    (microsoft.public.sqlserver.connect)