May 5, 2011 at 3:02 am
Here is what happened
I have successfully installed SQL server 2008 on my pc (windows VISTA) and now the issue is I am not able to connect to the server with default name MSSQLSERVER. When I am trying to connect to the server, SSMS is taking USERNAME-PC/SQLEXPRESS as current instance, which was automatically created when I installed SQL server express and no longer exists.
I have tried changing the name to MSSQLSERVER manually, still no result.
Microsoft itself admitted about this bug and advised to install Service Pack2 to resolve this issue, which obviously I did. Even installing service pack 2 has not fixed this error.
So, any more methods from geniuses out there to fix this issue
Thank you
May 5, 2011 at 3:21 am
Try connecting with . or your PCname to connect to default instances.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
May 5, 2011 at 3:36 am
Hi thanks for your response .... I have already tried both... Still no result
May 5, 2011 at 3:43 am
what is the error you are getting?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
May 5, 2011 at 5:48 am
Did you try (local) or localhost.
Did you check the protocols for that instance in Sql server configuration manager. Also verify the instance name in configuraion manager. May be SQL Server service is stopped for that instance.
Also provide the full error message or screenshot if possible.
May 5, 2011 at 9:32 am
wow.. some magic happened... after a couple of restarts... issue resolved automatically, and its working fine now... thanks for your responses
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply