Viewing 15 posts - 1,786 through 1,800 (of 2,436 total)
Just to chime in ... got the error twice yesterday and once today ...
October 19, 2005 at 4:40 pm
I took the extract below from thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=202884
Here's how:
I've had this problen quite frequently lately (ughh...)
First thing you need to do is download the setspn utility (link...
October 19, 2005 at 4:34 pm
Are you configured to run SQL Mail ? If so then the 'profile' for SQL Mail may be corrupt or might have been deleted ...
October 19, 2005 at 4:29 pm
Are you running the backup from a maintenance plan ? If you are not using a maintenance plan, is the Job executed via the SQL Agent ? If it is...
October 19, 2005 at 4:27 pm
Check out the following links for a start ...
http://www.hds.com/pdf/wp_149_san_nas_convergence.pdf
By the way a SAN is not a cheap venture ... a 1 cabinet Hitachi with a few terrabytes of...
October 19, 2005 at 4:09 pm
The solution posted is a good start, but I would not rely on ping alone ... The OS could be alive and SQL Server down is one sitiation I've seen...
October 19, 2005 at 3:58 pm
What type of error are you receiving (e.g. 42000 login failed - usually bad username/password) Can you ping the SQL server ? Can you perform a telnet to port 1433...
October 19, 2005 at 3:54 pm
Just a couple of other points to factor in ... did you perform the database backup to disk or directly to tape ? Will the restore be from disk or...
October 19, 2005 at 3:51 pm
What OS/SP are you running ? What SQL Version/SP are you running ? Is the error occurring on the SQL Server itself ? Is the error occurring on a client...
October 19, 2005 at 3:31 pm
I am going to, ughhh, assume, that your present server is sized correclty and performing well. In an ideal world your devlelopment server would mirror your production server (cost and...
October 19, 2005 at 3:27 pm
Do you run sp_ecompile for the table as well ? If not then the optimizer is still using the old execution plan,
October 18, 2005 at 12:11 pm
Collation affects alot of things ... some of the more notable things, order by and group by clauses (resultant query data may appear in a different order). You can change...
October 18, 2005 at 11:58 am
Let me take a wild guess ... you have taken and are presently executing the installation defaults for SQL Server, Analysis Server ... on multi-use and/or heavily hit servers this...
October 18, 2005 at 11:46 am
What is your network connectivity ? The reason I ask is that I have been in a similar situation once before. The only things you may be able to do...
October 18, 2005 at 11:38 am
What is your network connectivity ? The reason I ask is that I have been in a similar situation once before. The only things you may be able to do...
October 18, 2005 at 11:38 am
Viewing 15 posts - 1,786 through 1,800 (of 2,436 total)