Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using Named SQL Instance

  Asked By: Uma    Date: Feb 22    Category: Sharepoint    Views: 3530

Has anyone run into issues running the wizard/install process for a new
installation against a SQL db that is using a server/instance configuration?



8 Answers Found

Answer #1    Answered By: Upendra Bordoloi     Answered On: Feb 22

Should work fine. What problem are you seeing?

Answer #2    Answered By: Ali Javed     Answered On: Feb 22

At first I thought we were seeing problems with the ports on the cluster. I
found this article that made me think we were close to an answer. see:
html But, even using this DSN fix didn't work. Install still fails with a
'....Server does not exist or access denied.'

To summarize, we have:

- clustered Active - Passive sql  cluster 2008 with (3) name instance. SharePoint
is using one of those instance.
- Farm service account used for installation of SharePoint is a domain account,
local admin on WFE(s) and has public, security admin and db creator rights on
SQL server database.
- initial Wizard is being run  on Index server

Answer #3    Answered By: Karrie Wooten     Answered On: Feb 22

Local admin rights are not necessary at all. Deployment are done as the user
initiating the command, not the farm account.

Ensure that the SQL Browser service is running. SharePoint won't see the
instance without it running.

Answer #4    Answered By: Alan West     Answered On: Feb 22

Make sure the SQL Browser service is running

Answer #5    Answered By: Maribel Todd     Answered On: Feb 22

Yep. Up and running.

We are starting to suspect an ACL issue. The WFE(s) are on a different subnet
than the SQL cluster.

Answer #6    Answered By: Akshara Negalur     Answered On: Feb 22

Have you checked to make sure that you're running  the correct access
protocols, and that your Surface Area config isn't shutting you out?

Answer #7    Answered By: Timothy Davis     Answered On: Feb 22

If I understand what you are suggesting to review, from SQL Server Configuration
Manager, my Instance is reporting "...Shared Memory, Named Pipes and TCP/IP" as
all being "Enabled". Am I missing something?

Answer #8    Answered By: Adya Deshmane     Answered On: Feb 22

Are there any other applications that can try to connect to a named  instance
from the same subnet as the WFEs? Perhaps one of those freebie sql  clients, just
to test is connectivity is the issue. Integrated security is what you want, and
if using Kerberos, it may also be related to that. Check for Kerberos errors in
the windows event logs.

Ensure the user account running  the config wizard has at least DBA rights on the
cluster. I think DB Creator and DB Security Admin are the necessary role. You
also might want to turn on C2 audit tracing on the SQL server to try and find
out if it's a permission issue on the sql servers. Another trick is to turn on
Auditing for everything in the Local Computer Security Policy, be sure to audit
all failures. Might be a good idea to add that to the hard drive hosting the SQL
databases as well.

Didn't find what you were looking for? Find more on Using Named SQL Instance Or get search suggestion and latest updates.