(local) DB?

[jaylou]

I am having issues where i lose connections to my SQL server 2000. I get errors like "Logon to server '(local)' failed (JobManager)"
I checked sysdatabases and there is an entry for (local) and also for my servername.

My serverName is SrvID 0 and (local) is SrvID = 20
ServerName isremote = 1 and (local) isremote = 0 (linked)

Can anyone tell me what this local is and can I get rid of it?

TIA,
Joe

 

[SQLBill]

(local) is just the default name for the default instance on the server. Test this:

Open Query Analyzer. Instead of putting in your servername, type (local). Then enter your login (or the SA login if you know it). Does it attach?

Now log off and try just entering a period '.' as the servername. That is 'shorthand' for local.

-SQLBill

Posting advice: FAQ481-4875