Sunday, March 25, 2012

Authentication Problems

We have an application which uses a SQL Server 7 database installed locally
on laptops. This then replicates with a central server. The laptops, server
etc are all on the same domain and the database uses Windows Authentication
only.
Everything works fine when running W2K.
However following the installation of SQL Server 7 and the app on laptops
running XP SP2 we are experiencing problems. The app runs fine when the user
is VPNed into the network but when they are working remotely with only their
local databases problems occur.
Usually the app authenticates seamlessly with the local database but under
XP SP2 a dialog entitled 'SQL Server Login' is displayed and access to the
database is not allowed.
There are also issues in relation to the running of the SQL Server Agent.
When working remotely users cannot start the service properly, they receive
the following message :
'The sqlserveragent service on local computer started and then stopped.
Some services stop automatically if they have nothing to do , for example,
the performance logs and alerts service'.
My suspicion is that it is an XP SP2 issue.
There may be issues related to the installation of IIS as well but I'm not
sure.
Any help to solve this problem would be gratefully appreciated.
Thanks,
DD.
Yeah, XPSP2 is your culprit there.
Make sure you've followed these articles:
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
Contains links to articles that you can use to help you configure Windows
Firewall to permit access for SQL Server, Analysis Services, and MSDE.
http://support.microsoft.com/default...b;en-us;841249
Microsoft SQL Server: FAQ: How Windows XP Service Pack 2 (SP2) Affects SQL
Server and MSDE
Get answers to frequently asked questions about how Windows XP Service Pack
2 (SP2) affects installations of SQL Server 2000 and MSDE.
http://www.microsoft.com/sql/techinf...inxpsp2faq.asp
Donna Lambert
"Dave52" wrote:

> We have an application which uses a SQL Server 7 database installed locally
> on laptops. This then replicates with a central server. The laptops, server
> etc are all on the same domain and the database uses Windows Authentication
> only.
> Everything works fine when running W2K.
> However following the installation of SQL Server 7 and the app on laptops
> running XP SP2 we are experiencing problems. The app runs fine when the user
> is VPNed into the network but when they are working remotely with only their
> local databases problems occur.
> Usually the app authenticates seamlessly with the local database but under
> XP SP2 a dialog entitled 'SQL Server Login' is displayed and access to the
> database is not allowed.
> There are also issues in relation to the running of the SQL Server Agent.
> When working remotely users cannot start the service properly, they receive
> the following message :
> 'The sqlserveragent service on local computer started and then stopped.
> Some services stop automatically if they have nothing to do , for example,
> the performance logs and alerts service'.
> My suspicion is that it is an XP SP2 issue.
> There may be issues related to the installation of IIS as well but I'm not
> sure.
> Any help to solve this problem would be gratefully appreciated.
> Thanks,
> DD.

No comments:

Post a Comment