A war between me and the network admin over the SQL EXPRESS

The network admin is saying that if I run my SQL Express in the office , it will intefere with his SQL Server 2000 connection and its services.

He asked me to disconnect myself from the network and do the work locally, what the!?

I had my SQL express remote connection set to Local and remote connections (using TCP/IP connection )

However , I really dont believe a SQL express running on my laptop would in anyway steal incoming connection to the SQL server 2000 running on the company server.

I now have my SQL express set to Local connections only, I would like to ask you guys does SQL express actually conflict with ANY services running on the same network ?
Thanks a million

No actually not. The service is a server based network service, in the meaning that you wil lhave to adress the server or any virtual device in a cluster environment to establish a connection to the service. SQL Server does not "steal" anything.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Here is more detail:

The company runs a Window Server 2003 and SQL Server 2000 and exchange server. The SQL server has reporting service and some other "advanced features" available to other interstate's branch network.

My laptop has a SQL Express installed, and the SQL express is set to Local and TCP/IP connection. My laptop has ethernet connection to the company network for internet access. The domain of my laptop is "AAA" and it is used by the software division only (no one else within the same domain is running SQL express).

The admin is complaining about the MSSQLEXPRESS from my SQL Express is somehow affecting the server. How this could affect the win server 2003 in anyway? As Jens say the SQL Express is a server based network service, what I think is, unless you attempt to set your win server to bypass incoming SQL request to my laptop IP address which has a SQL Express running, otherwise my SQL express should not be able to steal or disturb other services running on different IP.

I would like to see anyone who has this problem before?

Thanks

|||

Hi again,

to clarify: Compared to a telephone net, your telephone is called on a specific number. There is no chance that another telephone will ring and will be ansered if the caller dialed the right number. The telephone won′t force to aquire the incoming call. This is just a point2point connection.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks Jens, me and my supervisor also think the SQL server express is a server and the nature of a server is to sit there listenining for incoming connection and serve data on request. Yeah, there is no point the server application is playing up because someone runs a SQL express on different IP address on different domain, different IP.

We don't know what got into the network admin but what is certain is we will try to avoid this guy as much as possible.

a server hardware/environment question..

my network admin gives me two servers to set up for sql2k.
one will be for dev/testing qa, and one will be for production (mostly
reporting , not business operation type of stuff)
one server is good (raid 5), and the other is very good (raid 10).
the type of development will be in VB and data warehousing areas with
about 5 developers. the audience for the production reports can range
from a few people to a couple of hundreds of employees.
what would make the most sense in terms of server allocation?
should i give the best server to dev/testing? or to production (mainly
for reports)?
thank you.I tend to always give production the edge when building a dev server
(if I ca't have identical boxes); it will be more likely that
performance issues will show up on the weakest server, and I would
prefer to deal with them during development rather than production.
What would make this question interesting would be the processor and
memory specs as opposed to just the hard drive allocations...
HTH,
Stu|||On the development server when designing queries and report design
templates, you will probably want to work with more manageable subsets of
data, so the lessor equipped server should suffice. My development server is
typically just my PC with a local intall of SQL Server Developer edition.
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1121891806.861200.159450@.g49g2000cwa.googlegroups.com...
> my network admin gives me two servers to set up for sql2k.
> one will be for dev/testing qa, and one will be for production (mostly
> reporting , not business operation type of stuff)
> one server is good (raid 5), and the other is very good (raid 10).
> the type of development will be in VB and data warehousing areas with
> about 5 developers. the audience for the production reports can range
> from a few people to a couple of hundreds of employees.
> what would make the most sense in terms of server allocation?
> should i give the best server to dev/testing? or to production (mainly
> for reports)?
> thank you.
>|||> What would make this question interesting would be the processor and
> memory specs as opposed to just the hard drive allocations...
Yes, definitely if you can, have more than one processor in dev if your
production machines have > 1.
(Often problems due to parallel processing / plans can be missed because the
first time the queries have a chance to utilize that hardware is in
production.)
Also, try to have the same amount of memory, e.g. if production uses AWE
then you should have the same settings in dev (for the same reasons as
above).

'A required privilege is not held by the client' when re-initalization

Hi all,
the sys admin has changed the service a/c to another admin. id. But now, i can't start the replication jobs even re-created the publication and subscription with the new admin. id. Any advise? Thanks in advance!

'Executed as user: test.com\admin. A required privilege is not held by the client. The step failed.'

Hi Stephaine,

How do your admin change the service account? He/she might use Windows Service Control Manager to change account. To solve the issue, please refer to this KB article (http://support.microsoft.com/kb/911305/en-us).

Thanks,

Peng

|||an issue i found was that sql server agent and ssis had been changed to not use the local system account. this caused me to continually get the dreaded --> "A required privilege is not held by the client" error. i fought with it all afternoon and eventually updated the services to use the local system account and it worked. perhaps this will save some other as much time as i wasted.

'A required privilege is not held by the client' when re-initalization

Hi all,
the sys admin has changed the service a/c to another admin. id. But now, i can't start the replication jobs even re-created the publication and subscription with the new admin. id. Any advise? Thanks in advance!

'Executed as user: test.com\admin. A required privilege is not held by the client. The step failed.'

Hi Stephaine,

How do your admin change the service account? He/she might use Windows Service Control Manager to change account. To solve the issue, please refer to this KB article (http://support.microsoft.com/kb/911305/en-us).

Thanks,

Peng

|||an issue i found was that sql server agent and ssis had been changed to not use the local system account. this caused me to continually get the dreaded --> "A required privilege is not held by the client" error. i fought with it all afternoon and eventually updated the services to use the local system account and it worked. perhaps this will save some other as much time as i wasted.