| Author |
Topic |
|
getSqlMastered
Starting Member
12 Posts |
 Posted - 2009-05-19 : 11:58:48
|
| Hi dear Friends, I have an application that access a remote sql server 2000 database from a client PC. I have also a similar database on another remote sql server 2000 but im not able to access it remotely via the same application installed on the same client PC.I have made connetcion path adjustments based on server and database names with similar sql server configuration. But from one server the application runs perfectly and from the other it gives an error message " Object Reference not set for an instance of an object".I kindly request your help and experince on this regrad. Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-19 : 12:07:41
|
| Does the user you are using have the same rights on both servers? Are you connecting via IP Address or Named Pipes?Are you on the same release on both servers? |
 |
|
|
getSqlMastered
Starting Member
12 Posts |
Posted - 2009-05-19 : 12:16:35
|
| thanks dear,yes the user has same right on both server, the application release/version is same on both servers, and I used both Named Pipes and TCP/IP with port # 1433 on both servers |
|
|
|
getSqlMastered
Starting Member
12 Posts |
Posted - 2009-05-19 : 12:26:46
|
quote:
Originally posted by RickD
Does the user you are using have the same rights on both servers? Are you connecting via IP Address or Named Pipes?Are you on the same release on both servers?
thanks RickDI used on both server same application with same release and user with same access rights. more over, same Named Pipes and TCP/IP port 1433 |
|
|
|
getSqlMastered
Starting Member
12 Posts |
Posted - 2009-05-19 : 12:29:29
|
quote:
Originally posted by RickD
Does the user you are using have the same rights on both servers? Are you connecting via IP Address or Named Pipes?Are you on the same release on both servers?
thanks RickDI used on both server same application with same release and user with same access rights. more over, same Named Pipes and TCP/IP port 1433 |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-20 : 04:11:13
|
| So, can you ping the servers?Can you telnet to the server that isn't working?Can you set up an ODBC to each server from the client machine?Can you do a select @@version on both servers and post the results here? If they are the same, can you set up an Alias on the second server and see if that helps? |
|
|
|
getSqlMastered
Starting Member
12 Posts |
Posted - 2009-05-21 : 02:10:31
|
| here is the version for the two servers. yes i can also ping both servers. I have enabled Telnet automatic both at a clinet and on the serever but the application doesnt still work properly versionsMicrosoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2) |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-21 : 04:28:58
|
| Well, the first server has no service packs and the second server is SP3, so which one is working?At minimum you should be at SP3, if not SP4, otherwise you are asking for trouble. |
|
|
|
getSqlMastered
Starting Member
12 Posts |
Posted - 2009-05-29 : 02:30:45
|
| thanks alot the one which doesnot have servcie pack is not working.I have download sql server service pack 3 and /or 4 and try to install on the server both as domain administrator and local administrator, but the application doesnt start tp install and says permission denial. I have tried it on the sever that is working and it starts installing.so what might be the case? any help |
|
|
|
|
" Object Reference not set for an instance of an o