Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    SQL data source (Access 2003 SP2)

    I have setup a SQL database with 1 table at the moment.
    I wish to setup a datasource of this database so i can use Access to link to the SQL tables.
    How do i setup the data source ( i presume i use control panel/ODBC.
    Do I use User, System or file dsn.
    The SQL database is on my laptop.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SQL data source (Access 2003 SP2)

    Since it's for testing purposes, it doesn't really matter what kind of DSN you create (a user DSN is available to your login only, a system DSN to all users of the PC).

    If you do a Google search for create sql server dsn you'll find many tutorials, just select one from the first page of results.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    thanks Hans

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    I have tried that and it comes up with Sql Server does not exist or Access denied.

    What is the meaning of this message, and how do i overcome it?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    There is a article in there that says SQL Server must be started.

    How do i start SQL Server?

  7. #7
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL data source (Access 2003 SP2)

    Hi Pat,
    SQL Server runs as a service. On the computer running SQL, right click on My Computer, then click on Manage, the Computer Management console will pop up. Expand Services and Applications, then click on Services. Scroll until you see SQL Server. If it is running you will see, under Status, started. If not, right click on SQL Server and select Start.
    If you are using SQL Server 2005 and have installed the Workstation components as well, you can open SQL Server Configuration Manager, click on SQL Server 2005 Services. In the right hand pane, if it is started you will see Running under the State column. If not, right click the SQL Server entry (again in the right hand column, and select start.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    Thanks Gary, so SQL Server 2005 has been started, i checked the My computer way and the config manager way of checking. I still have a problem trying to setup a DSN on my laptop.

  9. #9
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL data source (Access 2003 SP2)

    You need to check the protocols and see which one's are enabled. You can do this through the SQL Server Configuration Manager or the SQL Server Surface Area console. By default TCP/IP and Named Pipes are disabled. By MY default, whenever I install an instance of SQL Server I enable both, for both local and remote connections. Then, if necessary, will disable one or the other, depending on how the database is to be accessed. Attached is a zip file of a word doc which will show you where you can make those changes with SQL Server Surface Area console. A following post to this one will have the 'where to' using SQL Server Configuration Manager.
    Attached Files Attached Files
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  10. #10
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL data source (Access 2003 SP2)

    --configuration mgr--
    Attached Files Attached Files
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  11. #11
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    Thanks for that, i will check what you have sent.
    I used this laptop to connect to a clients network and one of the DSN's is SQL Server in their network. I also have a sign on on this laptop for the network sign on.
    Do I need to delete the sign on and DSN of this client on y laptop, could this be causing a problem.
    I installed SQLServr32.exe from the web to test SQL Server.

    In case you hadn't noticed i am a novice in SQL Server.

  12. #12
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL data source (Access 2003 SP2)

    A DSN will be separate from your sign on in as much as it depends on how you are able to authenticate to SQL Server, rather than how you are able to login to their network.
    Are you connecting to their network via VPN? If so, you have a domain login and you will be able to log into SQL Server using that username and have access to the database(s), role(s) and/or permission(s) assigned to that username. You can therefore use that username for your DSN's authentication. SQL Server can be configured to accept only Windows Authentication.
    If you do not have a domain login then you would use SQL Server authentication to login into SQL Server and use that for your DSN's authentication, again, having access to the database(s), role(s) and/or permission(s) assigned to that username. Your network sign on, in this case, has nothing to do with how you authenticate to SQL Server. SQL Server must be configured to accept both Windows Authentication and SQL Authentication.
    You can, of course, have a domain login, have a separate SQL Server login and use that SQL login to access the SQL Server.
    I normally use a machine (system) ODBC connection, which is available to all who use a particular computer, with Windows authentication when all the connections are within a domain and use SQL Server authentication when crossing domains.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  13. #13
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    I don't need that client login, so i will just delete it, i will also delete the DSN that it uses too. I have no idea if i use a VPN or not.

    This means i'll setup my own DSN that i can use for my on login to my laptop. The domain of my login is the laptop i am using.

    Do you see any probs with me deleting that Clent login and it's associated SQL Server DSN?

  14. #14
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL data source (Access 2003 SP2)

    <hr>Do you see any probs with me deleting that Clent login and it's associated SQL Server DSN?<hr>
    Only if you need that login to access the SQL Server database on their network. If you stay within your machine there shouldn't be any problems. It won't hurt or bother anything though if you keep them.
    This is contingent on me understanding your question correctly.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  15. #15
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL data source (Access 2003 SP2)

    You undersood the question, english expression is not a strong point of mine.

    I wont be going to that client premise again so i thought i would delete the login and dsn they have.

    I am still having my original problem. I haven't deleted their login or dsn yet.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •