Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Connect to SQL server on remote machine

Author  Topic 

sunil_sgt
Starting Member

3 Posts

Posted - 2010-03-08 : 05:49:36
Hello,

Please help me.
I have my application installed on my local machine and my db on remote machine. I want to access db.

So can anyone help me out of "how could I connect to db on remote machine from my local machine using 'Windows Authentication' mode there"?????

Please help me ASAP.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-09 : 01:33:57
Do you mean from an application that you are writing, a SQL client tool such as Management Studio, or something else?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

sunil_sgt
Starting Member

3 Posts

Posted - 2010-03-09 : 01:54:16
Say I have a network of machine A & B. My application is on machine A. Now I want to connect to db on machine B using machine B's windows authentication for sql.

So what should I do in my application or wat connection string I should provide??
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-09 : 19:53:27
See this: http://www.connectionstrings.com/sql-server-2008

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

sunil_sgt
Starting Member

3 Posts

Posted - 2010-03-10 : 00:08:17
I ahve already gone through that site earlier.

It provides connection string for Windows Authentication for own machine. But in my case I wanna connect to remote db with windows authentication of same remote machine.

Now can u help me?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-10 : 14:40:11
You are incorrect about the link. It does show you how to connect remotely.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -