Re: Can't connect to SQL server

Parrot (Parrot@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
After installing Visual Studio 2005 and the SLQEXPRESS 2005 I cannot
connect to the server. It says that I need SQL Server 2005 data
management tools to connect to the server. Therefore, I cannot import
or copy any databases from the SQL 2000 server. Anyone have any
suggestions on what I have to do to connect to the server in SQL Server
Enterprise Manager?

You cannot connect to SQL 2005 from Enterprise Manager.

Look at http://msdn.microsoft.com/vstudio/express/sql/download/ for
various download options, for instance SQL Server Mangement Studio
Express.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SQL Server 2000 Books On-Line
    ... Help topics associated with the Help icon are for Microsoft Management ... To open Books Online from Enterprise Manager, from the tool bar select View ... SQL Server Documentation Team ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)
  • Re: keine Verbindung zu SQL 2005
    ... Der Enterprise Manager kann mit SQL Server 2005 nichts anfangen. ... kann aber nicht auf ihn zugreifen, der 2005 wird mir garnicht angezeigt. ...
    (microsoft.public.de.sqlserver)
  • Re: Hard Drive wont stop spinning
    ... Security Accounts Manager ... SQL Server ... Symantec Lic NetConnect service ... Windows Firewall/Internet Connection Sharing ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Jobs not running manually or scheduled
    ... From reading what you've said, the SQL Server is not clustered. ... Have you checked the schedule information for the job (e.g. double ... Activity" node in Enterprise Manager? ...
    (microsoft.public.sqlserver)
Loading