Hi, no matter I tried I still can't access instance of MSSQLServer I install on my machine, and I'm trying to do it thru MS SSMS on local machine,
I see Instance MSSQLSERVER in configuration, I started all services (SQL Server, SQL Browser), enabled TCP (port 1433) , (Shared memory also ENABLED). REstarted all services.
Using W authentication on SSMS, going to .\MSSQLSERVER, localhost\MSSQLSERVER, t410\MSSQLServer...
user Name = T410\lenovo which is confirmed correct.
... and still geting error 87 "A network-related or instance-specific error occured while connecting to MSSQL server.
checked firewall for tcp/1433 http://msdn.microsoft.com/en-us/library/ms175043.aspx
In my SSMS ServerName dropdown, I still have stored sqlexpress instance, should be lef from my prev installaion of express. But now I'm on 2008 R2, running W7 64. I also have <Microsoft SQL Server 2008> folder I think left from prev install, it has only Configuration tools.
All new install in <Microsoft SQL Server 2008 R2>
Looks like only thing left is firewall? That what I learned from www, but I'm local so should be the case either. Is there any more diagnostics I can run, not sure about isql -L?
APpreciate all help. How to make it work,