Thursday, 8 March 2012

Conncting to SQL Server 2005 database

Hi,
I have SQL Server 2000 Client installed on Windows XP and SQL Server
2005 Database on Windows 2003 which is not on domain. I want to access
SQL Server 2005 database from SQL Server2000 Client. When i am trying
to connect it, i get access denied error. Is it possible to connect...?When you say sql server client do you mean query analyser / enterprise
manager. If so no they cant connect to sql 2005.
If you are linking servers then it is possible.
If you have sql 2005 tools and are going to server that is not on the domain
you may need to enable sql authentication on the sql server and connect usin
g
a sql username and password.
Chris
"saurabh.sarode@.gmail.com" wrote:

> Hi,
> I have SQL Server 2000 Client installed on Windows XP and SQL Server
> 2005 Database on Windows 2003 which is not on domain. I want to access
> SQL Server 2005 database from SQL Server2000 Client. When i am trying
> to connect it, i get access denied error. Is it possible to connect...?
>

No comments:

Post a Comment