SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Remote sqlserver instance name missing?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Terryw
Starting Member

2 Posts

Posted - 03/23/2013 :  19:02:41  Show Profile  Reply with Quote
Hi,

I have sql server express on a laptop and a desktop.

When I browse for LAN connected sql servers, from my desktop, using the sql server management studio I can see my laptop's sql server but the instance name is always missing. The instance name is 'SQLExpress' (the installation default).

If I do the same in the reverse direction I can see the instance name on my desktop. No problems.

Both firewalls are set the same. Both machines run Windaz 7.

Using the sql server configuration manager I have set visibility of the instance name but it still doesn't show up.

I can connect in both directions. In the desktop to laptop direction I have to manually input the instance name because I can't see it.

Why do I care? I am writing software to ease the burden of installation for a package that uses sql server as it storage. My software uses an API to get data sources and list them. However, it is tremendously unreliable.

Can anyone throw some light on this?
Terry

meghasql001
Starting Member

1 Posts

Posted - 03/30/2013 :  12:06:38  Show Profile  Reply with Quote
Hi,
I have installed SQLManagementStudio_x86_ENU on my system but when i try to connect using windows authentication it gives me error as :-


TITLE: Connect to Server
------------------------------

Cannot connect to localhost.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)


When I go to Start->All Programs->Microsoft Sql Server 2008 R2->Configuration Tools->Sql Server Configuraion Manager->Sql Server Services I dont see any sql server services.

Any advice!!! :-(



Megha
Go to Top of Page

Terryw
Starting Member

2 Posts

Posted - 03/30/2013 :  14:10:08  Show Profile  Reply with Quote
It may mean that you don't have the sql services (processes) installed and running. First thing I'd do is see if the services are running. Typically, "sql server (instance name)" plus "sql server browser" should be running. Use control panel -> administration -> services to see if they are present and correct. That way you don't have to rely on the "foibles" of sql configuration manager.

Did the installation work ok? Normally, you get notification when things went horribly wrong. Plus, there is of course an installation log. Not quite sure where it is but a look around where the executable resides will soon find it.

Good hunting.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000