Cant see SQL Server 2008 R2 on local, no matter what

Question

Cant see SQL Server 2008 R2 on local, no matter what

mario17

SSCertifiable

Points: 6078
More actions
March 26, 2013 at 6:22 pm

#291581

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,
Thanks
V

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Animal Magic SSChampion Points: 13964 More actions · Answer 1

Have you got a named instance called MSSQLSERVER? If not and your just trying to connect to the default instance then drop the /MSSQLSERVER from the end of your connections. So (local), . , <servername> should all work

Also have you tried a local copy of SSMS to rule out firewalls etc?

mario17 SSCertifiable Points: 6078 More actions · Answer 2

Thanks, Animal Magic

I did not created named instance, now in Services I have (MSSQLSERVER).

And I open FW for TCP/1433

And just tried to connect to <tcp:T410> and got connected to default engine.

So probably I'm OK !!

So "MSSQLSERVER" I see in services is default?

Can I convert default to named instance? I plan to play witn linked servers, not sure will it work for default.

I'm just itching to try it all.

Tx again to all

V

Animal Magic SSChampion Points: 13964 More actions · Answer 3

Hi,

Yes a default instance is fine for everything you will want to do. You only need named instances when you need more than one instance as you can only have one default instance.

John