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 |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2008-01-02 : 20:52:23
|
| All,I have sql server 2005 standard edition on a xp pro machine. I want to be able to connect my laptop; running xp home to the sql server. Can I do this. I have file and print sharing lan enabled on both computers. I can put sql developer on the laptop if that will work. Please help me.Thanks |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-02 : 21:42:41
|
| >>I have sql server 2005 standard edition on a xp pro machineTo do so u have to install express edition(client tools) on your laptop (because on XP u can't install any other edition) but limited features are availble with express edition.Then u an register instance u want to connect to.This is what my understanding i am new as well. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-02 : 22:59:33
|
| Yes, you can install sql2k5 standard edition on win xp pro machine. If you have direct network connection between that machine and laptop, then you can access sql server from laptop. |
|
|
|
slimjen
Yak Posting Veteran
61 Posts |
Posted - 2008-01-03 : 18:43:03
|
| I setup the network between my computers. It's working. I can see both in my network connections. But when I try to setup a login in Sql Server Management Studio, I don't see my laptop in "locations" to add a user for my laptop. What am I doing wrong? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-03 : 22:02:15
|
| Did you register sql server in ssms yet? |
|
|
|
slimjen
Yak Posting Veteran
61 Posts |
Posted - 2008-01-04 : 08:21:18
|
| No. Is this the problem? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-05 : 00:05:49
|
| Then how do you connect to sql in ssms? |
|
|
|
|
|
|
connect to sql server