2
votes
1answer
129 views

MSSQLSvc Service Principal Names, Kerberos, and NTLM

Was recently helping a DBA with an issue that appeared to be related to an invalid SPN. Discovered that a good number of SQL service accounts simply don't have an SPN set, resulting in NTLM ...
0
votes
1answer
96 views

How to resolve SSPI context error without changing Service Account from MSSQL

There is a issue while connecting from new Windows 8.1 Clients to SQL Server 2008 running on Windows Server 2008 R2. The SQL Service running under account Domain\mssqlservice on a machine thats works ...
1
vote
1answer
116 views

Connecting to a domain-joined SQL Server from a non-domain client

I struggled for some time yesterday, attempting to log into a SQL Server 2008 instance on a domain-joined server from a non-domain-joined client. The computers in question: -fhsvr is a domain-joined ...
3
votes
2answers
2k views

SQL Server running under a domain account cannot register its SPN

I am trying to configure a fresh install of SQL Server to run under a domain account. However, I get intermittent errors when trying to connect to the server using another domain account, and I still ...
0
votes
1answer
59 views

Internal Office Domain and External Server Domain Trusts

I have a single office domain - internal with an external IP address. This server is our office active directory running windows server 2008r2. (AD : PPInternal) With that, I have a private cloud ...
2
votes
3answers
158 views

Is it okay to put applications on an Active Directory secondary server? What pitfalls?

I have a fixed number of VMs in my Windows/IIS website setup, which I cannot change in the short term: a web server, which is badly overloaded from a memory and cpu load standpoint (IIS6, Server ...
1
vote
2answers
792 views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
1
vote
2answers
121 views

2012 domain functional level with 2008 r2 web server

We are in the process of setting up a brand new domain and associated services (exchange, etc), on a new VMware environment. We want use Windows 2012 however the web-based ERP application requires ...
0
votes
3answers
576 views

Why Does A/D Account Need SQL Server Login?

I need some help on understanding the differences between Windows and SQL Server Authentication: We have a SQL Server 2008 set to SQL Server and Windows Authentication Mode. There is one A/D user -- ...
1
vote
1answer
96 views

Sharepoint 2010 server farm

Here is my current Sharepoint 2010 setup. I have 3 VM's running on the same server. The 3 VM's are as follows (all Windows 2008 R2) 1) Active Directory server 2) Sharepoint server 3) SQL Server ...
1
vote
1answer
291 views

Clear SPN changes from server cache

We have in house IIS apps built on ASP .Net 2.0 running on IIS 7.5- Server 2008 R2 x64. Back end is SQL 2005. It uses Kerberos (Windows integrated) authentication. Once in a while we need to change ...
2
votes
1answer
81 views

MSSQL 2008 Service Account

Background: We are a smallish company that prefers to keep things simple and not have to manage our Active Directory very much. My company uses a single administrator account to setup and do all the ...
0
votes
0answers
61 views

Reporting Server and Multiple AD Domains

We have a Database sever running Microsoft Reporting Services on our network. The users with browser permissions on the server come from our AD Domain, and from a second AD Domain we share trust with ...
1
vote
1answer
518 views

How to trust a non Domain PC over a VPN connected via a Domain Account for SQL Windows Authentication

We are trying to enable a windows login to SQL Server from an untrusted laptop. The SQL Server has been enabled to allow the domain account to login and browse the data When a domain user connects ...
3
votes
2answers
1k views

Can't Connect w/ SQL Management Studio After Domain Change

Our old Small Business Server 2003 (acting as our domain controller) was on the fritz, so we replaced it with a new Windows Server 2008 box and set the server up as our new domain controller. In ...
0
votes
1answer
646 views

Can't login to SQL Server 2008 on Domain Controller [duplicate]

