Monday, July 8, 2013

[SQL 2012] SQL Server 2012 Express - Error 10060 sleeping connection

[SQL 2012] SQL Server 2012 Express - Error 10060 sleeping connection


SQL Server 2012 Express - Error 10060 sleeping connection

Posted: 07 Jul 2013 10:42 PM PDT

We have SQL Server 2012 Express installed on a VMware instance of MS Server 2012. Most (but not all) mornings I find that a connection cannot be established through the clients. SQL Server returns the 10060 error. I then open the SSMS and make the connection with a SQL authenticated account and all is well for all the clients who can then connect normally. It is like SQL is sleeping. I've read the 10060 error posts but since a connection [b]can[/b] be made the suggested resolutions do not seem applicable. Selected Server Settings:Protocols: Shared Memory, TCP/IP enabled; Named Pipes disabledSQL Server Services: SQL Service, Browser: Automatic; Server Agent: State-Stopped w/Start Mode set to OtherWindows Services: SQL Server (SQLEXPRESS): AutomaticSQL Server Agent: DisabledSQL Server Browser: AutomaticSQL Server VSS Writer: AutomaticAny ideas would be appreciated.

Manage server memory via Resource Governor/WSRM vs SQL server Properties

Posted: 07 Jul 2013 12:15 PM PDT

Hi,I am very new to dba and I have question about managing min/max server memory. What would be the reason of configuring server memory via Resource Governor instead of via SQL properties page? What is the benefit over each other?However, it does make sense though when configuring the CPU consumption via Resource Governor as Properties page does not offer the functionality.Can anyone please shed a light, will be much appreciated.Thanks.

Create a data base on specific data file or log file

Posted: 07 Jul 2013 07:07 AM PDT

Hello I'm going to create a data base on data file but i saw this errors ,I know one of them is relatetd to user permission but I don't know how can i change the permission.[b]Msg 5123, Level 16, State 1, Line 1CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\Data\testdatafile.mdf'.Msg 1802, Level 16, State 4, Line 1CREATE DATABASE failed. Some file names listed could not be created. Check related errors.[/b]thanks alot

Validation Errors and Error Propagation in SSIS 2012

Posted: 07 Jul 2013 05:44 AM PDT

Hi everyone!I got a question... here's the situation:Do the validation errors at runtime in SSIS packages have a particular behavior when is comes to error propagation?I have a package with a Send Mail Task that gets the recipients list (CC included) from a table in a database, so at design time I set the [i]DelayValidation[/i] property to true in order to execute the package.The send mail task is inside a foreach loop and I've set the [i]Propagate[/i] system variable to false in the loop's onerror event handler... therefore if an error ever occur inside the loop it wouldn't be propagated to higher levels.The thing is that at runtime could not there be recipients at all (just an empty string) and it seems that case is causing an error to propagate to the package level regarding the onerror handler of the loop.I've tried with other type of errors like setting an invalid mail (not empty) and the package works as expected: the fail in one iteration does not prevent the loop from keeping iterating.The error is "there were errors during task validation"Thanks in advance and warm regards :)

No comments:

Post a Comment

Search This Blog