Yes, that's right. database server level settings need be set at the instance level and persist regardless of the node. So, if you set the max memory paramter...

Is the SQL Server service running?

Start>Run>Services.msc

Sort by name and look at the status of the sql server service. If the service is not started, try starting it.

NJ-DBA (9/1/2011)

---

I'm sure it's not the answer you want to hear, but in your shoes, I'd consider starting over with the client... uninstall and resinstall everything, including sql server components......

I'm sure it's not the answer you want to hear, but in your shoes, I'd consider starting over with the client... uninstall and resinstall everything, including sql server components... maybe...

manually register the .dll's- any difference?

NJ-DBA (8/29/2011)

---

Has there recently been any change to evironement variables like the PATH? I remember exact same issue occurred when multiple versions of client tools are installed.... some issue...

Has there recently been any change to evironement variables like the PATH? I remember exact same issue occurred when multiple versions of client tools are installed.... some issue with...

>> Open Management Studio

>> On the menu bar click on Help

>> About

should show how many days left.

to Upgrade:

1. Start the SQL Server Installation Center

2. Select "Maintenance"

3. Click "Edition...

NJ-DBA (8/26/2011)

---

best solution... start over with a server that doesnt include a hyphen in the name...

a possible workaround... use the host file to create an alternative name for the server......

best solution... start over with a server that doesnt include a hyphen in the name...

a possible workaround... use the host file to create an alternative name for the server... not...

SSIS is a great way to automate imports of datafiles... if you need to import and manipulate .csv data into SQL Server SSIS is the way to do it.

NJ-DBA (8/26/2011)

---

I have to say- I find it surprising that one client it works without specifying the port number and another you must specify the port number. To me...

I have to say- I find it surprising that one client it works without specifying the port number and another you must specify the port number. To me this...

Can you please rephrase your question? This doesnt really make sense. What are you trying to determine?

If:

-Client A can connect via servername\instance name

-Client B can not connect via servername\instance name

-Cleints A and B can both connect when specifying port

Then this is a SQL browser issue. ...