Re: SQL 2000 with SQL 7 tools
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 02/13/05
- Next message: Mike Epprecht \(SQL MVP\): "Re: Newbie: SQL Server connection, help needed"
- Previous message: Ray Woerner: "SQL 2000 with SQL 7 tools"
- In reply to: Ray Woerner: "SQL 2000 with SQL 7 tools"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 13 Feb 2005 20:51:41 +0100
Hi
You have to use SQL 2000 tools for SQL 2000. There are a number of changes
introduced in SQL 2000 that the old tools do not understand.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Woerner" <rpw_01@netzero.net> wrote in message
news:1108313601.b510a3b1323e463c116912be1b4e6a13@teranews...
> I'm a newbie at SQL Server connections. I've contracted for a SQL 2000
> database with my hosting ISP but have Client Network Utility and
Enterprise
> Manager from SQL Server 7 which was loaded during my install of Visual
> Studio .NET 2003.
>
> I've read that I must "add an alias that points to
> \\computername\pipe\MSSQL$instancename\sql\query".
>
> However, I still can't get the connection set up correctly.
>
> For example, with Server IP address of 11.22.33.44, using TCP/IP on port
> 1234 with instance name SQL101/I1; I've used this setup in Client Network
> Utility (please don't laugh TOO hard):
>
> Server alias = websql; Network Library = TCP/IP;
> Connection parameters = \\11.22.33.44\pipe\MSSQL$SQL101\I1\sql\query
> Port number = 1234
>
> In Enterprise Manager, I've set the SQL Server Registration to "Use SQL
> Server Authentication" and to prompt me for the name and password.
>
> My login fails.
>
> Any help would be appreciated. Please be specific about parameter
settings -
> I'm completely new at SQL server connections.
>
> Thanks,
>
> Ray
>
>
>
- Next message: Mike Epprecht \(SQL MVP\): "Re: Newbie: SQL Server connection, help needed"
- Previous message: Ray Woerner: "SQL 2000 with SQL 7 tools"
- In reply to: Ray Woerner: "SQL 2000 with SQL 7 tools"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
