Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalorenzini
Starting Member
4 Posts |
 Posted - 2012-06-13 : 16:59:04
|
| I am looking for some expert advice and your forum popped into my head. I have been out of the SQL Server DBA game for awhile now and ran across an issue that I can’t seem to get around.I just installed SQL Server 2008 R2 Express called CRHADbSRV\SQLExpress plus all the management tools on to a Windows 2008 server. I have installed Studio Manager 2008 R2 on number of desktops but for some reason they will not recognize the CRHADBSRV\SQLEXpress. I should also mention When you are in studio manager and you are going to connect to the server by using the Server drop down list and if you browse for network servers. It shows up as CRHADBSrv and not CRHADBSRV\SQLEXPRESS even though you cannot connect to either one.The error reads when trying to connect to CRHAdbSRV\SQLEXPRESS"A network-related or instance-specific error occured while establishing a connection to SQL Server. The server is 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 Interface, error: 26 - Error locating server/Instance specified) (Microsoft SQL Server)The error reads when trying to connect to CRHADBSRV:"A network-related or instance-specific error occured while establishing a connection to SQL Server. The server is not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider; Name Pipes, error: 40-Could not open a connection to SQL Server) (Microsoft SQL Server, Error:2)SQL Server Express in running on a domain account called SQLService. I am plumb out of ideas? Perhaps you could point me in the right direction?Thank you,Art Lorenzini |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalorenzini
Starting Member
4 Posts |
Posted - 2012-06-13 : 18:33:46
|
| So what should we be look at as far as the firewall is concerned? The SQL Server is started.Thank you,Art Lorenzini |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalorenzini
Starting Member
4 Posts |
Posted - 2012-06-13 : 18:52:48
|
| Took down firewall and it worked fine. So it is probably a port issue with the firewall. Because as soon as we turn the firewall back on we have the same issue.Where do we go from here?Thank you,Art Lorenzini |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalorenzini
Starting Member
4 Posts |
Posted - 2012-06-13 : 20:29:08
|
| Problem solved. Follow the steps in this article from Microsoft to open the correct ports:http://support.microsoft.com/kb/968872Thanks for everyone's assistance.Thank you,Art Lorenzini |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Cannot see SQL Server 2008 R@ Express server
Tara Kizer