wrong server name

During a test setup of replication on SQL2005, I received an error
indicating that I had to connect to the server with the actual server name
(and then it gave me the name). PRoblem is that the computer name actually
changed after SQL2005 was installed so I am now connecting with the actual
server name but SQL doesn't see it that way. Also, the old name will not
allow any connection either (i.e. the name the error gave me it was looking
for).

So, is there a way to modify the internal server name that SQL thinks it
has?

Thanks,

Shawn


.

Relevant Pages

  • Re: DCOM Error - Event 10009
    ... using SQL Server Management Studio 2005. ... Whenever we first launch SQL ... when connecting to a different registered server, it will hang again for 5 - ... I have checked DCOM Config using dcomcnfg, ...
    (microsoft.public.sqlserver.clients)
  • Re: Heres a weird one for all of you...
    ... SQL: SQL 2005 Demo ... SQL 2005 Processor Licensed (connecting via port 14330) ... Additional Major S/W on that server: ... logs showed was an operation timeout error, ...
    (microsoft.public.sqlserver.connect)
  • Re: Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net
    ... When you are connecting to SQL server in integrated security mode IIS is ... passing SQL server the account used to run the website. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • error -2147467259 sql server does not exist or access is denied
    ... I have a number of applications that I have written in VB6 connecting to SQL ... application needed to run on a box other than the SQL server itself. ... If I wait about 20 seconds then re-issue the same command the system returns ...
    (microsoft.public.vb.database.ado)
  • Re: Forms authentication - change password
    ... Contact the server administrator. ... I think your authentication validation method needs to be set to ... the change password feature within ISA ... | | meant not connecting to a Global Catalog. ...
    (microsoft.public.isa)