Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have Windows 7 64bit as my OS + SQL Server 2008 R2 installed. I can connect to SQL Databases (2008), but cannot connect to a SQL 2005 database.

I can, however, connect to the 2005 SQL Database on a PC that has Windows XP as the OS and also has SQL Server 2008 R2 installed. So it seems that it works fine on XP but not on Windows 7 (32 or 64bit).

is this an Operating System issue?

Error message:

Cannot connect to OMRSQLV016\PRODSQL002.

===================================

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)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476


Error Number: -1 Severity: 20 State: 0

share|improve this question

2 Answers 2

MSSQL doesn't give explicit error codes to the clients (in your case SQL Management Studio ) , I would suggest checking the error message on the server with error number , Severity and state . I would go first in event viewer , but if you need more information or if you don't find the exact error please have a look here http://www.sqlmag.com/article/log-files/sql-server-log-files.

Bellow you can find a quick guide for troubleshooting general MSSQL server errors http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx .

share|improve this answer

If you're running multiple instances of SQL Server make sure the SQL Browser Service is running.

share|improve this answer
    
Hi, I have resolved the issue. Had to create an alias to the server in the 32bit Aliases on SQL Server Configuration Manager. I only had an alias in the 64bit Aliases. –  Darryl Lawrence Jun 12 '12 at 13:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.