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.
| Author |
Topic |
|
amitbadgi
Starting Member
29 Posts |
 Posted - 2005-07-12 : 15:54:07
|
| Hi gys, I am new to sql server, i want to know how i could get connected to a sql server located elsewhere from my laptop, do i need to install sql server on my laptop to gain access to the main sql server or do i need something else. thanks in advance. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-12 : 16:16:48
|
| depends on what you want to do. will you being using the query analyzer to write queries or will you being admining or will you be accessing it though an application.Is there a database or system administrator at your company who needs to set you up with software and passwords. Go to talk yo him or her first.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-07-12 : 16:21:54
|
You will probably just need client and tools on your laptop. In the installation it will ask you which remote machine or which sql server you will be connecting to. You can add other "Registration" entries at a later date.Good luckJon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
amitbadgi
Starting Member
29 Posts |
Posted - 2005-07-12 : 17:20:48
|
| thanx for teh reply guys, actually i am working on a .net web application and there are connection files to teh database in teh sql server, so i need to get connected to access the database and work on the application. Hence if u could guide me on what exactly I need to get the access to teh server it would be great. He would give me the ip, username, password. Thanks. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-07-12 : 18:31:16
|
| You can get all the valid connection string formats at http://www.connectionstrings.com. If you need a sample application, you can get one from http://www.asp.net.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
connection to sql server