Viewing 15 posts - 1,936 through 1,950 (of 6,395 total)
Perry's stairway has all the steps necessary on setting up the cluster from the ground up for Always-On
http://www.sqlservercentral.com/stairway/112556/
The share has to be aware from the cluster, eg on your corporate...
October 27, 2015 at 5:13 am
Your loosing quorum so the cluster is going offline.
You need an odd number of objects to get a true quorum, add in a 3rd node or add in a file...
October 27, 2015 at 4:46 am
The 18456 error is happening on the mirror node.
The connection strings / connection managers are all set to point to the principal node.
October 27, 2015 at 4:07 am
Yeah my thoughts where to have 2 DB's one to load the copy of the tables you needed into
Eg, DB1 has TableA_Today, TableA_Yesterday, DB2 has TableA, run a checksum...
October 27, 2015 at 4:04 am
You could also firewall off people from connecting to the DB server by blocking your active port for the instance out for everyone, then only punching a hole into the...
October 27, 2015 at 3:54 am
ChrisM@Work (10/27/2015)
anthony.green (10/27/2015)
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver spoons on...
October 27, 2015 at 3:44 am
Does the report have to run as the user running the report?
If not then change the data source to use a generic account to run the queries, this is the...
October 27, 2015 at 3:41 am
Do you need the full source DB or is it just a subset?
October 27, 2015 at 3:26 am
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver spoons on hand. ...
October 27, 2015 at 3:15 am
Yep the login is defaulted to master, I am guessing that the initial catalog in the connection string/connection manager is forcing it to ignore the default db and go straight...
October 27, 2015 at 2:37 am
Use a central management server or register all your servers in SSMS and run a query against the registered server group
October 23, 2015 at 8:53 am
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
Risk
Assessment
October 23, 2015 at 5:42 am
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
October 23, 2015 at 5:30 am
Take a look at GRANT
GRANT SELECT ON .... TO ....
GRANT INSERT UPDATE DELETE ON .... TO ....
Also take a look at ROLES in case you need to do this to...
October 23, 2015 at 4:10 am
Viewing 15 posts - 1,936 through 1,950 (of 6,395 total)