<div>
Perfect!<br />
Out of the query question:<br />
Is it possible if we're using SQL Server 2008 R2 &amp;&nbsp;we'll put license of SQL Server 2010? Will it work?
</div>


Perfect!
Out of the query question:
Is it possible if we're using SQL Server 2008 R2 & we'll put license of SQL Server 2010? Will it work?

<div>
No idea on that part. But ideally it should not because every product has its own key and you can upgrade one but using a new key for the old product seems illogical I guess.
</div>


No idea on that part. But ideally it should not because every product has its own key and you can upgrade one but using a new key for the old product seems illogical I guess.

<div>
<div class="content wysiwyg-content">
Dear EE experts,<br />
<br />
Please see the attached screenshot for the error result that we got when we tried to login to our SQL SMS.<br />
We even couldn't open our SharePoint site anymore, it says here: &quot;Cannot connect to the configuration database.&quot;<br />
2 weeks ago, everything's fine, we can connect to our SP site, access SQL SMS, then just yesterday, we don't know what went wrong why we couldn't access our SQL SMS anymore that affects our SP site...<br />
<br />
Kindly advise what would be the problem &amp;&nbsp;how to resolve it...<br />
<br />
Thank you!<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/12_w52/533731/SQL-connection-error.jpg" target="_blank" class="file-inline" title="SQL connection error (248 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SQL-connection-error.jpg</a>
</div>
</div>


SQL-connection-error.jpg

Dear EE experts,

Please see the attached screenshot for the error result that we got when we tried to login to our SQL SMS.
We even couldn't open our SharePoint site anymore, it says here: "Cannot connect to the configuration database."
2 weeks ago, everything's fine, we can connect to our SP site, access SQL SMS, then just yesterday, we don't know what went wrong why we couldn't access our SQL SMS anymore that affects our SP site...

Kindly advise what would be the problem & how to resolve it...

Thank you!

How to resolve the SQL db can't connect to SharePoint site?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.