Connect to REMOTE SQL server

Hello!
I have a SQL server standard Edition installed in a Server, and the other
( Standard Edition - but only client tool) installed in a Client (using
Windows XP). Please tell me how to connect from Client computer to Server(
in local network) , When I was trying to connect, it could not connect and
return a message:" Can not found server. ConnectionOpen(Connect())"
Pls help me!
Thanks in advance!
Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
SQL Server MVP
"Chi Pheo" <chipheo2k@.mail.ru> wrote in message
news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hello!
> I have a SQL server standard Edition installed in a Server, and the other
> ( Standard Edition - but only client tool) installed in a Client (using
> Windows XP). Please tell me how to connect from Client computer to Server(
> in local network) , When I was trying to connect, it could not connect and
> return a message:" Can not found server. ConnectionOpen(Connect())"
> Pls help me!
> Thanks in advance!
>
|||Hi, Thanks so much!
But nothing better.
My SQL Server is installed in a Computer with Win 2000 server , to access to
this Computer (in local network) I must log in as Administrator (means that,
when i use Windows Explorer, and type the IP address as 172.16.18.6, it
requires to enter user name, and i type Administrator). So I don't know if
it prevents us to connect to SQL server or not?
I tried to test by Ping 172.16.18.6, it's OK. I openned CLient Network
utility and in TCP/IP, I type Alias MyServer, IP: 172.16.18.6 and port 1433.
But when I connect as "sa", it shows: login failed for 'sa'. Not associated
with a trusted SQL server connection.
Thanks for all your helps!
"Hari Prasad" <hari_prasad_k@.hotmail.com> /
: news:uCmhJq6vEHA.4028@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Hi,
> This error can come in below situations:-
> 1. SQL Server is down
> 2. Your client network issues. Try a ping to server and check the network
> connection
> 3. Providing wrong SQL server name.
> If all the above is OK, then create a ALIAS server name using the CLient
> network utility specifying protocol as TCIP , IP address , port number.
> After that try to connect using that ALIAS name.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Chi Pheo" <chipheo2k@.mail.ru> wrote in message
> news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
other[vbcol=seagreen]
Server([vbcol=seagreen]
and
>

Connect to REMOTE SQL server

Hello!
I have a SQL server standard Edition installed in a Server, and the other
( Standard Edition - but only client tool) installed in a Client (using
Windows XP). Please tell me how to connect from Client computer to Server(
in local network) , When I was trying to connect, it could not connect and
return a message:" Can not found server. ConnectionOpen(Connect())"
Pls help me!
Thanks in advance!Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
SQL Server MVP
"Chi Pheo" <chipheo2k@.mail.ru> wrote in message
news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hello!
> I have a SQL server standard Edition installed in a Server, and the other
> ( Standard Edition - but only client tool) installed in a Client (using
> Windows XP). Please tell me how to connect from Client computer to Server(
> in local network) , When I was trying to connect, it could not connect and
> return a message:" Can not found server. ConnectionOpen(Connect())"
> Pls help me!
> Thanks in advance!
>|||Hi, Thanks so much!
But nothing better.
My SQL Server is installed in a Computer with Win 2000 server , to access to
this Computer (in local network) I must log in as Administrator (means that,
when i use Windows Explorer, and type the IP address as 172.16.18.6, it
requires to enter user name, and i type Administrator). So I don't know if
it prevents us to connect to SQL server or not'
I tried to test by Ping 172.16.18.6, it's OK. I openned CLient Network
utility and in TCP/IP, I type Alias MyServer, IP: 172.16.18.6 and port 1433.
But when I connect as "sa", it shows: login failed for 'sa'. Not associated
with a trusted SQL server connection.
Thanks for all your helps!
"Hari Prasad" <hari_prasad_k@.hotmail.com> /
: news:uCmhJq6vEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> This error can come in below situations:-
> 1. SQL Server is down
> 2. Your client network issues. Try a ping to server and check the network
> connection
> 3. Providing wrong SQL server name.
> If all the above is OK, then create a ALIAS server name using the CLient
> network utility specifying protocol as TCIP , IP address , port number.
> After that try to connect using that ALIAS name.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Chi Pheo" <chipheo2k@.mail.ru> wrote in message
> news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
other[vbcol=seagreen]
Server([vbcol=seagreen]
and[vbcol=seagreen]
>

Connect to REMOTE SQL server

Hello!
I have a SQL server standard Edition installed in a Server, and the other
( Standard Edition - but only client tool) installed in a Client (using
Windows XP). Please tell me how to connect from Client computer to Server(
in local network) , When I was trying to connect, it could not connect and
return a message:" Can not found server. ConnectionOpen(Connect())"
Pls help me!
Thanks in advance!Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
SQL Server MVP
"Chi Pheo" <chipheo2k@.mail.ru> wrote in message
news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hello!
> I have a SQL server standard Edition installed in a Server, and the other
> ( Standard Edition - but only client tool) installed in a Client (using
> Windows XP). Please tell me how to connect from Client computer to Server(
> in local network) , When I was trying to connect, it could not connect and
> return a message:" Can not found server. ConnectionOpen(Connect())"
> Pls help me!
> Thanks in advance!
>|||Hi, Thanks so much!
But nothing better.
My SQL Server is installed in a Computer with Win 2000 server , to access to
this Computer (in local network) I must log in as Administrator (means that,
when i use Windows Explorer, and type the IP address as 172.16.18.6, it
requires to enter user name, and i type Administrator). So I don't know if
it prevents us to connect to SQL server or not'
I tried to test by Ping 172.16.18.6, it's OK. I openned CLient Network
utility and in TCP/IP, I type Alias MyServer, IP: 172.16.18.6 and port 1433.
But when I connect as "sa", it shows: login failed for 'sa'. Not associated
with a trusted SQL server connection.
Thanks for all your helps!
"Hari Prasad" <hari_prasad_k@.hotmail.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:uCmhJq6vEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> This error can come in below situations:-
> 1. SQL Server is down
> 2. Your client network issues. Try a ping to server and check the network
> connection
> 3. Providing wrong SQL server name.
> If all the above is OK, then create a ALIAS server name using the CLient
> network utility specifying protocol as TCIP , IP address , port number.
> After that try to connect using that ALIAS name.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Chi Pheo" <chipheo2k@.mail.ru> wrote in message
> news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> > Hello!
> > I have a SQL server standard Edition installed in a Server, and the
other
> > ( Standard Edition - but only client tool) installed in a Client (using
> > Windows XP). Please tell me how to connect from Client computer to
Server(
> > in local network) , When I was trying to connect, it could not connect
and
> > return a message:" Can not found server. ConnectionOpen(Connect())"
> > Pls help me!
> > Thanks in advance!
> >
> >
>sqlsql

ConfigureUnDouble installation help

I am having trouble installing the ConfigureUnDouble tool. I followed all the directions, at least I though i did, and it keeps giving me this error message: "Falure initializing gacutil". I'm not sure if the gacutil.exe is failing or if the dll is not getting created properly. Can anyone help with this?

GACUTIL is a utility that comes as part of the .NET framework. If you open the Visual Studio 2005 Command Prompt and type GACUTIL /?, you should see a list of command line switches. If you don't, something is wrong with your .NET / Visual Studio install.

configure sql server details

Hi everybody,

I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL Server
details.

Host Name: ?
Port: 1433
Database Name: xxx
User Name: ?
Password: ?

I don't know which host name I need to put in and also I don't know
which user name and password is required.

Please can anyone help me with this.

Thank you!(pearl146@.hotmail.com) writes:

Quote:

Originally Posted by

I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL Server
details.
>
Host Name: ?
Port: 1433
Database Name: xxx
User Name: ?
Password: ?
>
I don't know which host name I need to put in and also I don't know
which user name and password is required.
>
Please can anyone help me with this.

Since all this is information that is local to your site we cannot really
help you. But we can give some hints:

The host name is usually the machine which SQL Server is running on. If
you have SQL Server on a cluster, it's likely to be the virtual cluster
name. SQL Server can be installed with named instances, in case which
the server is accessed on the form "MACHINE\INSTANCE". I have no idea
what OpManager wants in this case, but since they ask for port number,
I would guess that they stll only want the machine name, and you would
have to use a different port number.

Username and password. By default, SQL Server is installed with
Windows Authentication. This means that when you log into SQL Server,
SQL Server gets your authentication information from Windows, and you
don't supply any user name or password at all. SQL Server can also be
configured for mixed authentication, so that SQL logins are accepted
as well. SQL Logins are username/password pairs.

What username you should specify in this case, I don't know. Probably
you need to create a login and give that the permissions needed by
OpManager. But if your server is not configured for mixed authentication,
there is all reason if you want to activate to run a certain application.
I would expect the app to work with Windows Authentication as well.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

CONFIGURE REPORT SERVER - Initialization button disabled / Key not valid for use in specified st

Hi There,

I am trying to setup a RS with Configure Report Server tool. (Windows 2003 Server / SQL 2005)

* All the items are with green check points except Encryption Keys (Blue exclamation point) and initialization wich is disabled. * Event log shows a lots of errors: Report Server Windows Service (SQL2K5) cannot connect to the report server database. * Browsing the Web Reports Server is returning the errror: Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

Can someone give me a ideea where to dig next?

Regards,

Toronto,

Canada

Which edition of RS are you using? The initialization button could be disabled because your edition doesn't support scale-out deployment. Does the disabled button show a check mark or a cross?

When you browse http://<server>/reportserver, are there any errors in the log file? Also review what's on the database setup panel. Perhaps try to reapply the settings on the panel. (The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.)

|||

EDITION:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Initialization button show a cross.

(The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.) - I totaly agree with you here - this is a paradox.

The database button is green with the check sign and the log is full of:

Report Server Windows Service (SQL2K5) cannot connect to the report server database.

Encryption Keys is blue with exclamation sign. Buttons backup and change disabled, delete and restore available.

Is there any way to post some screenshots of these?

Regards,

Toronto

|||

Scale-out is only supported for Developer, Enterprise and Evaluation edition, so you'd expect the Initialization to be disabled. (However, it should not be a cross.)

The database button is green means that the connection information is set in rsreportserver.config file. It is possible that the connection information is incorrect. Although, if you used the config tool to configure this panel, you should end up with a good connection information. Perhaps you can review http://msdn2.microsoft.com/en-us/ms159133.aspx. After reapplying the settings, check if your RS catalog databases is granted the correct permissions. Perhaps you can also check from the SQL profiler if your database is getting hit, and if the logons are denied.

|||

RS service is running under the same Windows account wich is designated for SQL server service. This account is part of Administrators group on OS and on SQL instance.

Does RS service require a distinct account?

I have loged in the server with the Windows account above mentioned.

I have accesse the RS database and the RSTemp database with no problem.

What else is missing?