machine name/sqlexpress2008r2 is giving error
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
Software/Hardware used:
Software/Hardware used:
ASKED:
September 7, 2012 3:31 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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
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.
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.