Connection Question

  • Thread starter Thread starter coder316
  • Start date Start date
C

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
 
coder316 said:
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
Click to expand...

Well what are you using? And was SQL Express on the machine before?
 
Well what are you using? And was SQL Express on the machine before?
Click to expand...

Yes it was,
Removed it and are supposded to be using sql 2008 dev edition.
Connection string looks right.
 
Connection string looks right.
Click to expand...

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 said:
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
Click to expand...

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! |
************************************************
 
<add connectionString="Server=AMP-PC;Database=aspnetdb;Integrated
Security=true" name="Users" />
Click to expand...

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