Re: SQL 2000 Client with SQL 2005 Server Alias

You can also try creating a SQL Server alias with the Client Network Utility
if modifying DNS is not an option. The utility is part of SQL Server client
tools, stand-alone in 2000, bundled into Configuration Manager in 2005. It's
also included with MDAC so if SQL Server is not installed on the same
machine, run "cliconfg" at the DOS prompt. The downside of using SQL Server
alias is that you have to do it on every workstation. Easy for a web server
but harder if you have a bunch of VB apps on mutliple workstations.

Roman

--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak


"Stewart" <stewart@xxxxxxx> wrote in message
news:u41tWiQwHHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
I tried editing the host file, but that did not work. I was hoping that we
wouldn't have to modify the connection string because the previous
developer hard coded it into the source and it's an old VB app...

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:ek$K2UQwHHA.3684@xxxxxxxxxxxxxxxxxxxxxxx
Change the DNS entry to point to the new IP address or change the
connection strings.

--
Andrew J. Kelly SQL MVP

"Stewart" <stewart@xxxxxxx> wrote in message
news:u%23PH72PwHHA.4228@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

Does anyone know how to configure a SQL 2005 Alias where SQL 2000
Clients can access it by name? I migrated a db over to a new server and
would like to decommission the old one but point all of the clients to
the 05 server.

Regards,
Stewart







.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL and Bandwidth use
    ... In addition to the other responses, take a look at the memory and CPU usage ... in Great Plains Client software. ... > near 100Mb/sec bandwidth). ... Client PC is on same segment as SQL server (not passing through ...
    (microsoft.public.sqlserver.server)
Loading