Installing a SharePoint server using an external SQL server on a non domain environment

[Miguel J. E. Branco da Silva]

Hi

I have a SQL server 2000 SP3a installed on a stand alone server . This SQL
server serves several applications we are running as their DB server.

We want to make some experiments with a SharePoint Portal Server (from now
on SP) and I set up a new stand alone Windows 2003 server to install it. My
idea was to use our SQL server to be the DB server for the SP!

I've instaled SP choosing the option without database instalation. Both SP
server and services installed ok. When it started the process to configures
the SP and create the database on the SQL server, I became stucked because
I'm unable to connect to the SQL server and create the database for SP.

According to what I've read till now the only way to the SP server contact
and make a successfully login on the SQL server is if both servers are on a
Windows Domain... Is there any way to make the SP server to contact the SQL
server but instead of using a Windows login, using an SQL server login (I
have the SQL server in Mixed mode authentication) to access the database and
create the SP database?

Thank you very much!

Best regards
Miguel Branco da Silva

[GregD]

From what I know I think it needs to be a windows account e.g.
DOMAIN\Administrator

Id be suprised if it will even work on mixed mode auth in sql server as some
people have had issues creating a portal when sql is installed in this way.

Also make sure your server with sql on has the latest MDACs installed.

Greg

Post by Miguel J. E. Branco da Silva
Hi
I have a SQL server 2000 SP3a installed on a stand alone server . This SQL
server serves several applications we are running as their DB server.
We want to make some experiments with a SharePoint Portal Server (from now
on SP) and I set up a new stand alone Windows 2003 server to install it. My
idea was to use our SQL server to be the DB server for the SP!
I've instaled SP choosing the option without database instalation. Both SP
server and services installed ok. When it started the process to configures
the SP and create the database on the SQL server, I became stucked because
I'm unable to connect to the SQL server and create the database for SP.
According to what I've read till now the only way to the SP server contact
and make a successfully login on the SQL server is if both servers are on a
Windows Domain... Is there any way to make the SP server to contact the SQL
server but instead of using a Windows login, using an SQL server login (I
have the SQL server in Mixed mode authentication) to access the database and
create the SP database?
Thank you very much!
Best regards
Miguel Branco da Silva