Viewing 15 posts - 16 through 30 (of 51 total)
My understanding is that SQL doesn't use page files
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 24, 2015 at 3:22 am
Is the failover target SYNCHRONIZED
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 23, 2015 at 3:46 am
Try reading this
http://windowsitpro.com/windows-server/six-common-problems-failover-clusters
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 20, 2015 at 3:02 am
Can you confirm that you have only 1 cluster ip address
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 20, 2015 at 1:54 am
If you have SA licence mobility then you are only required to licence cores on the active server.
So if you have 8 cares in your active and 8 cores in...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 20, 2015 at 1:50 am
This may help
http://www.sqlservercentral.com/Forums/Topic694674-146-1.aspx
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 19, 2015 at 8:30 am
the "System" account should have permissions everywhere accross your infrastructure. If not any service that is using a local service account will fail. Your backups are most likely to fail...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 19, 2015 at 4:21 am
farax_x (11/18/2015)
mark.williams 37494 (11/18/2015)
So you are on the SQL server itself and you are trying to connect to 127.0.0.1 ?
Yes. It connects when I'm connecting with "." or server name...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 19, 2015 at 1:53 am
You need to look at the state part of the error message
2, 5 = Invalid userid
6 = Attempt to use a Windows login name with SQL Authentication
7 = Login disabled...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 19, 2015 at 1:52 am
itguy2015 (11/18/2015)
MadAdmin (11/18/2015)
Can you list the SQL services you have as well as whether they are running or not.
Here is a screen shot of the services. Note that where I...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 9:25 am
See if this returns anything, changing recipient
USE msdb ;
GO
-- Show the subject, the time that the mail item row was last
-- modified, and the log information.
-- Join sysmail_faileditems to sysmail_event_log...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 9:10 am
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 8:35 am
anthony.green (11/18/2015)
Telnet from...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 6:53 am
Brandie Tarvin (11/18/2015)
jbrandenburg (11/17/2015)
How is this configuration option completed? What is the impact of doing so?
Which configuration option are you talking about?
Have you gotten with the server admin to...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 4:40 am
So you are on the SQL server itself and you are trying to connect to 127.0.0.1 ?
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 3:48 am
Viewing 15 posts - 16 through 30 (of 51 total)