I have Windows 7 Home edition SP1 installed on my system, and downloaded SQL Server 2008 R2 Management Studio and got it installed. But when I try to connect via .\SQLEXPRESS, SSMS shows error
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 .
I go back to check the local services there I don't find any SQL Server service running.
What I have to do for this? DO I need to install any SQL service on my system? or how I should proceed?
5条答案
按热度按时间nwo49xxi1#
downloaded Sql server management 2008 r2 and got it installed. Its getting installed but when I try to connect it via .\SQLEXPRESS it shows error. DO I need to install any SQL service on my system?
You installed management studio which is just a management interface to SQL Server. If you didn't (which is what it seems like) already have SQL Server installed, you'll need to install it in order to have it on your system and use it.
http://www.microsoft.com/en-us/download/details.aspx?id=1695
vyu0f0g12#
Updated link to install Sql server Database in local machine. Once it is installed you can get access to local database and you can see SQL Server windows services instance up and running in your services list window.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
9bfwbjaz3#
You need to start the SQL Server manually. Press
windows + R
type
sqlservermanager12.msc
right click ->Start
Service configuration does not display SQL Server?
rt4zxlrg4#
For me it was just human mistake. In the Feature selection screen make sure you check the Database Engine Services.
I apparently installed without having it checked. Then adding features I did it and it worked for me. Now it is grayed out and cannot apparently be uninstalled from there.
The service now appears in different locations:
SQL Server Configuration Management
Windows Services
SSMS
fv2wmkja5#
This is an old question, but what helped me after installing a named instance of SQL Server 2022 was to create an incoming firewall exception for
and
Did not need to do anything in SQL Server Configuration Manager.