How can I open the database of Microsoft SQL Server 2005?

5 pts.
Tags:
SQL Server 2005
SQL Server database
Actually I have a system and I use the Microsoft SQL Server 2005 for the Database. Can anybody help me. Thanks.

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: 4  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
  • ToddN2000
    How are you looking to open this; by a program either .NET, VB or C# or just view it through SQL server? IF just to view through SQL server, log into management studio with the server IP address info, click databases folder, open the select database, open the tables and you will see your data. Right click and select options to view, edit and others.
    9,690 pointsBadges:
    report
  • ToddN2000

    To open via an application you need to build a connection string in your web.config file something like this

      <connectionStrings>
        <add name="MyConnectionString" connectionString="MultipleActiveResultSets=True;Data Source=USER\SQLEXPRESS;Initial Catalog=MyCatalog;Integrated Security=True" providerName="System.Data.SqlClient" />
      </connectionStrings>
    9,690 pointsBadges:
    report
  • Subhendu Sen
    If u have admin rights/ authenticated to operate, then u can open the database and do ur necessary work. As u mentioned, u have a system, but what a system u have that u did not reveal ! U must have some front-end program/ apps that and from there u want to open database. However, every programming language has its own syntax to connect database, but logic should be same.
    27,780 pointsBadges:
    report
  • carlosdl
    Assuming that you want to be able to see or read the data stored in the database by your system (as is many times the case when we get questions like this one), you could do it using a tool from Microsoft called "SQL Server Management Studio" (if you have the necessary credentials, of course) to run your queries.
    69,045 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