Re: Need help with ASP.NET website administration tool! - Can't connect to the database when clicked on (AspSqlProvider) test link!

Hello Dominick,
Thanks for the quick reply. I have done as you directed but no luck
yet and a I am not sure if I have done it right.
Here is the ConnectionStrings code from the machine.config file
*********************************************************************
<connectionStrings>
<!--<add name="LocalSqlServer" connectionString="data
source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User
Instance=true" providerName="System.Data.SqlClient" />-->


<add name="LocalSqlServer" connectionString="data
source=.\DEV\SQLDM2005;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User
Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>
********************************************************************
In the above code I have commented out the original line of connection
string as you see and copy pasted the same line and changed the
datasource paramater to , data source=.\DEV\SQLDM2005 but I got the
same message as in my first post. DEV\SQLDM2005 is SQL Server 2005 and
DEV is our SQL Server 2000 so I tried using both the servers but no
luck.

Have I done it right in the machine.config file? And I am not familiar
how do I it in the provider config file either.

Please help.
Thanks
-L

.

Relevant Pages

  • Re: Need help with ASP.NET website administration tool! - Cant connect to the database when clic
    ... you have to remove the .\ at the beginning of the datasource name - and some other junk ... have you used the aspnet_regsql tool to create the database in sql server?? ... Here is the ConnectionStrings code from the machine.config file ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: General Question: Single Quotes in Text Fields
    ... StoredPrcedure in the SQL server, when single quote involved. ... Good Luck ... to morph apostrophes into some other character or just delete them ...
    (microsoft.public.access.modulesdaovba)
  • Provider not found
    ... occur with any ODBC or SQL based database, not just MS SQL Server. ... controls connected to a Sybase database. ... I re-applied the SQL server SP 3 - no luck ... I found these in my i386 folder. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Dynamic Table Name is Source Query
    ... >lookup books and other source for few days and still out of luck. ... Then use a dynamic properties task to take the global variable and ... assign it to the SourceObjectName property of your DataPump task. ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: ORDER BY in VIEW not working
    ... it's just a coincidence that in other views (see ... > sorted in the specified order? ... You could call it luck, ... SQL Server 2005 added some engine improvements ...
    (comp.databases.ms-sqlserver)