QL Server Configuration Manager, qustion, what is what, and whats it used for

Question

QL Server Configuration Manager, qustion, what is what, and whats it used for

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Generally speaking, it's best to separate IIS and web pages/application from SQL Server, but I understand that can't always be done.

SQL Server Native Client is a way to connect to SQL Server. There are other ways. You have to configure both things. I recommend searching for both items in MSDN. There's a fair amount of material about both. A lot more than can be covered in a simple forum post.

Disabling "Shared Memory" means that applications on the same server, which you have, have to use TCP/IP to connect to SQL. You'll need to review the effects of that, but usually Shared Memory is the best way to have local applications access the server.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

brownghost SSC Enthusiast Points: 173 More actions · Answer 2

thanks ill re enable shared memory..

what about this, i did not see answer for that question?

1. Why are there both 32 and one one called anything = i thing its 64 bit.

I have disable all the things in the 32 bit thing..

Was that smart??

Or if i configure them both, will it give me even better performances, like under DDos attacks and no more connections will there be both 32 bit and 64 bit connections available???

Thanks
BrownGhost

GSquared SSC Guru Points: 260824 More actions · Answer 3

brownghost (6/2/2011)
thanks ill re enable shared memory..
what about this, i did not see answer for that question?
1. Why are there both 32 and one one called anything = i thing its 64 bit.
I have disable all the things in the 32 bit thing..
Was that smart??
Or if i configure them both, will it give me even better performances, like under DDos attacks and no more connections will there be both 32 bit and 64 bit connections available???

I'm afraid I don't understand that question as it's worded. Are you talking about 32-bit vs 64-bit? On what?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

brownghost SSC Enthusiast Points: 173 More actions · Answer 4

native client.. look in picture..

why are there 2??

Thanks
BrownGhost

GSquared SSC Guru Points: 260824 More actions · Answer 5

Because there are 32-bit and 64-bit drivers. Unless you can be certain only one or the other will ever be used, you're probably better off leaving both running.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon