SQL SERVER NAME problem

[swatii]

I am doing project in C#.net and I am using crystal reports.While using Crystal report I have to specify the server name which is "EVERY" on my system which is the default name of my system while it should be "localhost" as my project is a desktop appliaction so may I know how to change the name of the sql server.
If I specify "EVERY" then it works fine on my system but it doesn't work on any other system.
So please solve my problem of server name!!!!

[swatii]

I tried the following code to chnage the name of the server..

1. Open Query Analyzer
2. Type Select @@ServerName to verify that the server name is correct or incorrect.It will return "EVERY".

3. Next, type sp_dropserver ‘EVERY’

4. You are now ready to add the correct name by typing sp_addserver ‘local’, local

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.


6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.


But still crystal reports are not working fine on another system

[balame2004]

You need to know how to connect remote datatabase in crystal report. Read online tutorials.

[swatii]

I already studied it...But unable to remove the problem....
The problem I recieve when I enter local (desktop application)as server name is:-
Logon Failed
Details:ADO ErrorCode:0X
Source:Microsof t OLEDB provider for SQL SERVER
Description:Inv alid authorization specification
SQL State:28000
I am using OLEDB(ADO) for connection of crystal report to the sql server 2000.