→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eriken
Engaged Sweeper II
We have problem with our installation, we get the following problem when we try to delete from the database.

"Could not find server 'SQL02' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers"

But if I trye to add the server to itself I get "You cannot create a local SQL Server as a Linked Server".

We have an external sql2005 server with windows server 2003. With the name SQL02 as stated in the message above.

I have read in the forum and we have not changed name or sql server neither the app/web server.
3 REPLIES 3
Hemoco
Lansweeper Alumni
run the following sql code: (replace yourserver)

EXEC sp_serveroption 'YourServer', 'DATA ACCESS', TRUE
eriken
Engaged Sweeper II
After that solution I got a new problem,

"Server 'SQL02' is not configured for DATA ACCESS.
Hemoco
Lansweeper Alumni
Please follow these guidelines: http://www.techrepublic.com/blog/datacenter/changing-the-name-of-your-sql-server/192

Check first to see if the name matches the name of your server.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now