I have created a view and have connected to the view through Excel. I am trying to give a user acceess and give him the ability to refresh the excel document. I have given the user access rights to view.
Everything works fine in my environment but when I send a link to a Microsoft Data Connection or send an Excel file with everything already set up to the user, I get the following error:
Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myuser'
I tried to follow the following documentation but the solutions don't work: http://support.microsoft.com/kb/165866Can someone help me?
asked Jan 24 '12 at 08:09 AM in Default
If you look in the SQL Server log, you should see an entry for the failed login. You'll also find the "state" of the issue which then you can go to here: http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx to gain a little more insight as to what the problem might be.If you can let us know what the state of the error might be, that might give us a clue.
answered Jan 24 '12 at 08:42 AM
If you are setting up everything in Excel and then sending the user the Excel worksheet (xls or xlsx) I do not believe the ODBC connection information is sent along with it.
You might want to look at sending them a [query file] that will save the connection information and query. When they open this file up it will pull the information into a Excel worksheet for them.: http://office.microsoft.com/en-us/excel-help/about-sharing-data-connections-HP005262328.aspx
answered Jan 24 '12 at 09:55 AM