Connection Question

[coder316]

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

 

[Mr. Arnold]

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?

 

[coder316]

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.

 

[Mr. Arnold]

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...=f&aqi=&aql=&oq=&gs_rfai=&fp=467c3568f2eec009>

 

[Andy O'Neill]

Connection string looks right.

Show us the string.
Just don't forget to change any password and user name.
I would guess you're using the wrong named instance or something which is
sql express specific.

 

[coder316]

Research it

<http://www.google.com/#hl=en&source=hp&q=>+SQLExpress+database+file...>

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

 

[Gregory A. Beamer]

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! |
************************************************

 

[Mark Rae [MVP]]

<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...