sql server 2008 connection string error

Question

I know this is a quite standard issue... but can't figure it out..

So here's what i want to do:

I want to connect to my local sql server .\SQLEXPRESS by windows authentication. I can login by using the SQL Server Management Studio.

My connection string is like this:

string connStr = "Provider=SqlOleDB;Data Source=.\\SQLExpress; Initial Catalog=Sports; Integrated Security=SSPI";

it throws me an error:

Cannot open database "Sports" requested by the login. The login failed.

so i tried:

string connStr = "Provider=SqlOleDB;Data Source=.\\SQLExpress; Initial Catalog=Sports; Trusted_Connection=True";

it gives me:

Invalid authorization specification

Then i tried:

string connStr = "Provider=SqlOleDB;Data Source=.\\SQLExpress; Initial Catalog=Sports; Integrated Security=True";

it returns:

No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).

Any ideas??

updates: i forgot to mention, i'm using virtual machine windows 7 running the sql server 2010 express. Is there anything to do with the virtual machine???

marc_s · Accepted Answer · 2010-11-16 22:06:27Z

2

Are you familiar with http://www.connectionstrings.com ??

I would try something like:

Server=.\\SQLExpress;Database=Sports;Integrated Security=SSPI

That should work, I hope (no need to specify a provider and all that stuff).

answered Nov 16, 2010 at 22:06

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sbs Over a year ago

i tried most the combinations from the connectionstrings.com website. And if i didn't add the provider, it gives me an error telling me that i need to specify the provider. This connection string works fine when i connect to the server, but not works fine when i want to connect to the local.

Manvi · Accepted Answer · 2010-11-16 21:45:09Z

0

Yo,

Do u use some IDE? Like VS2008? First, try restart SqlServer in your Configuration Manager.

answered Nov 16, 2010 at 21:45

Manvi

1

Collectives™ on Stack Overflow

sql server 2008 connection string error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related