SQL Server Name Change affecting SQL Database Service

what is your connection string?

im just trying to connect via the SQL Management Studio on the SQL Server, i tried reverting to the previous name but i still cannot connect

While renaming the SQL Server you should also rename the physical server.
The physical layer is what allows the user to connect using the DNS name. Without changing that name changing the internal reference of SQL Server is meaningless as you would not be able to find the name on the network. You could refer to it still as the old name and could connect with the old name or the IP address.  Attempt to reference the renamed SQL install.

Either change the SQL server back to the original, or rename the physical server on which is resides to match the name that you set SQL server to.

you can browse the servers, select it and connect...

Thanks, i did that however, when i did logon via windows authentication all the databases i had previously are not there anymore, does that mean i will have to reattach all the Databases including the views, SP's and SSIS packages?

regards,
Grand

if you login to new db server and dont see the databases, then it means they are not there!
you have to attach all existing ones or create new db and restore from backups...

Renaming a Server should be performed very carefully as it affects the SQL Server instances.
Did you read the correspondent MSDN article about it?
If not then you'll need to perform changes in the SQL Server instance:

sp_dropserver <old_name>;  
GO  
sp_addserver <new_name>, local;  
GO  

Select allOpen in new window

Btw, if you didn't change the IP as well there's a chance that you can connect using the IP address and port number.

These 2 statements have to return the same name:


select @@servername                              -- will retuturn old name
select SERVERPROPERTY('servername')      -- will return new name

At least the server name before the \ if is an instance name.

Grand Wavine, a feedback will be appreciated.
Cheers