SQL Server - connection cannot be made to server 1

[Gramm]

I am running SQL Server 2005 using BI Projects. A project was created a while back but now I cannot access it.

The message I am getting is that a connection cannot be made to the server. This is a local database and local server (on a single machine). There have been no changes to the configuration of the system or machine since the project was created.

Does anyone know how to overcome this issue?

Many Thanks

 

[mrdenny]

Is the SQL Service running on your local machine?
Has the service been started?


Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Gramm]

Yes it is running locally and set to auto start. Thank you for responding.

 

[mrdenny]

Check the ERRORLOG (typically in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log\ERRORLOG) and see if there are any errors. Also check the event log.

Also run though the info in this FAQ faq962-5481. It's got the basic steps to troubleshooting connections to SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Gramm]

Thank you!! This is exactly what I have been searching for. Cheers!!

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com