Login failed for user ''. The user is not associated with a tr

First, I made a mistake, it works fine on my dev computer, just not on my IS
P
site.
Here are the connection strings I am using:
<connectionStrings>
<!--<add name="Personal" connectionString="Data
Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDire
ctory|Personal.mdf"
providerName="System.Data.SqlClient"/>-->
<!--<add name="Personal" connectionString="Data
Source=sql2005.aspnix.com;Integrated Security=True;User
Instance=True;AttachDBFilename=c:\domain
s\topodepot.com\wwwroot\App_Data\Per
sonal.mdf" providerName="System.Data.SqlClient"/>-->
<add name="Personal" connectionString="Data
Source=sql2005.aspnix.com;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDire
ctory|Personal.mdf"
providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/>
<!--<add name="LocalSqlServer" connectionString="Data
Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDire
ctory|aspnetdb.mdf"/>-->
<!--<add name="LocalSqlServer" connectionString="Data
Source=sql2005.aspnix.com;Integrated Security=True;User
Instance=True;AttachDBFilename=c:\domain
s\topodepot.com\wwwroot\App_Data\asp
netdb.mdf"/>-->
<add name="LocalSqlServer" connectionString="Data
Source=sql2005.aspnix.com;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDire
ctory|aspnetdb.mdf"/>
</connectionStrings>
The first commented out one in each section is the local connection string
that works fine on my dev computer. The second commented out one used to wor
k
on my ISP. It now gives the "Login failed for user" error. The third one I
tried, but it gives the "Invalid value for key 'attachdbfilename'. " error.
Is there any log files anywhere that might give more information, or does
anyone there know what might be causing this problem? I used the "Copy web
site..." procedure to deploy from my dev machine to my ISP (ASPNix BTW).
Roger Bedell, President, Sylvan Ascent Inc.
"Jeff" wrote:
> Sounds like your connection string is using "Integrated Security".
> Jeff
> "Sylvan" wrote:
>Hi Roger,
Most ISPs require the User ID and Password you were issued in the connection
string. Try checking the support forum on your ISP for more information on
the proper format for the connection string when using SQL Express.
'Integrated Security = true' almost always implies that you have been
authenticated via windows security.
Sorry I can't offer more help - perhaps other forum users can chime in..
Jeff
"Sylvan" wrote:
> First, I made a mistake, it works fine on my dev computer, just not on my
ISP
> site.
> Here are the connection strings I am using:
> <connectionStrings>
> <!--<add name="Personal" connectionString="Data
> Source=.\SQLExpress;Integrated Security=True;User
> Instance=True;AttachDBFilename=|DataDire
ctory|Personal.mdf"
> providerName="System.Data.SqlClient"/>-->
> <!--<add name="Personal" connectionString="Data
> Source=sql2005.aspnix.com;Integrated Security=True;User
> Instance=True;AttachDBFilename=c:\domain
s\topodepot.com\wwwroot\App_Data\P
ersonal.mdf" providerName="System.Data.SqlClient"/>-->
> <add name="Personal" connectionString="Data
> Source=sql2005.aspnix.com;Integrated Security=True;User
> Instance=True;AttachDBFilename=|DataDire
ctory|Personal.mdf"
> providerName="System.Data.SqlClient"/>
> <remove name="LocalSqlServer"/>
> <!--<add name="LocalSqlServer" connectionString="Data
> Source=.\SQLExpress;Integrated Security=True;User
> Instance=True;AttachDBFilename=|DataDire
ctory|aspnetdb.mdf"/>-->
> <!--<add name="LocalSqlServer" connectionString="Data
> Source=sql2005.aspnix.com;Integrated Security=True;User
> Instance=True;AttachDBFilename=c:\domain
s\topodepot.com\wwwroot\App_Data\a
spnetdb.mdf"/>-->
> <add name="LocalSqlServer" connectionString="Data
> Source=sql2005.aspnix.com;Integrated Security=True;User
> Instance=True;AttachDBFilename=|DataDire
ctory|aspnetdb.mdf"/>
> </connectionStrings>
>
> The first commented out one in each section is the local connection string
> that works fine on my dev computer. The second commented out one used to w
ork
> on my ISP. It now gives the "Login failed for user" error. The third one I
> tried, but it gives the "Invalid value for key 'attachdbfilename'. " error
.
> Is there any log files anywhere that might give more information, or does
> anyone there know what might be causing this problem? I used the "Copy web
> site..." procedure to deploy from my dev machine to my ISP (ASPNix BTW).
> --
> Roger Bedell, President, Sylvan Ascent Inc.
>
> "Jeff" wrote:
>
Ok, It's all figured out.
Actually, the personalization stuff in ASP.NET 2.0 was not working. After
much research, I found the following blog which explains why. Basically,
since ASPNix (my ISP) is using the real SQL 2005, not SQL Express, it is mor
e
difficult to create and use the databases that ASP.NET uses internally. See
the blog, and especially my entry toward the end:
http://weblogs.asp.net/bsimser/arch...px?Pending=true
Roger
Roger Bedell, President, Sylvan Ascent Inc.
"Jeff" wrote:
> Hi Roger,
> Most ISPs require the User ID and Password you were issued in the connecti
on
> string. Try checking the support forum on your ISP for more information o
n
> the proper format for the connection string when using SQL Express.
> 'Integrated Security = true' almost always implies that you have been
> authenticated via windows security.
> Sorry I can't offer more help - perhaps other forum users can chime in..
> Jeff
> "Sylvan" wrote:
>