We have SQL Server 2008 installed on a virtual server-KYSQL1P
I need to install a restored version of a SQL 2005 database onto this server. When I attempt to register the new server from within Enterprise Manager, I get a login error upon test. I think I need to nmake sure tha t i have rights to perform this type of operation before procedding. Please advise.