CODEWITHSUNDEEP
sqlsql-servervisual-studio
Nike
Nike

Reputation: 1357

Why there is no any Sql Server in Add Connection list

I use Microsoft Visual Studio 2010 Professional (I installed all components).
Here is what I'm trying to do. I create a new ASP.NET project. Then I open Server Explorer (View->Server Explorer), right click on Data Connections and choose Add Connection. Then I choose Microsoft SQL Server and press Continue, but the 'Server name' list is empty.
I launch Sql Server Configuration Manager and it shows that SQL Server is in running state (Agent and Browser are stopped)
Why there is no any Sql Server in Add Connection list?
--------------------------------------------------------------
I allow remote filestream for SQl Server, so no I can choose server in the list, but when I enter new database name and click Ok I get a error "sql server was not found or was not accessible" alt text

--------------------------------------------------------------
Here is a list of installed programs with 'SQL' filter alt text

Upvotes: 1

Views: 3711

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300769

Have you configured SQL Server to allow remote connections? By default, SQL Server Express Edition and SQL Server Developer Edition do not allow remote connections.

For SQL Server 2005:

How to configure SQL Server 2005 to allow remote connections

For SQL Server 2008:

  1. From start menu of SQL Server 2008, run SQL Server Configuration Manager.

  2. From left side view of SQL Server Configuration Manager, expand SQL Server Network Configuration.

  3. In the right view, you will see the list of SQL Server protocols. By default only Shared Memory is enabled. Enable the other protocols to get your SQL server to accept connections over the network.

Your problem appears to be that you have more than one SQL Server instance installed locally. You will need to use the fully qualified name.

Upvotes: 1

Related Questions