Possible Duplicate: Cannot connect to SQL Server I had SQL Server 2008 functional before I installed Active Directory and setup a domain (this is on Server 2008 R2, the only domain ...
2
votes
3answers
955 views

SQL Server bulk import from fileshare. How can I get SQL Server to see the share?

I have two servers A and B. B is a database server, A is (here) a client to the database server. A tool running on server A connects to SQL Server on server B and ultimately triggers a bulk import ...
1
vote
1answer
130 views

SQL Server connection for Active Directory users without creating explicit logins for each of them

Users, who are part of an Active Directory domain (Windows Server 2008), need to be able to connect to a SQL Server 2008 R2 (it can be Express edition) with the "public" role rights. Should I ...
1
vote
1answer
159 views

Can I set MSSQL permissions for individual users with a group login?

I have a lot of SQL 2005 servers with a lot of databases and a lot of Windows users that need access to all the servers but only a few databases, and that last part changes regularly. Managing these ...
3
votes
1answer
1k views

SQL Server Windows Authentication NTUSERNAME is different to Windows Login

An employee at a client has just got married and as a result they have changed her details, login name et al., in Active Directory (AD). The problem is SUSER_NAME() in procedures and the NTUSERNAME ...
1
vote
1answer
63 views

database server on domain?

Are there any significant drawbacks to joining a SQL Server machine to the domain (i.e. security, performance, etc)? Our box is currently off the domain so we just manage users locally, but we were ...
0
votes
2answers
166 views

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. ...
1
vote
2answers
409 views

MSSQL Failover Witness Server on a Domain Controller

I have 3 servers 1 production 1 standby and 1 just sitting there. I want 1 to stay production and I have been working on setting up an MSSQL automatic failover cluster between the production server ...
0
votes
1answer
150 views

Application Compatibility Clients do not show in MSSQL database, but do show in \AppCompat\

Application Compatibility Clients are denied access to the central MSSQL database, but are able to leave their own files in the \AppCompat\ share. The only computer that shows up in the "Microsoft ...
2
votes
1answer
2k views

Can't login to SQL Server after joining domain

I installed a SQL Server 2008 on a machine and created a database on it. Subsequently, the machine that this was installed on was added to a Windows domain and it appears the original local user ...
2
votes
1answer
457 views

Is it possible as an Administrator to gain access to a SQL Server 2008 instance without changing any passwords?

I have administrative access on our network, but I don't manage the installation of all servers or software. On some of our machines instances of SQL Server 2008 have been installed which I need to be ...
0
votes
3answers
255 views

What is the SQL Server services credentials usage?

What's the importance of changing SQL Server service credentials login ? Can we leave it as the default builtin account or shall we change it with something DOMAIN\username ? Thanks.
4
votes
3answers
305 views

SQL Server 2008 Fail-over Cluster

I am using SQL Server 2008 Enterprise and I want to install SQL Server 2008 fail-over Cluster. I am wondering, (1) do I need an active directory domain? (2) what is the minimal number of machines do ...
0
votes
3answers
666 views

Cannot authenticate a domain user with SQL Server 2008

I'm new to setting up Domains so I might be missing something simple here... I've installed SQL Server 2008 on a Windows Server 2008 R2 box and I have another WS2008 R2 box acting as the domain ...
0
votes
1answer
588 views

Can't access Sql Server after installing Active Directory

I had SQL Server 2008 set up with databases and sites running, then installed MS Exchange on the server which required Active Directory before moving forward. After installing both, my sites were no ...
1
vote
2answers
311 views

Querying the Active Directory domain of a Windows 2008 host in SQL

There is code in our shop that must query a SQL Server 2008 server, determine the Active Directory domain that the host belongs to, and, in SQL, create Windows login principals based on this ...
2
votes
3answers
1k views

Managing SQL Server users via Active directory groups

I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins. I have several groups with different roles (admin, developer, user etc.), and I ...
5
votes
3answers
4k views

Recommended service account setup for MS SQL Server 2005/2008

We have a number of MS SQL servers in our environment running either SQL Server 2005 standard/enterprise or SQL server 2008 enterprise. Currently the SQL services are running as local service or ...
2
votes
1answer
2k views

SQL Server Windows Auth Login sees Domain as untrusted

I've had someone set up a domain controller on windows 2008 on one server, and sql server 2008 on another. The domain seems to be working fine, I'm logged on as a domain user on both servers, nothing ...
2
votes
1answer
738 views

A username changed in ActiveDirectory, but the old UserName is still showing in SQL Profiler

We changed the username of one of the ActiveDirectory users, but now, days later the old username is still showing in SQL Profiler when they login. Are these SIDs cached locality with a copy of the ...
7
votes
6answers
4k views

What's the best wiki to run on Windows?

I want to set up a wiki for my team. I need it to run on Windows/IIS and if it needs a database, against SQL Server. User-authentication must use/integrate with Active Directory, ideally natively ...
1
vote
1answer
168 views

How to deploy SQL Server 2005 Reporting Services on a network without a domain server?

I have a small Windows network (~30 machines) and I need to deploy SQL Server 2005 Reporting Services. Because I use SQL Server Standard Edition and not Enterprise, I am forced to use Windows ...
0
votes
2answers
177 views

How to get full domain name of a virtual PC with windows server 2003 installed?

Sorry if it's a noob question. I now have 3 virtual PCs, which all installed windows server 2003. In order to create an database mirroring demo, I have to know the full domain name of them. These ...
1
vote
1answer
76 views

What's more secure, several active directory/windows domain users for to run different SQL server machines under or one to rule them all?

I have three sql server 2005 servers, and I am about to switch them to from running their sql server service as a local user to running as a domain user. Should I use a unique domain user for each ...
1
vote
3answers
2k views

What permissions are required for SQL Server to run as a (active directory) domain user

I wish to switch the SQL Server 2005 service from running as a local user to running under a domain user (mainly so I can make backups to domain-permissioned shares). I can't seem to find a ...
0
votes
1answer
197 views

Single Sign on between client and server in untrusted AD domains

A customer of mine is migrating some serveres to a provider, which will cause (temporarily) clients and servers to be in separate, untrusted AD domains. The application in question is a SQL Backend / ...
3
votes
1answer
184 views

Moving SQL Server into domain

We have a MS SQL Server installed on a stand alone server. We would now like to add the server into a domain. Is this possible? Do we have to do anything with the rights to the database after the ...
2
votes
2answers
771 views

User or role does not exist in this database

I am trying to add a new login in SQL Server 2005. I can go into the security properties for the database in SQL Management Studio, and I can select a domain user, but when I click OK to close out of ...
4
votes
1answer
887 views

netlogon errors

I have two instances of mssql 2005 and am using CA XOSoft replication. The master is a failover cluster and the replica is a standalone server. They are all running Server 2003 sp2 x64. Same patch ...
1
vote
2answers
1k views

AD account change not effective on sql server

When we have to change a user's last name lets say from jsmith to jjones, in our Win2000 active directory, we experience a bit of strange behavior with Sql Server 2008. When jjones hits the server ...
1
vote
4answers
115 views

Is there service management software in existence that meets these needs?

I work in an IT dept. at a higher ed. institution. Because the department is small and the infrastructure simple, managing all the services we offer out to the school (like LDAP, AD, various DBMS', ...
2
votes
7answers
811 views

processor - dual core or quad core for ad/ss

I'm looking at getting a few additional servers. Can someone enlighten me as to which I should prefer based on the following uses? Active Directory/DNS Server (<50 users): Dual Core IntelĀ® ...
2
votes
3answers
7k views

Change AD domain membership of a Server 2008 running MS SQL 08

Is it safe to change the domain membership of a Windows Server 2008 that runs MS SQL 08? Have you already done this and did you experience any problems? I fear that there could be some kind of domain ...
0
votes
2answers
71 views

Designing AD Domain for SQL Server in multiple third-party locations

I have an application that uses SQL Server where I plan on deploying four instances to four different third-party dedicated hosting providers. The databases will replicate between each other. So, does ...
4
votes
2answers
2k views

Permissions required for an SQL Server account

We're trying to get SQL running under a domain account, however we're not sure what permissions will be required for the service to start. At present it is just a standard user in the active ...