Re: Sql client 2000 connecting to Sql Server 2005

Hello,

You could use Query Analyzer or OSQL to connect to SQL Server 2005;
Enterprise manager will not support SQL 2005.

Thanks
Hari

"Geoff" <Geoff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E1A1AB4-19F2-44E2-8996-8CB5E75FE161@xxxxxxxxxxxxxxxx
Is it possible to connect to a Sql Server 2005 with Sql Client 2000? We
have
a piece of software that only communicates with the 2000 client but would
like to use sql server 2005.

Thanks,
Geoff.


.

Relevant Pages

  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: Replication problems
    ... machine than SQL Server as you must reference a share on the machine and not ... You can't create a publication due to the 1038 error. ... > not yet have any Publications in my Enterprise Manager. ... > start the SQL Server Agent service manually". ...
    (microsoft.public.sqlserver.ce)
  • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
    ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
    (microsoft.public.isaserver)
  • Re: login security question
    ... > I have an application which connects to the SQL server. ... Use Enterprise Manager to access the database / roles. ... Give the Application Role the appropriate permissions. ... what the stored proc is called) using the secret password for the App Role ...
    (microsoft.public.sqlserver.server)