Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Programming / Connectivity / July 2008

Tip: Looking for answers? Try searching our database.

SSMSE and Remote Database via TCP/IP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MF - 14 Jul 2008 20:16 GMT
Is it possible to connect to and manage a remote database on the Internet
using SQL Server Management Studio for Express? If it is, does anyone know
where I can find step-by-step instructions on how to establish the connection?

I currently have SSMSE sp2 and I cannot get it to connect to a remote SQL
2005 database with Windows Authentication. Some fields such as Username and
Password are greyed out under the Windows Authentication option which is what
I also need. Simply put, the database is in DC and I am in VA.

Any ideas?
Rick Byham, (MSFT) - 17 Jul 2008 16:55 GMT
The Username and Password fields are always grayed out when connecting with
Windows Authentication. After all, Windows knows who you are and has already
authenticated you. And no, you can't change your Windows credentials at this
point.
If the DC computer and your VA computer are in the same domain or in trusted
domains, then your VA computer has already authenticated you and you should
be able to connect.
If you need to connect using a different set of domain credentials, then log
off (in VA), and log back into Windows with those credentials. Or, use the
Run as option in Windows, to start SSMSE with the desired domain
credentials. If you can't do one of these two things, (probably because the
VA computer isn't trusted in the DC computer domain), then you will not be
able to use Windows Authentication.
So then you need to set up SQL Server Authentication on the DC computer.
This may or may not be allowed depending on their policy. Then, in VA, you
can start SSMSE, select SQL Server Authentication, and then provide a user
and password.
All this assumes that the computer DC computer is listening on the internet
is some way. In other words, can you ping the IP address of the DC computer
from VA?
I hope this helps.
Signature

Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

> Is it possible to connect to and manage a remote database on the Internet
> using SQL Server Management Studio for Express? If it is, does anyone know
[quoted text clipped - 9 lines]
>
> Any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.