Question Answered - The base cd's for the x64 os already has sp1 applied.

You can restore a sql 2000 (or 7) database straight onto a sql 2005 server.

Watch the compatibility mode as I seem to remember it stays at the old level. Hence if you want...

I was just checking the config for the x64 sql server 2005 server install , and see that is say you need windows 2003 sp1. I can't find any reference to...

Check the sql server log file to see if the sql server service could take the port. Sometimes other applications take the port before sql, and this is reported in...

What edition of sql server are you using? If MSDE the network libraries are disabled as part of the install.

Was it installed with tcp-ip?

You can check the sql server...

No, as the account which runs the sql server service needs access to the sql server.

I have it on one (new) prod msde install, and a couple of dev boxes.

Waiting for the AWE and SQLDiag fix prior to upgrading older servers, as I try and...

Have you got the -m startup switch set on the sql server in question?

(Right click on the server name in EM and choose properties. Then startup parameters)

Public access gives the user what ever permissions are assigned to the public role.

You can have one database owner, but many people in the dbo group.

dbo's have full access to...

I was thinking of the version info going, with the reg keys above.

To get rid of the null I usually use the following, code

exec sp_dropserver '<oldname>'

exec sp_addserver '<newname>',...

The only time I have seen this is when certain registry keys have been deleted. ie the \CurrentVersion and \Parameters ones

from

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\

I'd suggest rewriting the reqery using ANSI-92 e.g.

SELECT count(*)

FROM SAM_GUIA_EVENTOS E

INNER JOIN SAM_GUIA G

   ON E.GUIA = G.HANDLE and G.PEG= 752074

WHERE E.CLASSEGERENCIALPAGTO is NULL

Collation can be set at field level on the table.

I have just tried sqldiag on my developer edition xp2 destop and got the same error

I've installed it on my developement machine (xp sp2) , and had one problem  in replsys.out, which I sorted. Once installed no issues at all

Login failed for user '<my account>. Reason:...