Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2005
    Location
    Athens, Greece
    Posts
    14

    Unanswered: Just installed SQL SERVER and need help

    Please forgive me if this sounds so silly, but I am a complete newbie on SQL SERVER (the only think I ve worked on so far is Access) and I need help.

    I ve just installed the SQL Server 2005 and the things I have are about configuation, such as:
    -sql server configuration manager
    -sql server error and usage reporting
    -sql server surface area configuration
    -notification services command prompt
    -reporting services configuration

    Is that all? Did I miss anything? How am I supposed to create databases? How can I connect remotely to another server (database)?

    I know I may sound stupid but Im on the beginning and I would so much appreciate any kind of help.

    Thanks in advance,
    Martha
    Last edited by martha; 12-23-05 at 18:47.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by martha
    Please forgive me if this sounds so silly, but I am a complete newbie on SQL SERVER (the only think I ve worked on so far is Access) and I need help.
    See my comments below:
    Quote Originally Posted by martha
    I ve just installed the SQL Server 2005 and the things I have are about configuation, such as:
    -sql server configuration manager
    lets you configure service startup properties and network connection properties

    Quote Originally Posted by martha
    -sql server error and usage reporting
    dunno, haven't looked into this yet; but if it's what I think it is (ie, automated reporting to MS of usage and errors, I would be okay with it ONLY in a development environment. Be sure to check company policy first (if applicable).

    Quote Originally Posted by martha
    -sql server surface area configuration
    another tool for configuring specific features that are available. Only turn on those things that you KNOW you are going to be using.

    Quote Originally Posted by martha
    -notification services command prompt
    no clue; sorry

    Quote Originally Posted by martha
    -reporting services configuration
    Allows you to configure your reporting services environment. Wait a while on this one. If you're new to MS SQL, MS Reporting Services is another big chunk to start working on right away.

    Quote Originally Posted by martha
    Is that all? Did I miss anything? How am I supposed to create databases? How can I connect remotely to another server (database)?
    To create a database, start SQL Server Management Studio. Expand your server and the database node under your server. Then Right Click on the 'Databases' node and select "Create New Database".

    To connect remotely, it depends on what you are connecting with. If it's with MS Access (like ADP), then you should be able to connect to SQL using the MS SQL OLE DB driver. If you're installing the client tools on your workstation, you should just be able to point to your server (with a valid username/password and off you go.

    Quote Originally Posted by martha
    I know I may sound stupid but Im on the beginning and I would so much appreciate any kind of help.

    Thanks in advance,
    Martha

    Best of luck. SQL 2005 is a bit of a new animal and I'm just getting started on it right now. There are some good resources out there:

    http://www.micrsoft.com/sql
    http://www.sqlis.com/
    http://www.sqldev.net/
    http://www.dbforums.com/f7 (this forum)
    http://www.sqlteam.com (who loves you Brett?)
    http://www.sqlservercentral.com

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Apr 2005
    Location
    Athens, Greece
    Posts
    14
    Thanks for your time answering my post.

    I installed Management Studio and connected to my remote database.

    The problem now is that im trying to get a backup but it is saved on the remote server. I tried to change "destination" by clicking "add" and the following error occurs:
    Code:
    Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
    Actually, the remote server is the host of my website. Is it possible that they arent giving permission to backup the database?

  4. #4
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    probably that the user who you are trying to write the backup file with does not have permissions on the remote server...at least it would appear that way. I'm not sure how security would shake out as it is probably trying to write the file using the "service" account you setup during installation and if you just took the "local account" I'm not sure it would have rights whereas if the service account was setup with an NT authenticated account it could be granted write permissions on that server...

Posting Permissions

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