April 22, 2008 at 10:49 pm
Hi,
I have x64 windows SD and i installed x64 sql server 2005 SD Edition.
And i selected as a local instance with mixed mode Authontication.
All the instalation went successfull.
But When i open Management Studio i cannot able to browse or See any local instances.
Can any one help me out i tried many times in uninstalling and installing.
Thanks and Regards
Sreedhar.k
April 24, 2008 at 2:56 am
When SSMS starts, by default it will try to connect to the default instance on the local server. Does this happen for you?
If you want to have a list of servers you can choose to connect to, similar to the list shown in SQL Server 2000 EM, you will have to register the servers in SSMS. Registering a server just makes point and click connections easier - you can always type the server name in the connection dialogue to get to any server you can access.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 24, 2008 at 4:24 am
Hi ,
Thx for reply.
Can you tell me is SSMS is a service in the windows services.
See in general as i did in 32 versions.After installation i can see my local instances which i created.
But in 64bit versions i can see the same instance in the network servers not in the local servers.
Will there be any different in 64 bit versions. if so.
Please let me know.
What steps i have to follow to fix this.
Thanks and Regards
Sreedhar.k
April 24, 2008 at 4:28 am
SSMS is SQL Server Management Studio. I have not noticed any changes in the way is works between 32-bit and 64-bit.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 25, 2008 at 2:19 am
Hello ,
I am facing the same problem during installation of sqlserver 2005 x64..i cant see the local server which i installed in a normal way..i can see the service running in the services.msc and also in sql server configuration manager..but am not able to see it in managment studio.I saw tools are sitting on Programfiles(x86) and database files in Programfiles.Is this is the reason for management studio not taking the local servers when we browse from SSMS.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply