SQL server

[eatingrice]

Hi,

Can the SQL server that is used by SMS 2.0 be used by other application beside SMS 2.0? I read somewhere that once the SQL server is assigned to SMS 2.0, no other application can use that SQL server.

thanks
;-p

 

[JudeToo]

We are using SQL 2000 and SMS 2.0 and use the SQL server for many other applications apart from SMS. No problems so far!

 

[eatingrice]

But during the installation of SMS and when it prompts to install SQL for you, there is a sentence stating that this SQL server is for SMS use only. Does anyone care to guess?

thanks
;-p

 

[Kaine]

I know that Microsoft reconmend that the SQL server is only used for SMS but is some places that is not cost effictive. I have a SMS server with SQL 2000 SP2 installed on it as I have a few other SQL servers around for our other applications.

I have run the SMS database on another SQL server and it does run ok. The performance is effected by the network and the number of requests that SMS tends to make to the SQL server.

If you move the SMS Database off the local machine SQL Server, you can not move it back.

 

[JudeToo]

Our SQL for SMS is on a separate server to the SMS server which was configured before installing SMS. Ther have been no performance issues (both servers are on the same bit of LAN)