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 |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2010-05-11 : 08:27:38
|
| I am connecting my report to Sql Server 2008 database through OLE DB connection. And providing TCP IP as "Server" but unfortunately its not working BUT when i provide server name instead of IP address no such problem occur and it works fine.With Sql Server 2005 , no such problem exists.Whats missing (Sql Server 2008) DB server side ? Any configuration required ? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2010-05-12 : 06:20:08
|
| ??? |
 |
|
|
vmenon
Starting Member
17 Posts |
Posted - 2010-05-16 : 23:34:29
|
| Using "SQL Server Configuration manager" on the SQL Server Box, please can you check the protocols for your instance, under the header "SQL Server Network Configuration". Specially check whether TCP/IP is enabled.Other things which you might need to check is whether the SQL instance is running on a static port other than the default port, if yes, you will need to provide the port number along with the TCP/IP address. |
|
|
|
|
|
|
Crystal Report Connection Through TCP IP