| Subject: Vista - Msquery MsExcel and SQL data works in XP but not in VISTA |
| Group: microsoft.public.windows.vista.security |
| Date: 9/21/2008 2:03:27 PM |
| From: ian.tiesdell@hotmail.co.uk |
Hi i have an excel workbook that opens an msquery to a SQL database in auto_open macro. This is made available via Sharepoint to our users, the problem is running it on a Vista PC. Tt work fine with the many XP pc's in the company, unfortunately the CEO has Vista and it doesn't work (the trusted location is set in Excel) i get the following errors connection failed SQLState: '01000' SQL Server Error:5 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()) Connection failed SQLState: '08001' SQLServer Error 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied it does exist and is error free because i tried the worksheet before during and after tryng it on Vista Any ideas / pointers would be much appreciated Ian |
| Back |
| Subject: Re: Vista - Msquery MsExcel and SQL data works in XP but not in VISTA |
| Group: microsoft.public.windows.vista.security |
| Date: 9/21/2008 2:24:39 PM |
| From: Paul Montgumdrop [Email Address Protection] |
ian.tiesdell@hotmail.co.uk wrote: > Hi > > i have an excel workbook that opens an msquery to a SQL database in > auto_open macro. This is made available via Sharepoint to our users, > the problem is running it on a Vista PC. Tt work fine with the many > XP pc's in the company, unfortunately the CEO has Vista and it > doesn't > work (the trusted location is set in Excel) > > > i get the following errors > > > connection failed > SQLState: '01000' > SQL Server Error:5 > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen > (Connect()) > Connection failed > SQLState: '08001' > SQLServer Error 17 > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not > exist > or access denied > > > it does exist and is error free because i tried the worksheet before > during and after tryng it on Vista > > > Any ideas / pointers would be much appreciated I would say the Excel.exe is not running with Run As Administrator to give it the needed privileges on Vista during a privileged escalation process. 1) set the exe to run with Run As Administrator 2) turn UAC off 3) use the Super Administrator account on Vista to give the Admin full rights, like it would have on XP when a Admin\user is running an application on XP, look it up use Google. |
| Back |
| Subject: Re: Vista - Msquery MsExcel and SQL data works in XP but not in VISTA |
| Group: microsoft.public.windows.vista.security |
| Date: 9/21/2008 8:30:47 PM |
| From: ian.tiesdell@hotmail.co.uk |
On Sep 22, 9:24=A0am, Paul Montgumdrop <P...@Montgumdrop.com> wrote: > ian.tiesd...@hotmail.co.uk wrote: > > Hi > > > i have an excel workbook that opens an msquery to a SQL database in > > auto_open macro. =A0This is made available via Sharepoint to our users, > > the problem is running it on a Vista PC. =A0Tt work fine with the many > > XP pc's in the company, unfortunately the CEO has Vista and it > > doesn't > > work (the trusted location is set in Excel) > > > i get the following errors > > > connection failed > > SQLState: '01000' > > SQL Server Error:5 > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen > > (Connect()) > > Connection failed > > SQLState: '08001' > > SQLServer Error 17 > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not > > exist > > or access denied > > > it does exist and is error free because i tried the worksheet before > > during and after tryng it on Vista > > > Any ideas =A0/ pointers would be much appreciated > > I would say the Excel.exe is not running with Run As Administrator to > give it the needed privileges on Vista during a privileged escalation > process. > > 1) set the exe to run with Run As Administrator > 2) turn UAC off > 3) use the Super Administrator account on Vista to give the Admin full > rights, like it would have on XP when a Admin\user is running an > application on XP, look it up use Google.- Hide quoted text - > > - Show quoted text - Many thanks for your speedy reply - i'll have a look at this (its the only Vista desktop in the building but it is the CEO's) |
| Back |