|
| Can't connect to sql from sharepoint |
 |
Sat, 22 Jul 2006 12:08:58 +000 |
Hi Gurus, I am working on a Sharepoint project and have just started with this
technology. My Sharepoint server is on a different machine in our local intranet
and the SQL server is also located on another server. Now I have made a web part
which accesses the data from this sql server and shows the data in a web part
hosted on sharepoint. I have the web part without the connection working showing
only the static server controls on the page, but when I try to access the
database from the SQL Server, it doesn't connect. Any help will be highly
appreciated Happy coding,
Sachin
|
| Post Reply
|
| Re: Can't connect to sql from sharepoint |
 |
Sun, 30 Jul 2006 20:48:03 +000 |
Hi Sachin,
Have you setup the connection to the SQL database using SQL Authentication via
Sharepoint? By default it uses a MSDE locally installed database but can be
configured to use remote DB's too. Hope this helps.
Cheers,
Mark
|
| Post Reply
|
|
|
|
|
|
|
|
|
|