Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2007-12-13 : 10:06:30
|
| Testing a client application which needs to connect to a Analysis Services DB on a different LAN. The application needs to resolve a <server_name>\<instance_name> to connect however we keep obtain an error message such as "Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running"Using ODBC we can connect to the SQL Engine on the SQL Server on the remote LAN and all accounts used are correct, to my knowledge I have installed OLE DB Provider for Analysis Services 9.0 but configured nothing. Can anyone explain where I can set up a connection to Analysis Sevices via OLE DB, ODBC or any other method required to allow our client to connect. So far I'm unable to see any OLAP connection methods in ODBC, only SQL Server or Native SQL.Any ideas? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-12-13 : 11:12:53
|
| if you have the client tools... check sqlbrowser if it's running...if not specify the port number which the instance is listening to in your connection informationHTH--------------------keeping it simple... |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-12-13 : 11:43:23
|
| try using the ip address instead of computer name.When you use the DSN, it will automatically put in the correct strings.If it is a file DSN, it will not store the password, you will have to do it manually later.Let us know of your success or otherwise.RegardsParesh MotiwalaBoston, USA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-13 : 23:19:12
|
| Can you connect to remote AS in ssms? |
|
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2007-12-14 : 11:00:43
|
| Can remote into the DB Engine from SMSS on the client, but not AS since it uses window authentication which is not working across LAN's. Using sa to access the engine works but this won't work for A. Any ideas? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-14 : 22:11:33
|
| Have to trust domains if they are not in same domain. |
|
|
|
|
|
|
How to connect to a SQL Instance in another LAN