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 |
|
Robban
Starting Member
3 Posts |
 Posted - 2008-10-09 : 08:47:48
|
| I am trying to connect to a SQL Server 6.5 database via the Microsoft Ole DB Source and Ole DB Provider for SQL Server. The server is located in an nt domain separate from the server I am using.I changed the network library property to tcp without any success.The error message I get is something like "The SQL Server does not exist or access is denied".What can I try?Regards Robert |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-09 : 08:58:08
|
| Are you able to ping each other? Are you trying to migrate from SQL 6.5 to SQL 2005? |
 |
|
|
Robban
Starting Member
3 Posts |
Posted - 2008-10-09 : 09:03:03
|
| Thank you for your reply!I am able to ping the NT server from the Windows 2003 server where SQL Server 2005 is running.No I am not migrating. I am trying to read from a table do some operations and then insert them in my SQL Server 2005. |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
|
Robban
Starting Member
3 Posts |
Posted - 2008-10-09 : 09:32:21
|
| Hmm I dont know, I was kind of hoping that I would not have to mess with the SQL Server 6.5.I dont have any user account for that domain but apperantly it should work if I map a drive on the server and then use named pipes.Like this:http://windowsitpro.com/article/articleid/493/questions-answers-and-tips-about-sql-server.htmlIs there a way to do this whithout having to map a drive? Sending credentials for that domain from my SQL Server or something? |
|
|
|
|
|
|
Connect to SQL Server 6.5