CoffeeGirl

Hi Everyone..


Hope someone can help me.. this is what i have done and what i'm getting..

First within sharepoint designer opened Data Source Library and opend Connect to a database, select Use custom connection string entred this string..

Data Source={MyServerName};Database={MyDBName};Integrated Security=SSPI;

Initial Catalog={MyDBName};Trusted_Connection=yes;

Uid={UserName};Password={Password};

Provider=SQLOLEDB;Provider=SQLOLEDB

then select ok, and then the next button and i keep getting...

The Selected authentication option saves the username and passord as clear text in the data connection. Other authors of this web site can access this information...

the only why to get to the next screen is to select cancel.. awy i do see the database connection within the Data Source Libary if i right click on it and select show data.. i get
"The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator."

i can see the data with in the desing view if i add the data source then add a gridview..

so i saved it... and when to sharepoint to see it and i keep getting this error

This control does not allow connection strings with the following keywords: ¡®Integrated Security¡¯, ¡®Trusted_Connection¡¯.

found info about removing this section of the web.config file with in the wwwroot folder

<tagMapping>

<add tagType="System.Web.UI.WebControls.SqlDataSource, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" mappedTagType="Microsoft.SharePoint.WebControls.SPSqlDataSource, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />

</tagMapping>

so did that and then i get this error:

The control type 'System.Web.UI.WebControls.SqlDataSource' is not allowed on this page. The type is not registered as safe.

HELP ME PELEASE GOING CRAZY LOL....

Thank you...




Re: SharePoint - Design and Customization Cant not connect to sql database

rote

CoffeeGir take it easy and don't go cray LOL Smile I

How did you remove the tag did you use remove like so :-

<tagMapping>

<!--
<add tagType="System.Web.UI.WebControls.SqlDataSource, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" mappedTagType="Microsoft.SharePoint.WebControls.SPSqlDataSource, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
-->
<remove tagType="System.Web.UI.WebControls.SqlDataSource, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</tagMapping>

Just copy and paste the above it should work like a charm.
You will notice i have commented out the first one and the second one starts with a remove.
Hope that helps

Patrick





Re: SharePoint - Design and Customization Cant not connect to sql database

CoffeeGirl

Ok i will hold off a bit for going crazy lol

i did the above.. and know i'm getting

The control type 'System.Web.UI.WebControls.SqlDataSource' is not allowed on this page. The type is not registered as safe.






Re: SharePoint - Design and Customization Cant not connect to sql database

rote

Ok CoffeeGirl

In your Web.config can you please locate

the safecontrol tag and in there you should see the below:

<SafeControl Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.WebControls" TypeName="SqlDataSource" Safe="False" AllowRemoteDesigner="False" />

if not please add it.

And it should be fine

Patrick





Re: SharePoint - Design and Customization Cant not connect to sql database

CoffeeGirl

Hi There it is there..






Re: SharePoint - Design and Customization Cant not connect to sql database

CoffeeGirl

so it's there and still not working any ideas on how i can do this

Thank you...






Re: SharePoint - Design and Customization Cant not connect to sql database

CoffeeGirl

Hi There,

have another question...

does this have to be in kerberos mode.. because it is still not working...

Thank you..







Re: SharePoint - Design and Customization Cant not connect to sql database

rote

Coffee what error are you now getting
I have no idea what could be wrong if you are still getting that error Sad
Try reseting your IIS please and let me know.
Patrick





Re: SharePoint - Design and Customization Cant not connect to sql database

Capt

In the previous post under the web config safe assembly for the sql set it to true and allowremote designer to true.

It worked for me. Safe=True