Cannot remotely login to SQL Express since last windows update

Since today (after installing the latest Windows Updates !on my local machine!) I cannot login to a SQLExpress instance remotely; stating that it cannot find the server/instance.

The weird thing is: it only happens when I want to login to the non-default instance (sqlexpress 2005) (<IP>\<instance>).

When i'm using the default instance (msde 2000 or sqlexpress 2005 on another machine) (<IP>) it seems to work fine.

Does this have something to do with the windows updates, or is it just a coincedence?

Thanks in advance,

Remco RosThis is probably due to the update changed your setting. Just check your firewall on the server and put sqlbrowser.exe or UDP port 1434 to exception. Also make sure your sqlbrowser is running.|||we didn't install the updates on the server (yet) only on the client, so it must be a client thing.

Server:
Win 2003 / SQL Express 2005
Tcp/ip / named pipes: yes
sqlbrowser running
firewall exception on 1434udp 1433tcp.

tested on these client(s):
Local (without latest updates): CAN connect
XP Home with SQL Server Management studio (with lates windows updates): CANNOT connect
XP Pro with SQL Server Management studio Express (with lates windows updates): CANNOT connect
Win 2003 with SQL Server Management studio Express

(WITHOUT lates windows updates): CAN connect.

I see a pattern here...|||Are you sure your SQL Express listens on TCP port 1433 since your put 1433 in exception? What's the result if you run "telnet yourserver sql_tcp_port"? Can it connect? Could it be possible that IPSEC blocked the traffic between the problem machine if the IPSEC is on?

Cannot open database "database" requested by the login

We have a back end procedure that inserts/updates records in a table. Usually the upload file will have around 20k records. This procedure is called from our application which is designed using hibernate,struts.

Upload is getting completed. But after the upload is over and control goes to application code, we are again hitting the above table to get some details. Is this the root cause for the below issue?

This is what we get in application logs,

SQL Error: 4060, SQLState: S1000
2007-04-30 16:17:27,840 - ERROR [TP-Processor2] JDBCExceptionReporter.logExceptions(58) | Cannot open database "sdgebis" requested by the login. The login failed.
2007-04-30 16:17:27,840 - WARN [TP-Processor2] JDBCExceptionReporter.logExceptions(57) | SQL Error: 18456, SQLState: 28000
2007-04-30 16:17:27,840 - ERROR [TP-Processor2] JDBCExceptionReporter.logExceptions(58) | Login failed for user 'sa'.

2007-04-30 16:17:27,856 - WARN [TP-Processor2] SQLErrorCodeSQLExceptionTranslator.translate(279) | Unable to translate SQLException with errorCode '4060', will now try the fallback translator

What could be the reason for the above error?

Can anyone help me out please?Sounds like the two connections use different logins. And only one of them is mapped to a user in the database.

Cannot Install SQL2005 developer on Windows XP with Office 2007 pr

Have a new computer with Windows XP SP2 and all updates and Office 2007
professional.
When I try and install SQL2005 developer get an error 1706: Setup cannot
find the required file c:/program files/Microsoft Office11/1033/setup.chm
Any assistance is appreciated.
GavinHi Gavin,
This is actually a known bug and Microsoft is aware of it. Until a fix
is released you need to workaround it by uninstalling Microsoft Office
2003 Web Components from the Add/Remove Software control panel and then
re-run the SQL Server setup.
Hope this helps!
Jonathan
gavin wrote:
> Have a new computer with Windows XP SP2 and all updates and Office 2007
> professional.
> When I try and install SQL2005 developer get an error 1706: Setup cannot
> find the required file c:/program files/Microsoft Office11/1033/setup.chm
> Any assistance is appreciated.
> Gavin|||On Aug 2, 10:17 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Gavin,
> This is actually a known bug and Microsoft is aware of it. Until a fix
> is released you need to workaround it by uninstalling Microsoft Office
> 2003 Web Components from the Add/Remove Software control panel and then
> re-run the SQL Server setup.
> Hope this helps!
> Jonathan
>
> gavin wrote:
> > Have a new computer with Windows XP SP2 and all updates and Office 2007
> > professional.
> > When I try and install SQL2005 developer get an error 1706: Setup cannot
> > find the required file c:/program files/Microsoft Office11/1033/setup.chm
> > Any assistance is appreciated.
> > Gavin- Hide quoted text -
> - Show quoted text -
Interesting. I was curious to what it was looking in the Office11
folder, as I believe Office 2007 falls withing the Office12 arena. I
have the same setup (no Office Web Components) and had no issues
installing the SQL 2005 developer edition.

Cannot Install SQL2005 developer on Windows XP with Office 2007 pr

Have a new computer with Windows XP SP2 and all updates and Office 2007
professional.
When I try and install SQL2005 developer get an error 1706: Setup cannot
find the required file c:/program files/Microsoft Office11/1033/setup.chm
Any assistance is appreciated.
Gavin
On Aug 2, 10:17 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Gavin,
> This is actually a known bug and Microsoft is aware of it. Until a fix
> is released you need to workaround it by uninstalling Microsoft Office
> 2003 Web Components from the Add/Remove Software control panel and then
> re-run the SQL Server setup.
> Hope this helps!
> Jonathan
>
> gavin wrote:
>
> - Show quoted text -
Interesting. I was curious to what it was looking in the Office11
folder, as I believe Office 2007 falls withing the Office12 arena. I
have the same setup (no Office Web Components) and had no issues
installing the SQL 2005 developer edition.

Cannot Install SQL2005 developer on Windows XP with Office 2007 pr

Have a new computer with Windows XP SP2 and all updates and Office 2007
professional.
When I try and install SQL2005 developer get an error 1706: Setup cannot
find the required file c:/program files/Microsoft Office11/1033/setup.chm
Any assistance is appreciated.
GavinOn Aug 2, 10:17 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Gavin,
> This is actually a known bug and Microsoft is aware of it. Until a fix
> is released you need to workaround it by uninstalling Microsoft Office
> 2003 Web Components from the Add/Remove Software control panel and then
> re-run the SQL Server setup.
> Hope this helps!
> Jonathan
>
> gavin wrote:
>
> - Show quoted text -
Interesting. I was curious to what it was looking in the Office11
folder, as I believe Office 2007 falls withing the Office12 arena. I
have the same setup (no Office Web Components) and had no issues
installing the SQL 2005 developer edition.