Urgent question SQL Server

From: Alex (alex_at_NOSPAM.com)
Date: 04/28/05


Date: Thu, 28 Apr 2005 09:58:40 -0400

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.



Relevant Pages

  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to Replicate an SQL Server 2000 Database
    ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
    (microsoft.public.sqlserver.setup)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Check the database connection information and make sure that the database ... Uninstall SQL Server; ... Reinstall Monitoring and Sharepoint and make sure they work; ...
    (microsoft.public.windows.server.sbs)
  • RE: Need help with copy database
    ... in the event log for the server SQL was running on. ... This was a username from the database ... SQL Server Agent service is run with a domain account that has full admin ... if @backupSetId is null begin raiserror(N''Verify failed. ...
    (microsoft.public.sqlserver.dts)