Viewing 15 posts - 226 through 240 (of 508 total)
check to see if port 1434 is open as well. you can connect to it via 1433 with access I'm guessing.
November 25, 2003 at 8:13 am
they have given out beta 1 at PASS and at PDC I don't know if there is an NDA on those copies.
November 22, 2003 at 1:54 pm
The MSA should give you much more than 800 i/o's a second. A 15k drive should do around 133 i/o's by it's self. One thing to look at is the...
November 21, 2003 at 8:59 am
I've played with it a bit. It did unregister my DMO objects and broke my EM after the install. Other than that works as advertised.
Wes
November 21, 2003 at 8:47 am
I doubt it is a DNS problem check your protocol is it named pipes or tcp? Does the application only support WINS? osql -L will only list servers on the...
November 19, 2003 at 9:51 am
without looking at the cluster logs or eventlogs on the server there isn't much we on the board can do for you.
November 18, 2003 at 7:55 am
Also make sure all the resources that belong to sql are in the sql cluster group i.e. disk or services that may not have been included.
Wes
November 18, 2003 at 6:07 am
Is this a windows 2000 cluster? More info on your setup would help us find an answer.
Thanks,
Wes
November 17, 2003 at 1:08 pm
if you look at the sql agent there is an option to forward all handled or unhandled events to another machine this will send events from the logs to another...
November 17, 2003 at 6:06 am
We also have a large number of servers. I have a large list of scripts that run as well.
Things I have done to make life easier.
One, setup a SQL server...
November 16, 2003 at 5:23 pm
I would also recommend checkalloc if you can't fit a checkdb in a normal timeframe. If checkdb won't run in a reasonable amount of time what do you do for...
November 16, 2003 at 5:03 pm
Test the queries first. Complicated tsql updates can easily destroy data. I've shot myself in the foot more than once with a complicated update join.
WEs
November 7, 2003 at 10:21 pm
datetime and smalldatetime time both have month day year hour minute second in them smalldatetime rounds to the nearest second. you have to parse the datetime ether using datepart() or...
November 7, 2003 at 3:47 am
can you tell us what service pack you are on sql and windows wise and the MDAC version you are using as well. I don't know anything off the top...
November 4, 2003 at 5:59 pm
I would asume it has something to do with the fact that the port is tied to a cluster resource ether network or sql. Check that direction.
Wes
October 29, 2003 at 9:03 pm
Viewing 15 posts - 226 through 240 (of 508 total)