Problem installing STS - does not recognize sa SQL server account

[Android]

I have installed SQL Server and Analysis Services and their SP3's on a Windows 2000 server. In trying to install STS, in the early screen where the SQL Sever database setver name and database admin user name is requested, the roor I get is:
Setup Error:
Cannot connect to the databse server using the specified SQL Server account
The reasons could be:
1.. The SQL Server logon name and password combination is incorrect
2.. The logon name is not an SQL Server account
To get around this I created a separate SQL Sever account with all the Server Roles and access to databases. I get the same error using this account.

I had a similar problem when installing the MSDE version. That was resolved by using a recommendation from this group to use "Administrator" as the ID, with no password. However that does not work here.

Any suggestions?

 

[Gary Chefetz [MVP]]

Android:

Have you tried using the built-in SA account?

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use cut and paste for these.


I have installed SQL Server and Analysis Services and their SP3's on a Windows 2000 server. In trying to install STS, in the early screen where the SQL Sever database setver name and database admin user name is requested, the roor I get is:
Setup Error:
Cannot connect to the databse server using the specified SQL Server account
The reasons could be:
1.. The SQL Server logon name and password combination is incorrect
2.. The logon name is not an SQL Server account
To get around this I created a separate SQL Sever account with all the Server Roles and access to databases. I get the same error using this account.

I had a similar problem when installing the MSDE version. That was resolved by using a recommendation from this group to use "Administrator" as the ID, with no password. However that does not work here.

Any suggestions?

 

[Buck]

Try creating a test ODBC to the database before the
install.

-----Original Message-----
I have installed SQL Server and Analysis Services and

their SP3's on a Windows 2000 server. In trying to
install STS, in the early screen where the SQL Sever
database setver name and database admin user name is
requested, the roor I get is:

Setup Error:
Cannot connect to the databse server using the specified SQL Server account
The reasons could be:
1.. The SQL Server logon name and password combination is incorrect
2.. The logon name is not an SQL Server account
To get around this I created a separate SQL Sever

account with all the Server Roles and access to
databases. I get the same error using this account.

I had a similar problem when installing the MSDE

version. That was resolved by using a recommendation from
this group to use "Administrator" as the ID, with no
password. However that does not work here.

 

[Android]

Originally I was using ID=sa, which was setup by SQL
Server's Setup when I installed the SQL server.

If you mean the account called "BUILTIN". I tried it just
now and got the same error. I notice this account uses
Windows authentication.

Android.

-----Original Message-----
Android:

Have you tried using the built-in SA account?

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to

the news group, use cut and paste for these.

I have installed SQL Server and Analysis Services and

their SP3's on a Windows 2000 server. In trying to install
STS, in the early screen where the SQL Sever database
setver name and database admin user name is requested, the
roor I get is:

Setup Error:
Cannot connect to the databse server using the specified SQL Server account
The reasons could be:
1.. The SQL Server logon name and password combination is incorrect
2.. The logon name is not an SQL Server account
To get around this I created a separate SQL Sever

account with all the Server Roles and access to databases.
I get the same error using this account.

I had a similar problem when installing the MSDE

version. That was resolved by using a recommendation from
this group to use "Administrator" as the ID, with no
password. However that does not work here.

 

[Android]

Buck,
I'm afraid I'm not familiar enough with SQL Server to know
exactly what that means or how to do create it. Could you
please elaborate a little.

Android.

 

[Gary Chefetz [MVP]]

Android:

This isn't going to be easy without some familiarity with SQL. I don't
suppose I can simply ask whether you've enabled TCPIP on the SQL Server?
Let's try a few things:

1) Open SQL Enterprise Manager and expand the SQL Server Group
2) Right click on the machine icon labeled with your server name and select
properties
3) Click on the general tab and then click the Network Configuration button
at the bottom
4) Make sure that TCP/IP is enabled on the right side along with Named Pipes

Was TCPIP enabled? If not this could be your problem.

5) Click on the Security Tab
6) Make sure that SQL Server and Windows radio button is selected under
Authentication

Were both authentication modes enabled when you got there? If not, this
could be your problem.

Are you logging into the server with an account that is a member of the
local administrator's group on the server? If not, this could be your
problem.

Let us know if this helps you move forward.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

 

[Android]

Hi Gary,

I appreciate you taking the time to kelp me in this.

I do have some familiarity with SQL (but I do need some pointers re where to
look for stuff).

Using your checklist below,
- TCP/IP is enabled (as are Named Pipes)
- SQL Server and Windows radio is selected (this is one of the checks I
did, folllowing the sequence in your book -- which is great btw)

I have the server just for testing out Project Server. I do logon to it
locally (using a remote desktop tool).

I had not installed SP3 for Microsoft SQL Server 2000 Desktop Engine (MSDE
2000) before because I did'nt think it was needed when using SQL Server.
Installed it just now to remove it as a potential proble.

Still getting the same error however.

Android.

 

[Gary Chefetz [MVP]]

Android:

1) Is your logon a member of the local administrator's group on the server?

2) When you're installing (now that I know you're working through terminal
services or something else) are you at the server? If not, is the CD in the
server's drive? If not, how are you accessing the CD? Do you have direct
access to the server?

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

 

[Android]

Gary,
Yes - my logon is a member of the local administrator's group on the server
I am not at the server when installing.
a) I am at my normal office workstation, from where I launch the
terminal server to connect to the Windows 2000 server.
b) SQL Server is a trial version downloaded to the local disk on the
server. Installed from there.
c) The Project Server CD is on another server. It is mapped in my
Windows Explorer in the Windows 2000 server
d) I can probably work directly at the server if I need to. I assumed
that that is the same as getting to it via the terminal server, which I am
doing now.

In case this is relevant:
a) Windows 2000 server is Ver 5 (Build 2195L SP4)
b) SQL Server version is SP3: Microsoft SQL Server 2000 - 8.00.760

Android.

 

[Gary Chefetz [MVP]]

Android:

Assuming this has nothing to do with the fact that you're using the trial
version of SQL, are you mapping to the CD drive as a mapped drive or are you
simply accessing the share through a browse or a path? If you use the former
method, first map a drive on the server to the shared CD, so that you 're
installing from X:setup rather than \\server\share\setup, the install should
run. If you've already tried this with the CD mapped to a drive, and this is
occurring, I'll have to scratch my head some more, but I would still want
you to try from the actual console.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

 

[Android]

Gary,
I'm embarassed to say that this particular problem turned out to be that I
needed to indicate the computer name as well as the SQL Server name (as in
PROJECTSERV2\PROJECTSERVER) for the Database server. Perhaps this is
because I am using a terminal server, and am not at the server itself.

Having said that, I'm now troubleshooting error 76. I see the doc on this in
the book and on the web. Hoping that will solve it.

In answer to your question, I am installing from X:setup

Thanks for all your help.

Android.

 

[Gary Chefetz [MVP]]

Oh, a named instance!

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

 

[Android]

Hi Gary,

A final update on this string.

Re the Error 76 during STS install....

After checking the hints provided in your book and on the MS KB, the problem
remained. It turned out to be related to either the terminal server I was
using to acess the server, or the fact the CD was mapped.

When installing physically at the server with the CD also locally on that
server, the problem disappeared.

Regards,

Android.