connect to server via intranet - how is it done (new to this)

Hi all!

I have msde2000 on one machine. want to connect to it from other machine. both machines are connected via a switch with integrated firewall.

Do I need to set up this firewall to enable connections? Like opening ports for msde in the virtual servers settings of the firewall?

If I do this, will that make my sql-server visible and accessible to the internet?

Or should I be able to find my sql server without such steps. And if so how?

networking is up and i can access folders of both machines via the intranet. Is that enough or do i need more settings here?

Let's say the machine and thus the server is called Alpha. What goes into my connectionstring from the other machine?

this wont be enough, right?
strconn = "Provider=SQLOLEDB;" & _
"Data Source="Alpha";"

Please shed some light on these questions.

tia

KumaFirst you will have to configure the ODBC settings in your machine. Make sure the datasource name is "alpha" , the same as the server name. You can then use "alpha" in the connection string. The code that is required is

'VB Code starts here

Set db = New ADODB.Connection

db.Properties("Data Source").Value = "alpha"
db.Properties("Initial Catalog").Value = "Northwind"
db.Properties("User ID").Value ="XXX"
db.Properties("Password").Value = "YYYYY"
db.Open

'ASP Code starts here
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB;Data Source=alpha;Initial Catalog=Northwind;User Id=XXX;Password=YYY"

'CODE ENDS HERE

Roshmi Choudhury

Confusion in AWE

suppose i have enabled only AWE option in sql server but i didn't add 3

GB switch in boot.ini. in this case what will be the effect on physical memory?

Having /PAE in your boot.ini file allows a 32-bit OS to access more than 4GB ofRAM using AWE. Using /3GB in the boot.ini file only reserves 1GB for the OS, and allows applications to use 3GB of RAM instead of the normal 2GB of RAM.

http://support.microsoft.com/kb/274750

http://msdn2.microsoft.com/en-us/library/ms175581.aspx

|||

/PAE can you be used only for intel

In case other model what can be used to access more than 4GB of memory

|||

Hi Satyanarayana,

what platform is your sql machine. Also is it 32bit or 64 bit? And how much RAM is on the box.

Jag

|||we are using AMD opteron processor. it is 32 bit and about 4GB RAM|||

With only 4gb of RAM there is no need for /PAE. Using /3GB will allow for use of up to 3GB of Virtual address space by SQL Server. This will likely be sufficient for a machine with 4GB of RAM.

|||

AWE will be in effect with or without the /3GB switch. The AWE mechanism require the process using it to "map" the memory into a window in virtual memory. The size of this window will be greater (and therefore more RAM could be mapped simulataneously if the /3GB switch is used)

Thanks, Ron D.

|||today it is 4GB. tomorrow definitely physical memory will be increased (say 8 GB). in that case what can done for non intel machines to use more than 3GB of memory|||how do we know the AWE is in effect?|||

The following message should be in the errorlog:

"Address Windowing Extensions is enabled. This is an informational message only; no user action is required."

Thanks, Ron D.