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 |
|
mimmo
Starting Member
3 Posts |
 Posted - 2009-02-02 : 08:28:12
|
| I'm doing the first lesson of SQL Server Integration Services Tutorial using a local Database.During the OLE DB Connection Manager configuration (after I specified for Server Name localhost and for the Database name the right one) when I click to the test button this message appears:"An error has occured while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under the dafault settings SQL Server does not allow remote connections.Named Pipes Provider: could not open a connection to SQL Server[2]."What can I Do to find a solution? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-02 : 09:01:34
|
| have you enabled remote connections from surface configuration manager of SQL Server[2]? |
 |
|
|
mimmo
Starting Member
3 Posts |
Posted - 2009-02-02 : 09:09:00
|
quote:
Originally posted by visakh16
have you enabled remote connections from surface configuration manager of SQL Server[2]?
I how can I do this? |
|
|
|
mimmo
Starting Member
3 Posts |
Posted - 2009-02-02 : 09:30:27
|
[quote]Originally posted by visakh16
have you enabled remote connections from surface configuration manager of SQL Server[2]?I done what you said (I configured "Local and remote connection: using both TCP/IP and named pipes", but the same message appears!!Help me, please! |
|
|
|
|
|
|
Tutorial SQL Server 2005 Integration Services