July 13, 2012 at 10:27 am
I have installed Sql Server 2008 R2 Express Edition in my laptop. OS is Windows 7. It has installed successfully, including the Sql Server Management Studio. While configuring the server, I have given the mixed mode, so that it will take Windows and Sql server authentication. While trying to open the sql server studio, it is giving the error " A network-related or instance-specific error occurred while establishing connection to Sql server. The server was not found or accessible.
When I tried to check for the servers as mentioned in this site,http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/, I got the result as blank list of servers. So how do I include the server in the network? Please help.
Thanks
Rajaram.
July 13, 2012 at 10:33 am
Make sure SQLExpress is configured for remote access, TCP is enabled in SQL Configuration Manager and SQL Browser Service is on. From elsewhere on the network you should be able to connect as <machinename>\SQLExpress
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply