An interactive session to install MSDE in corporate setup

  • As you friends remember. Yes, I am the same guy who posted a very long, un-understandable topic called 'A Giant Hurlde in my Giant Leap'. Ok. Let's make it shorter then. I decided to go step-by-step. one question at a time whenever I face hurdles. Ok? I believe you guys support me.

    Current problem:

    MSDE has been installed and working in my pc through an administrator account. But when I logged into my account (limited). MSDE is running. But shows a while ball in the system tray. says "Unknown - \\ - MSSQLServer". What is the problem? What is the remedy? Wants to understand the situation instead of simply solving the problem. Thank you.

  • I don't have an answer to your question, but here are a couple of suggestions to attack this.

    Have you tried looking up the problem? More often than not, you're going to be encouraged to try to look it up yourself and see how much you can figure out. This way, you'll get a measure of hands-on and you'll learn about the system. Hey, they say experience is the best teacher . . . 😉

    I tried Googling your message. Here are the results.

    Also, do you have Books Online (you'll see it on these forums as "BOL") installed? BOL is an invaluable reference; in fact, when I start SQL in the morning, the first thing I do is start BOL.

    Sorry that I don't have an answer, but I hope this helps. Good luck!

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • What permissions does your normal account have on the MSDE instance? It could be possible that you don't have permissions to see the SQL instance, so it cannot give you a status of the instance.

    Joie Andrew
    "Since 1982"

  • Silly question--is there a reason you need to use MSDE as opposed to a more modern version of SQL Express? MSDE has some pretty hard limits on the number of transactions per second it will support which were removed in SQL Express, as I recall.

  • Ray K (2/1/2010)


    I don't have an answer to your question, but here are a couple of suggestions to attack this.

    Have you tried looking up the problem? More often than not, you're going to be encouraged to try to look it up yourself and see how much you can figure out. This way, you'll get a measure of hands-on and you'll learn about the system. Hey, they say experience is the best teacher . . . 😉

    I tried Googling your message. Here are the results.

    Also, do you have Books Online (you'll see it on these forums as "BOL") installed? BOL is an invaluable reference; in fact, when I start SQL in the morning, the first thing I do is start BOL.

    Sorry that I don't have an answer, but I hope this helps. Good luck!

    Hi! Ray...

    Thank you for your special care. Since, I am working in a project nearing to its deadline. I am not having enough time/patience to read books now. Please dont take it otherwise. I even have to go office in weekends too. Thank you for the search results.

    Joie Andrew (2/2/2010)


    What permissions does your normal account have on the MSDE instance? It could be possible that you don't have permissions to see the SQL instance, so it cannot give you a status of the instance.

    May I ask you one question. What permissions do an account needs to see the SQL instance? You know, I am very very poor in windows xp user roles and security configurations. If you explain in detail I believe it will be very helpful for me to approach and explain our IT support guy to enable the permissions for my account. Thank you.

    paul.knibbs (2/3/2010)


    Silly question--is there a reason you need to use MSDE as opposed to a more modern version of SQL Express? MSDE has some pretty hard limits on the number of transactions per second it will support which were removed in SQL Express, as I recall.

    Yeah. You are right. For your information I already know about the MSSQL Express Edition and the advantages of it. But since I am in an automation(which deals with Ms-Office only) we are only authorised to use whatever the tools which are supplied with Ms-Office CD. So no plan-B here. Thank you.

  • If your account is an administrator on the machine and Built-in Administrators is in the sysadmin server role, then your account should not have problems accessing SQL

    Joie Andrew
    "Since 1982"

  • sprabhakaran.karuppaih (2/3/2010)


    Since, I am working in a project nearing to its deadline. I am not having enough time/patience to read books now.

    That project will take you far longer than necessary if you don't know what you're doing. No one's going to tell you exactly, step by step, what to do if you don't have the patience to read manuals/tutorials/help files for yourself.

    Bear in mind that everyone here is volunteering their spare time to help out. We all have our own projects, our own deadlines and our own problems.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • If your account is an administrator on the machine and Built-in Administrators is in the sysadmin server role, then your account should not have problems accessing SQL and starting the services.

    If your account is not an admin account on the box (which I think is what your original post stated) then ensure that your account has a login on the instance:

    - Login to the machine with the admin account

    - Open up Enterprise Manager

    - Navigate to the server > Security > Logins

    - Ensure there is a server login for your Windows account. If not create one using the GUI in Enterprise Manager

    - Ensure that the account is added to a server role that is adequate for what you will need

    Check out the Books OnLine article to help you determine what role will best fit your needs:

    Adding a Member to a Predefined Role

    Joie Andrew
    "Since 1982"

  • First I want to thank everyone for giving me constant support. Thank you.

    Joie Andrew (2/3/2010)


    If your account is an administrator on the machine and Built-in Administrators is in the sysadmin server role, then your account should not have problems accessing SQL

    Hi!

    Yeah. You are right. My Account is not an administrator on the machine. In fact, I am not logging to the machine directly. I am logging to the machine through my corporate domain.

    That project will take you far longer than necessary if you don't know what you're doing. No one's going to tell you exactly, step by step, what to do if you don't have the patience to read manuals/tutorials/help files for yourself.

    Bear in mind that everyone here is volunteering their spare time to help out. We all have our own projects, our own deadlines and our own problems.

    I abide you words. Yeah you are right and straight forward. It is better if you atleast give me some links regarding the MSDE. You know it is hard for a beginner to find himself.

    If your account is an administrator on the machine and Built-in Administrators is in the sysadmin server role, then your account should not have problems accessing SQL and starting the services.

    If your account is not an admin account on the box (which I think is what your original post stated) then ensure that your account has a login on the instance:

    - Login to the machine with the admin account

    - Open up Enterprise Manager

    - Navigate to the server > Security > Logins

    - Ensure there is a server login for your Windows account. If not create one using the GUI in Enterprise Manager

    - Ensure that the account is added to a server role that is adequate for what you will need

    Check out the Books OnLine article to help you determine what role will best fit your needs:

    A Very very helpful reply. This is the first time a person who actually located and proved that still microsoft is keeping and supporting the pages for MSDE 2000. Thank you very much for telling me about the 'Book Online'. By the way, I want to confess you that we are only supposed to use whatever tools bundled with the MS-Office CD, thus MSDE is the last Resort to me. Friend, I have one problem now. I dont know why I am not able to download the whitepaper named 'AccSQL02.exe' from the link http://support.microsoft.com/kb/301413/. I even tried from my home. Help needed. Thank you.

  • Anyone have this file?

    AccSQL02.doc

  • Not sure. It seems like it was either taken offline or they denied access to the file. You may want to post a question on one of the SQL/Office forums in TechNet or MSDN and see if you get an answer.

    Joie Andrew
    "Since 1982"

  • Hi Friends! I have located almost most of the Resources in Configuring the MSDE. But the file 'AccSQL02.exe' is very essential to me. Since its having the instructions on how to configure the MSDE server over the TCP/IP protocol. I am feeling like struck here. I believe you understand my necessity and urgency. Thank you.

  • I am not sure if you are going to be able to get that file anymore. It is probably better that you describe what your problem is in detail, that way we can help you solve that instead of going on about getting a document that it does not look like Microsoft is handing out any longer.

    Is your problem that you cannot connect to an installed MSDE instance, or is it that you cannot connect to an instance by IP address?

    Please be as descriptive and clear as possible in telling us what you are trying to do, what is going wrong and what errors you are receiving, with the exact error text. That way we have more information to help you get where you are trying to go.

    Joie Andrew
    "Since 1982"

  • sprabhakaran.karuppaih (2/3/2010)


    Since, I am working in a project nearing to its deadline. I am not having enough time/patience to read books now. Please dont take it otherwise. I even have to go office in weekends too. Thank you for the search results.

    Hi . . . apologies for not replying sooner -- I've been pretty busy myself, and haven't been very good about checking the forums lately!

    No offense taken, although I do agree with Gail that you should definitely take the time to do research when you can. I realize you have deadlines (hey, so do I! ;-)), but sometimes, it's better to take a little time to gain some knowledge that'll help you over the long run!

    Definitely keep asking your questions -- these forums are a great resource to utilize!

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • whenever I tries to create a 'new project using new data' in my server instance through a trusted connection, I am getting this error

    "An error occurred while trying to create the database; the wizard can't continue. (Server Error 262: CREATE DATABASE permission denied in database 'master'.) Your ADP file will not be connected to a server database."

    For your information, I already grantlogin and grantdbaccess to my account 'domainname\myusername' for the 'mysystemname\instancename' and the pubs db respectively. When I tries to access the pubs db using the trusted connection (which I already loaded into the MSDE server using an admin account-which is in the local system), it also gives an error message stating that "Test connection failed because of an error in initializing provider. Cannot open database requested in login 'pubs'. Login fails."

    To the worst of all, I am not even able to see the list of databases in the server whenever I tries to access through SQL Server Authentication. But I am very sure I gave my 'sa' password while installing the MSDE (in mixed mode only). The password is 'pass'. But it fails. Help needed. Thank you.

    Anyone found the file? AccSQL02.doc?

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply