?
Solved

Create a smal testing environment for MS SQL 2008 in LAN

Posted on 2009-04-21
7
Medium Priority
?
269 Views
Last Modified: 2012-05-06
I want to create a smal testing environment for myself in my local area network. I have installed MS SQL server 2008 (Trial) on one computer in my network. I will install a DB on this server. On another computer in the LAN I wish to connect to the server. The computer with the MS SQL server is running Vista and the other computer XP.

I am a programmer, but not a server-guy. Please give me some links or instructions how to do it. Firewall issues? How to connect? I have not changed anything in the installation wizard for MS SQL 2008.

I have so far only connected an Access database to a local My SQL server.

Thank you!
0
Comment
Question by:hke72
  • 4
  • 3
7 Comments
 
LVL 43

Expert Comment

by:pcelba
ID: 24193580
Everything you need on another computer is SQL Server client tools or ODBC driver at least. Client tools allow to manipulate data on the server, ODBC driver allows to connect from your applications to the SQL Server database.

Connection to SQL Server is similar to MySQL. You have to use proper connection string (containing right driver and computer/server name and that's it).

To allow connection you'll need user and password with appropriate access rights defined on the SQL Server or you have to allow Windows account login on the server. For the beginning you may try to connect as an SQL administrator.
0
 
LVL 1

Author Comment

by:hke72
ID: 24194100
I am trying to "Upscale" a database from MS Access 2007. I cannot connect to the SQL server. Is it because it is a trial?
0
 
LVL 43

Expert Comment

by:pcelba
ID: 24194169
No, not at all. It is just invalid connection definition. You should try to connect from SQL Management studio and then from Access. Some problems were reported with case sensitive collations and lower case letters in computer names.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:hke72
ID: 24194518
I have created a new user using SQL Management studio (SQL MS).  I have granted as many rights as I could (in the properties of the user). I manage to logon with SQL MS as you said. When using this account running upscale wizard in Access I now get the message (Translated!)  "Upscale wizard  only works with Microsoft SQL Server (version 6.5 or later). Logg on to an SQL Server datasource." So I did not get the same message. Something is different?
Ideas?
0
 
LVL 43

Accepted Solution

by:
pcelba earned 800 total points
ID: 24196387
The connection is OK but SQL Server 2008 has version 10.xx and it seems the Upscale wizard checks just the first digit...

Looking on the web it seems it is known issue and you can use SQL Server Migration Assistant for Access from http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx It should work with SQL 2008.

Some experience with SSMA is e.g. here
http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/
0
 
LVL 1

Author Comment

by:hke72
ID: 24196628
You got me in the right path and then I found this>
http://download.microsoft.com/download/6/4/c/64c1f9f5-cac4-4571-8b4e-04512e9a5e4f/SSMA%202008%20for%20Access%20v4.0.zip
Which I will try! Thank you!
0
 
LVL 1

Author Closing Comment

by:hke72
ID: 31572676
Good help all the way through! Thank you very much!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Loops Section Overview
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question