P
PaulHMA
Hi
I have an Excel file that connects to a SQL Server database to refresh data
in the Excel file. I am experiencing a problem, and I am wondering if I am
doing something wrong or if its a bug in Excel 2007.
If I go into the Workbook Connections window, and click on Properties for a
connection and click OK (doesn't matter if you make changes or not), I get a
'SQL Server Login' error that says 'Connection Failed, SQL State:'08004'
Error 4060 and the message 'Server rejected the connection; Access to the
selected database is denied'.
When I click OK, I get the SQL Server Login window. I click OPTIONS to
expand the window and the database name is always garbled. Sometimes it has
the database name twice, sometimes it has the database name followed by
several characters that look like asian characters and sometimes it just has
misc characters appended to the database. Each time I have to click on the
database name dropdown field and reselect the database name.
Has anyone seen this happen?? Does anyone know if I am doing something wrong?
Is this a bug I should report to Microsoft?
I have an Excel file that connects to a SQL Server database to refresh data
in the Excel file. I am experiencing a problem, and I am wondering if I am
doing something wrong or if its a bug in Excel 2007.
If I go into the Workbook Connections window, and click on Properties for a
connection and click OK (doesn't matter if you make changes or not), I get a
'SQL Server Login' error that says 'Connection Failed, SQL State:'08004'
Error 4060 and the message 'Server rejected the connection; Access to the
selected database is denied'.
When I click OK, I get the SQL Server Login window. I click OPTIONS to
expand the window and the database name is always garbled. Sometimes it has
the database name twice, sometimes it has the database name followed by
several characters that look like asian characters and sometimes it just has
misc characters appended to the database. Each time I have to click on the
database name dropdown field and reselect the database name.
Has anyone seen this happen?? Does anyone know if I am doing something wrong?
Is this a bug I should report to Microsoft?