How to connect....HELP

How can I connect to database from a remote computer in the same domain?
I developed many database applications using Access, but now I need a code
snippet to make some of my existing application to run in a remote Sql server
with the same structure (databases, views)...and I can't figure how...
Anybody can help me?
http://www.able-consulting.com/ADO_Conn.htm
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:8E8F6961-D166-45D4-8C8E-3E3CD032B768@.microsoft.com...
> How can I connect to database from a remote computer in the same domain?
> I developed many database applications using Access, but now I need a code
> snippet to make some of my existing application to run in a remote Sql
server
> with the same structure (databases, views)...and I can't figure how...
> Anybody can help me?
sql

How to connect....HELP

How can I connect to database from a remote computer in the same domain?
I developed many database applications using Access, but now I need a code
snippet to make some of my existing application to run in a remote Sql serve
r
with the same structure (databases, views)...and I can't figure how...
Anybody can help me?http://www.able-consulting.com/ADO_Conn.htm
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:8E8F6961-D166-45D4-8C8E-3E3CD032B768@.microsoft.com...
> How can I connect to database from a remote computer in the same domain?
> I developed many database applications using Access, but now I need a code
> snippet to make some of my existing application to run in a remote Sql
server
> with the same structure (databases, views)...and I can't figure how...
> Anybody can help me?

how to connect to ssis service - The RPC server is unavailable err

