machine name/sqlexpress2008r2 is giving error

55 pts.
Tags:
SQL Server 2008
Dear friends, I have just installed sql server. I created an instance name, but was not able to connect to the server. However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB. However, when using the same connection string in the VB.Net, its giving some error. Can you please help me. Thank you

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    I created an instance name, but was not able to connect to the server.   Why not? What happens?   However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB.   Where was the machine name?   However, when using the same connection string in the VB.Net, its giving some error.   "Some error"? What error?   Can you please help me.   Not without a lot more information. Where is the database? Where is the code running? What is the connection string? What does the code look like? What errors are you seeing?   Knowing those might give us enough to make a guess, or enough to ask some specific questions to work towards an answer.   Tom
    125,585 pointsBadges:
    report
  • carlosdl
    Since it is a named instance, you need to specify the server and the instance name, but as mentioned by Tom, without more details we have no way to help you.
    69,045 pointsBadges:
    report
  • ToddN2000
    Is this database Client or Server side?What method are you using to access the data?SqlDataSource, AccessDataSource, ObjectDataSource or XmlDataSource?If you can post you connection string maybe we can help.
    9,690 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following