Re: SQL 2000 Client with SQL 2005 Server Alias

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: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: SBS 2003 R" Premium stops responding to clients
    ... Sometimes the SBS lost DC ... when all clients were down and there are no sql ... The sql load on this system is very small, and there were no sql server ... Mem is 2 GB and there are 10 clients. ...
    (microsoft.public.windows.server.sbs)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
Loading