Re: Please advice

Hi Ekrem,

In the webserver (connection string) I am using IPAddress\Instance and in
that box I don't have SQL Server 2005 "SQL Native Client Configuration"
installed, any idea how I can resolve this IpAddress\Instance name?

Thanks

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:2CEF3095-6465-4F8E-ABFB-A9CBAB6A1FEF@xxxxxxxxxxxxxxxx
First of all, be sure that you and ping that machine and then be sure that
it can ping yours. Then:

You should use Aliases instead of using IP addresses. You can create an
alias for a server from SQL Server Configuration Manager. Go to "SQL
Native Client Configuration" node and expand it. On the "Aliases" right
click and "New Alias...". Give it a new, a port number, select TCP\IP as
protocol and type remote server's IP address into the Address editbox.

And then go to your SSMS and type "<alias_name>\instance_name" and
connect.

--
Ekrem Önsoy



"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:u9ZnlOA8HHA.5752@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for your reply but quick question again for u

When I try to connect from Microsoft SQL Server Management Studio
remotely through ServerName\InstanceName it works perfacly fine but when
I try to connect through IPAddress\InstanceName didn't work and if I try
to connect locally through IPAddress\InstanceName it works so remote
connectevety issue... any idea?

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:CD7E1583-74AA-4B14-9A8B-7169D13DD597@xxxxxxxxxxxxxxxx
Hello Rogers,


Go to Start\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL
Server Surface Area Configuration. Select your instance and expand it.
Go to Remote Connections and check it out if TCP\IP is selected.

After that, Go to Start\Programs\Microsoft SQL Server 2005\Configuration
Tools\SQL Server Configuration Manager. Expand SQL Server 2005 Network
Configuration. Select your instance and from the right pane, make sure
TCP\IP is enabled and configure it from its properties to make your SQL
Server to be connectable by your client application or whatever.


--
Ekrem Önsoy



"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:envxKN%237HHA.5404@xxxxxxxxxxxxxxxxxxxxxxx
I can't connect from client to Server.

Here is the Server configuration Settings:-

sp_configure

Min Max Config Run

allow updates 0 1 0 0

clr enabled 0 1 0 0

cross db ownership chaining 0 1 0 0

default language 0 9999 0 0

max text repl size (B) 0 2147483647 65536 65536

nested triggers 0 1 1 1

remote access 0 1 1 1

remote admin connections 0 1 1 1

remote login timeout (s) 0 2147483647 20 20

remote proc trans 0 1 0 0

remote query timeout (s) 0 2147483647 600 600

server trigger recursion 0 1 1 1

show advanced options 0 1 0 0

user options 0 32767 0 0

select @@version

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007
22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition
on Windows NT 5.2 (Build 3790: Service Pack 2)



Please advice








.

Relevant Pages

  • Re: Failed to register SharePoint Services 2007
    ... with SQL Server 2K and use that instead of SQL Server 2005. ... When I ran the configuration databse for the first time I had a failure ... System.ArgumentException: Exception of type ... So I used the ntrights to get that privilege on my sharepoint user. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Failed to register SharePoint Services 2007
    ... with SQL Server 2K and use that instead of SQL Server 2005. ... When I ran the configuration databse for the first time I had a failure ... System.ArgumentException: Exception of type ... So I used the ntrights to get that privilege on my sharepoint user. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: MS SQL 2005 Configuration ???
    ... I have a command under my SQL Server 2005 menu called "SQL Surface Area ... Connections" was "Surface Area Configuration for Services and Connections". ... Remote connection does not mean a connection from another ... localhost does not indicate a remote connection. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Server Configuration
    ... Determining the best configuration for your SQL Server has a few ground ... as the backplane is configured as RAID1 you'll have great redundancy ... Monitoring CPU Usage ... For more information about performance tuning and configuration, ...
    (microsoft.public.sqlserver.setup)
  • Database Connection Problems
    ... I'm new to SQL Server and seem to have a lot of problems with my connection string not working. ... I have SQL Server Express installed and SQL Server Configuration Manager is setup as follows: ...
    (microsoft.public.dotnet.framework.adonet)
Loading