Hi ,

I have a very urgent to solve issue with my SQL Server.
I have SQL Server 2000 installed on my server and a lot of application
working with the existing databases. These application stop recognazing the
name of the SQL Server yesterday (the name is CentralServer) so no one works
any more.
What is strange is that if I use (local) instead of database server
("CentralServer") the applications are working (but this is not a solution
because I have a lot of config files where I use the name of the server and
not :local").. If I call from other machine on the nework I can see and work
with the name "CentralServer" so any application installed outside this
machine is working fine and can find the Sql database.
It seems that some settings on the server are corrupted like the serverName
in registry somewhere but I don;t have any ideea where to search.

Does anybody had this problem?

I really don't know what to do so any help will be appreciate.

Thanks.
John.

Try creating an alias with the same name using "Client Network Utility" and
test if you can connet to it using osql.


AMB

"Alex" wrote:

> Hi ,
>
> I have a very urgent to solve issue with my SQL Server.
> I have SQL Server 2000 installed on my server and a lot of application
> working with the existing databases. These application stop recognazing the
> name of the SQL Server yesterday (the name is CentralServer) so no one works
> any more.
> What is strange is that if I use (local) instead of database server
> ("CentralServer") the applications are working (but this is not a solution
> because I have a lot of config files where I use the name of the server and
> not :local").. If I call from other machine on the nework I can see and work
> with the name "CentralServer" so any application installed outside this
> machine is working fine and can find the Sql database.
> It seems that some settings on the server are corrupted like the serverName
> in registry somewhere but I don;t have any ideea where to search.
>
> Does anybody had this problem?
>
> I really don't know what to do so any help will be appreciate.
>
> Thanks.
> John.
>
>
>

Thanks for the answer but....
The connexion with osql is working even on the actual name (not need to test
with alias). I can connect using osql on to the server using the name not
the (local).
Still, all my apoplications stopped to wotk using (server_name) and are
working only if I use (local) insteed.
Any other ideeas? Thanks in advance.
John.

"Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
news:FB86819C-EB7D-40F5-B057-41FCE6DC9965@microsoft.com...
> Try creating an alias with the same name using "Client Network Utility"
and
> test if you can connet to it using osql.
>
>
> AMB
>
> "Alex" wrote:
>
> > Hi ,
> >
> > I have a very urgent to solve issue with my SQL Server.
> > I have SQL Server 2000 installed on my server and a lot of application
> > working with the existing databases. These application stop recognazing
the
> > name of the SQL Server yesterday (the name is CentralServer) so no one
works
> > any more.
> > What is strange is that if I use (local) instead of database server
> > ("CentralServer") the applications are working (but this is not a
solution
> > because I have a lot of config files where I use the name of the server
and
> > not :local").. If I call from other machine on the nework I can see and
work
> > with the name "CentralServer" so any application installed outside this
> > machine is working fine and can find the Sql database.
> > It seems that some settings on the server are corrupted like the
serverName
> > in registry somewhere but I don;t have any ideea where to search.
> >
> > Does anybody had this problem?
> >
> > I really don't know what to do so any help will be appreciate.
> >
> > Thanks.
> > John.
> >
> >
> >

Alex,

check if there is an entry in master.dbo.sysservers.

select *
from master.dbo.sysservers
where svrname = 'CentralServer'

if there is one entry, then:

use master
go

exec sp_dropserver 'CentralServer'
go

exec sp_addserver 'CentralServer', 'local'
go

if there is not one entry then:

use master
go

exec sp_addserver 'CentralServer', 'local'
go


AMB

"Alex" wrote:

> Thanks for the answer but....
> The connexion with osql is working even on the actual name (not need to test
> with alias). I can connect using osql on to the server using the name not
> the (local).
> Still, all my apoplications stopped to wotk using (server_name) and are
> working only if I use (local) insteed.
> Any other ideeas? Thanks in advance.
> John.
>
> "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
> news:FB86819C-EB7D-40F5-B057-41FCE6DC9965@microsoft.com...
> > Try creating an alias with the same name using "Client Network Utility"
> and
> > test if you can connet to it using osql.
> >
> >
> > AMB
> >
> > "Alex" wrote:
> >
> > > Hi ,
> > >
> > > I have a very urgent to solve issue with my SQL Server.
> > > I have SQL Server 2000 installed on my server and a lot of application
> > > working with the existing databases. These application stop recognazing
> the
> > > name of the SQL Server yesterday (the name is CentralServer) so no one
> works
> > > any more.
> > > What is strange is that if I use (local) instead of database server
> > > ("CentralServer") the applications are working (but this is not a
> solution
> > > because I have a lot of config files where I use the name of the server
> and
> > > not :local").. If I call from other machine on the nework I can see and
> work
> > > with the name "CentralServer" so any application installed outside this
> > > machine is working fine and can find the Sql database.
> > > It seems that some settings on the server are corrupted like the
> serverName
> > > in registry somewhere but I don;t have any ideea where to search.
> > >
> > > Does anybody had this problem?
> > >
> > > I really don't know what to do so any help will be appreciate.
> > >
> > > Thanks.
> > > John.
> > >
> > >
> > >
>
>
>

Thank you for the answer.
Sorry but is not working, Any other ideea?


thanks!
"Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
news:F13C879F-DCB4-4035-B0C2-9F5C7C8F3E20@microsoft.com...
> Alex,
>
> check if there is an entry in master.dbo.sysservers.
>
> select *
> from master.dbo.sysservers
> where svrname = 'CentralServer'
>
> if there is one entry, then:
>
> use master
> go
>
> exec sp_dropserver 'CentralServer'
> go
>
> exec sp_addserver 'CentralServer', 'local'
> go
>
> if there is not one entry then:
>
> use master
> go
>
> exec sp_addserver 'CentralServer', 'local'
> go
>
>
> AMB
>
> "Alex" wrote:
>
> > Thanks for the answer but....
> > The connexion with osql is working even on the actual name (not need to
test
> > with alias). I can connect using osql on to the server using the name
not
> > the (local).
> > Still, all my apoplications stopped to wotk using (server_name) and are
> > working only if I use (local) insteed.
> > Any other ideeas? Thanks in advance.
> > John.
> >
> > "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in
message
> > news:FB86819C-EB7D-40F5-B057-41FCE6DC9965@microsoft.com...
> > > Try creating an alias with the same name using "Client Network
Utility"
> > and
> > > test if you can connet to it using osql.
> > >
> > >
> > > AMB
> > >
> > > "Alex" wrote:
> > >
> > > > Hi ,
> > > >
> > > > I have a very urgent to solve issue with my SQL Server.
> > > > I have SQL Server 2000 installed on my server and a lot of
application
> > > > working with the existing databases. These application stop
recognazing
> > the
> > > > name of the SQL Server yesterday (the name is CentralServer) so no
one
> > works
> > > > any more.
> > > > What is strange is that if I use (local) instead of database server
> > > > ("CentralServer") the applications are working (but this is not a
> > solution
> > > > because I have a lot of config files where I use the name of the
server
> > and
> > > > not :local").. If I call from other machine on the nework I can see
and
> > work
> > > > with the name "CentralServer" so any application installed outside
this
> > > > machine is working fine and can find the Sql database.
> > > > It seems that some settings on the server are corrupted like the
> > serverName
> > > > in registry somewhere but I don;t have any ideea where to search.
> > > >
> > > > Does anybody had this problem?
> > > >
> > > > I really don't know what to do so any help will be appreciate.
> > > >
> > > > Thanks.
> > > > John.
> > > >
> > > >
> > > >
> >
> >
> >

I agree with Alejandro Mesa i think that after adding the server in the
master database you need to restart the SQL server service.

"Alex" wrote:

> Thank you for the answer.
> Sorry but is not working, Any other ideea?
>
>
> thanks!
> "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
> news:F13C879F-DCB4-4035-B0C2-9F5C7C8F3E20@microsoft.com...
> > Alex,
> >
> > check if there is an entry in master.dbo.sysservers.
> >
> > select *
> > from master.dbo.sysservers
> > where svrname = 'CentralServer'
> >
> > if there is one entry, then:
> >
> > use master
> > go
> >
> > exec sp_dropserver 'CentralServer'
> > go
> >
> > exec sp_addserver 'CentralServer', 'local'
> > go
> >
> > if there is not one entry then:
> >
> > use master
> > go
> >
> > exec sp_addserver 'CentralServer', 'local'
> > go
> >
> >
> > AMB
> >
> > "Alex" wrote:
> >
> > > Thanks for the answer but....
> > > The connexion with osql is working even on the actual name (not need to
> test
> > > with alias). I can connect using osql on to the server using the name
> not
> > > the (local).
> > > Still, all my apoplications stopped to wotk using (server_name) and are
> > > working only if I use (local) insteed.
> > > Any other ideeas? Thanks in advance.
> > > John.
> > >
> > > "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in
> message
> > > news:FB86819C-EB7D-40F5-B057-41FCE6DC9965@microsoft.com...
> > > > Try creating an alias with the same name using "Client Network
> Utility"
> > > and
> > > > test if you can connet to it using osql.
> > > >
> > > >
> > > > AMB
> > > >
> > > > "Alex" wrote:
> > > >
> > > > > Hi ,
> > > > >
> > > > > I have a very urgent to solve issue with my SQL Server.
> > > > > I have SQL Server 2000 installed on my server and a lot of
> application
> > > > > working with the existing databases. These application stop
> recognazing
> > > the
> > > > > name of the SQL Server yesterday (the name is CentralServer) so no
> one
> > > works
> > > > > any more.
> > > > > What is strange is that if I use (local) instead of database server
> > > > > ("CentralServer") the applications are working (but this is not a
> > > solution
> > > > > because I have a lot of config files where I use the name of the
> server
> > > and
> > > > > not :local").. If I call from other machine on the nework I can see
> and
> > > work
> > > > > with the name "CentralServer" so any application installed outside
> this
> > > > > machine is working fine and can find the Sql database.
> > > > > It seems that some settings on the server are corrupted like the
> > > serverName
> > > > > in registry somewhere but I don;t have any ideea where to search.
> > > > >
> > > > > Does anybody had this problem?
> > > > >
> > > > > I really don't know what to do so any help will be appreciate.
> > > > >
> > > > > Thanks.
> > > > > John.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>