Here's what it say in my machine .config file:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data
source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspn etdb.mdf;User
Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>
If I put this in my local web.config (changing the .\SQLEXPRESS to
..SQL2005 -- the named instance), then when I start the ASP.NET configuration
tool and click on the security tab I get the following error message.
I'm a total newbie here so I appreciate any help I can get with this.
S
"Alexey Smirnov" <al************@gmail.comwrote in message
news:11*********************@v33g2000cwv.googlegro ups.com...
On Feb 10, 1:15 am, "SAL" <S...@NoNo.comwrote:
>I'm trying to use the website configuration tool and it keeps telling me
that it is unable to connect the SQL Server Database.
I do not have SQL Server Express installed. I have the real deal
installed
on my development box. Is this the problem or is there someway to tell
this
tool that I'm using and named instance of SQL Server.
I ran the aspnet_regsql.exe tool and it installed the aspnetdb database
in
the server.
In the machine.config it's got
LocalSqlServer
As the connectionStringName
".\SQLEXPRESS" is name of an instance SQL Server Express creates by
default. The dot means the local server and \SQLEXPRESS specifies the
SQLEXPRESS named instance. And this is configured by default the
website configuration tool. If you don't have SQL Server Express
installed you need to specify name(instance) of your server.
For example, it could be "localhost" and LocalSqlServer could be
server=localhost;database=...;uid=...;pwd=...;