Prev: AJAX v. Postback
Next: Changes in aspx page not reflected on production site
From: coder316 on 11 Apr 2010 14:44
On Apr 11, 2:18 pm, "Mr. Arnold" <Arn...(a)Arnold.com> wrote:
> coder316 wrote:
> > On Apr 11, 1:32 pm, "Mr. Arnold" <Arn...(a)Arnold.com> wrote:
> >> coder316 wrote:
> >>> Hello,
> >>> I get this message when trying to connect on a local machine.
> >>> A network-related or instance-specific error occurred .....
> >>> SQLExpress database file auto-creation error....
> >>> I'm not using express though.
> >>> Thanks
> >>> Mike
> >> Well what are you using? And was SQL Express on the machine before?
>
> > Yes it was,
> > Removed it and are supposded to be using sql 2008 dev edition.
> > Connection string looks right.
>
> Research it
>
> <http://www.google.com/#hl=en&source=hp&q=%3E+SQLExpress+database+file...>

<add connectionString="Server=AMP-PC;Database=aspnetdb;Integrated
Security=true" name="Users" />
From: Gregory A. Beamer on 11 Apr 2010 16:11


"coder316" <coder316(a)gmail.com> wrote in message
news:b01314e7-ea99-4a86-ba75-447114fb9433(a)u22g2000yqf.googlegroups.com...
> Hello,
> I get this message when trying to connect on a local machine.
> A network-related or instance-specific error occurred .....
> SQLExpress database file auto-creation error....
>
> I'm not using express though.
> Thanks
> Mike

Membership? It defaults to either Express or Access. To get around this,
create the database using the scripts and then change the connection string.
After that, everything works.

Not membership? Still sounds like "change the connection string" to me.

--
Peace and Grace,
Greg

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

************************************************
| Think outside the box! |
************************************************

From: Mark Rae [MVP] on 12 Apr 2010 06:49
"coder316" <coder316(a)gmail.com> wrote in message
news:3d860838-63b0-4f04-b122-415bafbc6fb3(a)u22g2000yqf.googlegroups.com...

> <add connectionString="Server=AMP-PC;Database=aspnetdb;Integrated
> Security=true" name="Users" />

Just in case, try setting Integrated Security to SSPI instead of True. I
realise that they are supposed to be the same, but I have encountered
instances where SSPI worked and True didn't...

Also, you're not specifying an Initial Catalog (i.e. database) setting - try
setting that...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

First  |  Prev  | 
Pages: 1 2
Prev: AJAX v. Postback
Next: Changes in aspx page not reflected on production site