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 |
|
boblaraie
Starting Member
1 Post |
 Posted - 2012-03-10 : 20:51:51
|
| Hi, i am kind of new to sql server. We got a windows server 2003 and there is sql server 2005 installed.. I can access it via windows authentication inside the remote desktop connection. How can i access it from my own sql server 2005? in remote connection? Everything is set on the sql server 2005 to be able to remote connection but what is the servername to use? and the login and password? Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-10 : 23:07:18
|
| are the server and your machine in same domain? Is your domain login added inside the sql server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-12 : 01:43:57
|
| The server name to use is name that you can ping to. If the remote server is referenced as SERVR1.mydomain.net , then the SQL Server will be accessed as SERVR1.mdomain.net\MYINSTANCEWindows Authentication will depend on whether you logged on as BUILTIN\Administrator or as an AD based logon. On your SQL Server , what logon details have you added?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
sql server 2005 from remote