Thursday, March 29, 2012

Access denied after installing XP-SP2

Hi,
we have an app running in a network where the MSDE database is running on
win XP Pro PC. This has been running perfect since january but after
installing XP SP2 we get "SQL server does not exist or access denied" when
trying to run the app from a client. The app runs fine when started on the
server.
See my reply to "MSDE over the network". You may need to apply SP3 to MSDE.
Also, check the Windows Firewall in control panel and make sure that there
is an exception for sqlservr.exe or adjust the firewall accordingly to allow
incoming connections and broadcast packets from MSDE.
Jim
"Olav" <Olav@.discussions.microsoft.com> wrote in message
news:CB7DBF9C-07DA-4EF0-A822-C7F1EE5617D4@.microsoft.com...
> Hi,
> we have an app running in a network where the MSDE database is running on
> win XP Pro PC. This has been running perfect since january but after
> installing XP SP2 we get "SQL server does not exist or access denied" when
> trying to run the app from a client. The app runs fine when started on the
> server.
|||Thanks Jim,
making an exception for sqlserver.exe solved it!
"Jim Young" wrote:

> See my reply to "MSDE over the network". You may need to apply SP3 to MSDE.
> Also, check the Windows Firewall in control panel and make sure that there
> is an exception for sqlservr.exe or adjust the firewall accordingly to allow
> incoming connections and broadcast packets from MSDE.
> Jim
>
> "Olav" <Olav@.discussions.microsoft.com> wrote in message
> news:CB7DBF9C-07DA-4EF0-A822-C7F1EE5617D4@.microsoft.com...
>
>

No comments:

Post a Comment