﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Re-invent ASP.NET Hosting Community / Web Site Development / Design / SQL 2008/2005/2000 and MS Access Database  / ASP.Net Web Site Administration Tool / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>Re-invent ASP.NET Hosting Community</description><link>http://community.re-invent.com/</link><webMaster>community@re-invent.com</webMaster><lastBuildDate>Thu, 20 Nov 2008 10:08:12 GMT</lastBuildDate><ttl>20</ttl><item><title>ASP.Net Web Site Administration Tool</title><link>http://community.re-invent.com/Topic468-4-1.aspx</link><description>&lt;P&gt;Hi Folks, I could use some help if you have time. I have a server on my LAN at home running XP Pro, IIS 5.1, SQL, Server Express, And .Net FX 2.0. I'm trying to get the Web Site Administration Tool to work on the Lan. I'm using the server for testing.&lt;/P&gt;&lt;P&gt;I want to connect in the same manner as the link but connect to my server.&lt;/P&gt;&lt;P&gt;&lt;a target=_blank href="http://support.re-invent.com/article.aspx?id=10353" target=_blank&gt;http://support.re-invent.com/article.aspx?id=10353&lt;/A&gt;&lt;/P&gt;&lt;P&gt;I have my site set up on the remote LAN server and everthing works great. I can set up new users from the Create User Wizard on one of the site pages. The new user can log in and everything works fine.&lt;/P&gt;&lt;P&gt;My current problem is that I can't access the site through the Web Site Administration Tool on my developement computer. I want to access the site to modify roles. users, etc. with the Tool.&lt;/P&gt;&lt;P&gt;When I open the Tool and click on "Security", I get a message &lt;SPAN id=ctl00_ctl00_content_content_exceptionMessageLabel1 style="FONT-WEIGHT: bold"&gt;Login failed for user ''me" The user is not associated with a trusted SQL Server connection.&lt;BR&gt;&lt;/SPAN&gt;&lt;BR&gt;&lt;/P&gt;&lt;P&gt;cString is:&lt;/P&gt;&lt;P&gt;&amp;lt;remove name="LocalSqlServer" /&amp;gt;&lt;BR&gt;    &amp;lt;add name="LocalSqlServer" connectionString="data source=ServerName;Integrated Security=False;Initial Catalog=aspnetdb.mdf;User Instance=true;user id=me;password=mypassword" providerName="System.Data.SqlClient"/&amp;gt;&lt;/P&gt;&lt;P&gt;I don't know how to set a User ID and Password on the server for the connection. You have this command in your setup procedure:&lt;/P&gt;&lt;P&gt;&lt;FONT face=Tahoma&gt;aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face=Tahoma&gt;Can I use this on SQL Express? I don't know the syntax. Is it like this:&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face=Tahoma&gt;aspnet_regsql.exe -S myServer -U myLogin -P myPword -A all -d apsnetdb.mdf&lt;/FONT&gt;&lt;BR&gt;&lt;/P&gt;&lt;P&gt;I have &amp;lt;roleManager enabled="true" /&amp;gt; and &amp;lt;authentication mode="Forms"/&amp;gt; in the web.config and no providers listed in web.config&lt;BR&gt;&lt;/P&gt;&lt;P&gt;I cannot connect with various mods of the connectionString.&lt;/P&gt;&lt;P&gt;&lt;B&gt;Can you help me, please?&lt;/B&gt;&lt;/P&gt;</description><pubDate>Tue, 02 Jan 2007 21:25:00 GMT</pubDate><dc:creator>dotNetDude</dc:creator></item></channel></rss>