Mike Levan (3/11/2009)

---

recently i installed sql server 2005 enterprise on my machine and in the wizard when asked for instance name i gave " REVDEV" but after completion if installtion i see that it was named as " REVDEV\REVDEV".

Now how do i rename it to REVDEV.

I used sp_dropserver and sp_addserver it did work, when query

select @servername it gives me REVDEV\REVDEV

sp_helpserver gives REVDEV

When i try connecting to REVDEV it will not but if i connect using REVDEV\REVDEV it conenctd good.

where am i doing wrong?