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 |
|
mojpro
Starting Member
15 Posts |
 Posted - 2007-04-20 : 01:47:20
|
| Hi,Does anyone know why I can not create data connection? It says that SQL server does allow remote connection, everything was looking ok when I was installing it..Thank you,Mojpro |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-04-20 : 07:46:56
|
| what is the "exact" error message being seen?it might indicate a "permissions" issue.can both servers "ping" each other? |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-04-20 : 08:48:05
|
| Assuming that your server "allows remote connections", you may want to try creating and alias for that server using the SQL Configuration tool. It has never failed me.If you are unclear, what this means, write back asap.RegardsParesh MotiwalaBoston, USA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-20 : 09:44:20
|
| Is sql browser service running on sql server? Did you enable remote access in SAC. |
|
|
|
|
|
|
My SQL Server does not allow ODBC ??