Hi there,

During the setup of Sql Server 2005 Standard/Express, a failure occurs :

---------------------------------------------------------------------------------------------------
SQL Server can't connect to the database service for the server
configuration. Error is :
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. "
---------------------------------------------------------------------------------------------------

The thing is that, if I have a look when the failure occurs, I can see that
the Sql Service is running (under the NetWork service account), but this
service doesn't appear in the Sql Server configuration manager. When I
cancel the setup, the rollback uninstall this service.

Any idea ?

Philippe

Hello Philippe,

I understand that you encounter logon failure when installing SQL 2005
standard/express edition. Based on my experience, this issue might be
caused by some third party service such as Antivirus etc.

If applicable, I suggest that you stop all services except these services
and try to install SQL 2005 at this time

Alerter
Computer Browser
DHCP Client
Directory Replicator
Event Log
License
Logging
Net Logon
Network DDE
Network DDE DSDM
Plug n Play
NT LM Security Support Provider
Remote Procedure Call (RPC) Locator
Remote Procedure Call (RPC) Service
Server
Spooler
TCP/IP Netbios er
Workstation

If the issue persists, please get the sql setup log under following folder
and send it to me. You could remove "online" from my disaplayed email
address.

%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG

I look forward to your update. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

you were absolutely right. I've succedeed ! What clue make you suspect the
antivirus ? Is the situation identical with Sql 2008 ?

Thanks a lot

Hello Phil,

Actually I saw similar issues before. Some antivirus programs may cause the
problem and I think the problem would occur for SQL 2008 because it's
compatiblity issue on Antivirus programs. You may want to contact the
vendor to get more information on this.

If you have any further questions or concerns, please feel free to let's
know. Thank you.


Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,
""Peter Yang[MSFT]"" <petery@online.microsoft.com> a écrit dans le message
de newsngPrIAsIHA.4284@TK2MSFTNGHUB02.phx.gbl...
> Hello Phil,
>
> Actually I saw similar issues before. Some antivirus programs may cause
> the
> problem and I think the problem would occur for SQL 2008 because it's
> compatiblity issue on Antivirus programs. You may want to contact the
> vendor to get more information on this.
>
> If you have any further questions or concerns, please feel free to let's
> know. Thank you.
Yes I have. Now, if I want to access a remote database with a sql login, I
can't ! If think this is a similar issue...

Philippe

Hello Philippe,

I'd like to confirm the following information:

1. Is the remote SQL Server also SQL 2005? Is it configured as "mixed mode"
authentication?

2. Does the issue occur when you try to log on to the SQL Server via a sql
login from local console of that server?

3. Does the issue only occur with a specific remote SQL server or any
remote SQL Server?

This sql login issue doesn't seem to relate to the original setup problem.
If so, you may want to submit a new thread so that it could be traced
better in the community.

If you have any update, please feel free to let's know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Helo Peter,
""Peter Yang[MSFT]"" <petery@online.microsoft.com> a écrit dans le message
de news:qu2wj8KwIHA.4216@TK2MSFTNGHUB02.phx.gbl...
> Hello Philippe,
>
> I'd like to confirm the following information:
>
> 1. Is the remote SQL Server also SQL 2005? Is it configured as "mixed
> mode"
> authentication?
Yes
>
> 2. Does the issue occur when you try to log on to the SQL Server via a sql
> login from local console of that server?
Yes. I can't use windows authentication since my account is on a different
domain.
>
> 3. Does the issue only occur with a specific remote SQL server or any
> remote SQL Server?
I can't say. I have 2 instances only.

> This sql login issue doesn't seem to relate to the original setup problem.
> If so, you may want to submit a new thread so that it could be traced
> better in the community.
ok

Thanks

Hello Phil,

Since you only have 1 remote instance, it's not easy to isolate the issue.
I'd like to know the remote server/instancename? Is it the default instance
or named instance?

I sugget that you try:

1. check if you can ping remote server

ping remoteservername

2. Check if you can telnet 1433 if remote sql server is default instance

telnet remoteserver 1433


3. Try to use osql to connect to remote server using different protocals:

TCP:

osql -S tcp:servername\instancenmae,portnumber -U username -P passowrd

For example:

osql -S tcp:server1\instance1,1433 -U sa -P mypassword


named pipes:

osql -S np:\\servername\pipe\sql\query -U username -P passowrd


osql -S np:\\ComputerA\pipe\MSSQL$instancename\sql\query -U username -P
passowrd

If you have any update, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

""Peter Yang[MSFT]"" <petery@online.microsoft.com> a écrit dans le message
de news:cYaKDzhwIHA.4216@TK2MSFTNGHUB02.phx.gbl...
> Hello Phil,
>
> Since you only have 1 remote instance, it's not easy to isolate the issue.
Yes but I can connect a Sql client on a XP machine on this remote instance.
Besides, I realized that I have a second Sql Express instance on this remote
machine, and I can't connect to this instance...
> I'd like to know the remote server/instancename? Is it the default
> instance
> or named instance?
This is a named instance, which contains SharePoint databases.
>
> I sugget that you try:
>
> 1. check if you can ping remote server
I can ping it

> ping remoteservername
>
> 2. Check if you can telnet 1433 if remote sql server is default instance
>
> telnet remoteserver 1433
My remote server has a dynamic TCP/IP configuration. Now I change it to make
it static but now my SharePoint is not working anymore (althought I can
still connect locally bwith tha database). I then reset the configuration to
"dynamic" but no luck, my SharePoint site can't open (I've got a
configuration erreor !). I will try to fix that. Even with a static config,
Telnet tcp doesn't work.
>
> 3. Try to use osql to connect to remote server using different protocals:
>
> TCP:
>
> osql -S tcp:servername\instancenmae,portnumber -U username -P passowrd
>
> For example:
>
> osql -S tcp:server1\instance1,1433 -U sa -P mypassword
The answer is that it can't find any ODBC driver.

Thanks a lot

Sharepoint is running now !
Something I can add: I can see the remote instance databases from Visual
Studio 2008 (using a DataConnection). So this is definitely my sql client
which has a problem.

Hello Phil,

Thank you for your reply. I understand that the following situation for
this issue:

1. You can use visual studio to connect to remote SQL instance hosting
Sharepoint database.

2. telnet remoteserver portnumber doesn't work.

3. osql -S tcp:server1\instance1,1433 doesn't work with the error message
"can't find any ODBC driver."

Going forward, I'd like to get the following information:

1. Which client tool do you use to connect to remote sql instance when you
first saw the error?

2. Please collect the error log of remote SQL instance and send it to me.
Please remove "online" from my displayed email address.

C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG

3. Do you have firewall enabled on the remote sql server?

4. If you use sqlcmd (which uses sql native client protocal) to connect,
what's the result?


sqlcmd -S tcp:server1\instance1,port number

5. Use profiler on remote SQL instance to audit logins to get more details
information when connecting from Visual Studio and from client tools.
Please enable "audit sucessful login" and "audit failed" events in profiler
trace

Using SQL Server Profiler
http://msdn2.microsoft.com/en-us/library/ms187929.aspx

SQL Server Profiler Reference
http://msdn2.microsoft.com/en-us/library/ms173757.aspx


If you have any update, please feel free to let's know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter,

for some reason, the connection is working now... Perhaps a parameter has
been changed on the server, I can't say. I would have liked to understand
why my connection didn't work previously, but I think that the result of my
investigation is not guaranted, and besides I've got plenty of things to do
!

Thanks again for you .

Philippe