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 |
|
hanz1331
Starting Member
1 Post |
 Posted - 2007-12-20 : 01:41:29
|
| I am having a problem connecting to an sql server i installed on my other desktop. Locally I can access my database. But whenever I use my laptop to connect to it, I fail to connect always. I have used 'odbcping' already. If I use 'odbcping -s ip address', there is no problem. But if I use the server name 'odbcping -s jmjsql', that's where my problem begins. Also, when I use my query tool, the server could be seen but the database returns an error like it doesn't exist or I have no permission. Please enlighten me. =) |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-20 : 07:41:20
|
Are you connecting to it via SMS or Enterprise manager? Is it a linked server to your local machines server?Are remote connections enabled on the other desktop?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 15:24:56
|
| And check if sql server browser service is running on that machine. |
|
|
|
|
|
|
no connection