Hi
I am trying to connect to ssis service on remote machine using the sql 2005
management studio
I get the following error :
TITLE: Connect to Server
Cannot connect to <servername>.
Connect to SSIS Service on machine "<servername>" failed:
The RPC server is unavailable.
What do I miss please help
Best regards
Meron FridmanDid you figure out a solution ' I have the same problem
--
homebre
----
homebrew's Profile: http://www.dbtalk.net/m5
View this thread: http://www.dbtalk.net/t29008|||I've got the same problem in a two-node active/active environment.
Anyone got any further info?
"homebrew" wrote:
> Did you figure out a solution ' I have the same problem.
>
> --
> homebrew
> ---
> homebrew's Profile: http://www.dbtalk.net/m55
> View this thread: http://www.dbtalk.net/t290084
> .
>|||I found out that one of our developers (developer #1) wasn't having an
problems, and that he had used a different disk to install on hi
desktop. So then developer #2 used his disk, and her problem went away
I had already put in a call to Microsoft, and we tested my RPC port
and they seemed fine. So I think I got a bad disk ... perhaps som
file is corrupted ?
Then he had another utility for me to try, but I haven't bothered yet
since I'm pretty sure it's the disk, and not something on my desktop
--
homebre
----
homebrew's Profile: http://www.dbtalk.net/m5
View this thread: http://www.dbtalk.net/t29008sql

how to connect to ssis service - The RPC server is unavailable err

Hi
I am trying to connect to ssis service on remote machine using the sql 2005
management studio
I get the following error :
TITLE: Connect to Server
Cannot connect to <servername>.
Connect to SSIS Service on machine "<servername>" failed:
The RPC server is unavailable.
What do I miss please help
Best regards
Meron Fridman
Did you figure out a solution ? I have the same problem.
homebrew
homebrew's Profile: http://www.dbtalk.net/m55
View this thread: http://www.dbtalk.net/t290084

how to connect to ssis service - The RPC server is unavailable err

Hi
I am trying to connect to ssis service on remote machine using the sql 2005
management studio
I get the following error :
TITLE: Connect to Server
Cannot connect to <servername>.
Connect to SSIS Service on machine "<servername>" failed:
The RPC server is unavailable.
What do I miss please help
Best regards
Meron FridmanDid you figure out a solution ' I have the same problem.
homebrew
---
homebrew's Profile: http://www.dbtalk.net/m55
View this thread: http://www.dbtalk.net/t290084|||I found out that one of our developers (developer #1) wasn't having any
problems, and that he had used a different disk to install on his
desktop. So then developer #2 used his disk, and her problem went away.
I had already put in a call to Microsoft, and we tested my RPC ports
and they seemed fine. So I think I got a bad disk ... perhaps some
file is corrupted ?
Then he had another utility for me to try, but I haven't bothered yet,
since I'm pretty sure it's the disk, and not something on my desktop.
homebrew
---
homebrew's Profile: http://www.dbtalk.net/m55
View this thread: http://www.dbtalk.net/t290084

How to connect to Remote SQL Server database using SQL Server 2005 Express

Hi,

I've an account with a hosting service provider online for SQL Server database. I've downloaded SQL Server 2005 Express from ASP.Net. How can I use it to connect to my SQL Server Database which is sitting on remote server? The hosting provider gave me following things to connect to the remote database.

Server Name
Database Name
User Name
Password

Regards,
A.K.R

Anyone?

|||I don't want to ask the obvious, but is there not a Read Me fileincluded with the download of SQL Express which would explain how toconnect?

Sorry I can't be more helpful, but I've only ever briefly looked at SQLExpress and decided to stick to MSDE since I could not see any benefitof using Express when MSDE is a cheap but far more powerful option thanSQL Express.

How to Connect to remote sql express from client comp/app?

Hi,

I think this is a taff problem for me when I connect to remote sql express from .net application

I use Connection String:

Data Source=MYREMOTESVR\SQLEXPRESS;Initial Catalog=microDB;Integrated Security=SSPI;Persist Security Info=True;User ID=micro;Password=micro

OR

Data Source=MYREMOTESVR\SQLEXPRESS;Initial Catalog=microdb;Integrated Security=True;Persist Security Info=True;User ID=micro;Password=micro

And found EROR message when running aplication from client comp/application

"... Login failed foruser MYCOMP\Guest... "

How to setup a user in the sql expss server to support Client/Server Application?

Anyone can help me?

regards.

md5

hi,

please have a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2177202&SiteID=1&mode=1

regards

|||

Hi Andrea,

Ow.. I understand that.. its Loud and Clear...
Evrything goes Ok now. Thanks So munch for yur help.

regards
mudiasa sanatan (md5)

How to connect to remote server

Hi All,

I have created my sql database script using SQL data publishing wizard, now i want to execute the same on my shared hosting database. But i am not getting any option to connect to remote server in SSMSE.

I have developed web based application with back hand as SQL Server 2005, so now i want to execute my script file onto the server. so how i will connect with my server using SSMSE ?

My application is located under www.briskonsales.com/sales

Any idea ?

Thanks,

Jay

You will have to work with your Hosting provider to obtain access through their firewalls to access their SQL Server instance.

|||Is the remote instance a SQL Server Express edition ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Very few hosting providers will allow you to connect to their server using SSMS; rather they provide their own set of management tools accessable through their site. If you log into your account you will likely find a set of links that take you to the management console for your hosted database. From there you should be able to load the script file that you saved from the DPW and run it to create your objects in the hosted database.

As others mention, contact your hosting provider if you have questions about managing your hosted database.

Mike

How to connect to remote MSDE database using VB.NET

Greetings
I have a VB.NET application that works great with a local MSDE database. But, when I try to revise my connection string to point to a remote MSDE server and database, it fails. The MSDE Server Manager can pick up the remote server and tell me its runni
ng, but when I try to register it using SQL Server, or use a DSN to connect to it, I get a "SQL Server does not exist or access denied. ConnectionOpen(Connect())" My connection string is:
Provider=SQLOLEDB.1;Server=DSS\VSDOTNET;Database=d atabase;User ID=sa;Password = xxxxx;Integrated Security=SSPI
Any help will be appreciated. Thanks...
- Tim B.
hi Tim
"Tim Balderramos" <pacmantab@.hotmail.com> ha scritto nel messaggio
news:28F08CF8-86CF-4C04-9E5A-900296EC78A7@.microsoft.com...
> Greetings
> I have a VB.NET application that works great with a local MSDE database.
But, when I try
>to revise my connection string to point to a remote MSDE server and
database, it fails. The
>MSDE Server Manager can pick up the remote server and tell me its running,
but when I try
>to register it using SQL Server, or use a DSN to connect to it, I get a
"SQL Server does not
>exist or access denied. ConnectionOpen(Connect())" My connection string
is:
> Provider=SQLOLEDB.1;Server=DSS\VSDOTNET;Database=d atabase;User
>ID=sa;Password = xxxxx;Integrated Security=SSPI
the most frequent causes of that kind of error are reported in
http://support.microsoft.com/default...06&Product=sql
KB article...
please verify the remote MSDE instance has enabled networkprotocols too,
using the remote Server Network Utilityes (svrnecn.exe)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I think that does it. Here is what my co-worker did:
During MSDE setup, use SECURITYMODE=SQL
Then use SVRNETCN.exe and enable TCP/IP as a network library. I did this on
both machines, but you may not need to do it for both (wasn't sure, but didn't
think it mattered).
Here's the connection string that was working -
Provider=SQLOLEDB;Data Source=wrctest;user id=sa;password=wrctest;Initial
Catalog=winthrop;Net=dbmssocn;Auto Translate=True;Persist Security
Info=False;Use Encryption for Data=False

How to connect to remote database using MS SQL Server 2005

i'm using sql server 2005 developer edition. In sql server 2000, when i connect to my remote database, i just need to provide my IP address, server name with password in Query Analyzer. However, i do not know how to connect to remote database in SQL Server 2005. I did allow local and remote connection using Surface Area Configuration. However, after setting this, i do not know where to input the IP add, server name and pwd as well...>_<.

Who can help me? Thanks for ur expertise.

So you want to connect to another sql server instance through sql server 2005 query? Are you not able to type it in on the server name on the Connect to Server dialog? Don't use the drop down... type it in.

Hope this helps.

|||

Hi, thanks for replying.

I'm sorry, this is my first time to use SQL Server 2005, so i'm quite new for those features.

What i did is in the Object Explorer, there is the only one localhost server. I right click the server name and select connect. Then there is Connect to Server dialog, for the server name, i select <Browse for more...>, (i'm doing this because my database is located at other side through Internet.) However, i cant find any field for me to input my IP address for locating my remote database, username and password as what i did in SQL Server 2000 using Query Analyser before.

Thanks.

|||When you open the "Connect to server" dialogue box, do not choose "Browse for more", instead, type the IP address into the server name dialogue box, then your authentication details below this - does this work?|||Thanks, i get it..sql

how to connect to a remote sql DB

Hi all,

myDB is located atX:\Program Files\Microsoft SQL Server\MSSQL\Data\myDB.mdf
and my code is located at : C:\Inetpub\wwwroot\applicationfolder
how do I code my server.mapPath?

Btw, can I get VS 2005 to detect the server path when using server solution.Thanks

sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("X:\Program Files\Microsoft SQL Server\MSSQL\Data\myDB.mdf"))
dbconn.Open()
sql = "SELECT * FROM myTable"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
myDB.DataSource = dbread
myDB.DataBind()
dbread.Close()
dbconn.Close()
end sub

One big problem you are pointing to Access database which lets you map the path and SQL Server which controls the path so if your database is Access you can map the path, if it is SQL Server you cannot map the path because the database is not the runtime the relational engine is the runtime. Hope this helps.

How to connect to a remote database ?

Hello,

First, sorry for my bad English.

Here is my problem:

BoxA: XPpro + Apache + php (using php_mssql.php)+ ADOdb + MS SQL Server
+ My_Prog (using local MS SQL PUBS database)

BoxB: NT4 + Apache + php (using php_mssql.php)+ ADOdb + My_Prog (using
remote BoxA PUBS database)

BoxC: W2K

My_Prog uses:
$serveur = '10.0.0.1'; BoxA's IP address
$admin_nom = 'sa';
$admin_mdp = '';
$base = 'PUBS';

$conn = &ADONewConnection($sgbd);
$conn->debug = true;
$a = $conn->Connect ($serveur,$admin_nom,$admin_mdp,$base);

From BoxC, using IE, connecting to:
- BoxA My_Prog : I access PUBS, that's OK
- BoxB My_prog : "Warning: mssql_connect(): message: Echec de la
connexion de l'utilisateur 'sa'. Raison : Non associ une connexion
scurise SQL Server. (severity 14) in ...\adodb-mssql.inc.php on line
438." (I prefer to report the "French" message)

Anyone knows about ?

Thanks in advance,
EricEricP <eric.piquot@.wanadoo.fr> wrote in message news:<bvqrdf$6ri$1@.news-reader3.wanadoo.fr>...
> Hello,
> First, sorry for my bad English.
> Here is my problem:
> BoxA: XPpro + Apache + php (using php_mssql.php)+ ADOdb + MS SQL Server
> + My_Prog (using local MS SQL PUBS database)
> BoxB: NT4 + Apache + php (using php_mssql.php)+ ADOdb + My_Prog (using
> remote BoxA PUBS database)
> BoxC: W2K
> My_Prog uses:
> $serveur = '10.0.0.1'; BoxA's IP address
> $admin_nom = 'sa';
> $admin_mdp = '';
> $base = 'PUBS';
> $conn = &ADONewConnection($sgbd);
> $conn->debug = true;
> $a = $conn->Connect ($serveur,$admin_nom,$admin_mdp,$base);
>
> From BoxC, using IE, connecting to:
> - BoxA My_Prog : I access PUBS, that's OK
> - BoxB My_prog : "Warning: mssql_connect(): message: Echec de la
> connexion de l'utilisateur 'sa'. Raison : Non associ une connexion
> scurise SQL Server. (severity 14) in ...\adodb-mssql.inc.php on line
> 438." (I prefer to report the "French" message)
> Anyone knows about ?
> Thanks in advance,
> Eric

The error message suggests that MSSQL is configured to accept only
Windows logins. I don't know anything about PHP, but is it possible
that your connection string is somehow being ignored, and PHP is
making a trusted connection instead of using the sa login and
password? If Apache on BoxA is running as a local administrator
account, for example, then by default it would be able to connect
using a trusted connection. But Apache on BoxB connecting to MSSQL on
BoxA would be running under a different account, and so could not
connect.

But that's more or less a guess - if it doesn't help, you may want to
post some extra information. MSSQL version, authentication mode
(Windows or Mixed), service accounts used by Apache etc. You might
also want to use sp_who to verify that when BoxA connects, it is
connecting as sa, and not as some other (perhaps Windows) account.

Simonsql

How to connect to a dedicated m/c

Hi,
Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can anyone help
me.But thru remote desktop, i was able to connect to the server m/c by
putting the ip address .
regards lara
First thing to do is install SP3. SQL2000 RTM isn't supported on
Windows 2003.
David Portas
SQL Server MVP
|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access denied'
regards lara
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1119436842.190857.7930@.o13g2000cwo.googlegrou ps.com...
> First thing to do is install SP3. SQL2000 RTM isn't supported on
> Windows 2003.
> --
> David Portas
> SQL Server MVP
> --
>
|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access denied'
regards lara

How to connect to a dedicated m/c

Hi,
Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can anyone help
me.But thru remote desktop, i was able to connect to the server m/c by
putting the ip address .
regards laraFirst thing to do is install SP3. SQL2000 RTM isn't supported on
Windows 2003.
David Portas
SQL Server MVP
--|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access de
nied'
regards lara
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1119436842.190857.7930@.o13g2000cwo.googlegroups.com...
> First thing to do is install SP3. SQL2000 RTM isn't supported on
> Windows 2003.
> --
> David Portas
> SQL Server MVP
> --
>|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access de
nied'
regards lara

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make the
change?
Thanks
Wendy
One thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesnt allow to make any changes, does anyone have the idea how to make the
>change?
>Thanks
>Wendy
|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:

> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
>
>
sql

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make t
he
change?
Thanks
WendyOne thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQ
L
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up th
e
>user name and password which is using for local login and gray out, it
>doesnt allow to make any changes, does anyone have the idea how to make th
e
>change?
>Thanks
>Wendy|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:

> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
>
>

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesnâ't allow to make any changes, does anyone have the idea how to make the
change?
Thanks
WendyOne thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:
>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesn?t allow to make any changes, does anyone have the idea how to make the
>change?
>Thanks
>Wendy|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:
> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >I am using the SQL 2005 management studio and trying to connect a remote SQL
> >2005 standard edition server in the mix authentication mode. I need to pick
> >up a different windows user name which existing in remote Server but is not
> >the one I am using to login my local. By default, the connection pick up the
> >user name and password which is using for local login and gray out, it
> >doesnâ't allow to make any changes, does anyone have the idea how to make the
> >change?
> >
> >Thanks
> >
> >Wendy
>

How to connect remote SQL Server?

I wnat to connect to remote sql server 2005, I do the following steps:

Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.

sp_addlogin 'Wind','ack@.123','db'

but still can't login,tips as follwing:

Login failed for user 'Wind',The user is not associated with a trusted SQL Server connection.

Error:18452

Why? Must use "SQL Server Authentication" connect?

YOu are trying to connect with SQL Server Authenitcation, but you only have Windows Authentication enabled. See the Screencast on my site for more information how to switch the Authentication mode.

Jens K. Suessmeyer

http://www.sqlserver2005.de

How To Connect Remote Server's DataBase from another's Server's QueryWindow

Please Help Me to do this...

Consider i hv already logged in

sql server 2005
ip no : 192.168.2.20
db name: framework

from this query window is it possible to access the objects(tables,stored porc's)
of another server's database

for example ,

sql server 2005
ip no : 192.168.2.21
db name: framework1

...................................................

Im able to access the same server's db objects
consider im frame work db
declare @.qry as nvarchar(max)
set @.qry= '
use [master]
select * from [Sales]
'
exec (@.qry)
... but when i use use statement like,(its not working)
use 192.168.2.21
use [master]

Please help me out .....

No it is not possible from that query window unless you use linked servers.

Take a look at: http://www.sqlservercentral.com/columnists/ksonti/anintroductiontolinkedservers.asp

Martin

|||If the servers are part of a replicated topology you will have to set the server option for data access to true,

is sp_serveroption 'ServerIWishToQuery','Data Access','True'

and then

select * from ServerIWishToQuery.Database.dbo.TableName|||Thank u Hilary...

It was really helpful...

as u said i executed

exec sys.sp_serveroption [192.168.2.20],'data access','true'

It is Giving this type of error ...

Msg 15015, Level 16, State 1, Procedure sp_serveroption, Line 101
The server '192.168.2.20' does not exist. Use sp_helpserver to show available servers.

I think we have to link the servers ..

can u please guide me how to do it.......

How to connect remote DB

If I already know that:

Domain: DM1

Server: SV1

Database: DB

user: u1

password: p1

How to connect to DB by Enterprise Manager ?

Take a look at your other post. I answered it there.

http://forums.asp.net/1153624/ShowPost.aspx

sql