login fail for windows authentication on a new server

Question

0.00/5 (No votes)

See more:

Dear programmer,

I have backuped my sql database and restored on another computer. Now when I try to login to it programatically using C# I get error: "Login failed for user 'new computer name'".
I am using windows authentication and my connection string looks like this:
Data Source=.\\sqlexpress;Initial Catalog="office_ session";Integrated Security=True

when I try Visual studio -> server explorer -> connect to a database wizard
everything works fine.

Thank you for your time

Posted 9-May-11 22:35pm

oentezari

Add a Solution

Comments

[no name] 10-May-11 5:28am

you need to show your code.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

cuteband · Answer 1 · 2011-05-09T22:39:00

Solution 1

did you try to connect it in SQL Management Studio? And did you already check your sql configuration?

Posted 9-May-11 22:39pm

cuteband

Comments

oentezari 10-May-11 5:22am

Actually the new computer has no management studio.
But as I mentioned visual studio connection wizard produces the same
string and connects perfectly.
thank you

Steven.Pinto2000 · Answer 2 · 2011-05-10T00:19:00

In order to know what is the connection string create a text file and change the extension of it to udl eg:ConnectionString.udl and click on it you will see a dialog now do the settings once you have done the settings test the

connection and then click on OK

Now right click the ConnectionString.udl file and open it with notepad you will get the connection string

Kim Togo · Answer 3 · 2011-05-10T00:29:00

Solution 3

Integrated Security in the connection string[^] tell to use the current Windows account credentials for authentication. You have to change some security settings for SQL Express.
And running you program as a service or under Visual Studio is not the same.

Posted 10-May-11 0:29am

Kim Togo

Updated 10-May-11 0:30am

v2