Viewing 15 posts - 151 through 165 (of 6,105 total)
OK, that means he has them configured as separate physical sites, which makes sense, then. That also explains why the SQL Servers are talking to their DCs. That's all per...
November 18, 2011 at 9:40 pm
forsqlserver (11/17/2011)
I am finding "BOOST SQL SERVER PRIORITY" setting but not "USE WINDOWS NT FIBERS" in sql server 2008.
Where is It?and How WINDOWS NT FIBERS are useful in...
November 17, 2011 at 1:16 pm
Here's a dumb question you may ask. Not sure how large your environment is, but in a lot of places with the upgrade to 2003 AD inter-site replication became significantly...
November 17, 2011 at 1:05 pm
Is it just doing this for this one account or for any Windows account?
November 17, 2011 at 12:54 pm
Kerberos authentication was likely set up. Was Kerberos delegation configured? This is required to go through the linked server connection to another SQL Server using the passed Windows credentials. If...
November 16, 2011 at 1:48 pm
schleep (11/16/2011)
Hey Brian,So if I understand you, I can create the AD groups on both DCs?
There won't be a problem with out-of-synch SIDs after replication occurs?
Paul
If you're talking DCs...
November 16, 2011 at 1:12 pm
Create the groups and run the script from the remote SQL Server. That will create everything on the DC it talks to, which will in turn replicate eventually to all...
November 16, 2011 at 12:38 pm
winston Smith (11/16/2011)
When i created the SPN it was created like this:
MSSQLSvc/Srv1:Instance1
When I added the sql account to the domain admins and restarted it, it created the...
November 16, 2011 at 9:20 am
In SQL Server Configuration Manager, disable all the network libraries but Shared Memory. Shared Memory can only be used locally. This will require a restart of SQL Server (not the...
November 16, 2011 at 9:14 am
christopher.metzger (11/16/2011)
November 16, 2011 at 9:06 am
It might just have taken a bit of time for it to replicate. We used to wait about 15 minutes after the SPN was put in. Since we're on 2008...
November 16, 2011 at 9:05 am
Yes, please be a little more specific. Also realize that answers given on a forum are a starting point. You really need folks who know what they are doing to...
November 16, 2011 at 8:46 am
Don't do this from within SQL Server. Instead, use an IPSEC policy at the OS level.
How to block specific network protocols and ports by using IPSec
This talks about how to...
November 16, 2011 at 8:38 am
Viewing 15 posts - 151 through 165 (of 6,105 total)