Last post May 19, 2015 10:57 AM by Siva Krishna Macha
May 19, 2015 10:07 AM|mike4u|LINK
I have installed sql server 2008 but when i try to connect it with windows authentication then i am getting following 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) (.Net SqlClient Data Provider)
May 19, 2015 10:25 AM|Siva Krishna Macha|LINK
Probably you've installed by using named instance or so.
1. To see if you really have a working instance in your server - click on Browse where you are typing the server name and you can find the local instances in one tab inside it - Select it and try connecting again.
i.e., typically on Connect to Server browser, you select the server name as localhost or (local) or so, in the same dropdown, you will also have <<Browse for more>> option as one of the dropdown items. Click on it, you will get a window where you can select
your local servers.
If Database Engine node appears, click on it, and you will see local servers in this.
2. Hope you have selected Windows or Mixed mode when you are installing SQL Server. If you select only SQL server authentication mode, then you will not be able to connect using Windows mode.
May 19, 2015 10:32 AM|mike4u|LINK
server type : databse engine
server name :
authentication mode : both i have tried i.e windows and sql server authenctication
i am getting above error
May 19, 2015 10:57 AM|Siva Krishna Macha|LINK
I hope you saw ServerName value in a dropdown?
Open that dropdown and scroll down to the bottom - Do you see a word like 'Browse...'?
If so, click on it and see what are the local servers listed in that new window?