| Author |
Urgent question SQL Server
|
|
|
| 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.
| |
| Alejandro Mesa 2005-04-28, 9:23 am |
| 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@discus
sions.microsoft.com> wrote in message
news:FB86819C-EB7D-40F5-B057- 41FCE6DC9965@microso
ft.com...
> Try creating an alias with the same name using "Client Network Utility"
and[color=darkred]
> test if you can connet to it using osql.
>
>
> AMB
>
> "Alex" wrote:
>
the[color=darkred]
works[color=darkred]
solution[color=darkr
ed]
and[color=darkred]
work[color=darkred]
serverName[color=dar
kred]
| |
| Alejandro Mesa 2005-04-28, 8:23 pm |
| 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@discus
sions.microsoft.com> wrote in message
> news:FB86819C-EB7D-40F5-B057- 41FCE6DC9965@microso
ft.com...
> and
> the
> works
> solution
> and
> work
> serverName
>
>
>
| |
|
| Thank you for the answer.
Sorry but is not working, Any other ideea?
thanks!
"Alejandro Mesa" < AlejandroMesa@discus
sions.microsoft.com> wrote in message
news:F13C879F-DCB4-4035-B0C2- 9F5C7C8F3E20@microso
ft.com...[color=darkred]
> 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:
>
test[color=darkred]
not[color=darkred]
message[color=darkre
d]
Utility"[color=darkred]
application[color=da
rkred]
recognazing[color=da
rkred]
one[color=darkred]
server[color=darkred
]
and[color=darkred]
this[color=darkred]
| |
|
| 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@discus
sions.microsoft.com> wrote in message
> news:F13C879F-DCB4-4035-B0C2- 9F5C7C8F3E20@microso
ft.com...
> test
> not
> message
> Utility"
> application
> recognazing
> one
> server
> and
> this
>
>
>
|
|
|
|