Options

New to SQL

billybob01billybob01 Member Posts: 504
in SQL Server exams
Just installed SQL 2005 and have just received the book!! My question is at work i am just playing around with SQL 2005 installed in vmware and i have an access 2000 database on a winxp machine, and using the SQL access migration wizard i have installed the database onto the 2005 server, but i need to connect them together!! I have tried setting up ODBC but the connection fails, what do i need to do in order to connect the access database to the server database??
· Share on FacebookShare on Twitter

Comments

  • Options
    brad-brad- Member Posts: 1,218
    1) Open SSMS
    2) Connect to your DB instance (ie. login)
    3) Rightclick databases --> Attach ....brose for your .mdf

    If memory serves, it will convert it into a new SQL database on the fly.
    · Share on FacebookShare on Twitter
Sign In or Register to comment.