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 |
|
mic8989
Starting Member
4 Posts |
 Posted - 2010-08-25 : 16:45:23
|
| Hi there,I installed a SQL server R2 64-bit and it works. But when I tried to access it from SharePoint portal it always gives error, saying the server not exists. During the installation I saw some tests, one of them, saying the processor is not 64-bit, I am using Windows 2008 R2 64, Hyper-V as virtual server, and hardware are dual CPUs of Intel Xeon 5520, what could be the problem and how should I to solve this? Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-26 : 02:47:57
|
| Are you making a connection between two different hyper-v images or are you installing sharepoint on the same server as the database? Do a "SELECT @@version" in Management Studio on the server...the result should include something about "x64" for both sql server and the OS. This is what I get when I run it on my server:Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
mic8989
Starting Member
4 Posts |
Posted - 2010-08-27 : 22:19:56
|
| thanks for replies. i tried server name same thing. i tried the select statement it gives version as:Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600 (X64) Apr 2 2010 15:48:46 Copyright ....then what? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mic8989
Starting Member
4 Posts |
Posted - 2010-08-28 : 19:39:02
|
| Thanks. Got problem solved. It is due to the firewall setting in Windows Server 2008 R2. Add sqlservr.exe to the firewall domain network location then it's ok now. I am afraid I'll do the same thing to Analysis and Reporting service. Just wonder why the installation engine does not set up those to the firewall automatically. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SQL Server R2 64-bit not accessible